Manually fix "Acc already connected"

If you use the joinserver from luciano w/e beta you have do it like this:

Open joinserver select user now be carefull if you refresh list and select account from there it won't work, so do it like this type the account name on the search window select it and press "Compulsory user disconnect" and it will work

It really works !

Thx to andr33aa

Of course it works, since you compolsory disconnect them from the joinserver -.-"

xDD

Dude i use this:

WZ_DISCONNECT_MEMB

CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0
Set @find_id = 'NOT'
select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id collate Chinese_PRC_CI_AS
where I.memb___id = @memb___id collate Chinese_PRC_CI_AS

if( @find_id <> 'NOT' )
begin
update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate()
where memb___id = @memb___id
end
end
GO



and work fo me !!!

yes works :)) thx dude

Tested and works,

GOod job

nothing new, this is for any version...is a manually option for disconnect users without enter to game...

Well Tanx Anyway... ;)

Quote:

---

Originally Posted by skurbold

Dude i use this:

WZ_DISCONNECT_MEMB

CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0
Set @find_id = 'NOT'
select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id collate Chinese_PRC_CI_AS
where I.memb___id = @memb___id collate Chinese_PRC_CI_AS

if( @find_id <> 'NOT' )
begin
update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate()
where memb___id = @memb___id
end
end
GO



and work fo me !!!

---

is it just replace the original WZ_DISCONNECT_MEMB stored procedure by this one? is that all?

tryed and works... thanks alot.... feel so stupid now..

Quote:

---

Originally Posted by Mulegend

nothing new, this is for any version...is a manually option for disconnect users without enter to game...

---

It's no nothing new, because on most join servers you can't just refresh the list and disconnect them, because its bugged! The whole thingy was about search...

Quote:

---

Originally Posted by skurbold

Dude i use this:

WZ_DISCONNECT_MEMB

CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0
Set @find_id = 'NOT'
select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id collate Chinese_PRC_CI_AS
where I.memb___id = @memb___id collate Chinese_PRC_CI_AS

if( @find_id <> 'NOT' )
begin
update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate()
where memb___id = @memb___id
end
end
GO



and work fo me !!!

---

Wtf is that crap? Just removed the comments from the original one and added the collate thingy o_O The whole problem is between main>GS>JS

Can some tell me what means PRC, CI e AS in "collate Chinese_PRC_CI_AS"?

thx man, it helped :P

Works. Thx Man

worked for me too. thanks

used this >> UPDATE MEMB_STAT SET CONNECTSTAT = 0
add that in query analyzer