summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-12-23 00:49:03 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-12-23 00:49:03 +0100
commit966ae872aed88253ae645c07b66ec6bd19d619df (patch)
tree09a6d1d7149d80bccf198bd930f020bfb0e4b2da /sql-files
parentabe9ce9611ad120c111783aebebd992c66403cc7 (diff)
downloadhercules-966ae872aed88253ae645c07b66ec6bd19d619df.tar.gz
hercules-966ae872aed88253ae645c07b66ec6bd19d619df.tar.bz2
hercules-966ae872aed88253ae645c07b66ec6bd19d619df.tar.xz
hercules-966ae872aed88253ae645c07b66ec6bd19d619df.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql14
1 files changed, 7 insertions, 7 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index f3174c6d2..674e7ad2f 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -7781,13 +7781,13 @@ REPLACE INTO `item_db` VALUES ('14609','Spoiled_Cuisine','Spoiled Cuisine','2','
REPLACE INTO `item_db` VALUES ('14611','M_Def_Potion','M Def 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','specialeffect2 EF_GUARD; sc_start SC_PROTECT_DEF, 120000, 3;','','');
REPLACE INTO `item_db` VALUES ('14612','M_Mdef_Potion','M Mdef 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','specialeffect2 EF_SPELLBREAKER; sc_start SC_PROTECT_MDEF, 120000, 3;','','');
REPLACE INTO `item_db` VALUES ('14613','RWC_Scroll_2012','RWC Arms Box','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 ('14614','Ex_Def_Potion','Special Defense Potion','11','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','specialeffect2 EF_GUARD; sc_start SC_PROTECT_DEF, 1800000, 3; sc_start SC_PROTECT_MDEF, 1800000, 3;','','');
-REPLACE INTO `item_db` VALUES ('14616','STR_Biscuit_Stick','Bar of Strength','11','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','sc_start SC_FOOD_STR, 180000, 15; sc_start SC_PLUSATTACKPOWER, 60000, rand(11,111);','','');
-REPLACE INTO `item_db` VALUES ('14617','VIT_Biscuit_Stick','Bar of Fitness','11','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','sc_start SC_FOOD_VIT, 180000, 15; percentheal rand(11,33), 0;','','');
-REPLACE INTO `item_db` VALUES ('14618','AGI_Biscuit_Stick','Bar of Agility','11','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','sc_start SC_FOOD_AGI, 180000, 15; sc_start SC_FOOD_BASICAVOIDANCE, 60000, rand(11,33);','','');
-REPLACE INTO `item_db` VALUES ('14619','INT_Biscuit_Stick','Bar of Knowledge','11','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','sc_start SC_FOOD_INT, 180000, 15; sc_start SC_PLUSMAGICPOWER, 60000, rand(11,111);','','');
-REPLACE INTO `item_db` VALUES ('14620','DEX_Biscuit_Stick','Bar of Tricks','11','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','sc_start SC_FOOD_DEX, 180000, 15; sc_start SC_FOOD_BASICHIT, 60000, rand(11,33);','','');
-REPLACE INTO `item_db` VALUES ('14621','LUK_Biscuit_Stick','Bar of Luck','11','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','sc_start SC_FOOD_LUK, 180000, 15; sc_start SC_CRITICALSUCCESSVALUE, 60000, rand(11,13);','','');
+REPLACE INTO `item_db` VALUES ('14614','Ex_Def_Potion','Special Defense 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','specialeffect2 EF_GUARD; sc_start SC_PROTECT_DEF, 1800000, 3; sc_start SC_PROTECT_MDEF, 1800000, 3;','','');
+REPLACE INTO `item_db` VALUES ('14616','STR_Biscuit_Stick','Bar of Strength','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','sc_start SC_FOOD_STR, 180000, 15; sc_start SC_PLUSATTACKPOWER, 60000, rand(11,111);','','');
+REPLACE INTO `item_db` VALUES ('14617','VIT_Biscuit_Stick','Bar of Fitness','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','sc_start SC_FOOD_VIT, 180000, 15; percentheal rand(11,33), 0;','','');
+REPLACE INTO `item_db` VALUES ('14618','AGI_Biscuit_Stick','Bar of Agility','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','sc_start SC_FOOD_AGI, 180000, 15; sc_start SC_FOOD_BASICAVOIDANCE, 60000, rand(11,33);','','');
+REPLACE INTO `item_db` VALUES ('14619','INT_Biscuit_Stick','Bar of Knowledge','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','sc_start SC_FOOD_INT, 180000, 15; sc_start SC_PLUSMAGICPOWER, 60000, rand(11,111);','','');
+REPLACE INTO `item_db` VALUES ('14620','DEX_Biscuit_Stick','Bar of Tricks','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','sc_start SC_FOOD_DEX, 180000, 15; sc_start SC_FOOD_BASICHIT, 60000, rand(11,33);','','');
+REPLACE INTO `item_db` VALUES ('14621','LUK_Biscuit_Stick','Bar of Luck','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','sc_start SC_FOOD_LUK, 180000, 15; sc_start SC_FOOD_CRITICALSUCCESSVALUE, 60000, rand(11,13);','','');
REPLACE INTO `item_db` VALUES ('14674','Cup_Of_Boza','Cup Of Boza','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_start2 SC_CUP_OF_BOZA, 120000, 10, 5;','','');
REPLACE INTO `item_db` VALUES ('15000','Bone_Plate','Bone Plate','5','20','10','1000','0','0','60','0','1','414946','58','2','16','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bMdef,3; bonus2 bIgnoreDefRate,RC_DemiPlayer,10; bonus2 bIgnoreDefRate,RC_Brute,10; bonus3 bAutoSpellWhenHit,NPC_WIDEBLEEDING,1,10;','','');
REPLACE INTO `item_db` VALUES ('15001','Odin\'s_Blessing_I','Odin\'s Blessing','5','0','0','0','0','0','10','0','0','2147483646','63','2','16','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');