Need help with error

Durum
Üzgünüz bu konu cevaplar için kapatılmıştır...
D

davidecek

Yeni Üye
Katılım
17 Mayıs 2012
Mesajlar
10
Hello i have neronlineworld db wth server files and i cant connect to the server



"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
 
R

Rookie

Kayıtlı Üye
Katılım
8 Mart 2012
Mesajlar
187
change create_new_char
 
D

davidecek

Yeni Üye
Katılım
17 Mayıs 2012
Mesajlar
10
Rookie' Alıntı:
change create_new_char
Genişletmek için tıkla ...



how ? ... :)



---------- Yorum eklendi 07:52'da ---------- Önceki yorum 07:49'da ----------



my create_new_Char

Kod: 
CREATE PROCEDURE [dbo].[CREATE_NEW_CHAR]

@nRet		smallint OUTPUT, 

@AccountID 	char(21), 

@index 		tinyint,

@CharID	char(21),

@Race 	tinyint, 

@Class		smallint, 

@Hair 		tinyint,

@Face 		tinyint, 

@Str 		tinyint, 

@Sta 		tinyint, 

@Dex 		tinyint,

@Intel 		tinyint, 

@Cha 		tinyint

AS

DECLARE @Row tinyint, @Nation tinyint, @Zone tinyint, @PosX int, @PosZ int

	SET @Row = 0	SET @Nation = 0  SET @Zone = 0  SET @PosX = 0 SET @PosZ = 0

	SELECT @Nation = bNation, @Row = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID

	

	IF @Row >= 5	SET @nRet =  1

	

	IF @Nation = 1 AND @Race > 10	SET @nRet = 2

	ELSE IF @Nation = 2 AND @Race < 10	SET @nRet = 2

	ELSE IF @Nation <>1 AND @Nation <> 2	SET @nRet = 2

	IF @nRet > 0

		RETURN

	SELECT @Row = COUNT(*) FROM USERDATA WHERE strUserId = @CharID

	IF @Row > 0 

	BEGIN

		SET @nRet =  3

		RETURN

	END

-- inserted by samma 2003.07.10

	SELECT @Row = COUNT(*) FROM ACCOUNT_CHAR WHERE strCharID1 = @CharID or strCharID2 = @CharID or strCharID3 = @CharID

	IF @Row > 0 

	BEGIN

		SET @nRet =  3

		RETURN

	END

-- inserted by samma 2003.07.10

	--SET @Zone = @Nation

	SET @Zone=21

	SELECT @PosX = InitX, @PosZ = InitZ  FROM ZONE_INFO WHERE ZoneNo = @Zone

BEGIN TRAN	

	IF @index = 0

		UPDATE ACCOUNT_CHAR SET strCharID1 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

	ELSE IF @index = 1

		UPDATE ACCOUNT_CHAR SET strCharID2 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

	ELSE IF @index = 2

		UPDATE ACCOUNT_CHAR SET strCharID3 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

	ELSE IF @index = 3

		UPDATE ACCOUNT_CHAR SET strCharID4 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

	ELSE IF @index = 4

		UPDATE ACCOUNT_CHAR SET strCharID5 = @CharID, bCharNum = bCharNum + 1 WHERE strAccountID = @AccountID

	

	INSERT INTO USERDATA (strUserId, Nation, Race, Class, HairColor, Face, Strong, Sta, Dex, Intel, Cha, Zone, PX, PZ ) 

	VALUES	 (@CharID, @Nation, @Race, @Class, @Hair, @Face, @Str, @Sta, @Dex, @Intel, @Cha, @Zone, @PosX, @PosZ )



	/* EXTRA */

	EXEC baslangicitem @CharID



	UPDATE USERDATA SET Class = 106 WHERE Class = 101 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 108 WHERE Class = 102 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 110 WHERE Class = 103 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 112 WHERE Class = 104 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 206 WHERE Class = 201 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 208 WHERE Class = 202 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 210 WHERE Class = 203 AND strUserId = @CharID

	UPDATE USERDATA SET Class = 212 WHERE Class = 204 AND strUserId = @CharID

	/* EXTRA */



	IF @@ERROR <> 0

	BEGIN	 

		ROLLBACK TRAN 

		SET @nRet =  4

		RETURN

	END

	

COMMIT TRAN

SET @nRet =  0

GO
 
R

Rookie

Kayıtlı Üye
Katılım
8 Mart 2012
Mesajlar
187
get it from another database and inject your create_new_char procedure
 
R

Rookie

Kayıtlı Üye
Katılım
8 Mart 2012
Mesajlar
187
Are you using another aujard ? only 1886 server files running



---------- Yorum eklendi 10:50'da ---------- Önceki yorum 10:47'da ----------



you problem is not procedure , you aujard use a different
 
Durum
Üzgünüz bu konu cevaplar için kapatılmıştır...

KoCuce Hakkında

Ko-Fox 2014 yılından bu yana pvp serverler tanıtım sektöründe öncü tanıtım sitesi olarak yayın hayatına devam eden bir private server forum sitesidir. 2014 yılından bu yana ko-fox.com olarak hizmet veren ve tüm oyunlara oyuncu katkısı sağlayan bir lider platform'dur frmtr

Ko-Cuce Links

En yeni üyeler

Sosyal bağlar

Üst Alt
Reklam
Reklam Banner
Reklam
Reklam Banner

Reklam Resmi
X