Resolve "Account Already Connected" Problem

well god guide but i have some one kuestion how i do if my wanip always chage need always edit my wanip???:vegeta:

Quote:

---

Originally Posted by powerfulpk

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?

---

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

Quote:

---

Originally Posted by powerfulpk

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?

---

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

Quote:

---

Originally Posted by powerfulpk

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?

---

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.

Quote:

---

Originally Posted by matrix17

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.

---

Yeah.. :/

Quote:

---

Originally Posted by kewtrewt

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

---

Sorry my noob question, but can any explain how and here we enter this ?
Thks in advance

so, no solution to this? I've already changed WZ_* procedures and nothing. Maybe I should give up CS

[QUOTE=nkerz;2035318]so, no solution to this? I've already changed WZ_* procedures and nothing. Maybe I should give up CS

Quote:

---

Originally Posted by techbyte

Can you tell how we change it pls
Thks

---

erm.. what you mean? just double click those function in SQL Server Manager and it will appear a window with the code o_O

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 ?

I am facing the same problem.

Same problem here..
have to disconnect player manually
any solution to this problem ?

Quote:

---

Originally Posted by kewtrewt

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

---

---

Someone explain please how i enter and where i need to enter this procedure?
Thanks

[quote=Z80;1536589]
1) You [B]DON

Same problem ...
Someone have script to disconnect people from web ?

i have this error too... someone maybe fixed this?

Same problem ...
Please someone who know the solution? Thanks

1. Stop GameServer
2. Run with Query Analyzer this:

Code:

---

UPDATE MEMB_STAT
SET ConnectStat='0'
WHERE ConnectStat>0

---

3. Start GameServer again.

This is all.

Quote:

---

Originally Posted by bate_jello

1. Stop GameServer
2. Run with Query Analyzer this:

Code:

---

UPDATE MEMB_STAT
SET ConnectStat='0'
WHERE ConnectStat>0

---

3. Start GameServer again.

This is all.

---

Tested and Worked, thank you very much!!

thp up !!!

Quote:

---

Originally Posted by Diabolik

thp up !!!

---

http://forum.ragezone.com/f197/relea...ct-dll-511299/

Hello

MapServerInfo

Quote:

---

0
0 0 1 Sdgmu.dyn.pl 55917
2 0 1 Sdgmu.dyn.pl 55901
19 0 0 Sdgmu.dyn.pl 55919
end

1
0 0 30 19
0 0 31 19
0 0 34 19

2 0 30 19
2 0 31 19
2 0 34 19

19 1 30 -1
19 1 31 -1
19 1 34 -1
end

---

And i dont have nothing in C:// / WINDOWS / system32 /Drivers / Etc / hosts


Please help:P?


What i must do to repeir this problem/bug , i must fast fix that.

Quote:

---

Originally Posted by kewtrewt

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

---

is this for all versions including season 4?

i aso need T_T for session4