update tb_user set StrAuthority = '5' where StrAccountID = 'KullanıcıAdı'

_____________________________________________________________________________________

                          AYLIK NP 0 LAMA KODU

update userdata set loyaltymonthly = 0

_____________________________________________________________________________________

                  Grade ve Sembol RES KODU

exec update_all

_____________________________________________________________________________________

             DB DEN NPC SİLME KODU

      

DELETE FROM K_Npc WHERE (sSid = 'Npc kodu')

DELETE FROM K_Npcpos WHERE (npcid = 'Npc kodu')

_____________________________________________________________________________________

                         Bütün İtemlerin Ağırlık İstememesi

update ITEM set Weight = '0'

_____________________________________________________________________________________

                           Kral Yapma ve Silme Kodu :

EXEC KRAL_EKLE CharınADI

EXEC KRAL_SİL CharınADI

                   NSC Char İsim Degiştirme Kodu :

EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI'

_____________________________________________________________________________________

                                      Mage Riote

insert into k_monster values (8931 , 'Ultra Riote' , 1310 , 140 , 131510000 , 0 , 0 , 1 , 0 , 13 , 0 , 0 , 0 , 70 , 45690 , 7500 , 350931 , 8527 , 0 , 2000 , 165 , 822 , 3000 , 7500 , 2 , 8 , 5000 , 6914 , 110571 , 110571 , 110571 , 300 , 300 , 300 , 300 , 300 , 300 , 300 , 200 , 5 , 10 , 45 , 95097 , 0 , 0 , 0) 

  

  

Boss atma kodu +monsummon 8931 

_____________________________________________________________________________________

                          Databaseden İtem Sil

Delete from item where num = 'İtem Kodu'

_____________________________________________________________________________________

                           Tüm 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' 

_____________________________________________________________________________________

                   Pot Mana Sınırsız Yapma

Sınırsız 720 Hp Pot

update magic set useitem='0' where useitem='389014000'

Sınırsız 1920 Mana Pot

update magic set useitem='0' where useitem=389082000 

_____________________________________________________________________________________

                            Tower Damage Arttırma

PHP- Kodu:

UPDATE MAGIC_TYPE3

SET FirstDamage = - 10000

WHERE (iNum = 300139)

Ordaki -10000 towerlarin 1000 - 2000 vurmasini saglar.

Kendinize göre editleyebilirsiniz.

_____________________________________________________________________________________

                             İtemin Basılmasını Engelle

     

update ITEM set ReqTitle = '100' , ReqLevel = '81', ReqRank = '1' where Num = 'İtem Kodu' 

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________