How to fix "error-L1 : CloseClient INVALID_SOCKET"

Hello RZ.
Today you can know how to fix this annoying and sometimes strange for ppl own servers.

First, is not a gs problem, cs problem , or wrong configured ips, neither the customer, nor the files.

Is a problem between the OS and databases, which are complementary.

SS:

http://img293.imageshack.us/img293/2574/gsaq1tf9.jpg

Example of gameserver log:

Quote:

---

17:00:32 connect : [4806][201.255.22.210]
17:00:33 connect : [4807][190.224.207.143]
17:00:43 connect : [4808][201.250.238.79]
17:00:53 (4803)logout : [201.250.190.27]
error-L1 : CloseClient INVALID_SOCKET
17:00:53 connect : [4809][190.224.207.253]
error-L1 : CloseClient INVALID_SOCKET
17:00:56 connect : [4810][200.29.248.26]
17:00:57 connect : [4811][201.254.76.67]
17:00:59 join send : (4811)maxxxx
error-L1 : CloseClient INVALID_SOCKET
17:00:59 login [201.254.76.67] : [maxxxx] numer:12791/ db:1
17:00:59 [maxxxx][] BillType : (3)

---

U need use this jobs in Query Analizer to fix it.

Quote:

---

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

---

Quote:

---

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

---

Clarification:
On Windows 2003 SP2 you'll get this problem.
On Vista too.

I hope this guide helped you.

great it works ^^

Quote:

---

Originally Posted by juliom

On Vista too.

---

offtopic: why am i not suprised lol :o

this guide is useless.. that dont work for any files anymore.. TESTED

i still have CloseClient INVALID_SOCKET when player disconnnects



btw, anyone know why nobody cant connect to my serv anymore lol

they can go normally up to acc/pass window but when hit click client DC's, i can connect normally

Quote:

---

Originally Posted by juliom

Is a problem between the OS and databases, which are complementary.

---

yeah ) right , and if i will say that GameServer doesnt connect to database ? :closedeyes:

Hmmm... lemme make a guide ^^

If you want Season 4 bugless with all features, do this:

Set experience to 99999999999999999999999x:

Go to MuOnline -> Character -> Right click -> Drop Table

Make a link to the gameserver.exe use 666.666.666.666 as startup paramete

And tadam!

:thumbdown:

Quote:

---

Originally Posted by juliom

Hello RZ.
Today you can know how to fix this annoying and sometimes strange for ppl own servers.

First, is not a gs problem, cs problem , or wrong configured ips, neither the customer, nor the files.

Is a problem between the OS and databases, which are complementary.

SS:

http://img293.imageshack.us/img293/2574/gsaq1tf9.jpg

Example of gameserver log:



U need use this jobs in Query Analizer to fix it.






Clarification:
On Windows 2003 SP2 you'll get this problem.
On Vista too.

I hope this guide helped you.

---

where did u get this? im not sure if i should use it...

i think this applys to windows 2003 sp2 only.

Quote:

---

Originally Posted by starmu

i think this applys to windows 2003 sp2 only.

---

yeah i know.. but i mean does it really work?

Quote:

---

Originally Posted by KREATOR

yeah i know.. but i mean does it really work?

---

same here:) does it really works?

Quote:

---

Originally Posted by ginalyn

same here:) does it really works?

---

i got another question too... do i have to run it just one time? or do i have to run it in the sql jobs and make run like every 1 min?

Guys don't you get it?... that error has nothing to do with the DB.

Quote:

---

Originally Posted by *HK*

great it works ^^

---

...

easy to fix it Install Windows Server 2003 Ent SP 1

Quote:

---

Originally Posted by Ragnaros

Guys don't you get it?... that error has nothing to do with the DB.

---

I KNOW THAT!! What i wanna know is what exactly this does...

Quote:

---

Originally Posted by KREATOR

I KNOW THAT!! What i wanna know is what exactly this does...

---

its just because of some 'security' in the new sp2 on win2003 server.. cannot be thrown off tho

My server runs SP2 and I have no problems ;)

Quote:

---

Originally Posted by bramdebouvere

its just because of some 'security' in the new sp2 on win2003 server.. cannot be thrown off tho

---

i mean i wanna know what the script does...

@DataMatrix It only affects OS with SP2 if the OS is 2003 version... example.. my OS is windows xp 2003 version and i have SP2... only 2003 versions with SP2 have this problem..

Quote:

---

Originally Posted by KREATOR

i mean i wanna know what the script does...

@DataMatrix It only affects OS with SP2 if the OS is 2003 version... example.. my OS is windows xp 2003 version and i have SP2... only 2003 versions with SP2 have this problem..

---

I am running 2003 with SP2:
http://zeus.zomsla.co.uk/index.php?disp=dynamic

Also, there is no such thing as Windows XP 2003 version. Only Windows XP, XP x64 and Windows 2003.

Quote:

---

Originally Posted by DataMatrix

I am running 2003 with SP2:
http://zeus.zomsla.co.uk/index.php?disp=dynamic

Also, there is no such thing as Windows XP 2003 version. Only Windows XP, XP x64 and Windows 2003.

---

yes there is.. all windows XP have a year version... one thing is the edition and another thing is the version. Look
http://img142.imageshack.us/img142/1804/windowsyc6.jpg


P.D. I wanna know what the script does :)

someone change the cds version in your windows. reg

i am a big fan of windows sp1.SP1 only
and i'm still using it.

but when i need to install a programs that needs sp2.

i simply go in windows reg. and change a simple code. and it changes me to sp2. without error.s

now i'm on sp3 to test a season4 with extrem settings. like marry system. free level when afk in town. ( gains 50X exp every 30 sec), people level under 200 no pk,

Quote:

---

Originally Posted by starmu

someone change the cds version in your windows. reg

i am a big fan of windows sp1.SP1 only
and i'm still using it.

but when i need to install a programs that needs sp2.

i simply go in windows reg. and change a simple code. and it changes me to sp2. without error.s

now i'm on sp3 to test a season4 with extrem settings. like marry system. free level when afk in town. ( gains 50X exp every 30 sec), people level under 200 no pk,

---

how do u do that?

it;s a nice small hack..

also when you change it.

when you autoupdate in windows. it detect you ass sp2 or sp3 or s4... how every you choose.

so you may get the updates for all service packs. just not the REAL packs installed.

think of it like emulation.

here. it;s sp4 now :P

This work in 97d?

great work :) it works for me gs runing 4 days no error

But as the return of what the system log? to it as I reinstall Windows XP? and as is already the jop do ... ?

this error have nothing to do with database!
Doing what in this tutorial say will not solve your problem,reinstall another windows and all will be ok!

Quote:

---

Originally Posted by [RCZ]ShadowKing

this error have nothing to do with database!
Doing what in this tutorial say will not solve your problem,reinstall another windows and all will be ok!

---

Ok. Any butent I need to load during the new order all recover? I need to do know. I do not want the servo Vīpes padaryt

i dont understand what you mean,use a translator..

I want to rebuild as it was against the use of this script. the table for me or something to upload to recover. I do not want daryt Vīpes server.

if you dont have backup of database before apply this scripts than you cant rebuild it

http://host.nol2.lt/images/619187untitled.JPG

How fix this error in join server

maby ahve some another idea to fix this problem?((( i have server MMT and have this problem and have=(

install windows server 2003... and if you dont wanna use windows server 2003 SP1 then get the winsock and winsock2 from windows server 2003 and replace in the OS you wanna use. Only windows OS

Quote:

---

Originally Posted by KREATOR

install windows server 2003... and if you dont wanna use windows server 2003 SP1 then get the winsock and winsock from windows server 2003 and replace in the OS you wanna use. Only windows OS

---

That works?, if i have Windows Server 2008 can i use the Winsock of Windows XP that works perfectly?.

This problem has nothing to do with DataBase, cuz i use the same DataBase on different PC and on one PC the INVALID_SOCKET shows , and the other PC no.

yes, thats what i did, im using windows server 2008 enterprise with winsock and winsock2 from windows server 2003 enterprise SP1 and it works perfect... That will fix the error in gameserver and in connectserver

Quote:

---

Originally Posted by KREATOR

yes, thats what i did, im using windows server 2008 enterprise with winsock and winsock2 from windows server 2003 enterprise SP1 and it works perfect... That will fix the error in gameserver and in connectserver

---

You know that Windows Server 2008 the Winsock are a lot of different than the Windows 2003 SP1?.

Because it use the Technlogy of IPv6, i dont know if it will work.. I have the same Windows Server version than you could you give me your winsock and wisock2?, cuz im searching on google and i dont found anything.

hey , i have a problem ->
Server: Msg 446, Level 16, State 9, Procedure WZ_CONNECT_MEMB, Line 61
Cannot resolve collation conflict for equal to operation.
??? `WZ_CONNECT_MEMB` i no have it , someone please post it .

Quote:

---

Originally Posted by EntretenimientO

You know that Windows Server 2008 the Winsock are a lot of different than the Windows 2003 SP1?.

Because it use the Technlogy of IPv6, i dont know if it will work.. I have the same Windows Server version than you could you give me your winsock and wisock2?, cuz im searching on google and i dont found anything.

---

Im telling you it works because thats what i did with my server. Thats what i have right now and i have NO problems! The only thing youll find is that you wont be able to go on the internet with IE, just use FireFox..

My Winsocks

This dont fix the Problem!!!...

I already try with the Winsock..

Still disconnecting the people..

ur doing something wrong then... i fixed this problem doing what i said...

I do what you say...

I have on the reg the one from the Windows 2003 SP1. Afther i put the Winsock and Winsock2 i restart

My IE dont work like you say, so im Using Firefox.

And the problem still afther 3 o 4 hours..

On Win2k3 R2 will work?, or only Win2k3 SP1?

i have this error on Windows 2k3 Standart edition Sp2

Quote:

---

Originally Posted by EntretenimientO

I do what you say...

I have on the reg the one from the Windows 2003 SP1. Afther i put the Winsock and Winsock2 i restart

My IE dont work like you say, so im Using Firefox.

And the problem still afther 3 o 4 hours..

On Win2k3 R2 will work?, or only Win2k3 SP1?

---

I used Windows server 2003 Enterprise R2 SP1 and it was all ok, i also used windows server 2003 Enterprise SP1 and it was all ok... No errors at all...

Quote:

---

Originally Posted by DragonMU

i have this error on Windows 2k3 Standart edition Sp2

---

Get it with SP1 or follow the guide on the first post...

Quote:

---

I used Windows server 2003 Enterprise R2 SP1 and it was all ok, i also used windows server 2003 Enterprise SP1 and it was all ok... No errors at all...

---

You say me that you are using 2008..

This error dont show afther 10 minutes, this error show afther like 3 Hours, so its hard to say no error, cuz some people i think that test for 30 minutes and no error, so they Say "no error at all"..

Win2k3 R2 Sp1 and on Win2k3 SP1 will work?, which is better R2 or without R2?. You are sue that with R2 SP1 will work?.

It says cleary I USED (past tense). This is the Nth time im telling you it worked for me because thats what im using, windows server 2008 enterprise with winsocks from windows server 2003 enterprise R2 SP1 and my servers is up 24/7

I will Pay 100us$ to change the OS to Win2k3 SP1.. I hope it work!.:thumbup:

Quote:

---

Originally Posted by EntretenimientO

I will Pay 100us$ to change the OS to Win2k3 SP1.. I hope it work!.:thumbup:

---

i have win2k3 SP1 but i have error L1 closeclient error :O:

Install Windows Server 2003 SP 1, free of problems here normally use.

already installed Windows Server 2003 SP 1 and I'm getting this error.
now trying Windows Server 2003 (Without SP1)

i try them all and i have the problem again...
we dont have a slolution for this?

If you dont want to have that problem just use win2k8 with sp2. All updates are needed cuz of security reasons. And if you dont have win2k3 with sp2 you dont have all the security updates...

As far as i see (maybe i am wrong) it's about SP2 no matter what you use XP 32/64 bit,Win2k3 ... or maybe it has nothing to do with OS you use ... i have XP64 bit with SP2 and GS closes exactly after 8 hours of running, it's fucking anoying. Now i don't know if you have to run some code in the GS, or maybe it has nothing to do with it but someone can put a reliable working solution for this ?? I don't think is a data base related problem, i don't see how, it'a about connection from the server to any PC wich is connected on the server and reverse ...

Quote:

---

Originally Posted by Taurus2001

As far as i see (maybe i am wrong) it's about SP2 no matter what you use XP 32/64 bit,Win2k3 ... or maybe it has nothing to do with OS you use ... i have XP64 bit with SP2 and GS closes exactly after 8 hours of running, it's fucking anoying. Now i don't know if you have to run some code in the GS, or maybe it has nothing to do with it but someone can put a reliable working solution for this ?? I don't think is a data base related problem, i don't see how, it'a about connection from the server to any PC wich is connected on the server and reverse ...

---

Gembrid wrote an excellent guide. Working perfect.

one question. will the SP3 solve this problem?!

I use windows 2003 server sp1 and got the same problem running the querys, some new fixes for this?
Version: 1.05 + Season 4 SCF

This really doesn't have anything to do with DB.
Looks like either Webzen failed at proper coding the IOCP or someone fuc*ed the server with their ub3r coding skills AND only after that it could lead to generate a failure in the DB or anywhere else and then the socket is terminated.

So the only way to fix this is to search for all the places where the sockets are being closed and there just disable the output and it won't bother you, but the problem probably is that either the player closed the client by forcing to terminate the process or there was a failure in the communication for example a problem sending data or receiving or some parts of packet were lost and so on...

Quote:

---

Originally Posted by KREATOR

It says cleary I USED (past tense). This is the Nth time im telling you it worked for me because thats what im using, windows server 2008 enterprise with winsocks from windows server 2003 enterprise R2 SP1 and my servers is up 24/7

---

u can put again the download link of winsock ?
i'm using like u windows server 2008 :/: and have this error...

Quote:

---

Originally Posted by Diabolik

u can put again the download link of winsock ?
i'm using like u windows server 2008 :/: and have this error...

---

I need it too, if anyone can re-upload will be good =(

OMG. This post is from 2008, and this query and winsock modificactions dont work to fix that problem.

The realy fix : install win 2003 sp1

Anyone knows how to Fix without installing Windows Server 2003 Sp1 ?

If so, please reply.

Thanks :)

Quote:

---

Originally Posted by sh4dOwMuAvenger

Anyone knows how to Fix without installing Windows Server 2003 Sp1 ?

If so, please reply.

Thanks :)

---

Try running this sql queries on ur muonline database:

1.

Code:

---

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

---

2.

Code:

---

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

---

Quote:

---

Originally Posted by KarLi

Try running this sql queries on ur muonline database:

1.

Code:

---

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

---

2.

Code:

---

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

---

---

Dont work :(

Gotta change OS then mate.

Win 7 64 can have this problem? i use that OS

- - - Updated - - -

I don't know if it totally works, but i used it and cleared all the "connected" accounts.....
UPDATE MEMB_STAT
SET ConnectStat=0 where ConnectStat=1

Windows 7 and this error. I just changed .dll file in Client from other version to new. Old one work good, new had this problem.

I use Windows Server 2008 R2 pack 1 x64 and have same problem appears in the Data Server "error-L1 : CloseClient INVALID_SOCKET"
After 24 hours players can no longer connect on server.

What to do?

maybe get service pack 2 if possible, else i think change OSwill be the solution or to change CPUCOUNT to 1

I have a problem with TitanLinkServer
server files 11.70.52
baules not open and when they open store things and then deletes them
I do not understand from where the mistake
slow logins
werehouse slowhis happens every 30 minutes and then settled and then another 30 minutes reoccurs

Error LOG
[DataServer1] error-L1 : CloseClient INVALID_SOCKET

My Sistem
SO : Windows Server 2008 R2 SP1
SQL 2000 + SP4
All Framenetwork
test all query

use windows2003 service pack 1 . problem will be fixed.

i get this error after using second query

Msg 468, Level 16, State 9, Procedure WZ_CONNECT_MEMB, Line 61
Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Korean_Wansung_CI_AS" in the is operation.

how fix?