diff options
| author | Hercules.ws <Hercules@efficiently.awesome> | 2015-12-17 05:50:48 +0100 |
|---|---|---|
| committer | HerculesWSAPI <Hercules@efficiently.awesome> | 2015-12-17 05:50:48 +0100 |
| commit | 928937106625058745ca78508df98696905d528a (patch) | |
| tree | ff0c8c2b42a61fc5afe1ecdcd7834f5b50bde4b7 /sql-files | |
| parent | 58da8501fe630285f3934508e0c9314e99bbb5f8 (diff) | |
| download | hercules-928937106625058745ca78508df98696905d528a.tar.gz hercules-928937106625058745ca78508df98696905d528a.tar.bz2 hercules-928937106625058745ca78508df98696905d528a.tar.xz hercules-928937106625058745ca78508df98696905d528a.zip | |
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
| -rw-r--r-- | sql-files/item_db.sql | 59 | ||||
| -rw-r--r-- | sql-files/item_db_re.sql | 81 |
2 files changed, 71 insertions, 69 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 5688ebdd1..92f665b8a 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -4468,14 +4468,14 @@ REPLACE INTO `item_db` VALUES ('12140','4th_Stage_Prize','Fourth Stage Prize','2 REPLACE INTO `item_db` VALUES ('12141','5th_Stage_Prize','Fifth Stage Prize','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12142','Magic_Book','Book of Magic','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','506',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_AGI,1800000,10;','',''); REPLACE INTO `item_db` VALUES ('12143','Red_Can','Red Can','2','50000','25000','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12144','Sphere_Case_Wind','Lightning Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13204,500;','',''); -REPLACE INTO `item_db` VALUES ('12145','Sphere_Case_Darkness','Blind Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13206,500;','',''); -REPLACE INTO `item_db` VALUES ('12146','Sphere_Case_Poison','Poison Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13205,500;','',''); -REPLACE INTO `item_db` VALUES ('12147','Sphere_Case_Water','Freezing Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13207,500;','',''); -REPLACE INTO `item_db` VALUES ('12148','Sphere_Case_Fire','Flare Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13203,500;','',''); -REPLACE INTO `item_db` VALUES ('12149','Bullet_Case','Cartridge','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13200,500;','',''); -REPLACE INTO `item_db` VALUES ('12150','Bullet_Case_Blood','Blood Cartridge','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13202,500;','',''); -REPLACE INTO `item_db` VALUES ('12151','Bullet_Case_Silver','Silver Cartridge','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 13201,500;','',''); +REPLACE INTO `item_db` VALUES ('12144','Sphere_Case_Wind','Lightning Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Lightning_Sphere, 500;','',''); +REPLACE INTO `item_db` VALUES ('12145','Sphere_Case_Darkness','Blind Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Blind_Sphere, 500;','',''); +REPLACE INTO `item_db` VALUES ('12146','Sphere_Case_Poison','Poison Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Poison_Sphere, 500;','',''); +REPLACE INTO `item_db` VALUES ('12147','Sphere_Case_Water','Freezing Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Freezing_Sphere, 500;','',''); +REPLACE INTO `item_db` VALUES ('12148','Sphere_Case_Fire','Flare Sphere Pack','2','2','1','350','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Flare_Sphere, 500;','',''); +REPLACE INTO `item_db` VALUES ('12149','Bullet_Case','Cartridge','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Bullet, 500;','',''); +REPLACE INTO `item_db` VALUES ('12150','Bullet_Case_Blood','Blood Cartridge','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Shell_Of_Blood, 500;','',''); +REPLACE INTO `item_db` VALUES ('12151','Bullet_Case_Silver','Silver Cartridge','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Silver_Bullet, 500;','',''); REPLACE INTO `item_db` VALUES ('12152','Special_Box','Special Present','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); REPLACE INTO `item_db` VALUES ('12153','Bow_Mercenary_Scroll1','Bowman Scroll 1','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_ARCHER01, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12154','Bow_Mercenary_Scroll2','Bowman Scroll 2','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_ARCHER02, 1800000;','',''); @@ -4507,7 +4507,7 @@ REPLACE INTO `item_db` VALUES ('12179','SpearMercenary_Scroll7','Spearman Scroll REPLACE INTO `item_db` VALUES ('12180','SpearMercenary_Scroll8','Spearman Scroll 8','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_LANCER08, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12181','SpearMercenary_Scroll9','Spearman Scroll 9','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_LANCER09, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12182','SpearMercenary_Scroll10','Spearman Scroll 10','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_LANCER10, 1800000;','',''); -REPLACE INTO `item_db` VALUES ('12183','Holy_Arrow_Quiver','Holy Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1772,500;','',''); +REPLACE INTO `item_db` VALUES ('12183','Holy_Arrow_Quiver','Holy Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Holy_Arrow, 500;','',''); REPLACE INTO `item_db` VALUES ('12184','Mercenary_Red_Potion','Mercenary Red Potion','2','500','250','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_heal 1000,0;','',''); REPLACE INTO `item_db` VALUES ('12185','Mercenary_Blue_Potion','Mercenary Blue Potion','2','1000','500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_heal 0,100;','',''); REPLACE INTO `item_db` VALUES ('12186','Red_Box','Old Red Box','2','50000','25000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 12186,1;','',''); @@ -4662,7 +4662,7 @@ REPLACE INTO `item_db` VALUES ('12337','Grilled_Sausage','Grilled Sausages','0', REPLACE INTO `item_db` VALUES ('12338','Grilled_Corn','Grilled Corn','2','100','50','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_STR,180000,2; sc_start SC_FOOD_INT,180000,2; sc_start SC_FOOD_AGI,180000,2;','',''); REPLACE INTO `item_db` VALUES ('12339','Cherish_Box_Ori','Treasure Edition Box','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 12339,1;','',''); REPLACE INTO `item_db` VALUES ('12340','Mysterious_Rice_Powder','Chewy Rice Powder','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'1',NULL,'0',NULL,'0','pet 1815;','',''); -REPLACE INTO `item_db` VALUES ('12341','Special_Alloy_Trap_Box','Special Alloy Trap Box','2','30000','15000','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 7940,100;','',''); +REPLACE INTO `item_db` VALUES ('12341','Special_Alloy_Trap_Box','Special Alloy Trap Box','2','30000','15000','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Special_Alloy_Trap, 100;','',''); REPLACE INTO `item_db` VALUES ('12342','Manuk\'s_Opportunity','Manuk\'s Opportunity','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','475',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_POTION_BERSERK; sc_start SC_MANU_ATK,600000,10;','',''); REPLACE INTO `item_db` VALUES ('12343','Manuk\'s_Courage','Manuk\'s Courage','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','475',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_GUARD; sc_start SC_MANU_DEF,600000,10;','',''); REPLACE INTO `item_db` VALUES ('12344','Pinguicula\'s_fruit_Jam','Pinguicula\'s Fruit Jam','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','475',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_POTION_BERSERK; sc_start SC_SPL_ATK,600000,10;','',''); @@ -4697,14 +4697,14 @@ REPLACE INTO `item_db` VALUES ('12372','Hell_Contract','Hell Contract','2','20', REPLACE INTO `item_db` VALUES ('12373','Boy\'s_Naivety','Boy\'s Pure Heart','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','pet 1370;','',''); REPLACE INTO `item_db` VALUES ('12374','Flaming_Ice','Ice Fireworks','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','pet 1837;','',''); REPLACE INTO `item_db` VALUES ('12375','Acaraje','Akaraje','2','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_STEAL; sc_start2 SC_ACARAJE,120000,5,10;','',''); -REPLACE INTO `item_db` VALUES ('12376','Mysterious_Can2','Mysterious Can2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12377','Mysterious_PET_Bottle2','Mysterious PET Bottle2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12378','2009_Rice_Cake_Soup','Rice Cake Soup','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('12376','Mysterious_Can2','Mysterious Can2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 3, 0; itemskill PR_GLORIA, 2;','',''); +REPLACE INTO `item_db` VALUES ('12377','Mysterious_PET_Bottle2','Mysterious PET Bottle2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0, 3; itemskill PR_MAGNIFICAT, 1;','',''); +REPLACE INTO `item_db` VALUES ('12378','2009_Rice_Cake_Soup','Rice Cake Soup','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50, 50;','',''); REPLACE INTO `item_db` VALUES ('12379','Pope\'s_Cookie','Pope Cookie','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12380','Desert_Wolf_Babe_Scroll','Job Change Flute','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_create M_DESERT_WOLF_B, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12381','ValkyrieA_Scroll','Ancient Languages Scroll','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (strcharinfo(3) == \"job3_arch02\") { mercenary_create VALKYRIE_A, 1800000; }','',''); REPLACE INTO `item_db` VALUES ('12382','ValkyrieB_Scroll','Ancient Languages Scroll','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (strcharinfo(3) == \"job3_arch02\") { mercenary_create VALKYRIE_B, 1800000; }','',''); -REPLACE INTO `item_db` VALUES ('12383','Vulcan_Bullet_Magazine','Vulcan Bullet Magazine','2','11000','5500','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('12383','Vulcan_Bullet_Magazine','Vulcan Bullet Magazine','2','11000','5500','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Vulcan_Bullet, 1000;','',''); REPLACE INTO `item_db` VALUES ('12384','Rainbow_Ruby_Water','Rainbow Ruby','11','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12385','Rainbow_Ruby_Fire','Rainbow Ruby','11','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12386','Rainbow_Ruby_Wind','Rainbow Ruby','11','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -4713,9 +4713,9 @@ REPLACE INTO `item_db` VALUES ('12388','Runstone_Crush','Rhydo Runestone For App REPLACE INTO `item_db` VALUES ('12389','Runstone_Storm','Pertz Runestone For Apprentice','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12390','Runstone_Millennium','Verkana Runestone For Apprentice','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12391','Lucky_Egg_C','Lucky Egg','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); -REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','220','110','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12393','RepairB','Repair B','0','500','250','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12394','RepairC','Repair C','0','1100','550','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','220','110','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(200,300), 0;','',''); +REPLACE INTO `item_db` VALUES ('12393','RepairB','Repair B','0','500','250','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(300,400), 0;','',''); +REPLACE INTO `item_db` VALUES ('12394','RepairC','Repair C','0','1100','550','70','0','0','0','0','0','1024','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(400,500), 0;','',''); REPLACE INTO `item_db` VALUES ('12395','Tantanmen','Tantan Noodle','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','pet 1519;','',''); REPLACE INTO `item_db` VALUES ('12396','Fools_Day_Box','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'1',NULL,'0',NULL,'0','.@temp = rand(1,10); if (.@temp == 1) itemskill AL_TELEPORT,1; else if (.@temp == 2) itemskill AL_TELEPORT,3; else if (.@temp == 3) percentheal 50,0; else if (.@temp == 4) percentheal 0,50; else if (.@temp == 5) percentheal 50,50; else if (.@temp == 6) getitem Apple,1; else if (.@temp == 7) itemskill ALL_REVERSEORCISH,1; else if (.@temp == 8) specialeffect2 EF_MAPPILLAR2; else if (.@temp == 9) specialeffect2 EF_ANGEL2; else specialeffect2 EF_COIN;','',''); REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'1',NULL,'0',NULL,'0','.@temp = rand(1,10); if (.@temp == 1) itemskill TF_DETOXIFY,1; else if (.@temp == 2) itemskill TF_PICKSTONE,1; else if (.@temp == 3) itemskill BA_FROSTJOKER,1; else if (.@temp == 4) itemskill DC_SCREAM,1; else if (.@temp == 5) percentheal 50,50; else if (.@temp == 6) getitem Jellopy,1; else if (.@temp == 7) itemskill AL_RUWACH,1; else if (.@temp == 8) specialeffect2 EF_BEGINASURA; else if (.@temp == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','',''); @@ -4726,7 +4726,7 @@ REPLACE INTO `item_db` VALUES ('12401','Rune_Kn_Test_Int','Rune Kn Test Int','2' REPLACE INTO `item_db` VALUES ('12402','29Fruit','29Fruit','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12403','Lucky_Egg_C2','Lucky Egg2','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12404','Acti_Potion','Acti Potion','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12405','Underripe_Yggseed','Underripe Yggseed','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('12405','Underripe_Yggseed','Underripe Yggseed','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','percentheal 30,30; skilleffect AL_BLESSING,0; sc_start SC_BLESSING,140000,5;','',''); REPLACE INTO `item_db` VALUES ('12406','Psychic_ArmorS','Psychic ArmorS','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12407','PCBang_Coupon_Box','PCBang Coupon Box','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12408','Leaf_Cat_Ball','Leaf Cat Ball','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','pet 2081;','',''); @@ -4848,12 +4848,13 @@ REPLACE INTO `item_db` VALUES ('12525','E_Assumptio_5_Scroll','E Assumptio 5 Scr REPLACE INTO `item_db` VALUES ('12526','E_Wind_Walk_10_Scroll','E Wind Walk 10 Scroll','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12527','E_Adrenaline_Scroll','E Adrenaline Scroll','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12528','E_Convex_Mirror','E Convex Mirror','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12529','White_Slim_Potion_Box','White Slim Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12530','Mastela_Fruit_Box','Mastela Fruit Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12531','White_Potion_Box','White Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Potion,100;','',''); -REPLACE INTO `item_db` VALUES ('12532','Royal_Jelly_Box2','Royal Jelly Box2','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Royal_Jelly,100;','',''); -REPLACE INTO `item_db` VALUES ('12533','Blue_Herb_Box2','Blue Herb Box2','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Blue_Herb,100;','',''); -REPLACE INTO `item_db` VALUES ('12534','Yggdrasil_Seed_Box','Yggdrasil Seed Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Seed_Of_Yggdrasil,30;','',''); +REPLACE INTO `item_db` VALUES ('12529','White_Slim_Potion_Box','White Slim Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Slim_Potion, 200;','',''); +REPLACE INTO `item_db` VALUES ('12530','Mastela_Fruit_Box','Mastela Fruit Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Fruit_Of_Mastela, 200;','',''); +REPLACE INTO `item_db` VALUES ('12531','White_Potion_Box','White Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Potion, 100;','',''); +REPLACE INTO `item_db` VALUES ('12532','Royal_Jelly_Box2','Royal Jelly Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Royal_Jelly, 100;','',''); +REPLACE INTO `item_db` VALUES ('12533','Blue_Herb_Box2','Blue Herb Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Blue_Herb, 100;','',''); +REPLACE INTO `item_db` VALUES ('12534','Yggdrasil_Seed_Box','Yggdrasil Seed Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Seed_Of_Yggdrasil, 30;','',''); +REPLACE INTO `item_db` VALUES ('12535','Iggdrasilberry_Box','Yggdrasil Berry Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Yggdrasilberry, 15;','',''); REPLACE INTO `item_db` VALUES ('12536','NY_Rice_Cake_Soup','NY Rice Cake Soup','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 20,20;','',''); REPLACE INTO `item_db` VALUES ('12537','Solo_Gift_Basket','Solo Gift Basket','2','1000','500','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); REPLACE INTO `item_db` VALUES ('12538','Couple_Event_Basket','Couple Event Basket','2','2000','1000','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); @@ -4867,8 +4868,8 @@ REPLACE INTO `item_db` VALUES ('12545','Lucky_Egg_C5','Lucky Egg C5','2','20','1 REPLACE INTO `item_db` VALUES ('12546','Suspicious_Dish','Suspicious Dish','2','100','50','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_POISON,12000,0;','',''); REPLACE INTO `item_db` VALUES ('12547','Chalcenodny_Box','Chalcenodny Box','2','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12548','Buy_Market_Permit2','Shabby Purchase Street Stall License','2','500','250','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','buyingstore 2;','',''); -REPLACE INTO `item_db` VALUES ('12549','White_Slim_Pot_Box2','White Slim Pot Box2','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Slim_Potion,200;','',''); -REPLACE INTO `item_db` VALUES ('12550','Poison_Bottle_Box2','Poison Bottle Box2','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Poison_Bottle,30;','',''); +REPLACE INTO `item_db` VALUES ('12549','White_Slim_Pot_Box2','White Slim Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Slim_Potion, 100;','',''); +REPLACE INTO `item_db` VALUES ('12550','Poison_Bottle_Box2','Poison Bottle Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Poison_Bottle, 30;','',''); REPLACE INTO `item_db` VALUES ('12551','MVP_Tele_Scroll','MVP Tele Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12552','Quest_Tele_Scroll','Quest Tele Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12553','Brysinggamen_Piece_Box','Brysinggamen Piece Box','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -4943,9 +4944,9 @@ REPLACE INTO `item_db` VALUES ('12738','Runstone_Rare','Rare Rune','0','2','1',' REPLACE INTO `item_db` VALUES ('12739','Snow_Flower','Snow Flowers','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 10,10;','',''); REPLACE INTO `item_db` VALUES ('12740','Inc_Str_Scroll','Amplification Scroll','2','1','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12741','Inc_Int_Scroll','Intellect Amplification Scroll','2','1','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12742','Valentine_Gift_Box1','Valentine Gift Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Valentine_Gold_Ring,1;','',''); -REPLACE INTO `item_db` VALUES ('12743','Valentine_Gift_Box2','Valentine Gift Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Valentine_Silver_Ring,1;','',''); -REPLACE INTO `item_db` VALUES ('12744','Chocotate_Box','Chocolate Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Chocolate,1;','',''); +REPLACE INTO `item_db` VALUES ('12742','Valentine_Gift_Box1','Valentine Gift Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Valentine_Gold_Ring, 1;','',''); +REPLACE INTO `item_db` VALUES ('12743','Valentine_Gift_Box2','Valentine Gift Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Valentine_Silver_Ring, 1;','',''); +REPLACE INTO `item_db` VALUES ('12744','Chocotate_Box','Chocolate Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Chocolate, 1;','',''); REPLACE INTO `item_db` VALUES ('12745','Skull_Scroll','Skull Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','sc_start SC_SKELSCROLL,1800000,5;','',''); REPLACE INTO `item_db` VALUES ('12746','Destruction_Scroll','Destruction Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DISTRUCTIONSCROLL,1800000,5;','',''); REPLACE INTO `item_db` VALUES ('12747','Royal_Scroll','Royal Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_ROYALSCROLL,1800000,5;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index b3c602741..5a5821845 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -5601,18 +5601,18 @@ REPLACE INTO `item_db` VALUES ('12000','Cold_Scroll_2_5','Level 5 Frost Diver',' REPLACE INTO `item_db` VALUES ('12001','Holy_Scroll_1_3','Level 3 Heal','11','1000','500','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill AL_HEAL,3;','',''); REPLACE INTO `item_db` VALUES ('12002','Holy_Scroll_1_5','Level 5 Heal','11','2000','1000','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','itemskill AL_HEAL,5;','',''); REPLACE INTO `item_db` VALUES ('12003','Holy_Scroll_2_1','Level 1 Teleport','11','1000','500','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','itemskill AL_TELEPORT,1;','',''); -REPLACE INTO `item_db` VALUES ('12004','Arrow_Container','Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1750,500;','',''); -REPLACE INTO `item_db` VALUES ('12005','Iron_Arrow_Container','Iron Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1770,500;','',''); -REPLACE INTO `item_db` VALUES ('12006','Steel_Arrow_Container','Steel Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1753,500;','',''); -REPLACE INTO `item_db` VALUES ('12007','Ori_Arrow_Container','Oridecon Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1765,500;','',''); -REPLACE INTO `item_db` VALUES ('12008','Fire_Arrow_Container','Fire Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1752,500;','',''); -REPLACE INTO `item_db` VALUES ('12009','Silver_Arrow_Container','Silver Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1751,500;','',''); -REPLACE INTO `item_db` VALUES ('12010','Wind_Arrow_Container','Wind Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1755,500;','',''); -REPLACE INTO `item_db` VALUES ('12011','Stone_Arrow_Container','Stone Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1756,500;','',''); -REPLACE INTO `item_db` VALUES ('12012','Crystal_Arrow_Container','Crystal Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1754,500;','',''); -REPLACE INTO `item_db` VALUES ('12013','Shadow_Arrow_Container','Shadow Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1767,500;','',''); -REPLACE INTO `item_db` VALUES ('12014','Imma_Arrow_Container','Immaterial Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1757,500;','',''); -REPLACE INTO `item_db` VALUES ('12015','Rusty_Arrow_Container','Rusty Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1762,500;','',''); +REPLACE INTO `item_db` VALUES ('12004','Arrow_Container','Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12005','Iron_Arrow_Container','Iron Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Iron_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12006','Steel_Arrow_Container','Steel Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Steel_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12007','Ori_Arrow_Container','Oridecon Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Oridecon_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12008','Fire_Arrow_Container','Fire Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Fire_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12009','Silver_Arrow_Container','Silver Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Silver_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12010','Wind_Arrow_Container','Wind Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Arrow_Of_Wind, 500;','',''); +REPLACE INTO `item_db` VALUES ('12011','Stone_Arrow_Container','Stone Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Stone_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12012','Crystal_Arrow_Container','Crystal Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Crystal_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12013','Shadow_Arrow_Container','Shadow Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Arrow_Of_Shadow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12014','Imma_Arrow_Container','Immaterial Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Immatrial_Arrow, 500;','',''); +REPLACE INTO `item_db` VALUES ('12015','Rusty_Arrow_Container','Rusty Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Rusty_Arrow, 500;','',''); REPLACE INTO `item_db` VALUES ('12016','Speed_Up_Potion','Speed Potion','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_MOVHASTE_INFINITY,5000,0;','',''); REPLACE INTO `item_db` VALUES ('12017','Slow_Down_Potion','Slow Potion','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_SLOWDOWN,5000,0;','',''); REPLACE INTO `item_db` VALUES ('12018','Fire_Cracker','Firecracker','2','2','1','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','end;','',''); @@ -5780,7 +5780,7 @@ REPLACE INTO `item_db` VALUES ('12179','SpearMercenary_Scroll7','Spearman Scroll REPLACE INTO `item_db` VALUES ('12180','SpearMercenary_Scroll8','Spearman Scroll 8','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_LANCER08, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12181','SpearMercenary_Scroll9','Spearman Scroll 9','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_LANCER09, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12182','SpearMercenary_Scroll10','Spearman Scroll 10','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','mercenary_create MER_LANCER10, 1800000;','',''); -REPLACE INTO `item_db` VALUES ('12183','Holy_Arrow_Quiver','Holy Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 1772,500;','',''); +REPLACE INTO `item_db` VALUES ('12183','Holy_Arrow_Quiver','Holy Arrow Quiver','2','2','1','250','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Holy_Arrow, 500;','',''); REPLACE INTO `item_db` VALUES ('12184','Mercenary_Red_Potion','Mercenary Red Potion','2','500','250','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_heal 1000,0;','',''); REPLACE INTO `item_db` VALUES ('12185','Mercenary_Blue_Potion','Mercenary Blue Potion','2','1000','500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_heal 0,100;','',''); REPLACE INTO `item_db` VALUES ('12186','Red_Box','Old Red Box','2','50000','25000','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 12186,1;','',''); @@ -5970,14 +5970,14 @@ REPLACE INTO `item_db` VALUES ('12372','Hell_Contract','Hell Contract','2','20', REPLACE INTO `item_db` VALUES ('12373','Boy\'s_Naivety','Boy\'s Pure Heart','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','pet 1370;','',''); REPLACE INTO `item_db` VALUES ('12374','Flaming_Ice','Ice Fireworks','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','pet 1837;','',''); REPLACE INTO `item_db` VALUES ('12375','Acaraje','Akaraje','2','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_STEAL; sc_start2 SC_ACARAJE,120000,5,10;','',''); -REPLACE INTO `item_db` VALUES ('12376','Mysterious_Can2','Mysterious Can2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 3,0; itemskill PR_GLORIA,2;','',''); -REPLACE INTO `item_db` VALUES ('12377','Mysterious_PET_Bottle2','Mysterious PET Bottle2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0,3; itemskill PR_MAGNIFICAT,1;','',''); -REPLACE INTO `item_db` VALUES ('12378','2009_Rice_Cake_Soup','Rice Cake Soup','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50,50;','',''); +REPLACE INTO `item_db` VALUES ('12376','Mysterious_Can2','Mysterious Can2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 3, 0; itemskill PR_GLORIA, 2;','',''); +REPLACE INTO `item_db` VALUES ('12377','Mysterious_PET_Bottle2','Mysterious PET Bottle2','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'1',NULL,'0',NULL,'0','percentheal 0, 3; itemskill PR_MAGNIFICAT, 1;','',''); +REPLACE INTO `item_db` VALUES ('12378','2009_Rice_Cake_Soup','Rice Cake Soup','2','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50, 50;','',''); REPLACE INTO `item_db` VALUES ('12379','Pope\'s_Cookie','Pope Cookie','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12380','Desert_Wolf_Babe_Scroll','Job Change Flute','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','mercenary_create M_DESERT_WOLF_B, 1800000;','',''); REPLACE INTO `item_db` VALUES ('12381','ValkyrieA_Scroll','Ancient Language Scroll','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (strcharinfo(3) == \"job3_arch02\") { mercenary_create VALKYRIE_A, 1800000; }','',''); REPLACE INTO `item_db` VALUES ('12382','ValkyrieB_Scroll','Ancient Language Scroll','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (strcharinfo(3) == \"job3_arch02\") { mercenary_create VALKYRIE_B, 1800000; }','',''); -REPLACE INTO `item_db` VALUES ('12383','Vulcan_Bullet_Magazine','Vulcan Bullet Magazine','2','13750','6875','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('12383','Vulcan_Bullet_Magazine','Vulcan Bullet Magazine','2','13750','6875','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Vulcan_Bullet, 1000;','',''); REPLACE INTO `item_db` VALUES ('12384','Rainbow_Ruby_Water','Rainbow Ruby','11','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_war02\") { itemskill WL_FROSTMISTY,5; }','',''); REPLACE INTO `item_db` VALUES ('12385','Rainbow_Ruby_Fire','Rainbow Ruby','11','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_war02\") { itemskill WL_CRIMSONROCK,5; }','',''); REPLACE INTO `item_db` VALUES ('12386','Rainbow_Ruby_Wind','Rainbow Ruby','11','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_war02\") { itemskill WL_CHAINLIGHTNING,5; }','',''); @@ -5986,9 +5986,9 @@ REPLACE INTO `item_db` VALUES ('12388','Runstone_Crush','Rhydo Runestone For App REPLACE INTO `item_db` VALUES ('12389','Runstone_Storm','Pertz Runestone For Apprentice','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_rune02\") { itemskill RK_STORMBLAST,1; }','',''); REPLACE INTO `item_db` VALUES ('12390','Runstone_Millennium','Verkana Runestone For Apprentice','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'1',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_rune02\") { itemskill RK_MILLENNIUMSHIELD,1; }','',''); REPLACE INTO `item_db` VALUES ('12391','Lucky_Egg_C','RWC Groove Pack','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); -REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','275','137','100','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(200,300),0;','',''); -REPLACE INTO `item_db` VALUES ('12393','RepairB','Repair B','0','625','312','140','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(300,400),0;','',''); -REPLACE INTO `item_db` VALUES ('12394','RepairC','Repair C','0','1375','687','180','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(400,500),0;','',''); +REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','275','137','100','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(200,300), 0;','',''); +REPLACE INTO `item_db` VALUES ('12393','RepairB','Repair B','0','625','312','140','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(300,400), 0;','',''); +REPLACE INTO `item_db` VALUES ('12394','RepairC','Repair C','0','1375','687','180','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmount() == MOUNT_MADO) itemheal rand(400,500), 0;','',''); REPLACE INTO `item_db` VALUES ('12395','Tantanmen','Tantan Noodle','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','pet 1519;','',''); REPLACE INTO `item_db` VALUES ('12396','Fools_Day_Box','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','.@temp = rand(1,10); if (.@temp == 1) itemskill AL_TELEPORT,1; else if (.@temp == 2) itemskill AL_TELEPORT,3; else if (.@temp == 3) percentheal 50,0; else if (.@temp == 4) percentheal 0,50; else if (.@temp == 5) percentheal 50,50; else if (.@temp == 6) getitem Apple,1; else if (.@temp == 7) itemskill ALL_REVERSEORCISH,1; else if (.@temp == 8) specialeffect2 EF_MAPPILLAR2; else if (.@temp == 9) specialeffect2 EF_ANGEL2; else specialeffect2 EF_COIN;','',''); REPLACE INTO `item_db` VALUES ('12397','Fools_Day_Box2','Gift Box?','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','.@temp = rand(1,10); if (.@temp == 1) itemskill TF_DETOXIFY,1; else if (.@temp == 2) itemskill TF_PICKSTONE,1; else if (.@temp == 3) itemskill BA_FROSTJOKER,1; else if (.@temp == 4) itemskill DC_SCREAM,1; else if (.@temp == 5) percentheal 50,50; else if (.@temp == 6) getitem Jellopy,1; else if (.@temp == 7) itemskill AL_RUWACH,1; else if (.@temp == 8) specialeffect2 EF_BEGINASURA; else if (.@temp == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','',''); @@ -6121,12 +6121,13 @@ REPLACE INTO `item_db` VALUES ('12525','E_Assumptio_5_Scroll','E Assumptio 5 Scr REPLACE INTO `item_db` VALUES ('12526','E_Wind_Walk_10_Scroll','E Wind Walk 10 Scroll','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12527','E_Adrenaline_Scroll','E Adrenaline Scroll','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12528','E_Convex_Mirror','E Convex Mirror','2','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12529','White_Slim_Potion_Box','Condensed White Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12530','Mastela_Fruit_Box','Mastela Fruit Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12531','White_Potion_Box','White Potion 100 Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Potion,100;','',''); -REPLACE INTO `item_db` VALUES ('12532','Royal_Jelly_Box2','Royal Jelly Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Royal_Jelly,100;','',''); -REPLACE INTO `item_db` VALUES ('12533','Blue_Herb_Box2','Blue Herb Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Blue_Herb,100;','',''); -REPLACE INTO `item_db` VALUES ('12534','Yggdrasil_Seed_Box','Yggdrasil Seed Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Seed_Of_Yggdrasil,30;','',''); +REPLACE INTO `item_db` VALUES ('12529','White_Slim_Potion_Box','White Slim Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Slim_Potion, 200;','',''); +REPLACE INTO `item_db` VALUES ('12530','Mastela_Fruit_Box','Mastela Fruit Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Fruit_Of_Mastela, 200;','',''); +REPLACE INTO `item_db` VALUES ('12531','White_Potion_Box','White Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Potion, 100;','',''); +REPLACE INTO `item_db` VALUES ('12532','Royal_Jelly_Box2','Royal Jelly Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Royal_Jelly, 100;','',''); +REPLACE INTO `item_db` VALUES ('12533','Blue_Herb_Box2','Blue Herb Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Blue_Herb, 100;','',''); +REPLACE INTO `item_db` VALUES ('12534','Yggdrasil_Seed_Box','Yggdrasil Seed Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Seed_Of_Yggdrasil, 30;','',''); +REPLACE INTO `item_db` VALUES ('12535','Iggdrasilberry_Box','Yggdrasil Berry Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Yggdrasilberry, 15;','',''); REPLACE INTO `item_db` VALUES ('12536','NY_Rice_Cake_Soup','New Year\'s Rice Cake','2','20','10','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 20,20;','',''); REPLACE INTO `item_db` VALUES ('12537','Solo_Gift_Basket','Gift Chocolate Basket','2','1000','500','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); REPLACE INTO `item_db` VALUES ('12538','Couple_Event_Basket','Firecracker Basket','2','2000','1000','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); @@ -6140,8 +6141,8 @@ REPLACE INTO `item_db` VALUES ('12545','Lucky_Egg_C5','Fortune Egg','2','20','10 REPLACE INTO `item_db` VALUES ('12546','Suspicious_Dish','Dark matter','2','100','50','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_POISON,12000,0;','',''); REPLACE INTO `item_db` VALUES ('12547','Chalcenodny_Box','Chalcenodny Box','2','0','0','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12548','Buy_Market_Permit2','Black Market Bulk Buyer Shop License','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','buyingstore 2;','',''); -REPLACE INTO `item_db` VALUES ('12549','White_Slim_Pot_Box2','Condensed White Potion 200 Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Slim_Potion,200;','',''); -REPLACE INTO `item_db` VALUES ('12550','Poison_Bottle_Box2','Poison Bottle Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Poison_Bottle,30;','',''); +REPLACE INTO `item_db` VALUES ('12549','White_Slim_Pot_Box2','White Slim Potion Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem White_Slim_Potion, 100;','',''); +REPLACE INTO `item_db` VALUES ('12550','Poison_Bottle_Box2','Poison Bottle Box','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Poison_Bottle, 30;','',''); REPLACE INTO `item_db` VALUES ('12551','MVP_Tele_Scroll','MVP Tele Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12552','Quest_Tele_Scroll','Quest Tele Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12553','Brysinggamen_Piece_Box','Brysinggamen Keep Box','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -6221,13 +6222,13 @@ REPLACE INTO `item_db` VALUES ('12631','Macro_Stone_A','Stone (1Hour)','11','0', REPLACE INTO `item_db` VALUES ('12632','Macro_Stone_B','Stone (1Hour)','11','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12633','Malang_Cat_Can','Malang Cat Can','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','specialeffect EF_MAGICALATTHIT; sc_start2 SC_OVERLAPEXPUP,1200000,10,20;','',''); REPLACE INTO `item_db` VALUES ('12636','Malang_Sp_Can','Malang Sp Can','2','20','10','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','warp \"malangdo\",140,114;','',''); -REPLACE INTO `item_db` VALUES ('12637','Gong_Bug_Pocket','Gong Bug Pocket','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Gong_Bung,200;','',''); -REPLACE INTO `item_db` VALUES ('12638','Dried_Squid_Box','Dried Squid Box','11','20','10','2000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Dried_Squid,200;','',''); -REPLACE INTO `item_db` VALUES ('12639','Flying_Fish_Box','Flying Fish Box','11','20','10','2000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Flying_Fish,200;','',''); -REPLACE INTO `item_db` VALUES ('12640','Starfish_Box','Starfish Box','11','20','10','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Starfish,200;','',''); +REPLACE INTO `item_db` VALUES ('12637','Gong_Bug_Pocket','Gong Bug Pocket','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Gong_Bung, 200;','',''); +REPLACE INTO `item_db` VALUES ('12638','Dried_Squid_Box','Dried Squid Box','11','20','10','2000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Dried_Squid, 200;','',''); +REPLACE INTO `item_db` VALUES ('12639','Flying_Fish_Box','Flying Fish Box','11','20','10','2000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Flying_Fish, 200;','',''); +REPLACE INTO `item_db` VALUES ('12640','Starfish_Box','Starfish Box','11','20','10','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Starfish, 200;','',''); REPLACE INTO `item_db` VALUES ('12641','Lucky_Egg_C8','New Recruit Pack','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12642','Fruit_Of_Mastela_Box2','Fruit Box (100)','0','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Fruit_Of_Mastela,100;','',''); -REPLACE INTO `item_db` VALUES ('12643','E_Coin_Pack50','E Coin Pack50','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Egrade_Coin,50;','',''); +REPLACE INTO `item_db` VALUES ('12642','Fruit_Of_Mastela_Box2','Mastela Fruit 100 Box','0','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','getitem Fruit_Of_Mastela, 100;','',''); +REPLACE INTO `item_db` VALUES ('12643','E_Coin_Pack50','E Coin Pack50','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Egrade_Coin, 50;','',''); REPLACE INTO `item_db` VALUES ('12644','PCBang_Coupon_Box4','PCRoom Coupon Box IV','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12645','J_Aspersio_5_Scroll_C','Sacred Scroll','11','2','1','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12646','Takoyaki','Fired Octopus','2','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_LUK,6000,10; sc_start SC_PLUSATTACKPOWER,6000,20; sc_start SC_PLUSMAGICPOWER,6000,20;','',''); @@ -6260,14 +6261,14 @@ REPLACE INTO `item_db` VALUES ('12672','Start_New_Box','Start New Box','2','20', REPLACE INTO `item_db` VALUES ('12673','Lucky_Egg_C10','Lucky Egg C10','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12674','God_Material_Box','God Material Box','2','20','10','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12675','Sg_Weapon_Supply_Box','Siege Weapon Supply Box','2','20','10','500','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem Sg_Weapon_Supply_Box,1;','',''); -REPLACE INTO `item_db` VALUES ('12676','Sg_Violet_Potion_Box','Siege Violet Potion Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_Violet_Potion,50;','',''); -REPLACE INTO `item_db` VALUES ('12677','Siege_Arrow_Quiver_S','Siege Arrow Quiver S','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','130',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Siege_Arrow_S,200;','',''); -REPLACE INTO `item_db` VALUES ('12678','Siege_Arrow_Quiver_A','Siege Arrow Quiver A','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','95',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Siege_Arrow_A,200;','',''); -REPLACE INTO `item_db` VALUES ('12679','Sg_White_Potion_Box','Siege White Potion Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_White_Potion,30;','',''); -REPLACE INTO `item_db` VALUES ('12680','Sg_Blue_Potion_Box','Siege Blue Potion Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_Blue_Potion,10;','',''); +REPLACE INTO `item_db` VALUES ('12676','Sg_Violet_Potion_Box','Siege Violet Potion Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_Violet_Potion, 50;','',''); +REPLACE INTO `item_db` VALUES ('12677','Siege_Arrow_Quiver_S','Siege Arrow Quiver S','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','130',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Siege_Arrow_S, 200;','',''); +REPLACE INTO `item_db` VALUES ('12678','Siege_Arrow_Quiver_A','Siege Arrow Quiver A','2','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','95',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Siege_Arrow_A, 200;','',''); +REPLACE INTO `item_db` VALUES ('12679','Sg_White_Potion_Box','Siege White Potion Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_White_Potion, 30;','',''); +REPLACE INTO `item_db` VALUES ('12680','Sg_Blue_Potion_Box','Siege Blue Potion Box','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_Blue_Potion, 10;','',''); REPLACE INTO `item_db` VALUES ('12681','Nestea_Lemon','Nestea Lemon','2','0','0','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12682','Nestea_Blacktea','Nestea Black Tea','2','0','0','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('12683','Sg_Vi_Potion_Box200','Siege Violet Potion Box (200)','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_Violet_Potion,50;','',''); +REPLACE INTO `item_db` VALUES ('12683','Sg_Vi_Potion_Box200','Siege Violet Potion Box (200)','2','20','10','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem Woe_Violet_Potion, 200;','',''); REPLACE INTO `item_db` VALUES ('12684','ASPD_Potion','ASPD Potion','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12685','Gryphon_Egg_Scroll','Gryphon Egg Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('12686','Str_Dish20','Str Dish20','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); |