Would you like to react to this message? Create an account in a few clicks or log in to continue.

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

    Admin
    Admin
    Admin
    YöneticiYönetici


    Erkek
    Mesaj Sayısı : 677
    Yaş : 33
    Nerden : çanakkale
    İş/Hobiler : öğrenci
    Lakap : webci
    Ruh Hali : Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Olgun10
    işletim sistemin : Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Yk-xp
    Seviye : Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Adminpw9
    Madalyaların : Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) 2c86f87e84e0330c97a7945abd3f976d
    Metin Alanı :
    Vatanını Seven Görevini En İyi Yapandı®.ElitSepet TeaM<<<< YÖNETİCİ

    Sanal Hayvan : Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Hay31hu1
    Rap Derecesi : Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Reputationpossscv3
    Kayıt tarihi : 15/07/08

    Rap Puanın
    Aktiflik:
    Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Img_left4999/5000Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Empty_bar_bleue  (4999/5000)
    Başarı puanı:
    Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Left_bar_bleue98787/98787Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Empty_bar_bleue  (98787/98787)
    Güçlülük :
    Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Img_left4999/5000Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Empty_bar_bleue  (4999/5000)
    • Post n°1

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

    Mesaj tarafından Admin 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 Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Biggrin
    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 Pet Eklemek - Satış Npcsi-Skill ve Patch (QUERY) Biggrin


    P
    Q
    K
    E
    M
    Q

    £
    M
    P
    İ
    R
    E
    • Sayfa başına dön

      Forum Saati Salı Mayıs 21, 2024 12:41 am