- Konu Yazar
- #1
Hello i have neronlineworld db wth server files and i cant connect to the server
"FAILED LOG. in to game server (255)"
Aujard log :
HELP ME !!!
---------- Yorum eklendi 03:24'da ---------- Önceki yorum 02:31'da ----------
here is ACCOUNT_LOGIN procedure
"FAILED LOG. in to game server (255)"
Aujard log :
Kod:
Aujard Start : 5żů 18ŔĎ 13˝Ă 34şĐ
2012-5-18 13:36, * Packet Count : recv=0, send=0, realsend=0 , time = 13:36
2012-5-18 13:38, * Packet Count : recv=0, send=0, realsend=0 , time = 13:38
2012-5-18 13:40, * Packet Count : recv=0, send=0, realsend=0 , time = 13:40
2012-5-18 13:42, * Packet Count : recv=0, send=0, realsend=0 , time = 13:42
Aujard Start : 5żů 18ŔĎ 13˝Ă 44şĐ
2012-5-18 13:46, * Packet Count : recv=0, send=0, realsend=0 , time = 13:46
2012-5-18 13:48, * Packet Count : recv=0, send=0, realsend=0 , time = 13:48
2012-5-18 13:50, * Packet Count : recv=0, send=0, realsend=0 , time = 13:50
2012-5-18 13:52, * Packet Count : recv=0, send=0, realsend=0 , time = 13:52
2012-5-18 13:54, * Packet Count : recv=0, send=0, realsend=0 , time = 13:54
2012-5-18 13:56, * Packet Count : recv=0, send=0, realsend=0 , time = 13:56
2012-5-18 13:58, * Packet Count : recv=0, send=0, realsend=0 , time = 13:58
2012-5-18 14:0, * Packet Count : recv=0, send=0, realsend=0 , time = 14:0
Aujard Start : 5żů 18ŔĎ 14˝Ă 9şĐ
2012-5-18 14:11, * Packet Count : recv=0, send=0, realsend=0 , time = 14:11
2012-5-18 14:13, * Packet Count : recv=0, send=0, realsend=0 , time = 14:13
2012-5-18 14:15, * Packet Count : recv=0, send=0, realsend=0 , time = 14:15
2012-5-18 14:17, * Packet Count : recv=0, send=0, realsend=0 , time = 14:17
Aujard Start : 5żů 18ŔĎ 14˝Ă 22şĐ
2012-5-18 14:24, * Packet Count : recv=0, send=0, realsend=0 , time = 14:24
Aujard Start : 5żů 18ŔĎ 14˝Ă 26şĐ
2012-5-18 14:28, * Packet Count : recv=0, send=0, realsend=0 , time = 14:28
HELP ME !!!
---------- Yorum eklendi 03:24'da ---------- Önceki yorum 02:31'da ----------
here is ACCOUNT_LOGIN procedure
Kod:
CREATE PROCEDURE dbo.ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(50),
@nRet smallint OUTPUT
AS
/*
Author: Nero
*/
DECLARE @AccountID2 varchar(50), @Password2 varchar(50), @Authority smallint, @Char1 smallint, @Char2 smallint, @Char3 smallint
SELECT @Char1 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID1 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID1 IS NOT NULL)
SELECT @Char2 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID2 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID2 IS NOT NULL)
SELECT @Char3 = Authority FROM USERDATA WHERE strUserID = (SELECT strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID and strCharID3 IS NOT NULL)
IF @Char1 = 255 or @Char2 = 255 or @Char3 = 255
BEGIN
UPDATE TB_USER SET strAuthority = 255 where strAccountID = @AccountID
END
ELSE
BEGIN
UPDATE TB_USER SET strAuthority = 0 where strAccountID = @AccountID
END
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays) VALUES (@AccountID, @Password, 1, '6')
END
/*
SELECT @AccountID2 = COUNT(strAccountID) FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @AccountID2 = 0
BEGIN
SET @nRet = 2 -- Account doesnt exist.
RETURN
END
*/
SELECT @Password2 = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID and iDays=6
IF @Password2 IS null or @Password2 != @Password
BEGIN
SET @nRet = 3 -- Invalid password.
RETURN
END
ELSE
IF @Authority = 255
BEGIN
SET @nRet = 4 -- Account is banned.
RETURN
END
ELSE
BEGIN
DELETE CURRENTUSER WHERE strAccountID = @AccountID
SET @nRet = 1
RETURN
END
GO