[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.

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.

 

[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 ****... 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-connectserver-error-goehs-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