Resolve "Account Already Connected" Problem

This is JoinServer problem.

When we Disconnect player on moment when he changing serwers the GS kick him but on Join Server is on list.

Maybe when we do god disconnect procedure the bug disapper but HOW?;/
I tired desolve that problem...

sry for bad eng ;p
 
This problem is join server problem and disconnect procedure too.
Must do procedure to disconnect acc from joinserver when changing servers GS>GS_CS or GS_CS>GS run fail or player have DC on this time!

But how do this i dont know xD
 
Its Join Server Game Server and DC procedure problem too.
When player have dc on time when changing servers the GS or base? dont send procedure to JoinServer to close acc connection.

Acc stuck on JoinServer but not on GS.

It becose when player have DC on that method (when changing servers) gs dont send close acc packet to join server.

But how to fix that i dont know ;/
 
Its Join Server Game Server and DC procedure problem too.
When player have dc on time when changing servers the GS or base? dont send procedure to JoinServer to close acc connection.

Acc stuck on JoinServer but not on GS.

It becose when player have DC on that method (when changing servers) gs dont send close acc packet to join server.

But how to fix that i dont know ;/

ANY IDEAS?
 
powerfulpk said:
Its Join Server Game Server and DC procedure problem too.
When player have dc on time when changing servers the GS or base? dont send procedure to JoinServer to close acc connection.

Acc stuck on JoinServer but not on GS.

It becose when player have DC on that method (when changing servers) gs dont send close acc packet to join server.

But how to fix that i dont know ;/

ANY IDEAS?
Click to expand...
i've this procedure on disconnect_memb_1 but it doesn't works...why? for me it would be right!!! i've tried but on table "chaacter" the player rest on map 30 or 31 and at successive logon client crash ...if i connect newly the character rest online for joinserver and i do restart server !!!!!!

this is procedure wz_disconnect_memb_1

CREATE PROCEDURE WZ_DISCONNECT_MEMB_1
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0 --
 
powerfulpk said:
Its Join Server Game Server and DC procedure problem too.
When player have dc on time when changing servers the GS or base? dont send procedure to JoinServer to close acc connection.

Acc stuck on JoinServer but not on GS.

It becose when player have DC on that method (when changing servers) gs dont send close acc packet to join server.

But how to fix that i dont know ;/

ANY IDEAS?
Click to expand...
i've this procedure but it doesn't works and the character rest on map 30 or 31
after logout with the consequence that for joinserver remains connected...

this is my procedure..if someone find where's the error thanks !!!
CREATE PROCEDURE WZ_DISCONNECT_MEMB_1
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0 --
 
powerfulpk said:
Its Join Server Game Server and DC procedure problem too.
When player have dc on time when changing servers the GS or base? dont send procedure to JoinServer to close acc connection.

Acc stuck on JoinServer but not on GS.

It becose when player have DC on that method (when changing servers) gs dont send close acc packet to join server.

But how to fix that i dont know ;/

ANY IDEAS?
Click to expand...
i've this procedure but it doesn't works and the character rest on map 30 or 31
after logout with the consequence that for joinserver remains connected...

this is my procedure..if someone find where's the error thanks !!!


CREATE PROCEDURE WZ_DISCONNECT_MEMB_1
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0 --
 
Has anybody solved this problem yet? Account still got stuck in JoinServer when you got disconnected from warping to different GS no matter how you fix dc procedure, mapserverinfo and host file.
 
Re: [Guide] Resolve "Account Already Connected" Problem

matrix17 said:
Has anybody solved this problem yet? Account still got stuck in JoinServer when you got disconnected from warping to different GS no matter how you fix dc procedure, mapserverinfo and host file.
Click to expand...

Yeah.. :/
 
Re: [Guide] Resolve "Account Already Connected" Problem

kewtrewt said:
How i was saying here are the procedures.

Code: 
CREATE PROCEDURE WZ_CONNECT_MEMB 

@uid varchar(10),
@server varchar(15),
@uip varchar(15)
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,ConnectStat,ServerName,IP,  ConnectTM) values (
@uid,
'1',
@server,
@uip,
(getdate())
) 
End 

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION

SET NOCOUNT OFF 
End
GO

and the Disconnect one:

Code: 
CREATE PROCEDURE WZ_DISCONNECT_MEMB 

@uid varchar(10)
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 DisConnectTM = (getdate()), connectstat = '0'  WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ConnectStat,DisConnectTM) values (
@uid,
0,
(getdate())
) 
End 


IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION

SET NOCOUNT OFF 
End
GO

This work for me without any problem (with the condition that you have setted your server correctly).
Click to expand...

Sorry my noob question, but can any explain how and here we enter this ?
Thks in advance
 
Re: [Guide] Resolve "Account Already Connected" Problem

so, no solution to this? I've already changed WZ_* procedures and nothing. Maybe I should give up CS
 
Re: [Guide] Resolve "Account Already Connected" Problem

The problem with the Account Connected still exists if someone Disconnects without proper Exit from CS_GS.... He gets stuck in joinserver T_T

Anyone has fix for it ?
 
Re: [Guide] Resolve "Account Already Connected" Problem

kewtrewt said:
How i was saying here are the procedures.

Code: 
CREATE PROCEDURE WZ_CONNECT_MEMB 
 
@uid varchar(10),
@server varchar(15),
@uip varchar(15)
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,ConnectStat,ServerName,IP,  ConnectTM) values (
@uid,
'1',
@server,
@uip,
(getdate())
) 
End 
 
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION
 
SET NOCOUNT OFF 
End
GO

and the Disconnect one:

Code: 
CREATE PROCEDURE WZ_DISCONNECT_MEMB 
 
@uid varchar(10)
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 DisConnectTM = (getdate()), connectstat = '0'  WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ConnectStat,DisConnectTM) values (
@uid,
0,
(getdate())
) 
End 
 
 
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION
 
SET NOCOUNT OFF 
End
GO
Click to expand...

Someone explain please how i enter and where i need to enter this procedure?
Thanks
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
2,651
Guests online
16,604
Total visitors
19,255
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back