summaryrefslogtreecommitdiff
path: root/sql-files
diff options
context:
space:
mode:
authorHercules.ws <Hercules@efficiently.awesome>2015-11-23 00:56:49 +0100
committerHerculesWSAPI <Hercules@efficiently.awesome>2015-11-23 00:56:49 +0100
commitaad6eaea82053f629cbbe204aa83db5fd4b557a4 (patch)
tree05a223830a229f6a507e25a85336f6c8cbc85e26 /sql-files
parentd33fa7b6348377d09136a7ab2e742bd93174973e (diff)
downloadhercules-aad6eaea82053f629cbbe204aa83db5fd4b557a4.tar.gz
hercules-aad6eaea82053f629cbbe204aa83db5fd4b557a4.tar.bz2
hercules-aad6eaea82053f629cbbe204aa83db5fd4b557a4.tar.xz
hercules-aad6eaea82053f629cbbe204aa83db5fd4b557a4.zip
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r--sql-files/item_db_re.sql17
1 files changed, 9 insertions, 8 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 0327c9212..c9b0462f2 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -7715,9 +7715,10 @@ REPLACE INTO `item_db` VALUES ('14614','Ex_Def_Potion','Special Defense Potion',
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 ('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 ('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','','','');
REPLACE INTO `item_db` VALUES ('15002','Rune_Plate','Rune Plate','5','0','0','0','0','0','95','0','1','128','56','2','16','0','99',NULL,'1','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -8169,11 +8170,11 @@ REPLACE INTO `item_db` VALUES ('17256','Good_Student_Gift_Box','Good Student Gif
REPLACE INTO `item_db` VALUES ('17257','Bad_Student_Gift_Box','Bad Student Gift Box','18','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','','','');
REPLACE INTO `item_db` VALUES ('17262','Ex_Def_Potion_Box','Special Defense Potion Box','18','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 ('17270','STR_Biscuit_Stick_Box','Bar of Strength Box','18','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','getitem STR_Biscuit_Stick,20;','','');
-REPLACE INTO `item_db` VALUES ('17271','VIT_Biscuit_Stick_Box','VIT Biscuit Stick Box','18','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','getitem VIT_Biscuit_Stick,20;','','');
-REPLACE INTO `item_db` VALUES ('17272','AGI_Biscuit_Stick_Box','AGI Biscuit Stick Box','18','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','getitem AGI_Biscuit_Stick,20;','','');
-REPLACE INTO `item_db` VALUES ('17273','INT_Biscuit_Stick_Box','INT Biscuit Stick Box','18','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','getitem INT_Biscuit_Stick,20;','','');
-REPLACE INTO `item_db` VALUES ('17274','DEX_Biscuit_Stick_Box','DEX Biscuit Stick Box','18','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','getitem DEX_Biscuit_Stick,20;','','');
-REPLACE INTO `item_db` VALUES ('17275','LUK_Biscuit_Stick_Box','LUK Biscuit Stick Box','18','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','getitem LUK_Biscuit_Stick,20;','','');
+REPLACE INTO `item_db` VALUES ('17271','VIT_Biscuit_Stick_Box','Bar of Fitness Box','18','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','getitem VIT_Biscuit_Stick,20;','','');
+REPLACE INTO `item_db` VALUES ('17272','AGI_Biscuit_Stick_Box','Bar of Agility Box','18','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','getitem AGI_Biscuit_Stick,20;','','');
+REPLACE INTO `item_db` VALUES ('17273','INT_Biscuit_Stick_Box','Bar of Knowledge Box','18','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','getitem INT_Biscuit_Stick,20;','','');
+REPLACE INTO `item_db` VALUES ('17274','DEX_Biscuit_Stick_Box','Bar of Tricks Box','18','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','getitem DEX_Biscuit_Stick,20;','','');
+REPLACE INTO `item_db` VALUES ('17275','LUK_Biscuit_Stick_Box','Bar of Luck Box','18','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','getitem LUK_Biscuit_Stick,20;','','');
REPLACE INTO `item_db` VALUES ('18000','Cannon_Ball','Cannon Ball','10','100','50','10','100','0','0','0','0','263168','8','2','32768','0','0',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
REPLACE INTO `item_db` VALUES ('18001','Holy_Cannon_Ball','Holy Cannon Ball','10','200','100','10','120','0','0','0','0','263168','8','2','32768','0','0',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy;','','');
REPLACE INTO `item_db` VALUES ('18002','Dark_Cannon_Ball','Dark Cannon Ball','10','200','100','10','120','0','0','0','0','263168','8','2','32768','0','0',NULL,'0','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Dark;','','');