Bütün query analyzer kodlari-admİnlerİn Çok İŞİne yarayacak-

'Web Programlama & Scriptler' forumunda NeslisH tarafından 2 Mayıs 2009 tarihinde açılan konu

  1. NeslisH

    NeslisH Özel Üye

    Bütün query analyzer kodlari-admİnlerİn Çok İŞİne yarayacak- konusu ||| AdMiN İçİN GeReKLi Query Analyzer Kodları |||
    __________________________________________________ _



    ______Guard Damage---

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


    ______Gm Yapma Kodu______________________________________________ ________________

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



    ______Edit Char Yapmak____________________________________________ _______________

    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




    ___________________________
     

Bu Sayfayı Paylaş