From 987b90508e7e6528eca2983416ac96cc1452ed61 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Tue, 5 Jan 2016 10:29:33 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) (limited to 'sql-files/item_db_re.sql') diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index bdf115cd3..75a5ac282 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -5732,10 +5732,10 @@ REPLACE INTO `item_db` VALUES ('11553','Casual_Stew','Anything Casserole','0','0 REPLACE INTO `item_db` VALUES ('11554','Golden_Roasted_Apple','92 Golden Apple','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','itemheal rand(20,30),0;','',''); REPLACE INTO `item_db` VALUES ('11557','TE_White_Potion','TE White Potion','0','200','100','300','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','itemheal rand(325,405),0;','',''); REPLACE INTO `item_db` VALUES ('11558','TE_White_Slim_Potion','TE White Slim Potion','0','275','137','100','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','itemheal rand(325,405),0;','',''); -REPLACE INTO `item_db` VALUES ('11592','Trance_Candy_R','Red Transform Candy','0','0','0','30','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','itemheal rand(45,65), 0; montransform BLOODY_MURDERER, 600000, SC_MTF_MHP, 1000;','',''); -REPLACE INTO `item_db` VALUES ('11593','Trance_Candy_B','Blue Transform Candy','0','0','0','30','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','itemheal rand(45,65), 0; montransform BATHORY, 600000, SC_MTF_MSP, 100;','',''); -REPLACE INTO `item_db` VALUES ('11594','Trance_Candy_Y','Yellow Transform Candy','0','0','0','30','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','itemheal rand(45,65),0; montransform JAKK, 600000, SC_MTF_PUMPKIN, 2000;','',''); -REPLACE INTO `item_db` VALUES ('11595','Trance_Candy_G','Green Transform Candy','0','0','0','30','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','itemheal rand(45,65),0; montransform QUVE, 600000, SC_MTF_HITFLEE, 10, 20;','',''); +REPLACE INTO `item_db` VALUES ('11592','Trance_Candy_R','Red Transform Candy','0','0','0','30','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','itemheal rand(45,65), 0; specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Bloody Murderer Fo-rm!!\"; montransform BLOODY_MURDERER, 600000, SC_MTF_MHP, 1000;','',''); +REPLACE INTO `item_db` VALUES ('11593','Trance_Candy_B','Blue Transform Candy','0','0','0','30','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','itemheal rand(45,65), 0; specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!!! Bathory Fo-rm!!\"; montransform BATHORY, 600000, SC_MTF_MSP, 100;','',''); +REPLACE INTO `item_db` VALUES ('11594','Trance_Candy_Y','Yellow Transform Candy','0','0','0','30','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','itemheal rand(45,65),0; specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Jack Fo-rm!!\"; montransform JAKK, 600000, SC_MTF_PUMPKIN, 2000;','',''); +REPLACE INTO `item_db` VALUES ('11595','Trance_Candy_G','Green Transform Candy','0','0','0','30','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','itemheal rand(45,65),0; specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Cube Fo-rm!!\"; montransform QUVE, 600000, SC_MTF_HITFLEE, 10, 20;','',''); REPLACE INTO `item_db` VALUES ('11701','Girl_Bunch_Of_Flower','Girl\'s Bouquet','0','20','10','50','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','itemheal rand(105,145),0;','',''); REPLACE INTO `item_db` VALUES ('11702','Moon_Cookie','Moon Cookie','0','0','0','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'1',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('11703','Mysterious_Blood','Mystery Blood','0','0','0','30','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','itemheal 0,rand(25,35);','',''); @@ -6400,13 +6400,13 @@ REPLACE INTO `item_db` VALUES ('12654','Lucky_Egg_C9','Recruit\'s Mount Gift','2 REPLACE INTO `item_db` VALUES ('12655','Brain_Powder','Brain Powder','11','2000','1000','100','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 ('12656','Magical_Powder','Magical Powder','11','3000','1500','200','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 ('12657','Madness_Powder','Madness Powder','11','4000','2000','300','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 ('12658','Trans_Scroll_Devi','Transformation Scroll(Deviruchi)','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','specialeffect2 EF_CLOAKING; montransform DEVIRUCHI, 1200000, SC_MTF_ASPD, 10, 5;','',''); -REPLACE INTO `item_db` VALUES ('12659','Trans_Scroll_Ray_Arch','Transformation Scroll(Raydric)','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','specialeffect2 EF_CLOAKING; montransform RAYDRIC_ARCHER, 1200000, SC_MTF_RANGEATK, 25;','',''); -REPLACE INTO `item_db` VALUES ('12660','Trans_Scroll_Mavka','Transformation Scroll(Mavka)','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','specialeffect2 EF_CLOAKING; montransform MAVKA, 1200000, SC_MTF_RANGEATK, 25;','',''); -REPLACE INTO `item_db` VALUES ('12661','Trans_Scroll_Marduk','Transformation Scroll(Marduk)','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','specialeffect2 EF_CLOAKING; montransform MARDUK, 1200000, SC_MTF_MATK, 25;','',''); -REPLACE INTO `item_db` VALUES ('12662','Trans_Scroll_Banshee','Transformation Scroll(Banshee)','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','specialeffect2 EF_CLOAKING; montransform BANSHEE, 1200000, SC_MTF_MATK, 25;','',''); -REPLACE INTO `item_db` VALUES ('12663','Trans_Scroll_Poring','Transformation Scroll(Poring)','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','specialeffect2 EF_CLOAKING; montransform PORING, 1200000, SC_MTF_CRIDAMAGE, 5;','',''); -REPLACE INTO `item_db` VALUES ('12664','Trans_Scroll_Golem','Transformation Scroll(Golem)','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','specialeffect2 EF_CLOAKING; montransform GOLEM, 1200000, SC_MTF_MLEATKED, 2;','',''); +REPLACE INTO `item_db` VALUES ('12658','Trans_Scroll_Devi','Transformation Scroll(Deviruchi)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Deviling Fo-rm!!\"; montransform DEVIRUCHI, 1200000, SC_MTF_ASPD, 10, 5;','',''); +REPLACE INTO `item_db` VALUES ('12659','Trans_Scroll_Ray_Arch','Transformation Scroll(Raydric)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Raydric Archer Fo-rm!!\"; montransform RAYDRIC_ARCHER, 1200000, SC_MTF_RANGEATK, 25;','',''); +REPLACE INTO `item_db` VALUES ('12660','Trans_Scroll_Mavka','Transformation Scroll(Mavka)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Mavka Fo-rm!!\"; montransform MAVKA, 1200000, SC_MTF_RANGEATK, 25;','',''); +REPLACE INTO `item_db` VALUES ('12661','Trans_Scroll_Marduk','Transformation Scroll(Marduk)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Marduk Fo-rm!!\"; montransform MARDUK, 1200000, SC_MTF_MATK, 25;','',''); +REPLACE INTO `item_db` VALUES ('12662','Trans_Scroll_Banshee','Transformation Scroll(Banshee)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Banshee Fo-rm!!\"; montransform BANSHEE, 1200000, SC_MTF_MATK, 25;','',''); +REPLACE INTO `item_db` VALUES ('12663','Trans_Scroll_Poring','Transformation Scroll(Poring)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Poring Fo-rm!!\"; montransform PORING, 1200000, SC_MTF_CRIDAMAGE, 5;','',''); +REPLACE INTO `item_db` VALUES ('12664','Trans_Scroll_Golem','Transformation Scroll(Golem)','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','specialeffect2 EF_CLOAKING; showscript \"Trans-Form-!! Golem Fo-rm!!\"; montransform GOLEM, 1200000, SC_MTF_MLEATKED, 2;','',''); REPLACE INTO `item_db` VALUES ('12665','Grovel_Buff','Grovel Buff','2','0','0','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 ('12666','Thai_Perfume_MATK','Thai Perfume(MATK)','11','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','','',''); REPLACE INTO `item_db` VALUES ('12667','Thai_Perfume_ATK','Thai Perfume(ATK)','11','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','','',''); -- cgit v1.2.3-60-g2f50