Query Analeyzer[QA] Kodları

CaNaVaReX · 15 May 2009

Dropları Sıfırlama
update k_monster_item set iItem01 = '0'
update k_monster_item set iItem02 = '0'
update k_monster_item set iItem03 = '0'
update k_monster_item set iItem04 = '0'
update k_monster_item set iItem05 = '0'

Bütün Accountları Silme
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
truncate table PREMIUM_SERVICE

1440 ve Holy Water Kaldırmak
DELETE FROM ITEM WHERE (Num = '379102000')
DELETE FROM ITEM WHERE (Num = '379103000')
DELETE FROM ITEM WHERE (Num = '379105000')
DELETE FROM ITEM WHERE (Num = '379104000')
DELETE FROM ITEM WHERE (Num = '379102000')
DELETE FROM ITEM WHERE (Num = '379101000')
Delete from item where num = '379101000'
delete from item where num = '379102000'
delete from item where num = '379103000'
delete from item where num = '379108000'
delete from item where num = '379113000'
delete from item where num = '379098000'
delete from item where num = '389015000'
delete from item where num = '389064000'
delete from item where num = '910005000'
delete from item where num = '389083000'

Guard Tower Damage Ayarlama
UPDATE MAGIC_TYPE3
SET FirstDamage = - 10000
WHERE (iNum = 300139)

First damageyi 10000 yaparsanız 1-2 k arası vurur, siz ayarlarsınız.

Okçu 30 k Vurma Fixed
update MAGIC_TYPE2
set AddDamagePlus = 1
where NeedArrow = 1 or NeedArrow = 3 or NeedArrow = 5

Sınırsız Pot Yapma
update magic set useitem='0' where useitem='389014000'
update magic set useitem='0' where useitem='389020000'

Banlanan çarların np'lerini sıfırlama
update userdata set Loyalty = '0'where Authority = '255'
update userdata set LoyaltyMonthly = '0'where Authority = '255'

Gm Yapma
update userdata set Authority = '0'
where struserid = 'Nick'

Full Edit Karakter Yapma
update userdata set Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255',Points = '255',Gold = '2100000000'
where struserid = 'Nick'

Kral Yapma
update userdata set Rank = '1'
where struserid = 'NICK'

Tüm Kollukları G1 Yapma
update Knights set Points = '999999'

Tüm Kollukları Yakma
update Knights set Ranking = '1'

İstediğiniz Karakterin İtemlerini Silme
UPDATE warehouse
SET WareHouseData = ''
WHERE strAccountID = 'Hesap Adı'

Karakteri İstediğiniz Clana Sokma
update Userdata set Knights = 'Clan Nosu'where struserid = 'Char Adı'

Query Analeyzer[QA] Kodları

CaNaVaReX

Benzer Konular

Sosyal Ağlarla Paylaş