Oto G1 Yapma Kodu :
update Knights set Points = '999999'
: Kıral Yapma Kodu :
EXEC KRAL_EKLE CharınADI
: NSC Char İsim Degiştirme Kodu :
EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI'
: Irak Degiştirme Kodu :
EXEC ACCOUNT_NATION_CHANGE 'HESABINIDSI','IRKNUMARASI'
: Symbol ve Clan Sıfırlama Resette :
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
: Charı Fll Edit Yapma :
update Userdata set strskill = 'ÿ'where struserid = 'Char Nick'
: Dbdeki Bütün Charları Silmek :
truncate table account_char
truncate table currentuser
truncate table deleted_userdata
truncate table knights
truncate table knights_rating
truncate table knights_user
truncate table tb_user
truncate table userdata
truncate table warehouse
: Exp Arttırmak :
update k_monster
set iexp = iexp*5
: Gm Yapma Kodu :
update userdata set Authority = '0'
where struserid = 'Karakter İsmi'
: Guvartower Atak Ayarlama Kodu :
UPDATE MAGIC_TYPE3
SET FirstDamage = 1000
WHERE (iNum = 300139)
. Userlerin Np Lerini Sıfırlar :
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 1
: Banlananlarının Kini Sıfırlar :
UPDATE USERDATA
SET Loyalty = 0
WHERE Authority = 255
: Oto Üyelik Yapma :
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