PVPKO Usko Görev Takıları ve Bazı İtemleri DB'e Ekle - 1299 Private Server Tanıtım,Database,Client ve Procedure Paylaşım Blogu
KnightOnline PVP Server Tanıtımı
Metin2 PVP Server Tanıtım

31 Aralık 2008 Çarşamba

Usko Görev Takıları ve Bazı İtemleri DB'e Ekle


Kullanımı ;
Q.A kodlarını db'ye girmeniz yeterli olacaktır. Genelde bütün datalarda eklidir.

İtem Kodları;
Kod:
910153111 Mage Earring
910154112 Mercenary Earring
910155113 Assassin Earring
910156114 Priest Earring

910157137 Mercenary Pendant
910158138 Messenger Pendant
910159139 Cleric Pendant

910160118 Body Belt

910161271 Messenger Ring
910162272 Mercenary Ring
910163273 Assassin Ring
910164274 Priest Ring
Kod:
insert into [ITEM] Values (910153000,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154000,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155000,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156000,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164000,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163000,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161000,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162000,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157000,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158000,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159000,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160000,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,50,0,0,0,0,0,0,0)

insert into [ITEM] Values (910153111,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154112,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155113,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156114,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164274,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163273,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161271,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162272,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157137,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158138,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159139,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160118,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,50,0,0,0,0,0,0,0)

Insert into [ITEM] values (379015000,'Bezoar of Glyptodont',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379007000,'Tooth of Smilodon',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379008000,'Claw of Stegodon',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379009000,'Heart of Haunga',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379010000,'Gavolt scales',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379254000,'Wolf Hide',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (910165000,'Wolfman',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389251000,'Arcas',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389252000,'Virgo',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389253000,'Libra',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389254000,'Canes Venatici',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389255000,'Leo',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389256000,'hydra',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379253000,'Skeleton',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379045000,'Cursed Bone',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379251000,'Kekoon gallbladder',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379252000,'Black silk spool',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (910118000,'Kekoon Armor',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379013000,'Mythril vessel',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389522000,'Golden Star Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389523000,'Red Bow Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (389524000,'Tinsel Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379270000,'Smirdon Meat',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379271000,'Smirdon Hide',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379272000,'Silver Feather',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379273000,'Animal Blood',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379275000,'Coarse Ground Bone',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,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 (379276000,'Oath of Darkness',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Buradan Kodları Not Defteri İçinde İndirebilirsiniz.



Kodlar styLemert'den aLıntıdır.



Dipnot
Bu yazı 31 Aralık 2008 Çarşamba günü yazılmıştır. Bulunduğu kategori : . Yazdığım yazıları RSS 2.0 sistemini kullanarak takip edebilir, dilerseniz yorum yapabilirsiniz.
31 Aralık 2008 Çarşamba by d0FuTr[!] · 0

“Usko Görev Takıları ve Bazı İtemleri DB'e Ekle” Konusunda 0 Tane Yorum Var

Yorum Gönder

* Cümle büyük harfle başlar, nokta ile biter.
* Noktadan sonra boşluk bırakılır, yeni cümle başlar.
* "gelcem, gitcem, gidiyom" denmez "geleceğim, gideceğim, gidiyorum" denir.
* Herkez" denmez "herkes" denir.
* "Yaaaa" çok laubali bir sözdür.
* "bU şEkiLDE" yazmak sadece okuyanı yorar.
* "Yanlız" değil "Yalnız" denir.
* "ğ" harfi "g" şeklinde yazılamaz.
* "Bende, sende" denmez, "Ben de, sen de" denir.
* "Dahi" anlamındaki "de" ayrı yazılır.
* "Geldimi?" yazılmaz "Geldi mi?" yazılır. Soru takıları ayrı yazılır. "OKmi?" değil, "Tamam mı?" denir.
* "ahmet, belgin, duru" denmez. "Ahmet, Belgin, Duru" denir. Özel isimlerin, illerin, ülkelerin ilk harfleri büyük yazılır.
* "ki" eki, bağlaç olarak kullanılıyorsa ayrı, iyelik eki olarak kullanıyorsa birleşik yazılır.
* "v" yerine "w" yazılmaz...<
* "Evet" Yerine "ewt" yazılmaz.

YASAL UYARI !! Sitemiz, hukuka, yasalara, telif haklarına ve kişilik haklarına saygılı olmayı amaç edinmiştir. Sitemiz, 5651 sayılı yasada tanımlanan yer sağlayıcı olarak hizmet vermektedir. İlgili yasaya göre, site yönetiminin hukuka aykırı içerikleri kontrol etme yükümlülüğü yoktur. Bu nedenle, sitemiz uyar ve kaldır prensibini benimsemiştir. Telif hakkına konu olan eserlerin yasal olmayan bir biçimde paylaşıldığını ve yasal haklarının çiğnendiğini düşünen hak sahipleri veya meslek birlikleri, s.gezer92[at]gmail.com mail adresinden bize ulaşabilirler. Şikayet yerinde görüldüğü takdirde ihlal olduğu düşünülen içerikler sitemizden kaldırılacaktır.
Arkasında Google Var! | Bu site Google Adsense ile gelir sağlamaktadır.