[Help] GS Error: CloseClient INVALID_SOCKET

[ColdAxe]

Hello Everyone.

the GS show this error.
it happend when some of the ppls that play my server quit their client.
they are using the same client as i am.
and when i quit my client the gs dosent show this msg.

ImageShack - Hosting :: gsaq1.jpg


some info...
i'm using the latest goeh release
and also his client patch that provided in the server files.

any idea how to solve it?
thx.

[MentaL]

[Lightcookie]

Check all of your IP' s, correct them and it will be fixedf.

[SHANG]

this is OS bug, not gs

[Lightcookie]

OS means?

[ColdAxe]

Operation System i guess...

[-=[Dark]=-]

sometimes this happens to me to.. and yeah it`s OS problem (operating system,yes) .. think it`s from the winsock :-??

[IPX]

Yeah i have same shit... its a minor error server works fine ...

[Hellvix]

Did you already solve it, ColdAxe?

[arend]

Anyone solve it?

[Hellvix]

You could have had dig through in the forum for it, but ok...


Read all posts that I and some guys made in this topic:

http://forum.ragezone.com/f193/help-...-files-266600/


It's explaining why the problem happens and the solution for it.


And use this jobs in Query:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_STAT_GJ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_STAT_GJ]
GO

CREATE TABLE [dbo].[MEMB_STAT_GJ] (
[memb___id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ServerName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ServerCode] [int] NULL ,
[IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[TM] [datetime] NULL
) ON [PRIMARY]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WZ_CONNECT_MEMB]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[WZ_CONNECT_MEMB]
GO

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(10),
@server varchar(20),
@uip varchar(20)
AS

Begin

BEGIN TRANSACTION

SET NOCOUNT ON

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET ip = @uip , connectstat = 1 , servername = @server , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername)
valueS (@uid,@uip,1,@server )
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

--写入登录记录
IF EXISTS ( SELECT UserID FROM UserLogin WITH (READUNCOMMITTED) WHERE UserID = @uid )
Begin
UPDATE UserLogin
SET LoginIP=@uip,Server=@server,LoginTM = (getdate()),OnlineSec=0,GiveMoney=0,logoutTM=null
WHERE UserID = @uid
End
ELSE
Begin
INSERT INTO UserLogin (UserID,LoginIP,Server,LoginTM,OnlineSec,GiveMoney)
values (@uid,@uip,@server,getdate(),0,0)
End
--自动封服务器不准进入的人物
declare @SmallestZS int
declare @LargestZS int
declare @Type int
select @Type=Type from SetServerList where ServerName=@server

if (@Type>0) begin

select @SmallestZS=Smallest_ZS from SetServerList where ServerName=@server
select @LargestZS=Largest_ZS from SetServerList where ServerName=@server

if not (@SmallestZS is null) begin
update character set ctlcode=(ctlcode | 0x81) where [name] not in
(
SELECT NAME FROM WEB_ZS WHERE (ACC = @uid) AND (ZSCS >= @LargestZS) AND (ZSCS <= @SmallestZS)
) AND (AccountID = @uid)
end
end
DELETE FROM MEMB_STAT_GJ WHERE (memb___id = @uid and servername=@server)
update character set ctlcode=(ctlcode | 0x81) where [name] in
(
SELECT name FROM MEMB_STAT_GJ WHERE (memb___id = @uid)
) AND (AccountID = @uid)

SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

[Sartigan]

Thanks A Lot!

[NooK]

Yes thanks a LOT!

[Hellvix]

Yeah, ok dude. Altho, I almost killed myself to solve this. ^_^

Enjoy.

[NooK]

Khmm.. So on XP SP2 nothing doing!?
I have it right... ?

[Hellvix]

Khmm.. So on XP SP2 nothing doing!?
I have it right... ?

On SP2, you'll get these problems.

[Sartigan]

on vista too u l get this prob ;D

[NooK]

Ok, but on Windows Server 2003 SP2 it works?

[Doro]

dont work for me (win 2003 sp2)

[inladros]

Thanks Hellvix vou estava com o mesmo problema vou ver se resolve