Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Problem With Character Reset

Status
Not open for further replies.
Junior Spellweaver
Joined
Aug 9, 2012
Messages
160
Reaction score
34
I`m using Titan Teech 11.11.82 Files and i have one problem. When try to reset an character it says to em that Account is connected on game, please logout.
But i`m 100% positive that account is not conected in game. I restarted server+mysql and still same. What should y do ?

Solved .
 
Newbie
Joined
Feb 13, 2011
Messages
772
Reaction score
69
I believe you started to experience that when you alter the procedure of WZ_DISCONNECT_MEMB, and it is related from these following http://forum.ragezone.com/f82/mucore-top-online-module-working-847278/ procedures.

I really dont know how to fixed that in order to work both from that link and the reset system in website, but if you want to fixed your reset system you need to delete your WZ_DISCONNECT_MEMB and create it again.

Heres the query for WZ_DISCONNECT_MEMB.
CREATE PROCEDURE WZ_DISCONNECT_MEMB

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


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

SET NOCOUNT OFF
End

GO

Hope it helps a bit.
 
Upvote 0
Status
Not open for further replies.
Back
Top