[Help] Rellog Problem

[Supernatural]

Hi all,

i have a problem with relog, allways when i go off and relog i cant login in. When i try it account is in use and i must restart server, eny one knows how can i fix?? Sry for my englis

[MentaL]

[kandykane]

I have the same problem .. :(

[q12345]

It's your DB, and account_logout proc is messed up, (I think).

[kandykane]

Well think ya could hook us up a fix? I hate clearin accounts every logout lol

[q12345]

CREATE PROCEDURE [dbo].[ACCOUNT_LOGOUT]
@AccountID varchar(21),
@ServerNo int,
@nRet smallint OUTPUT,
@nRet2 smallint OUTPUT

AS

BEGIN TRAN

DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID


COMMIT TRAN
SET @nRet = 1
SET @nRet2 = 1
GO

Try that, hopefully it'll work. Oh and:

CREATE PROCEDURE CLEAR_REMAIN_USERS
@AccountID varchar(50)
AS
BEGIN TRAN
DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
TRUNCATE TABLE CURRENTUSER
COMMIT TRAN

GO

Credits to whoever wrote them.

[kandykane]

I try it tomorrow,ty ~night~

[q12345]

Good luck.

[Supernatural]

Try that, hopefully it'll work. Oh and:



Credits to whoever wrote them.

i try it and nothing

[RascaL]

Is account_logout like ok?

~ RascaL

[Lagalos]

USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[ACCOUNT_LOGOUT]    Script Date: 05/09/2008 22:15:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[ACCOUNT_LOGOUT]
@AccountID	varchar(21),
@Password	varchar(13),
@a		smallint OUTPUT,
@nRet		smallint	OUTPUT
as
BEGIN TRAN
	DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
	
	DELETE FROM CURRENTUSER WHERE strCharID = @AccountID


COMMIT TRAN
BEGIN
set @a=1
set @nRet=1 
RETURN
END

try that

[Supernatural]

hi i all i got it you mast creat procedure,

CREATE PROCEDURE ACCOUNT_LOGOUT 
@AccountID   varchar(21), 
@nRet      smallint   OUTPUT 
AS 
BEGIN TRAN 
   DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID 
    
COMMIT TRAN 
SET @nRet = 1 
GO