summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-11-19 03:57:48 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-11-19 03:57:48 +0100
commit38bc4ce5ea082f221c3eb9c3dcd07391a8322545 (patch)
tree33762bbe9248a78b83cb7b690361881393ae12a8 /sql-files/item_db.sql
parent2fde851befe5237d860b1ece86e962287f0fb11f (diff)
downloadhercules-38bc4ce5ea082f221c3eb9c3dcd07391a8322545.tar.gz
hercules-38bc4ce5ea082f221c3eb9c3dcd07391a8322545.tar.bz2
hercules-38bc4ce5ea082f221c3eb9c3dcd07391a8322545.tar.xz
hercules-38bc4ce5ea082f221c3eb9c3dcd07391a8322545.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files/item_db.sql')
-rw-r--r--sql-files/item_db.sql46
1 files changed, 23 insertions, 23 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index 4688c1690..d53c956a9 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -4699,8 +4699,8 @@ REPLACE INTO `item_db` VALUES ('12392','RepairA','Repair A','0','220','110','70'
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 ('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','if(rand(1,10)==1) itemskill AL_TELEPORT,1; else if(rand(1,10)==2) itemskill AL_TELEPORT,3; else if(rand(1,10)==3) percentheal 50,0; else if(rand(1,10)==4) percentheal 0,50; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 512,1; else if(rand(1,10)==7) itemskill ALL_REVERSEORCISH,1; else if(rand(1,10)==8) specialeffect2 247; else if(rand(1,10)==9) specialeffect2 338; else specialeffect2 10;','','');
-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','if(rand(1,10)==1) itemskill TF_DETOXIFY,1; else if(rand(1,10)==2) itemskill TF_PICKSTONE,1; else if(rand(1,10)==3) itemskill BA_FROSTJOKER,1; else if(rand(1,10)==4) itemskill DC_SCREAM,1; else if(rand(1,10)==5) end; else if(rand(1,10)==6) getitem 909,1; else if(rand(1,10)==7) itemskill AL_RUWACH,1; else if(rand(1,10)==8) specialeffect2 328; else if(rand(1,10)==9) specialeffect2 68; else specialeffect2 196;','','');
+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','if (rand(1,10) == 1) itemskill AL_TELEPORT,1; else if (rand(1,10) == 2) itemskill AL_TELEPORT,3; else if (rand(1,10) == 3) percentheal 50,0; else if (rand(1,10) == 4) percentheal 0,50; else if (rand(1,10) == 5) percentheal 50,50; else if (rand(1,10) == 6) getitem Apple,1; else if (rand(1,10) == 7) itemskill ALL_REVERSEORCISH,1; else if (rand(1,10) == 8) specialeffect2 EF_MAPPILLAR2; else if (rand(1,10) == 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','if (rand(1,10) == 1) itemskill TF_DETOXIFY,1; else if (rand(1,10) == 2) itemskill TF_PICKSTONE,1; else if (rand(1,10) == 3) itemskill BA_FROSTJOKER,1; else if (rand(1,10) == 4) itemskill DC_SCREAM,1; else if (rand(1,10) == 5) percentheal 50,50; else if (rand(1,10) == 6) getitem Jellopy,1; else if (rand(1,10) == 7) itemskill AL_RUWACH,1; else if (rand(1,10) == 8) specialeffect2 EF_BEGINASURA; else if (rand(1,10) == 9) specialeffect2 EF_MVP; else specialeffect2 EF_CURSEATTACK;','','');
REPLACE INTO `item_db` VALUES ('12398','PCBang_Gift_Box','PCBang Gift Box','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','','','');
REPLACE INTO `item_db` VALUES ('12399','Castle_Treasure_Box','Castle Treasure Box','2','20','10','1000','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 ('12400','Water_Of_Blessing_','Water Of Blessing ','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','','','');
@@ -4832,11 +4832,11 @@ REPLACE INTO `item_db` VALUES ('12527','E_Adrenaline_Scroll','E Adrenaline Scrol
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','','','');
-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','','','');
-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','','','');
-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','','','');
-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','','','');
+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 ('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();','','');
REPLACE INTO `item_db` VALUES ('12539','Splendid_Box','Splendid Box','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','','','');
@@ -4846,11 +4846,11 @@ REPLACE INTO `item_db` VALUES ('12542','Fortune_Cookie2','Fortune Cookie2','2','
REPLACE INTO `item_db` VALUES ('12543','Fortune_Cookie3','Fortune Cookie3','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('12544','Mystic_Tree_Branch','Mystic Tree Branch','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 ('12545','Lucky_Egg_C5','Lucky Egg C5','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','packageitem();','','');
-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','','','');
+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','','','');
-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','','','');
+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 ('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','','','');
@@ -4875,8 +4875,8 @@ REPLACE INTO `item_db` VALUES ('12571','Cheer_Scarf10_Box','Cheer Scarf10 Box','
REPLACE INTO `item_db` VALUES ('12572','Cheer_Scarf10_Box2','Cheer Scarf10 Box2','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 ('12573','Fruit_Basket','Fruit Basket','2','20','10','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 ('12574','Mora_Berry','Mora Berry','2','0','0','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','','','');
-REPLACE INTO `item_db` VALUES ('12575','Arrow_Of_Elf_Cntr','Arrow Of Elf Cntr','2','500','250','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','','','');
-REPLACE INTO `item_db` VALUES ('12576','Hunting_Arrow_Cntr','Hunting Arrow Cntr','2','500','250','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','','','');
+REPLACE INTO `item_db` VALUES ('12575','Arrow_Of_Elf_Cntr','Arrow Of Elf Cntr','2','500','250','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_Elf,500;','','');
+REPLACE INTO `item_db` VALUES ('12576','Hunting_Arrow_Cntr','Hunting Arrow Cntr','2','500','250','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 Hunting_Arrow,500;','','');
REPLACE INTO `item_db` VALUES ('12577','Lucky_Egg_C6','Lucky Egg C6','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('12578','Rapid_Life_Water','Rapid Life Water','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 ('12579','Ring_Of_Valkyrie_Box','Ring Of Valkyrie Box','2','20','10','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','','','');
@@ -4885,7 +4885,7 @@ REPLACE INTO `item_db` VALUES ('12581','Vending_Search_Scroll2','Universal Catal
REPLACE INTO `item_db` VALUES ('12591','Uni_Catalog_Bz','Universal Catalog Bronze','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','searchstores 10,1;','','');
REPLACE INTO `item_db` VALUES ('12609','Old_Ore_Box','Old Ore Box','2','20','10','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 ('12701','Old_Blue_Box_F','Old Blue 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 ('12702','Old_Bleu_Box','Old Navy 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','getrandgroupitem 12702,1; getrandgroupitem 12702,1;','','');
+REPLACE INTO `item_db` VALUES ('12702','Old_Bleu_Box','Old Navy 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','getrandgroupitem Old_Bleu_Box,1; getrandgroupitem Old_Bleu_Box,1;','','');
REPLACE INTO `item_db` VALUES ('12703','Holy_Egg_2','Holy Egg','11','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 ('12704','Elixir_Of_Life','Elixir of Life','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','85',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','percentheal 100,0;','','');
REPLACE INTO `item_db` VALUES ('12705','Noble_Nameplate','Noble Nameplate','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','90',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','sc_start SC_CASH_PLUSEXP,1800000,100;','','');
@@ -4895,7 +4895,7 @@ REPLACE INTO `item_db` VALUES ('12708','Lucky_Cookie03','Lucky Cookie','11','0',
REPLACE INTO `item_db` VALUES ('12709','Guyak_Candy','Guyak Candy','0','0','0','150','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 30,30;','','');
REPLACE INTO `item_db` VALUES ('12710','Guyak_Pudding','Guyak Pudding','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 ('12711','Pretzel','Pretzel','0','2','1','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','itemheal rand(50,90),0;','','');
-REPLACE INTO `item_db` VALUES ('12712','Green_Beer','Green Beer','2','2','1','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 ('12712','Green_Beer','Green Beer','2','2','1','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 0,50;','','');
REPLACE INTO `item_db` VALUES ('12713','Monster_Extract','Monster Extract','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 ('12714','Easter_Scroll','Easter Scroll','2','1','0','10','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','getrandgroupitem 12714,1;','','');
REPLACE INTO `item_db` VALUES ('12715','Black_Treasure_Box','Black Treasure Box','2','0','0','0','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','','','');
@@ -4922,12 +4922,12 @@ REPLACE INTO `item_db` VALUES ('12735','Runstone_Ancient','Ancient Rune','0','2'
REPLACE INTO `item_db` VALUES ('12736','Runstone_Mystic','Mystic Rune','0','2','1','100','0','0','0','0','0','128','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','makerune 14;','','');
REPLACE INTO `item_db` VALUES ('12737','Runstone_Ordinary','General Rune','0','2','1','100','0','0','0','0','0','128','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','makerune 2;','','');
REPLACE INTO `item_db` VALUES ('12738','Runstone_Rare','Rare Rune','0','2','1','100','0','0','0','0','0','128','8','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','makerune 8;','','');
-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','','','');
+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','','','');
-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','','','');
-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','','','');
+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','','','');
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','autobonus \"{bonus2 bAddRace,RC_Boss,5}\",10000,1800000; autobonus \"{bonus2 bAddRace,RC_Angel,5;}\",10000,1800000; autobonus \"{bonus2 bAddEle,Ele_Holy,5;}\",10000,1800000;','','');
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','autobonus \"{bonus2 bSubRace,RC_Boss,5;}\",10000,1800000;','','');
@@ -4937,8 +4937,8 @@ REPLACE INTO `item_db` VALUES ('12750','Battle_Scroll','Battle Scroll','2','20',
REPLACE INTO `item_db` VALUES ('12751','Armor_Scroll','Armor 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_PROTECT_DEF,1800000,5; sc_start SC_FOOD_BASICAVOIDANCE,1800000,10;','','');
REPLACE INTO `item_db` VALUES ('12752','Prayer_Scroll','Prayer 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_PROTECT_MDEF,1800000,5; sc_start SC_INCFLEE2,1800000,10;','','');
REPLACE INTO `item_db` VALUES ('12753','Soul_Scroll','Soul 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_INCMHPRATE,1800000,5; sc_start SC_INCMSPRATE,1800000,5;','','');
-REPLACE INTO `item_db` VALUES ('12754','New_Year_Bun','New Year Bun','2','0','0','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','','','');
-REPLACE INTO `item_db` VALUES ('12755','Traditional_Firecrack','Traditional Firecrack','2','2','1','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','','','');
+REPLACE INTO `item_db` VALUES ('12754','New_Year_Bun','New Year Bun','2','0','0','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','percentheal 50,50;','','');
+REPLACE INTO `item_db` VALUES ('12755','Traditional_Firecrack','Traditional Firecrack','2','2','1','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','specialeffect2 EF_POK_JAP; itemskill MO_CALLSPIRITS,3; itemskill MO_FINGEROFFENSIVE,5;','','');
REPLACE INTO `item_db` VALUES ('12756','New_Gift_Envelope','New Gift Envelope','2','2','1','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('12757','Loyal_Ring1_Box','Loyal Ring1 Box','2','10','5','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 ('12758','Loyal_Ring2_Box','Loyal Ring2 Box','2','10','5','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','','','');
@@ -4949,7 +4949,7 @@ REPLACE INTO `item_db` VALUES ('12762','Bubble_Gum_Orange','Bubble Gum Orange','
REPLACE INTO `item_db` VALUES ('12763','Bubble_Gum_Red','Bubble Gum Red','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 ('12764','Fools_Day_Box_Tw','Fools Day Box Tw','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 ('12765','Summer_Knight_Box','Summer Knight 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','','','');
-REPLACE INTO `item_db` VALUES ('12766','Reward_Job_BM25','Reward Job BM25','2','0','0','0','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','','','');
+REPLACE INTO `item_db` VALUES ('12766','Reward_Job_BM25','Reward Job BM25','2','0','0','0','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_CASH_PLUSONLYJOBEXP,1800000,25;','','');
REPLACE INTO `item_db` VALUES ('12767','Passion_FB_Hat_Box','Passion FB Hat Box','2','0','0','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('12768','Cool_FB_Hat_Box','Cool FB Hat Box','2','0','0','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('12769','Victory_FB_Hat_Box','Victory FB Hat Box','2','0','0','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','packageitem();','','');
@@ -4959,8 +4959,8 @@ REPLACE INTO `item_db` VALUES ('12772','Cool_Hat_Box2','Cool Hat Box2','2','0','
REPLACE INTO `item_db` VALUES ('12773','Victory_Hat_Box2','Victory Hat Box2','2','0','0','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','packageitem();','','');
REPLACE INTO `item_db` VALUES ('12786','Change_Slot_Card','Character Position Change Coupon','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','SlotChange += 1;','','');
REPLACE INTO `item_db` VALUES ('12790','Change_Name_Card','Name Change Coupon','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','CharRename += 1;','','');
-REPLACE INTO `item_db` VALUES ('12831','Potion_Box','Potion Box','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','getitem 545,100; getitem 546,100; getitem 547,100; getitem 505,100;','','');
-REPLACE INTO `item_db` VALUES ('12848','Falcon_Flute','Falcon Flute','11','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','if(getskilllv(HT_FALCON)) { if(checkoption(Option_Wug)||checkoption(Option_Wugrider)) end; if(checkfalcon()==1) { setfalcon 0; } else { setfalcon 1; } }','','');
+REPLACE INTO `item_db` VALUES ('12831','Potion_Box','Potion Box','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','getitem Red_Slim_Potion,100; getitem Yellow_Slim_Potion,100; getitem White_Slim_Potion,100; getitem Blue_Potion,100;','','');
+REPLACE INTO `item_db` VALUES ('12848','Falcon_Flute','Falcon Flute','11','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','if(getskilllv(HT_FALCON)) { if(checkoption(Option_Wug) || checkoption(Option_Wugrider)) end; if(checkfalcon() == 1) { setfalcon 0; } else { setfalcon 1; } }','','');
REPLACE INTO `item_db` VALUES ('12900','Battle_Manual_Box','Battle Manual Box','18','20','10','10','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','getitem 12208,10;','','');
REPLACE INTO `item_db` VALUES ('12901','Insurance_Package','Insurance Package','18','20','10','10','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','getitem 12209,10;','','');
REPLACE INTO `item_db` VALUES ('12902','Bubble_Gum_Box','Bubble Gum Box','18','20','10','10','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','getitem 12210,10;','','');