From aad6eaea82053f629cbbe204aa83db5fd4b557a4 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Mon, 23 Nov 2015 00:56:49 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 17 +++++++++-------- 1 file 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;','',''); -- cgit v1.2.3-60-g2f50