Kral Forum



rel="publisher"

    Pet Eklemek - Satış Npcsi-Skill ve Patch

    Paylaş
    avatar
    uÄŸur
    Admin
    Admin

    Mesaj Sayısı : 2372
    Karizma Puanı : 7113
    Kayıt tarihi : 02/04/10

    Pet Eklemek - Satış Npcsi-Skill ve Patch

    Mesaj tarafından uÄŸur Bir Cuma Mayıs 21, 2010 8:06 am

    Birçok Kişinin Merak Ettiği Pet
    Bir işe yaramıyor ama öle gezdirelim yanımızda
    Eklemeyi ve kullandırmayı tam olarak anlatacağım ve elle ekleme gibi bir durum söz konusu değil hepsi query dir.

    Önce item Tablosuna Ekleyelim
    Query Analizerden Okutunuz

    Kod:

    insert into [ITEM] Values (610012000,'Harpy',255,15,0,0,0,0,0,1,1,3000,0,0,0,502032,0,1,99,0,0,0,0,0,0,0,2​55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610005000,'Bandicoot',255,15,0,0,0,0,0,1,1,3000,0,0,0,502025,0,1,99,0,0,0,0,0,0​,0,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610009000,'Hornet',255,15,0,0,0,0,0,1,1,3000,0,0,0,502029,0,1,99,0,0,0,0,0,0,0,​255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610008000,'Goblin',255,15,0,0,0,0,0,1,1,3000,0,0,0,502028,0,1,99,0,0,0,0,0,0,0,​255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610014000,'Lamia',255,15,0,0,0,0,0,1,1,3000,0,0,0,502034,0,1,99,0,0,0,0,0,0,0,2​55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610007000,'Kekoon',255,15,0,0,0,0,0,1,1,3000,0,0,0,502027,0,1,99,0,0,0,0,0,0,0,​255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610011000,'Stone Golem',255,15,0,0,0,0,1,1,1,3000,0,0,0,502031,0,1,99,0,0,0,0,0,0,0,255,0,0,0,0,0​,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610013000,'Dragon Teeth Soldier',255,15,0,0,0,0,0,1,1,3000,0,0,0,502033,0,1,99,0,0,0,0,0,0,0,255,0,0,0,0​,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610006000,'Taion',255,15,0,0,0,0,0,1,1,3000,0,0,0,502026,0,1,99,0,0,0,0,0,0,0,2​55,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
    insert into [ITEM] Values (610010000,'Smirdon',255,15,0,0,0,0,0,1,1,3000,0,0,0,502030,0,1,99,0,0,0,0,0,0,0​,255,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)



    Şimdi İse Skill Olarak Kullanmak İçin MAGIC tablosunu halledelim
    Query Analizer den okutunuz

    Kod:

    insert into [MAGIC] Values (502032,'Harpy','Harpy',0,0,0,1,0,1,0,0,0,0,9,610012000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502025,'Bandicoot','Bandicoot',0,0,0,1,0,1,0,0,0,0,9,610005000,5,1,70,9,0,0,1,0​)
    insert into [MAGIC] Values (502027,'Kekoon','Kekoon',0,0,0,1,0,1,0,0,0,0,9,610007000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502026,'Taion','Taion',0,0,0,1,0,1,0,0,0,0,9,610006000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502028,'Goblin','Goblin',0,0,0,1,0,1,0,0,0,0,9,610008000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502029,'Hornet','Hornet',0,0,0,1,0,1,0,0,0,0,9,610009000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502031,'Stone Golem','Stone Golem',0,0,0,1,0,1,0,0,0,0,9,610011000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502033,'Dragon Teeth Soldier','Dragon Teeth Soldier',0,0,0,1,0,1,0,0,0,0,9,610013000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502034,'Lamia','Lamia',0,0,0,1,0,1,0,0,0,0,9,610014000,5,1,70,9,0,0,1,0)
    insert into [MAGIC] Values (502030,'Smirdon','Smirdon',0,0,0,1,0,1,0,0,0,0,9,610010000,5,1,70,9,0,0,1,0)



    Şimdi Satış için Ayarlıyoruz.
    Bir npc oluşturun ve iseellingGroup 212 olsun
    Sundriese ekli olsun istiyorsanız koddaki 212 leri 255 yapın
    Ama tblyi editlemeyide unutmayın İtem_org.tbl yi açıp
    Harpy,Lamia vs gibi aratın familiar diye uzantılıdır açıklama kısmı
    onun en son satırını değiştirin patchte verdiğim tbl 212 yi destekliyor

    Query Analizerden Okutunuz

    Kod:

    update ITEM set SellingGroup = '212' where Num = '610008000' or Num = '610011000'

    update ITEM set SellingGroup = '212' where Num = '610013000' or Num = '610009000'

    update ITEM set SellingGroup = '212' where Num = '610005000' or Num = '610012000'

    update ITEM set SellingGroup = '212' where Num = '610006000' or Num = '610010000'

    update ITEM set SellingGroup = '212' where Num = '610014000' or Num = '610007000'

    update ITEM set SellingGroup = '212' where Num = '610004000'



    Alış Satış Fiyatlarını Düzenleme

    Kod:

    update ITEM set SellPrice = 'AlışFiyat' where Num = '610008000' or Num = '610011000'

    update ITEM set SellPrice = 'AlışFiyat' where Num = '610013000' or Num = '610009000'

    update ITEM set SellPrice = 'AlışFiyat' where Num = '610005000' or Num = '610012000'

    update ITEM set SellPrice = 'AlışFiyat' where Num = '610006000' or Num = '610010000'

    update ITEM set SellPrice = 'AlışFiyat' where Num = '610014000' or Num = '610007000'

    update ITEM set SellPrice = 'AlışFiyat' where Num = '610004000'

    update ITEM set BuyPrice = 'SatışFiyat' where Num = '610008000' or Num = '610011000'

    update ITEM set BuyPrice = 'SatışFiyat' where Num = '610013000' or Num = '610009000'

    update ITEM set BuyPrice = 'SatışFiyat' where Num = '610005000' or Num = '610012000'

    update ITEM set BuyPrice = 'SatışFiyat' where Num = '610006000' or Num = '610010000'

    update ITEM set BuyPrice = 'SatışFiyat' where Num = '610014000' or Num = '610007000'

    update ITEM set BuyPrice = 'SatışFiyat' where Num = '610004000'




    Buda Patch

    [Linkleri görebilmek için üye olun veya giriş yapın.]

      Similar topics

      -

      Forum Saati Cuma Ara. 15, 2017 11:31 pm