Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY)

    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)

    Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY)

    Mesaj tarafından Admin Bir Cuma Tem. 18, 2008 6:41 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,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 (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,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 (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,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 (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

    Kod:
    [url=http://rapidshare.com/files/128335567/Pet-Patch.rar][color=cyan]http://rapidshare.com/files/128335567/Pet-Patch.rar[/color][/url]

    İyi Pet Koşturmalar


    P
    Q
    K
    E
    M
    Q

    £
    M
    P
    İ
    R
    E

      Forum Saati C.tesi Ara. 15, 2018 2:49 am