update Knights set Points = '999999'where IDName = 'Clan Adı'

update Knights set Points = '999999'

update Userdata set Knights = 'Clan Nosu'where struserid = 'Char Adı'

update Userdata set Strong = '255'where struserid = 'Char Nick'
update Userdata set Sta = '255'where struserid = 'Char Nick'
update Userdata set Dex = '255'where struserid = 'Char Nick'
update Userdata set intel = '255'where struserid = 'Char Nick'
update Userdata set Cha = '255'where struserid = 'Char Nick'

delete from item where num=379047000 or num=379101000 or num=379102000 or num=379103000 or num=389010000 or num=910012000

6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0
6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0
9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4
9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4
9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4
9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4

declare @name varchar(21)
set @name = 'Karakter İsmi'


SELECT * from ACCOUNT_CHAR
where strcharid1 = @name
or strcharid2 = @name
or strcharid3 = @name

UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255

UPDATE warehouse
SET WareHouseData = ''
WHERE strAccountID = 'Hesap Adı'

UPDATE    MAGIC_TYPE3
SET              FirstDamage = - 10000
WHERE     (iNum = 300139)

CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21),
@Password varchar(13),
@nRet smallint OUTPUT
AS
delete from currentuser where straccountid = @AccountID

---Coded By ShellX---
declare @cnt BigInt
declare @nDays smallint

select @nRet = count(straccountid) from tb_user where straccountid = @AccountID


if @nRet = 0
begin
insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')
end

select @cnt = count(straccountid) from currentuser
select @nDays = count(nDays) from PREMIUM_SERVICE where straccountid = @AccountID

if @cnt > 40 and @nDays = '0'
begin
set @nRet = 0
end

if @cnt > 40 and @nDays = null
begin
set @nRet = 0
end



DECLARE @Nation tinyint
SET @Nation = 0
-- tid login method by samma 2004.02.24
DECLARE @pwd varchar(13)

SET @pwd = null

SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID
IF @pwd IS null
BEGIN
SET @nRet = 0
RETURN
END

ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 0
RETURN
END

SELECT @Nation = bNation FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = 1
RETURN
END
BEGIN
SET @nRet = @Nation+1
RETURN
END
GO