Stnq3r's Server Files 6.1 - v1351

Here...


*authority bug fix
*exe problems fixed
*Max level 83
*Ebenezer Close problem fixed
*there was a problem in v5 "tradedupe crash" (fixed)
*Ebenezer C++ fixed
*AI server close problem fixed
*Launcher download problem fixed
*Knight Online exe's viruses deleted and packed.
*new exe added
*maps added
*Turkish language support
*MD5 system deleted
*Special launcher added
*Anti flood
*Kill Switch fixed
*Merchant bug fixed (empty mechant bug)
*Anti ddos
*AI server connections edited.
*Aujard reads faster procs
*AI Server Crashes fixed
*Trade hack fixed
*Maksimum securty
*IPFW Added (new version)
*you can use with this srv files: item manager , on time dc , on time dupe scanner etc.
*Noticeall added u can use it with your gm character "/noticeall bla bla"
*Aujard USKO moradon problem fixed.
*ini files name stnq3r.ini
*Log system changed
*Server killer fixed.
.*International Chat (Karus Human Chat)
*CTRL block fix deleted , you can use ctrl now
*Count Down Attack fixed again
*Grade Update (automatic)
*Np Symbol update (automatic)
*Roll Back problem fix (use +down command before close server)
*On time SqlJob update
*Special Server File for Launcher
*Nation Select fix
*New Dupe Methots Blocked
*New R Hack Methots Blocked
*New Firewall ()
*Its needs password when you try to open it [pass : stnq3r ]
*USKO Font
*New Flood Hack Methots Fixed
*Two Stars New Dupe Scanner added (thanks to twostars)
*Ebenezer Crash errors debugged
*New AIServer
*Cz and War Zone money lost
*All Commands working
*+tp_all Command added
*authority bug fixed with a new methot
*anvil ebenezer crashs fixed
*Nation Hack Fixed
*Fast launch
*New Maps And Evts
*New looking.
*255 stat bug fixed
*Map coordinates changed (New Moradon)
*Skill NPC ID 18004
*You Can use my video on v5.


"Use this login proc"
*dont paste it account_login , paste query analyzer and press f5

Kod:

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('&yacute;',@AccountID) <> 0) OR 

    (CHARINDEX('&eth;',@AccountID) <> 0) OR (CHARINDEX('ö',@AccountID) <> 0) OR 

    (CHARINDEX('ü',@AccountID) <> 0) OR (CHARINDEX('ç',@AccountID) <> 0) OR 

    (CHARINDEX('&thorn;',@AccountID) <> 0) OR (CHARINDEX('@',@AccountID) <> 0) OR

    (CHARINDEX('+',@AccountID) <> 0) OR (CHARINDEX('-',@AccountID) <> 0) OR

    (CHARINDEX('=',@AccountID) <> 0) OR (CHARINDEX('ü',@AccountID) <> 0) OR

    (CHARINDEX('&eth;',@AccountID) <> 0) OR (CHARINDEX('&yacute;',@AccountID) <> 0) OR

    (CHARINDEX('''',@AccountID) <> 0)

BEGIN

    SET @nRet = 2

    RETURN

END

IF (CHARINDEX('&thorn;',@Password) <> 0) OR (CHARINDEX('&yacute;',@Password) <> 0) OR 

    (CHARINDEX('&eth;',@Password) <> 0) OR (CHARINDEX('ö',@Password) <> 0) OR 

    (CHARINDEX('ü',@Password) <> 0) OR (CHARINDEX('ç',@Password) <> 0) OR 

    (CHARINDEX('&thorn;',@Password) <> 0) OR (CHARINDEX('@',@Password) <> 0) OR

    (CHARINDEX('+',@Password) <> 0) OR (CHARINDEX('-',@Password) <> 0) OR

    (CHARINDEX('=',@Password) <> 0) OR (CHARINDEX('ü',@Password) <> 0) OR

    (CHARINDEX('&eth;',@Password) <> 0) OR (CHARINDEX('&yacute;',@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

"Download Link"


File Size : 780MB
Compressed Size : 37MB
Download Link : [Linkleri görebilmek için üye olun veya giriş yapın.]
rar pass : stnq3r