invalid password and no such registered ID...

My version is 1299.

i insert my account into the tbl TB_USER, i can log in the server for the first time, but when i log out and try the second login, i can not, as the warning 'invalid password '(actually,my password up tp 10 char) or 'no such registered ID'

i check my STORE PROCEDURE, it seems all right
as the Aujard log following:

Code:

---

2008-10-21 22:12-3, [AccountLogout] acname=hknight133, type = 2
2008-10-21 22:12-3, hknight133 : Insert Disconnected User List
2008-10-21 22:12-3, hknight133(2) : Billing End (0)Sent
2008-10-21 22:12-4, Logout(0) : hknight133, hkssfs1 (W:1,U:1)
2008-10-21 22:12-4, Invalid Logout : hknight133, hkssfs1 (W:1,U:1,A:-1) 2008-10-21 22:12-15, * Packet Count : recv=3, send=3, realsend=3
2008-10-21 22:12-15, Try to Connect To Session : 1
2008-10-21 22:12-15, Alive Packet Send : 0
2008-10-21 22:12-55, Try to Connect To Session : 1
2008-10-21 22:12-55, Alive Packet Send : 0
2008-10-21 22:13-35, Try to Connect To Session : 1
2008-10-21 22:13-35, Alive Packet Send : 0
2008-10-21 22:14-15, * Packet Count : recv=3, send=3, realsend=3
2008-10-21 22:14-15, Try to Connect To Session : 1
2008-10-21 22:14-15, Alive Packet Send : 0
2008-10-21 22:14-34, {call CHANGE_CASTLE_COMMERCE ( 0, 7, 0, 0, 0, 'default', 'default' )}
2008-10-21 22:14-34, {call KING_CHANGE_TAX ( 6, 0, 2751521, 0, 114238823, 44884095, 3331377, 365965330 )}
2008-10-21 22:14-55, Try to Connect To Session : 1
2008-10-21 22:14-55, Alive Packet Send : 0
2008-10-21 22:15-35, Try to Connect To Session : 1
2008-10-21 22:15-35, Alive Packet Send : 0
2008-10-21 22:16-15, * Packet Count : recv=3, send=3, realsend=3
2008-10-21 22:16-15, Try to Connect To Session : 1
2008-10-21 22:16-15, Alive Packet Send : 0
2008-10-21 22:17-0, Try to Connect To Session : 1
2008-10-21 22:17-0, Alive Packet Send : 0

---

the 'disconnect user list' is refering to some tables?

and the elmord gates do not work well, if u some nice guys have the transfered elmord maps or sth els, pls share with me, ill appreciate!!

no men here...its too early

Paste your ACCOUNT_LOGOUT proc.

Quote:

---

Originally Posted by IceMan1300

Paste your ACCOUNT_LOGOUT proc.

---

thx for ur reply,iceman!

here is my ACCOUNT_LOGIN PROC

Code:

---

CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT

AS


DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0

DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6
IF @pwd IS null
BEGIN
SET @nRet = 0
--SET @nRet = 4
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
--SET @nRet = 3
RETURN
END

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
--SET @nRet = 1
RETURN
END
GO

---

ACCOUNT_LOGOUT PROC as follow

Code:

---

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

---

and here is my version manager.exe and Ajuard.exe which im using right now, however, pls scan virus for ur PC!
they seem to work well, but i dont know whether my problems occured by these server exes.

Quote:

---

Originally Posted by HKjamie

and here is my version manager.exe and Ajuard.exe which im using right now, however, pls scan virus for ur PC!
they seem to work well, but i dont know whether my problems occured by these server exes.

---

Nothing absurdly wrong there.

Okay, now, is there any entries in Aujard.log? They could be the key to this.

Usually, when a procedure breaks, it adds that error to Aujard.log and breaks Aujard.

Quote:

---

Originally Posted by IceMan1300

Nothing absurdly wrong there.

Okay, now, is there any entries in Aujard.log? They could be the key to this.

Usually, when a procedure breaks, it adds that error to Aujard.log and breaks Aujard.

---

i translate this Aujard Log from chinese to english,may be not very correct.
#1 i dont know why and how the ACCOUNT_LOGOUT use the parameter '@nRnet'
#2 the LOAD_PREMIUM_SERVICE_USER is necessary?(i dont know whether this premium user function was added by some chinese private server GM to Aujard.exe)

Code:

---

2008-10-21 21:16, *** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet'，BUT NOT GIVEN。, 103 ***
2008-10-21 21:45, *** 37000, 2812, [Microsoft][ODBC SQL Server Driver][SQL Server]CAN NOT FIND PROCEDURE 'LOAD_PREMIUM_SERVICE_USER'。, 93 ***
2008-10-21 22:0, *** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet'，BUT NOT GIVEN。, 103 ***
2008-10-21 22:7, *** 37000, 2812, [Microsoft][ODBC SQL Server Driver][SQL Server]CAN NOT FIND PROCEDURE 'LOAD_PREMIUM_SERVICE_USER'。, 93 ***
2008-10-21 22:12, *** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet'，BUT NOT GIVEN。, 103 ***

---

Quote:

---

Originally Posted by HKjamie

i translate this Aujard Log from chinese to english,may be not very correct.
#1 i dont know why and how the ACCOUNT_LOGOUT use the parameter '@nRnet'
#2 the LOAD_PREMIUM_SERVICE_USER is necessary?(i dont know whether this premium user function was added by some chinese private server GM to Aujard.exe)

Code:

---

2008-10-21 21:16, *** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet'，BUT NOT GIVEN。, 103 ***
2008-10-21 21:45, *** 37000, 2812, [Microsoft][ODBC SQL Server Driver][SQL Server]CAN NOT FIND PROCEDURE 'LOAD_PREMIUM_SERVICE_USER'。, 93 ***
2008-10-21 22:0, *** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet'，BUT NOT GIVEN。, 103 ***
2008-10-21 22:7, *** 37000, 2812, [Microsoft][ODBC SQL Server Driver][SQL Server]CAN NOT FIND PROCEDURE 'LOAD_PREMIUM_SERVICE_USER'。, 93 ***
2008-10-21 22:12, *** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet'，BUT NOT GIVEN。, 103 ***

---

---

@nRet is an output parameter, not an input parameter.

Okay.
I'll be releasing a clean database sometime later, but for now this is LOAD_PREMIUM_SERVICE_USER procedure is going to be a 'dummy' proc.
Meaning, I don't know how your database works right now, but this proc will give all users 3 days of premium... forever. ;P

Code:

---

CREATE PROCEDURE [dbo].[LOAD_PREMIUM_SERVICE_USER]
    @AccountID varchar(21),
    @type int output,
    @days int output
AS
BEGIN
SET @days = 3
SET @type = 1
END

---

Now... as for ACCOUNT_LOGOUT:

Code:

---

ALTER PROCEDURE [dbo].[ACCOUNT_LOGOUT]
    @AccountID    varchar(21),
    @a        smallint OUTPUT,
    @nRet        smallint    OUTPUT
AS
    BEGIN
        DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
        UPDATE CONCURRENT SET zone2_count = (zone2_count - 1)
        SET @a = 1
        SET @nRet = 1
    END

---

thank u iceman but im also confused by 2 questions as follow
#1how u know we need THREE parameters when creating procdure LOAD_PREMIUM_USERS nd where @days @type go to?
#2what the TBL concurrent is using for?why u update the column zone2_count?

Quote:

---

Originally Posted by HKjamie

thank u iceman but im also confused by 2 questions as follow
#1how u know we need THREE parameters when creating procdure LOAD_PREMIUM_USERS nd where @days @type go to?
#2what the TBL concurrent is using for?why u update the column zone2_count?

---

1. @days and @type are again, output parameters. As such, they get returned to Aujard for further use.

2. To keep concurrent counts updating correctly; its not required, but its useful.

Quote:

---

Originally Posted by IceMan1300

1. @days and @type are again, output parameters. As such, they get returned to Aujard for further use.

2. To keep concurrent counts updating correctly; its not required, but its useful.

---

i tried ur advices but i also encountered the 'invalid' problem, it makes me so annoying.
would u share ur clean DB and the server files about 1299 version?
i tried many server exes in order to fix my problem, however, right now i cant start my own AI Server when i click the AI exe, nothing happening ;(

is there anybody to help me?

Again, paste the latest errors in Aujard.log.

Quote:

---

Originally Posted by IceMan1300

Again, paste the latest errors in Aujard.log.

---

again...i dont know why the proc need the @nRet

Code:

---

*** 37000, 201, [Microsoft][ODBC SQL Server Driver][SQL Server]PROCEDURE 'ACCOUNT_LOGOUT' NEED PARAMETER '@nRet' BUT NOT GIVEN 103 ***

---

nd also 'invalid logout'

Code:

---

[AccountLogout] acname=hknight133, type = 2
hknight133 : Insert Disconnected User List
hknight133(2) : Billing End (0)Sent
Logout(0) : hknight133, hkssfs1 (W:1,U:1)
Invalid Logout : hknight133, hkssfs1 (W:1,U:1,A:-1)

---

Code:

---

hknight133 : Insert Disconnected User List

---

what is the disconnected user list?one table in my db?what is the type=2 mean?
i know its very easy quetion...but i want to know