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
[Linkleri görebilmek için üye olun veya giriş yapın.]
Anasayfa
