BÜTÜN Q.A kodları

    Paylaş
    avatar
    Admin
    YöneticiYönetici

    Erkek
    Mesaj Sayısı : 677
    Yaş : 27
    Nerden : çanakkale
    İş/Hobiler : öğrenci
    Lakap : webci
    Ruh Hali :
    işletim sistemin :
    Seviye :
    Madalyaların :
    Metin Alanı :
    Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ

    Sanal Hayvan :
    Rap Derecesi :
    Kayıt tarihi : 15/07/08

    Rap Puanın
    Aktiflik:
    4999/5000  (4999/5000)
    Başarı puanı:
    98787/98787  (98787/98787)
    Güçlülük :
    4999/5000  (4999/5000)

    BÜTÜN Q.A kodları

    Mesaj tarafından Admin Bir Perş. Tem. 17, 2008 11:58 am

    90/1 Yapma
    Kod:

    Kod:
    update LEVEL_UP set Exp = '1'
    --------------------------------------------------
    Bütün İtemlerin Ağılık İstememesi
    Kod:

    Kod:
    update ITEM set Weight = '0'
    --------------------------------------------------
    Npc + larını Belirleme Ordaki 199009 sonunda 9 +9 oluo 7 yaparsanız +7 olur...
    Kod:

    Kod:
    update K_NPC set iSellingGroup = '199009'
    where strName = 'Npc İsmi'

    --------------------------------------------------

    NCS SCripti
    Kod:
    Kod:
    Exec NameChange 'EskiIsim', 'YeniIsim'

    --------------------------------------------------
    TB_Userdan Kısa Acc silme
    Kod:
    delete from tb_user where straccountid = 'char ismi'

    --------------------------------------------------

    Magicden Kısa Skill Silmesi ......
    Kod:
    delete from magic where magicnum = 'skill kodu'

    --------------------------------------------------

    Sadece Server I. Karus ve I.El moya [D] sembol ekleme

    Kod:
    Kod:
    CREATE PROCEDURE np_icon
    AS
    DECLARE
    --This script has been made by BERKİN GÜLER in 12.09.2007
    --Bu script BERKİN GÜLER tarafından 12.09.2007 tarihinde yapılmıştır
    @berkin varchar(100),
    @cigdm varchar(100),
    @i int
    BEGIN TRANSACTION
    SELECT @berkin=strUserID FROM USERDATA WHERE Nation = '1' ORDER BY Loyalty
    UPDATE USERDATA SET strUserID = '[D]' + @berkin WHERE strUserID = @berkin
    SELECT @cigdm=strUserID FROM USERDATA WHERE Nation = '2' ORDER BY Loyalty
    UPDATE USERDATA SET strUserID = '[D]' + @cigdm WHERE strUserID = @cigdm
    IF @@error<>0
    begin
    rollback transaction
    print 'Hata oluştu!'
    end
    else
    begin
    print 'ICON EKLEME ISLEMI BASARILI.'
    print @berkin + 've' + @cigdm + ',' + '[D]' + @berkin + 've' + '[D]' + @cigdm + 'olarak degistirildi!'
    end
    COMMIT TRANSACTION
    GO

    --------------------------------------------------
    Char Tahttan Kalkmıyor Diyenler için Sql Scripti
    Kod:

    Kod:
    insert into [ZONE_INFO] Values ('1','101','battle_0516.smd','15000','15000','1500 0','2','101','Dark Lunar')

    insert into [ZONE_INFO] Values ('1','102','battle_0516.smd','15000','15000','1500 0','2','0','BATTLE_ZONE???')

    insert into [ZONE_INFO] Values ('1','201','free_0810.smd','15000','15000','15000' ,'2','0','Colony Zone')

    update ZONE_INFO set ServerNo = '1'

    --------------------------------------------------
    Charı Gm Yapma Scripti
    Kod:

    Kod:
    update userdata set Authority = '0'
    where struserid = 'Karakter ismi'

    --------------------------------------------------

    Charı Normal Char Yapma Scripti
    Kod:

    Kod:
    update userdata set Authority = '1'
    where struserid = 'Karakter İsmi'

    --------------------------------------------------
    Charı Banlama Scripti
    Kod:

    Kod:
    update userdata set Authority = '255'
    where struserid = 'Karakter İsmi'

    --------------------------------------------------
    AC Kıyafetleri DB'den Kaldırmak:

    Kod:

    Database'den Item_Ext 13, 14, 15, 16 ve 17 Tablolarından :

    Kod:
    41-50 Arasını => 41 Ve 50 Dahil
    71-80 Arasını => 71 Ve 80 Dahil
    541-550 Arasını => 541 Ve 550 Dahil
    304-309 Arasını => 304 Ve 309 Dahil
    313-318 Arasını => 313 Ve 318 Dahil
    322-327 Arasını => 322 Ve 327 Dahil
    331-336 Arasını => 331 Ve 336 Dahil
    hepsini siLiniz!

    --------------------------------------------------
    NCS Aktif etmek için

    Kod:
    Kod:
    create procedure [NameChange]
    (@oldname varchar(30),@newname varchar(30))
    AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)
    begin tran
    Update account_char set strcharid1 = @newname where strcharid1 = @oldname
    Update account_char set strcharid2 = @newname where strcharid2 = @oldname
    Update account_char set strcharid3 = @newname where strcharid3 = @oldname
    Update userdata set struserid = @newname Where struserid = @oldname
    Update knights_user set struserid = @newname Where struserid = @oldname
    Update knights set chief = @newname where chief = @oldname
    Update knights set vicechief_1 = @newname where vicechief_1 = @oldname
    Update knights set vicechief_2 = @newname where vicechief_2 = @oldname
    Update knights set vicechief_3 = @newname where vicechief_3 = @oldname
    commit tran

    --------------------------------------------------
    Account Bulma:

    Kod:

    Kod:
    declare @name varchar(21)
    set @name = 'Karakter İsmi'


    SELECT * from ACCOUNT_CHAR
    where strcharid1 = @name
    or strcharid2 = @name
    or strcharid3 = @name

    --------------------------------------------------
    Ban'lanan Üyelerin NP'lerini Sıfırlamak:

    Kod:

    Kod:
    UPDATE USERDATA
    SET Loyalty = 0
    WHERE Authority = 255
    -

    -------------------------------------------------
    Character'i GM Yapmak:

    Kod:
    Kod:

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

    Unuqe itemlerin storedaki fıyatını arttırma


    Kod:
    --------------------------------------------------
    update item_basic
    SET iPriceSale = 2150000000
    WHERE (bySellGroup = 0)



    --------------------------------------------------

    Full Character Edit:

    Kod:

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

    Herkese 21 gb verme
    --------------------------------------------------
    Kod:

    update userdata set gold = '2100000000'

    --------------------------------------------------

    İstediğiniz Account'un Item'lerini Silin:

    Kod:

    Kod:
    UPDATE warehouse
    SET WareHouseData = ''
    WHERE strAccountID = 'Hesap Adı'
    -
    -------------------------------------------------
    Tüm itemleri +10 a %100 yapma scripti

    PHP Code:
    Kod:
    UPDATE UPGRADEEXT0 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT1 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT2 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT3 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT4 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT5 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT6 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT7 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT8 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT9 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT10 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT11 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT12 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT13 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT14 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT15 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT16 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT17 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT18 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT19 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT20 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT21 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT22 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0
    UPDATE UPGRADEEXT23 SET siPercent0 = 100, siPercent1 = 100, siPercent2 = 100, siPercent3 = 100, siPercent4 = 100, siPercent5 = 100, siPercent6 = 100, siPercent7 = 100, siPercent8 = 0, siPercent9 = 0

    --------------------------------------------------
    CZ'deki Kuleleri Aktif Yapmak:

    Kod:

    Kod:
    6701 Guard tower 5301 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6701 0 0 0
    6751 Guard tower 5401 100 0 0 0 5 0 22 0 0 0 100 71470 0 110245 15458 0 3445 124 124 124 2500 2 8 5000 0 0 0 83 83 83 83 83 83 83 200 5 15 20 359996 6751 0 0 0
    9001 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9001 0 0 4
    9002 Elmo Guard Tower 5301 180 0 0 2 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 470276 0 0 250 250 250 250 250 250 250 90 80 90 0 10930 9002 0 0 4
    9003 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9003 0 0 4
    9004 Karus Guard Tower 5401 180 0 0 1 7 0 1 1 2 0 100 80000 0 500000 5000 1550 5000 500 500 5000 500 2 8 500 300431 300269 110535 250 250 250 250 250 250 250 90 80 90 0 10930 9004 0 0 4
    -

    -------------------------------------------------
    Full Character Edit:

    Kod:

    Kod:
    update userdata set Strong = '255',Sta = '255',Dex = '255',Intel = '255',Cha = '255', Level = '100',Loyalty = '100000000',Points = '255',Gold = '2100000000'
    where struserid = 'Karakter İsmi'
    --------------------------------------------------
    İstediğiniz Account'un Item'lerini Silin:

    Kod:

    Kod:
    UPDATE warehouse
    SET WareHouseData = ''
    WHERE strAccountID = 'Hesap Adı'

    --------------------------------------------------


    item edit

    Kod:
    siDamage : vurus gücü (1k ve üstünde yaparsan takinca ölebilirsin ama)

    --------------------------------------------------
    siDefence : kaç ac verecegi ayardir 300 yaparsan defansin 300 artar
    siDefenceDagger,Axe,Arrow,Spear,Mace vb : bu silahlara karsi kaç defans olacagidir
    bunlar defanslardi
    --------------------------------------------------

    Silahin Light - Ice - Posion - Fire yanisini ayarlama

    byDamageFire : fire hasari ekler
    byDamageIce : ice hasari ekler
    byDamageThuner : lightning hasari erkler
    byDamagePosion : posion hasari erkler
    bunlar da damageler
    yanmasini istediginize yüksek bir sayi koyun digerlerine 0 deyin ( item_ext23.tbl ile editlenmeden olmayabilir ) Dip Not : Exc uyarin için saol

    --------------------------------------------------

    GELELIM BONUSLARAA...
    siBonusStr : str bonus
    siBonusMagic Attack : mp bonus
    siBonusDex : dex bonus
    siBonusInt : int bonus
    siBonusHp : hp bonus
    siBonusMsp : mana bonus

    --------------------------------------------------

    gerekensinimleri ayarlama

    siNeedLevel : kaç levelda takilabilecegini anlatir
    siNeedRank : 1 yaparsaniz sadece krallar takabilir 0 yaparsaniz userlara da açilir
    siNeedStr : str ihtiyaci
    siNeedInt,Dex,Hp vs vs : verilen statlarda olunmazsa takilamayacak

    Resistler

    siRegistFire, siRegistIce, siRegistElec, siRegistPosion
    Fire = fire resisti Ice= ice resisti Elec= Lr Posion = posion resisti vs..

    --------------------------------------------

    delos için

    Kod:

    Kod:
    insert into [K_WARPINFO] Values (21,316,'Delos','Delos Desert',5000,30,529,5,253,5)
    insert into [K_WARPINFO] Values (21,416,'Delos','Delos Desert',5000,30,529,5,253,5)
    insert into [K_WARPINFO] Values (30,321,'Moradon','Delos Zone',0,21,315,0,400,10)
    insert into [K_WARPINFO] Values (30,301,'Moradon','Delos Zone',0,21,315,0,400,10)
    insert into [K_OBJECTEVENT] Values (30,4030,1,0,5,30,1,650,0,650)
    insert into [K_OBJECTEVENT] Values (30,4031,1,0,5,32,1,550,0,255)
    insert into [EVENT] Values (30,2001,0,1,1,1,1,1,32,529,253,1,1)
    insert into [EVENT] Values (30,2002,0,1,1,1,1,1,32,529,253,1,1)
    insert into [ZONE_INFO] Values (2,30,'elmorad_1212.smd',15000,15000,15000,1,0,'wa r_a_ch')
    insert into [ZONE_INFO] Values (2,32,'elmorad_1212.smd',15000,15000,15000,1,0,'du ngeon_b1_th')
    -
    -------------------------------------------
    avatar
    Admin
    YöneticiYönetici

    Erkek
    Mesaj Sayısı : 677
    Yaş : 27
    Nerden : çanakkale
    İş/Hobiler : öğrenci
    Lakap : webci
    Ruh Hali :
    işletim sistemin :
    Seviye :
    Madalyaların :
    Metin Alanı :
    Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ

    Sanal Hayvan :
    Rap Derecesi :
    Kayıt tarihi : 15/07/08

    Rap Puanın
    Aktiflik:
    4999/5000  (4999/5000)
    Başarı puanı:
    98787/98787  (98787/98787)
    Güçlülük :
    4999/5000  (4999/5000)

    Geri: BÜTÜN Q.A kodları

    Mesaj tarafından Admin Bir Perş. Tem. 17, 2008 11:59 am

    Nation Transfer Scripti;
    Kod:
    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' ]

    --------------------------------------------------
    elmorad-karus

    Kod:

    Kod:
    CREATE procedure [nt1]
    @Account char(30)

    AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

    begin tran

    declare @char1 varchar(21)
    set @char1 = (select strcharid1 from account_char where straccountid = @account)
    declare @char2 varchar(21)
    set @char2 = (select strcharid2 from account_char where straccountid = @account)
    declare @char3 varchar(21)
    set @char3 = (select strcharid3 from account_char where straccountid = @account)
    declare @clannumber1 smallint
    set @clannumber1 = (select idnum from knights where chief = @char1)
    declare @clannumber2 smallint
    set @clannumber2 = (select idnum from knights where chief = @char2)
    declare @clannumber3 smallint
    set @clannumber3 = (select idnum from knights where chief = @char3)

    update account_char set bnation = '1' where bnation = '2' and straccountid = @Account

    update userdata set nation = '1' where nation = '2' and struserid = @char1
    Update userdata set race = '1' where class in ('201','205') and struserid = @char1
    Update userdata set race = '2' where race = '12' and class in ('207','211','202','204') and struserid = @char1
    update userdata set race = '3' where race = '13' and class in ('204','211') and struserid = @char1
    update userdata set race = '4' where class in ('203','209') and struserid = @char1
    update userdata set class = '105' where class = '205' and struserid = @char1
    update userdata set class = '107' where class = '207' and struserid = @char1
    update userdata set class = '109' where class = '209' and struserid = @char1
    update userdata set class = '111' where class = '211' and struserid = @char1
    update userdata set class = '101' where class = '201' and struserid = @char1
    update userdata set class = '102' where class = '202' and struserid = @char1
    update userdata set class = '103' where class = '203' and struserid = @char1
    update userdata set class = '104' where class = '204' and struserid = @char1
    update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
    delete from knights where chief = @char1
    delete from knights_user where sidnum = @clannumber1
    delete from knights_rating where shindex = @clannumber1
    update userdata set knights = 0, fame = 0 where knights = @clannumber1

    update userdata set nation = '1' where nation = '2' and struserid = @char2
    Update userdata set race = '1' where class in ('201','205') and struserid = @char2
    Update userdata set race = '2' where race = '12' and class in ('207','211','202','204') and struserid = @char2
    update userdata set race = '3' where race = '13' and class in ('204','211') and struserid = @char2
    update userdata set race = '4' where class in ('203','209') and struserid = @char2
    update userdata set race = '4' where class = '209' and struserid = @char2
    update userdata set class = '105' where class = '205' and struserid = @char2
    update userdata set class = '107' where class = '207' and struserid = @char2
    update userdata set class = '109' where class = '209' and struserid = @char2
    update userdata set class = '111' where class = '211' and struserid = @char2
    update userdata set class = '101' where class = '201' and struserid = @char2
    update userdata set class = '102' where class = '202' and struserid = @char2
    update userdata set class = '103' where class = '203' and struserid = @char2
    update userdata set class = '104' where class = '204' and struserid = @char2
    update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
    delete from knights where chief = @char2
    delete from knights_user where sidnum = @clannumber2
    delete from knights_rating where shindex = @clannumber2
    update userdata set knights = 0, fame = 0 where knights = @clannumber2

    update userdata set nation = '1' where nation = '2' and struserid = @char3
    Update userdata set race = '1' where class in ('201','205') and struserid = @char3
    Update userdata set race = '2' where race = '12' and class in ('207','211','202','204') and struserid = @char3
    update userdata set race = '3' where race = '13' and class in ('204','211') and struserid = @char3
    update userdata set race = '4' where class in ('203','209') and struserid = @char3
    update userdata set class = '105' where class = '205' and struserid = @char3
    update userdata set class = '107' where class = '207' and struserid = @char3
    update userdata set class = '109' where class = '209' and struserid = @char3
    update userdata set class = '111' where class = '211' and struserid = @char3
    update userdata set class = '101' where class = '201' and struserid = @char3
    update userdata set class = '102' where class = '202' and struserid = @char3
    update userdata set class = '103' where class = '203' and struserid = @char3
    update userdata set class = '104' where class = '204' and struserid = @char3
    update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
    delete from knights where chief = @char3
    delete from knights_user where sidnum = @clannumber3
    delete from knights_rating where shindex = @clannumber3
    update userdata set knights = 0, fame = 0 where knights = @clannumber3
    update userdata set knights = 0, fame = 0 where struserid = @char1
    update userdata set knights = 0, fame = 0 where struserid = @char2
    update userdata set knights = 0, fame = 0 where struserid = @char3
    Update knights set vicechief_1 = '' where vicechief_1 = @char1
    Update knights set vicechief_2 = '' where vicechief_2 = @char1
    Update knights set vicechief_3 = '' where vicechief_3 = @char1
    Update knights set vicechief_1 = '' where vicechief_1 = @char2
    Update knights set vicechief_2 = '' where vicechief_2 = @char2
    Update knights set vicechief_3 = '' where vicechief_3 = @char2
    Update knights set vicechief_1 = '' where vicechief_1 = @char3
    Update knights set vicechief_2 = '' where vicechief_2 = @char3
    Update knights set vicechief_3 = '' where vicechief_3 = @char3
    delete from knights_user where struserid = @char1
    delete from knights_user where struserid = @char2
    delete from knights_user where struserid = @char3

    commit tran

    GO
    -

    -------------------------------------------------
    avatar
    Admin
    YöneticiYönetici

    Erkek
    Mesaj Sayısı : 677
    Yaş : 27
    Nerden : çanakkale
    İş/Hobiler : öğrenci
    Lakap : webci
    Ruh Hali :
    işletim sistemin :
    Seviye :
    Madalyaların :
    Metin Alanı :
    Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ

    Sanal Hayvan :
    Rap Derecesi :
    Kayıt tarihi : 15/07/08

    Rap Puanın
    Aktiflik:
    4999/5000  (4999/5000)
    Başarı puanı:
    98787/98787  (98787/98787)
    Güçlülük :
    4999/5000  (4999/5000)

    Geri: BÜTÜN Q.A kodları

    Mesaj tarafından Admin Bir Perş. Tem. 17, 2008 11:59 am

    karus-elmorad

    Kod:

    Kod:
    CREATE procedure [nt2]
    @Account char(30)

    AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

    begin tran

    declare @char1 varchar(21)
    set @char1 = (select strcharid1 from account_char where straccountid = @account)
    declare @char2 varchar(21)
    set @char2 = (select strcharid2 from account_char where straccountid = @account)
    declare @char3 varchar(21)
    set @char3 = (select strcharid3 from account_char where straccountid = @account)
    declare @clannumber1 smallint
    set @clannumber1 = (select idnum from knights where chief = @char1)
    declare @clannumber2 smallint
    set @clannumber2 = (select idnum from knights where chief = @char2)
    declare @clannumber3 smallint
    set @clannumber3 = (select idnum from knights where chief = @char3)

    update account_char set bnation = '2' where bnation = '1' and straccountid = @Account

    update userdata set nation = '2' where nation = '1' and struserid = @char1
    Update userdata set race = '11' where class = '105' and struserid = @char1
    update userdata set race = '11' where class = '101' and struserid = @char1
    Update userdata set race = '12' where race = '2' and class in ('107','111','102','104') and struserid = @char1
    update userdata set race = '13' where race = '3' and class in ('104','111') and struserid = @char1
    update userdata set race = '13' where class in ('203','209') and race = '4' and struserid = @char1
    update userdata set class = '205' where class = '105' and struserid = @char1
    update userdata set class = '207' where class = '107' and struserid = @char1
    update userdata set class = '209' where class = '109' and struserid = @char1
    update userdata set class = '211' where class = '111' and struserid = @char1
    update userdata set class = '201' where class = '101' and struserid = @char1
    update userdata set class = '202' where class = '102' and struserid = @char1
    update userdata set class = '203' where class = '103' and struserid = @char1
    update userdata set class = '204' where class = '104' and struserid = @char1
    update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
    delete from knights where chief = @char1
    delete from knights_user where sidnum = @clannumber1
    delete from knights_rating where shindex = @clannumber1
    update userdata set knights = 0, fame = 0 where knights = @clannumber1

    update userdata set nation = '2' where nation = '1' and struserid = @char2
    Update userdata set race = '11' where class = '105' and struserid = @char2
    update userdata set race = '11' where class = '101' and struserid = @char2
    Update userdata set race = '12' where race = '2' and class in ('107','111','102','104') and struserid = @char2
    update userdata set race = '13' where race = '3' and class in ('104','111') and struserid = @char2
    update userdata set race = '13' where class in ('203','209') and race = '4' and struserid = @char2
    update userdata set class = '205' where class = '105' and struserid = @char2
    update userdata set class = '207' where class = '107' and struserid = @char2
    update userdata set class = '209' where class = '109' and struserid = @char2
    update userdata set class = '211' where class = '111' and struserid = @char2
    update userdata set class = '201' where class = '101' and struserid = @char2
    update userdata set class = '202' where class = '102' and struserid = @char2
    update userdata set class = '203' where class = '103' and struserid = @char2
    update userdata set class = '204' where class = '104' and struserid = @char2
    update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
    delete from knights where chief = @char2
    delete from knights_user where sidnum = @clannumber2
    delete from knights_rating where shindex = @clannumber2
    update userdata set knights = 0, fame = 0 where knights = @clannumber2

    update userdata set nation = '2' where nation = '1' and struserid = @char3
    Update userdata set race = '11' where class = '105' and struserid = @char3
    update userdata set race = '11' where class = '101' and struserid = @char3
    Update userdata set race = '12' where race = '2' and class in ('107','111','102','104') and struserid = @char3
    update userdata set race = '13' where race = '3' and class in ('104','111') and struserid = @char3
    update userdata set race = '13' where class in ('203','209') and race = '4' and struserid = @char3
    update userdata set class = '205' where class = '105' and struserid = @char3
    update userdata set class = '207' where class = '107' and struserid = @char3
    update userdata set class = '209' where class = '109' and struserid = @char3
    update userdata set class = '211' where class = '111' and struserid = @char3
    update userdata set class = '201' where class = '101' and struserid = @char3
    update userdata set class = '202' where class = '102' and struserid = @char3
    update userdata set class = '203' where class = '103' and struserid = @char3
    update userdata set class = '204' where class = '104' and struserid = @char3
    update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
    delete from knights where chief = @char3
    delete from knights_user where sidnum = @clannumber3
    delete from knights_rating where shindex = @clannumber3
    update userdata set knights = 0, fame = 0 where knights = @clannumber3
    update userdata set knights = 0, fame = 0 where struserid = @char1
    update userdata set knights = 0, fame = 0 where struserid = @char2
    update userdata set knights = 0, fame = 0 where struserid = @char3
    Update knights set vicechief_1 = '' where vicechief_1 = @char1
    Update knights set vicechief_2 = '' where vicechief_2 = @char1
    Update knights set vicechief_3 = '' where vicechief_3 = @char1
    Update knights set vicechief_1 = '' where vicechief_1 = @char2
    Update knights set vicechief_2 = '' where vicechief_2 = @char2
    Update knights set vicechief_3 = '' where vicechief_3 = @char2
    Update knights set vicechief_1 = '' where vicechief_1 = @char3
    Update knights set vicechief_2 = '' where vicechief_2 = @char3
    Update knights set vicechief_3 = '' where vicechief_3 = @char3
    delete from knights_user where struserid = @char1
    delete from knights_user where struserid = @char2
    delete from knights_user where struserid = @char3

    commit tran

    GO

    -------------------------------------------

    GM KomutLarı

    Kod:
    /clear (0-100 arası değer yazın) (ideali 50) (Açık hava)

    /rain (0-100 arası değer yazın) (ideali 50) (Yağmurlu hava)

    /snow (0-100 arası değer yazın) (ideali 50) (Karlı hava)

    /goto xxx,xxx ( xxx,xxx koordinatına ışınlanırsınız)

    /count (serverdaki online player sayısını gösterir)

    /notice ne yazmak istiyorsan yaz (Notice yazarsınız)

    /time (0-24) (Oyun saatini ayarlarsınız mesela 24 yapınca gece olur)

    'Q' harfine basılı tutup koşarsanız çok hızlı koşarsınız (Orc base'den Human Base'ye 10 saniyede gidersiniz sanırım)

    /ban yada /forbid_connect nick (kimi banlamak istiyorsanız onun nickini yazın)

    /mute yada /forbid_chat nick (kimi mutelemek istiyorsanız onun nickini yazın)

    /unmute yada /allow_chat nick (kimin mutesini açmak istiyorsanız onun nickini yazın)
    --------------------------------------------

    Oto Grade - Clan Rank


    database inizde bulunan "stored procedure" kısmına girin.
    en altta update_knights procedure ünü bulun.

    orada declare kısmından önceki bölüme
    Kod:

    Kod:
    exec rank_knights

    yazın.

    yani şöyle görünücek;
    Kod:

    -- sungyong 2002.08.22 create
    -- modify 2007 Metriyks1536 xD
    CREATE PROCEDURE UPDATE_KNIGHTS
    @nRet smallint OUTPUT,
    @Type tinyint,
    @UserId char(21),
    @KnightsIndex smallint,
    @Domanation tinyint
    AS

    exec rank_knights

    DECLARE @Row tinyint
    DECLARE @Members tinyint
    DECLARE @KnightsNumber smallint
    DECLARE @ViceChief_1 char(21)
    DECLARE @ViceChief_2 char(21)
    DECLARE @ViceChief_3 char(21)
    .
    .
    .
    .
    .


    ve sonra shu kodları giriniz ...
    kod:
    SELECT nRank AS siralama, strName AS isim, nPoints AS toplam_np
    FROM KNIGHTS_RATING
    ORDER BY nRank
    -
    ---------------------------------------------


    Karus Kadın Mage Yapımı

    Kod:
    1-) Usko(ROFD)'nun Item Dosyasını Kendi Serverimizin Item Dosyasıyla Değiştiriyoruz.
    2-) Oyunda Bir Priest Açıyoruz.
    3-) Enterprise Manager'den USERDATA Tablosunu Açıyoruz.
    4-) Priestimizi Bulup Classını 109 Olarak Değiştiriyoruz...

    -------------------------------------------------

    Beygir Olmak

    Kod:
    Karus Warrior Race : 5
    Karus Erkek Race : 6
    Karus Cüce Race : 7
    Karus Kadın Race : 8
    Elmorad Barbar Race : 14
    Elmorad Erkek Race : 15
    Elmorad Bayan Race : 16

      Forum Saati C.tesi Ara. 15, 2018 4:11 am