summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2014-04-19 13:40:14 +0200
committerHerculesWSAPI <Hercules@efficiently.awesome>2014-04-19 13:40:14 +0200
commit47e1e71c9ba917f288f96ff64f4533628188b921 (patch)
tree7b49d034015299c1d0e62ad27861a7837ad79c8d /sql-files
parent0604877dcb82f5124ead7106f24a91d83001e3aa (diff)
downloadhercules-47e1e71c9ba917f288f96ff64f4533628188b921.tar.gz
hercules-47e1e71c9ba917f288f96ff64f4533628188b921.tar.bz2
hercules-47e1e71c9ba917f288f96ff64f4533628188b921.tar.xz
hercules-47e1e71c9ba917f288f96ff64f4533628188b921.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql20
1 files changed, 10 insertions, 10 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 58362472a..842d22ee8 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -71,8 +71,8 @@ REPLACE INTO `item_db_re` VALUES ('538','Well_Baked_Cookie','Well-baked Cookie',
REPLACE INTO `item_db_re` VALUES ('539','Piece_Of_Cake','Piece of Cake','0','3000','1500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(270,330),0;','','');
REPLACE INTO `item_db_re` VALUES ('540','Falcon\'s_Feed','Falcon Food','0','2000','1000','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(185,225),0;','','');
REPLACE INTO `item_db_re` VALUES ('541','Pecopeco\'s_Feed','PecoPeco Food','0','3000','1500','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(325,405),0;','','');
-REPLACE INTO `item_db_re` VALUES ('542','Festive_Cookie','Festive Cookie','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','','');
-REPLACE INTO `item_db_re` VALUES ('543','Festive_Rainbow_Cake','Festive Rainbow Cake','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','','');
+REPLACE INTO `item_db_re` VALUES ('542','Festive_Cookie','Festive Cookie','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(325,405),0;','','');
+REPLACE INTO `item_db_re` VALUES ('543','Festive_Rainbow_Cake','Festive Rainbow Cake','0','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(325,405),0;','','');
REPLACE INTO `item_db_re` VALUES ('544','Fish_Slice','Raw Fish','0','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(25,60),0;','','');
REPLACE INTO `item_db_re` VALUES ('545','Red_Slim_Potion','Condensed Red Potion','0','150','75','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(45,65),0;','','');
REPLACE INTO `item_db_re` VALUES ('546','Yellow_Slim_Potion','Condensed Yellow Potion','0','600','300','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(175,235),0;','','');
@@ -5249,7 +5249,7 @@ REPLACE INTO `item_db_re` VALUES ('11530','Jujube','Jujube','0','10','5','100','
REPLACE INTO `item_db_re` VALUES ('11531','Coffee','Coffee','0','10','5','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal 0,10;','','');
REPLACE INTO `item_db_re` VALUES ('11532','Nasi_Goreng','Nasi Goreng','0','15','7','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(17,23),0;','','');
REPLACE INTO `item_db_re` VALUES ('11533','Satay','Satay','0','15','7','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(17,23),0;','','');
-REPLACE INTO `item_db_re` VALUES ('11534','Coco_Juice','Coconut Juice','0','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(17,23),rand(16,20);','','');
+REPLACE INTO `item_db_re` VALUES ('11534','Coco_Juice','Coconut Juice','0','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(17,23),0;','','');
REPLACE INTO `item_db_re` VALUES ('11535','Almond_Chocolate','Almond Chocolate','0','190','95','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal 0,rand(8,16);','','');
REPLACE INTO `item_db_re` VALUES ('11536','Cat_Hard_Biscuit','Cat\'s Ship Biscuit','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(70,110),0;','','');
REPLACE INTO `item_db_re` VALUES ('11537','Rice_weevil_Bug','Weevil Bug Worm','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(100,150),0;','','');
@@ -5262,14 +5262,14 @@ REPLACE INTO `item_db_re` VALUES ('11543','Goedo_Choco','Handmade Chocolate','0'
REPLACE INTO `item_db_re` VALUES ('11544','Huike_Choco','Handmade Chocolate','0','1','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal 50,50;','','');
REPLACE INTO `item_db_re` VALUES ('11545','Rune_Choco','Handmade Chocolate','0','1','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal 50,50;','','');
REPLACE INTO `item_db_re` VALUES ('11546','Pope_Choco','Handmade Chocolate','0','1','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal 50,50;','','');
-REPLACE INTO `item_db_re` VALUES ('11547','Woe_Violet_Potion','WoE Violet Potion','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(500,600),rand(60,80);','','');
-REPLACE INTO `item_db_re` VALUES ('11548','Woe_White_Potion','WoE White Potion','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','','');
-REPLACE INTO `item_db_re` VALUES ('11549','Woe_Blue_Potion','WoE Blue Potion','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','','');
+REPLACE INTO `item_db_re` VALUES ('11547','Woe_Violet_Potion','WoE Violet Potion','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(500,700),rand(60,85);','','');
+REPLACE INTO `item_db_re` VALUES ('11548','Woe_White_Potion','WoE White Potion','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','percentheal 10,0;','','');
+REPLACE INTO `item_db_re` VALUES ('11549','Woe_Blue_Potion','WoE Blue Potion','0','0','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','percentheal 0,10;','','');
REPLACE INTO `item_db_re` VALUES ('11550','Pumpkin_Cake','Pumpkin Cake','0','10','5','40','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','','');
-REPLACE INTO `item_db_re` VALUES ('11551','Savory_Herb_Salad','Aromatic Herb Seasoned','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','percentheal rand(20,30),0;','','');
-REPLACE INTO `item_db_re` VALUES ('11552','Apple_Carrot_Salad','Apple Carrot Salad','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','percentheal rand(20,30),0;','','');
-REPLACE INTO `item_db_re` VALUES ('11553','Casual_Stew','Anything Casserole','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','percentheal rand(20,30),0;','','');
-REPLACE INTO `item_db_re` VALUES ('11554','Golden_Roasted_Apple','92 Golden Apple','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','percentheal rand(20,30),0;','','');
+REPLACE INTO `item_db_re` VALUES ('11551','Savory_Herb_Salad','Aromatic Herb Seasoned','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(20,30),0;','','');
+REPLACE INTO `item_db_re` VALUES ('11552','Apple_Carrot_Salad','Apple Carrot Salad','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(20,30),0;','','');
+REPLACE INTO `item_db_re` VALUES ('11553','Casual_Stew','Anything Casserole','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(20,30),0;','','');
+REPLACE INTO `item_db_re` VALUES ('11554','Golden_Roasted_Apple','92 Golden Apple','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(20,30),0;','','');
REPLACE INTO `item_db_re` VALUES ('11701','Girl_Bunch_Of_Flower','Girl\'s Bouquet','0','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal rand(105,145),0;','','');
REPLACE INTO `item_db_re` VALUES ('11702','Moon_Cookie','Moon Cookie','0','0','0','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','','','');
REPLACE INTO `item_db_re` VALUES ('11703','Mysterious_Blood','Mystery Blood','0','0','0','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','itemheal 0,rand(25,35);','','');