summaryrefslogtreecommitdiff
path: root/sql-files/item_db.sql
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-11-19 09:44:17 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-11-19 09:44:17 +0100
commit016ec84075ae8a4c9069dcdd024422d8f7e1cc2c (patch)
tree490af7e1497235b777bf6c2cd3262a897cb614b5 /sql-files/item_db.sql
parente511dcf5940cee7a6e43744543a5ca96bc23cf84 (diff)
downloadhercules-016ec84075ae8a4c9069dcdd024422d8f7e1cc2c.tar.gz
hercules-016ec84075ae8a4c9069dcdd024422d8f7e1cc2c.tar.bz2
hercules-016ec84075ae8a4c9069dcdd024422d8f7e1cc2c.tar.xz
hercules-016ec84075ae8a4c9069dcdd024422d8f7e1cc2c.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.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index d53c956a9..0aec0d9a4 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) 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 ('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','.@i = rand(1,10); if (.@i == 1) itemskill AL_TELEPORT,1; else if (.@i == 2) itemskill AL_TELEPORT,3; else if (.@i == 3) percentheal 50,0; else if (.@i == 4) percentheal 0,50; else if (.@i == 5) percentheal 50,50; else if (.@i == 6) getitem Apple,1; else if (.@i == 7) itemskill ALL_REVERSEORCISH,1; else if (.@i == 8) specialeffect2 EF_MAPPILLAR2; else if (.@i == 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','.@i = rand(1,10); if (.@i == 1) itemskill TF_DETOXIFY,1; else if (.@i == 2) itemskill TF_PICKSTONE,1; else if (.@i == 3) itemskill BA_FROSTJOKER,1; else if (.@i == 4) itemskill DC_SCREAM,1; else if (.@i == 5) percentheal 50,50; else if (.@i == 6) getitem Jellopy,1; else if (.@i == 7) itemskill AL_RUWACH,1; else if (.@i == 8) specialeffect2 EF_BEGINASURA; else if (.@i == 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','','','');