summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2014-10-30 01:24:13 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2014-10-30 01:24:13 +0100
commit8f0508418425abb518381b46cc73caa1a9e66890 (patch)
treeac9e863cd6ffd05867ed46c42b7fa6e79f757ee1 /sql-files
parentc6f102ef8f7a08903617e70135fca5ccfe11b75a (diff)
downloadhercules-8f0508418425abb518381b46cc73caa1a9e66890.tar.gz
hercules-8f0508418425abb518381b46cc73caa1a9e66890.tar.bz2
hercules-8f0508418425abb518381b46cc73caa1a9e66890.tar.xz
hercules-8f0508418425abb518381b46cc73caa1a9e66890.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index cc0b07de9..a065fb4a6 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -5700,9 +5700,9 @@ REPLACE INTO `item_db_re` VALUES ('12388','Runstone_Crush','Rhydo Runestone For
REPLACE INTO `item_db_re` 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','507',NULL,'1',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_rune02\") { itemskill RK_STORMBLAST,1; }','','');
REPLACE INTO `item_db_re` 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','507',NULL,'1',NULL,'0',NULL,'0','if(strcharinfo(3)==\"job3_rune02\") { itemskill RK_MILLENNIUMSHIELD,1; }','','');
REPLACE INTO `item_db_re` 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','475',NULL,'0',NULL,'0',NULL,'0','packageitem();','','');
-REPLACE INTO `item_db_re` VALUES ('12392','RepairA','Repair A','0','275','137','100','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmadogear()) itemheal rand(200,300),0;','','');
-REPLACE INTO `item_db_re` VALUES ('12393','RepairB','Repair B','0','625','312','140','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmadogear()) itemheal rand(300,400),0;','','');
-REPLACE INTO `item_db_re` VALUES ('12394','RepairC','Repair C','0','1375','687','180','0','0','0','0','0','1024','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(checkmadogear()) itemheal rand(400,500),0;','','');
+REPLACE INTO `item_db_re` VALUES ('12392','RepairA','Repair A','0','275','137','100','0','0','0','0','0','1024','63','2','0','0','0',NULL,'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_re` VALUES ('12393','RepairB','Repair B','0','625','312','140','0','0','0','0','0','1024','63','2','0','0','0',NULL,'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_re` VALUES ('12394','RepairC','Repair C','0','1375','687','180','0','0','0','0','0','1024','63','2','0','0','0',NULL,'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_re` VALUES ('12395','Tantanmen','Tantan Noodle','2','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','pet 1519;','','');
REPLACE INTO `item_db_re` 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','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_re` 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','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;','','');