Konu Yazar
bykadir57
Active Member
- Nis
- 6,140
- 0
iletişim:[email protected]
Servere girişte pasword hatası veriyor yardım etcek varmı...?
- Konbuyu başlatan bykadir57
- Başlangıç tarihi
daraske
Member
- Ara
- 201
- 0
Cevap: Servere girişte pasword hatası veriyor yardım etcek varmı...?
bu kodları query analayzere yapıştır F5 yap
"kodlar bana ait değildir"
CREATE PROCEDURE [dbo].[STNQ3R_LOGINPROC] @AccountID varchar(21), @Password varchar(32), @nret smallint output AS -- # Prosedur Bana ait degildir kime aittir bilmiyorum ama eline saglik saygilar stnq3r # ---- # Turkish Character Letters And SQL Injection Disabled Start # -- IF (CHARINDEX('þ',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR (CHARINDEX('ð',@AccountID) <> 0) OR (CHARINDEX('ö',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ç',@AccountID) <> 0) OR (CHARINDEX('ş',@AccountID) <> 0) OR (CHARINDEX('@',@AccountID) <> 0) OR (CHARINDEX('+',@AccountID) <> 0) OR (CHARINDEX('-',@AccountID) <> 0) OR (CHARINDEX('=',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ğ',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR (CHARINDEX('''',@AccountID) <> 0) BEGIN SET @nRet = 2 RETURN END IF (CHARINDEX('þ',@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR (CHARINDEX('ð',@Password) <> 0) OR (CHARINDEX('ö',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ç',@Password) <> 0) OR (CHARINDEX('ş',@Password) <> 0) OR (CHARINDEX('@',@Password) <> 0) OR (CHARINDEX('+',@Password) <> 0) OR (CHARINDEX('-',@Password) <> 0) OR (CHARINDEX('=',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ğ',@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR (CHARINDEX('''',@Password) <> 0) BEGIN SET @nRet = 3 RETURN END -- # Turkish Character Letters and SQL Injection Disabled End # -- -- # Account Nation Transfers Queue # -- EXEC ACCOUNT_NATION_TRANSFER '' -- # Account Nation Transfers Queue # -- -- # Truncate Table # -- Select @nRet = Count(strAccountID) From TB_USER Where strAccountID = @AccountID -- # Truncate Table # -- -- # Game Options System Start # -- DECLARE @ProcedureName nvarchar(255) SET @ProcedureName = 'ACCOUNT_LOGIN' -- # Game Options System End # -- -- # Check Account # -- IF @nRet = 0 BEGIN INSERT INTO TB_USER (strAccountID, strpasswd, strSocNo, idays) VALUES (@AccountID, @Password, 1, '6') END DECLARE @pwd varchar(32), @Authority int, @count int, @Nation int, @CharNum int BEGIN SELECT @pwd = strPasswd FROM kn_online.dbo.TB_USER WHERE strAccountID = @AccountID IF @pwd IS null BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END ELSE IF @pwd <> @Password BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END -- Retrieve account data SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID -- Account does not exits IF @@ROWCOUNT = 0 BEGIN SET @nRet = 0 RETURN END -- Banned IF @Authority = 255 BEGIN SET @nRet = 0 RETURN END -- Empty password ELSE IF @pwd IS NULL BEGIN SET @nRet = 0 RETURN END -- Invalid password ELSE IF @pwd <> @Password BEGIN SET @nRet = 0 RETURN END -- # Check Account # -- -- # 3 Day's Premium # -- DECLARE @Premium varchar(21) SELECT @Premium = count(straccountid) FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID IF @Premium = 0 BEGIN INSERT INTO PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3) END -- #3 Day's Premium -- # Nation check # -- SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @@ROWCOUNT = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF @CharNum = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 1) BEGIN -- Nation Karus SET @nRet = 2 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 2) BEGIN -- Nation Human SET @nRet = 3 RETURN END END -- # Nation check # --GO
bu kodları query analayzere yapıştır F5 yap
"kodlar bana ait değildir alınıtıdır"
CREATE PROCEDURE [dbo].[STNQ3R_LOGINPROC] @AccountID varchar(21), @Password varchar(32), @nret smallint output AS -- # Prosedur Bana ait degildir kime aittir bilmiyorum ama eline saglik saygilar stnq3r # ---- # Turkish Character Letters And SQL Injection Disabled Start # -- IF (CHARINDEX('þ',@AccountID) <> 0) OR (CHARINDEX('ý',@AccountID) <> 0) OR (CHARINDEX('ð',@AccountID) <> 0) OR (CHARINDEX('ö',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ç',@AccountID) <> 0) OR (CHARINDEX('þ',@AccountID) <> 0) OR (CHARINDEX('@',@AccountID) <> 0) OR (CHARINDEX('+',@AccountID) <> 0) OR (CHARINDEX('-',@AccountID) <> 0) OR (CHARINDEX('=',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ð',@AccountID) <> 0) OR (CHARINDEX('ý',@AccountID) <> 0) OR (CHARINDEX('''',@AccountID) <> 0) BEGIN SET @nRet = 2 RETURN END IF (CHARINDEX('þ',@Password) <> 0) OR (CHARINDEX('ý',@Password) <> 0) OR (CHARINDEX('ð',@Password) <> 0) OR (CHARINDEX('ö',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ç',@Password) <> 0) OR (CHARINDEX('þ',@Password) <> 0) OR (CHARINDEX('@',@Password) <> 0) OR (CHARINDEX('+',@Password) <> 0) OR (CHARINDEX('-',@Password) <> 0) OR (CHARINDEX('=',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ð',@Password) <> 0) OR (CHARINDEX('ý',@Password) <> 0) OR (CHARINDEX('''',@Password) <> 0) BEGIN SET @nRet = 3 RETURN END -- # Turkish Character Letters and SQL Injection Disabled End # -- -- # Account Nation Transfers Queue # -- EXEC ACCOUNT_NATION_TRANSFER '' -- # Account Nation Transfers Queue # -- -- # Truncate Table # -- Select @nRet = Count(strAccountID) From TB_USER Where strAccountID = @AccountID -- # Truncate Table # -- -- # Game Options System Start # -- DECLARE @ProcedureName nvarchar(255) SET @ProcedureName = 'ACCOUNT_LOGIN' -- # Game Options System End # -- -- # Check Account # -- IF @nRet = 0 BEGIN INSERT INTO TB_USER (strAccountID, strpasswd, strSocNo, idays) VALUES (@AccountID, @Password, 1, '6') END DECLARE @pwd varchar(32), @Authority int, @count int, @Nation int, @CharNum int BEGIN SELECT @pwd = strPasswd FROM kn_online.dbo.TB_USER WHERE strAccountID = @AccountID IF @pwd IS null BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END ELSE IF @pwd <> @Password BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END -- Retrieve account data SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID -- Account does not exits IF @@ROWCOUNT = 0 BEGIN SET @nRet = 0 RETURN END -- Banned IF @Authority = 255 BEGIN SET @nRet = 0 RETURN END -- Empty password ELSE IF @pwd IS NULL BEGIN SET @nRet = 0 RETURN END -- Invalid password ELSE IF @pwd <> @Password BEGIN SET @nRet = 0 RETURN END -- # Check Account # -- -- # 3 Day's Premium # -- DECLARE @Premium varchar(21) SELECT @Premium = count(straccountid) FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID IF @Premium = 0 BEGIN INSERT INTO PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3) END -- #3 Day's Premium -- # Nation check # -- SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @@ROWCOUNT = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF @CharNum = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 1) BEGIN -- Nation Karus SET @nRet = 2 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 2) BEGIN -- Nation Human SET @nRet = 3 RETURN END END -- # Nation check # --GO
bu kodları query analayzere yapıştır F5 yap
"kodlar bana ait değildir"
CREATE PROCEDURE [dbo].[STNQ3R_LOGINPROC] @AccountID varchar(21), @Password varchar(32), @nret smallint output AS -- # Prosedur Bana ait degildir kime aittir bilmiyorum ama eline saglik saygilar stnq3r # ---- # Turkish Character Letters And SQL Injection Disabled Start # -- IF (CHARINDEX('þ',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR (CHARINDEX('ð',@AccountID) <> 0) OR (CHARINDEX('ö',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ç',@AccountID) <> 0) OR (CHARINDEX('ş',@AccountID) <> 0) OR (CHARINDEX('@',@AccountID) <> 0) OR (CHARINDEX('+',@AccountID) <> 0) OR (CHARINDEX('-',@AccountID) <> 0) OR (CHARINDEX('=',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ğ',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR (CHARINDEX('''',@AccountID) <> 0) BEGIN SET @nRet = 2 RETURN END IF (CHARINDEX('þ',@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR (CHARINDEX('ð',@Password) <> 0) OR (CHARINDEX('ö',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ç',@Password) <> 0) OR (CHARINDEX('ş',@Password) <> 0) OR (CHARINDEX('@',@Password) <> 0) OR (CHARINDEX('+',@Password) <> 0) OR (CHARINDEX('-',@Password) <> 0) OR (CHARINDEX('=',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ğ',@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR (CHARINDEX('''',@Password) <> 0) BEGIN SET @nRet = 3 RETURN END -- # Turkish Character Letters and SQL Injection Disabled End # -- -- # Account Nation Transfers Queue # -- EXEC ACCOUNT_NATION_TRANSFER '' -- # Account Nation Transfers Queue # -- -- # Truncate Table # -- Select @nRet = Count(strAccountID) From TB_USER Where strAccountID = @AccountID -- # Truncate Table # -- -- # Game Options System Start # -- DECLARE @ProcedureName nvarchar(255) SET @ProcedureName = 'ACCOUNT_LOGIN' -- # Game Options System End # -- -- # Check Account # -- IF @nRet = 0 BEGIN INSERT INTO TB_USER (strAccountID, strpasswd, strSocNo, idays) VALUES (@AccountID, @Password, 1, '6') END DECLARE @pwd varchar(32), @Authority int, @count int, @Nation int, @CharNum int BEGIN SELECT @pwd = strPasswd FROM kn_online.dbo.TB_USER WHERE strAccountID = @AccountID IF @pwd IS null BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END ELSE IF @pwd <> @Password BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END -- Retrieve account data SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID -- Account does not exits IF @@ROWCOUNT = 0 BEGIN SET @nRet = 0 RETURN END -- Banned IF @Authority = 255 BEGIN SET @nRet = 0 RETURN END -- Empty password ELSE IF @pwd IS NULL BEGIN SET @nRet = 0 RETURN END -- Invalid password ELSE IF @pwd <> @Password BEGIN SET @nRet = 0 RETURN END -- # Check Account # -- -- # 3 Day's Premium # -- DECLARE @Premium varchar(21) SELECT @Premium = count(straccountid) FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID IF @Premium = 0 BEGIN INSERT INTO PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3) END -- #3 Day's Premium -- # Nation check # -- SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @@ROWCOUNT = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF @CharNum = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 1) BEGIN -- Nation Karus SET @nRet = 2 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 2) BEGIN -- Nation Human SET @nRet = 3 RETURN END END -- # Nation check # --GO
bu kodları query analayzere yapıştır F5 yap
"kodlar bana ait değildir alınıtıdır"
CREATE PROCEDURE [dbo].[STNQ3R_LOGINPROC] @AccountID varchar(21), @Password varchar(32), @nret smallint output AS -- # Prosedur Bana ait degildir kime aittir bilmiyorum ama eline saglik saygilar stnq3r # ---- # Turkish Character Letters And SQL Injection Disabled Start # -- IF (CHARINDEX('þ',@AccountID) <> 0) OR (CHARINDEX('ý',@AccountID) <> 0) OR (CHARINDEX('ð',@AccountID) <> 0) OR (CHARINDEX('ö',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ç',@AccountID) <> 0) OR (CHARINDEX('þ',@AccountID) <> 0) OR (CHARINDEX('@',@AccountID) <> 0) OR (CHARINDEX('+',@AccountID) <> 0) OR (CHARINDEX('-',@AccountID) <> 0) OR (CHARINDEX('=',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ð',@AccountID) <> 0) OR (CHARINDEX('ý',@AccountID) <> 0) OR (CHARINDEX('''',@AccountID) <> 0) BEGIN SET @nRet = 2 RETURN END IF (CHARINDEX('þ',@Password) <> 0) OR (CHARINDEX('ý',@Password) <> 0) OR (CHARINDEX('ð',@Password) <> 0) OR (CHARINDEX('ö',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ç',@Password) <> 0) OR (CHARINDEX('þ',@Password) <> 0) OR (CHARINDEX('@',@Password) <> 0) OR (CHARINDEX('+',@Password) <> 0) OR (CHARINDEX('-',@Password) <> 0) OR (CHARINDEX('=',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ð',@Password) <> 0) OR (CHARINDEX('ý',@Password) <> 0) OR (CHARINDEX('''',@Password) <> 0) BEGIN SET @nRet = 3 RETURN END -- # Turkish Character Letters and SQL Injection Disabled End # -- -- # Account Nation Transfers Queue # -- EXEC ACCOUNT_NATION_TRANSFER '' -- # Account Nation Transfers Queue # -- -- # Truncate Table # -- Select @nRet = Count(strAccountID) From TB_USER Where strAccountID = @AccountID -- # Truncate Table # -- -- # Game Options System Start # -- DECLARE @ProcedureName nvarchar(255) SET @ProcedureName = 'ACCOUNT_LOGIN' -- # Game Options System End # -- -- # Check Account # -- IF @nRet = 0 BEGIN INSERT INTO TB_USER (strAccountID, strpasswd, strSocNo, idays) VALUES (@AccountID, @Password, 1, '6') END DECLARE @pwd varchar(32), @Authority int, @count int, @Nation int, @CharNum int BEGIN SELECT @pwd = strPasswd FROM kn_online.dbo.TB_USER WHERE strAccountID = @AccountID IF @pwd IS null BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END ELSE IF @pwd <> @Password BEGIN -- Sucessfully connecto to Server but failed logging into the game. (255) SET @nRet = 0 RETURN END -- Retrieve account data SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID -- Account does not exits IF @@ROWCOUNT = 0 BEGIN SET @nRet = 0 RETURN END -- Banned IF @Authority = 255 BEGIN SET @nRet = 0 RETURN END -- Empty password ELSE IF @pwd IS NULL BEGIN SET @nRet = 0 RETURN END -- Invalid password ELSE IF @pwd <> @Password BEGIN SET @nRet = 0 RETURN END -- # Check Account # -- -- # 3 Day's Premium # -- DECLARE @Premium varchar(21) SELECT @Premium = count(straccountid) FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID IF @Premium = 0 BEGIN INSERT INTO PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3) END -- #3 Day's Premium -- # Nation check # -- SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @@ROWCOUNT = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF @CharNum = 0 BEGIN -- Select Nation New Account SET @nRet = 1 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 1) BEGIN -- Nation Karus SET @nRet = 2 RETURN END ELSE IF (@CharNum <> 0) AND (@Nation = 2) BEGIN -- Nation Human SET @nRet = 3 RETURN END END -- # Nation check # --GO