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,