Şifre yanlış sorunu

[suskunkral_21]

Herşey tamam ama en son olarakta 1060 hatası veriyor

 

[Exquet]

Cevap: Şifre yanlış sorunu

Bu kodu Server kapı iken Qa yazdır.
Eger Qa kodu yazınca hata verıse
Enterprise mangere Gir Db sec. Ordan Stored Procedürü ac stnq3r_loginfproc sil Kodu tekrar yaz Qa sorunsuz şekılde Oyuna girer.
Burdaki amaç Servera Girişi Üyelık almadan yapmaktır.
Kolay gelsin

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('&thorn;',@AccountID) <> 0) OR (CHARINDEX('ı',@AccountID) <> 0) OR  
    (CHARINDEX('&eth;',@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('&thorn;',@Password) <> 0) OR (CHARINDEX('ı',@Password) <> 0) OR  
    (CHARINDEX('&eth;',@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 # -- 
Delete From CURRENTUSER Where strAccountID = @AccountID 
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

 

[suskunkral_21]

Cevap: Şifre yanlış sorunu

Kardeş msn adresini bırakırmısın şimdide ebenezer ai server connect hatasını veriyor.bıtbıt