Query Analyzer Kod's

Admin icin gerekli olan kodlar


Guard Damage

Kod:

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

Gm Yapma Kod

Kod:

update userdata set Authority = '0'
where struserid = 'Karakter İsmi'


Edit Char Yapmak

Kod:

update userdata set Strong = '255',Sta =
'255',Dex = '255',Intel = '255',Cha = '255', Level =
'80',Loyalty = '100000000',Points = '255',Gold =
'2100000000'
where struserid = 'Karakter İsmi'

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



______255 Skill Point vermek____________________________________________ ________

update Userdata set strskill = 'ÿ'where struserid = 'Char Nick'



______Useri istediğin Clana Koymak____________________________________________ ____
update Userdata set Knights = 'Clan Nosu'where struserid = 'Char Adı'



______Tek Clanı g1 yapmak____________________________________________ _____________

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



______Tek Clanın Kolluğunu Yakmak____________________________________________ ______

update Knights set Ranking = '1'where IDName = 'Ir0nWrisT'




______Acid Potionları Engellemek________________________________________ ____________

UPDATE ITEM SET SellingGroup = 0 Where Num = 389083000



______Resette Yapılacak oto Grade Oto Np Symbol___________________________________

exec otosymbol
exec rank_knights





______Bütün Clan ve Userleri Silme_____________________________________________ _____

Truncate table userdata
go
truncate table tb_user
go
truncate table account_char
go
truncate table knights
go
truncate table warehouse
go
truncate table itemler
go
truncate table Inventory_Edit
go
truncate table KING_ELECTION_LIST
go

truncate table CURRENTUSER
go
truncate table np_kings
go
truncate table np_kings2
go
truncate table USER_PERSONAL_RANK
go
truncate table FRIEND_LIST
go
truncate table HERO_USER
go


_____Oto Np 2_________________________________________________ __________________________________________________ _

exec otonpsimgesi
exec rank_knights ----------2

__________________________________________________ __________________________________________________ _____________




____Sadece Tek usere np vermek____________________________________________ __________________________________________________ __

update userdata set Loyalty = '1000000'
where struserid = 'Char İsmi'

__________________________________________________ __________________________________________________ _______________





np icon

exec imbacodermyst
exec np_icon
exec Rank_Knights




Nation Transfer Scripti;
El Morad Olan Charı Karus yapmak için için

[ exec nt1 'accountname' ]


Karus Olan Charı El Morad yapmak için için

[ exec nt2 'accountname' ]




namechange____________


EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKINICK','YENINICK'







__________________________________________________ _______________________________-



EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK