From 14b14e16cf8d6cac2159d6c6425daaeda4a03f4b Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Sun, 22 Nov 2015 05:32:33 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db.sql | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) (limited to 'sql-files/item_db.sql') diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index dc6f0b69a..e75a6cb91 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -4928,15 +4928,15 @@ REPLACE INTO `item_db` VALUES ('12741','Inc_Int_Scroll','Intellect Amplification REPLACE INTO `item_db` VALUES ('12742','Valentine_Gift_Box1','Valentine Gift Box','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','getitem Valentine_Gold_Ring,1;','',''); REPLACE INTO `item_db` VALUES ('12743','Valentine_Gift_Box2','Valentine Gift Box','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','getitem Valentine_Silver_Ring,1;','',''); REPLACE INTO `item_db` VALUES ('12744','Chocotate_Box','Chocolate Box','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','getitem Chocolate,1;','',''); -REPLACE INTO `item_db` VALUES ('12745','Skull_Scroll','Skull Scroll','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 ('12746','Destruction_Scroll','Destruction Scroll','2','20','10','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','autobonus \"{bonus2 bAddRace,RC_Boss,5}\",10000,1800000; autobonus \"{bonus2 bAddRace,RC_Angel,5;}\",10000,1800000; autobonus \"{bonus2 bAddEle,Ele_Holy,5;}\",10000,1800000;','',''); -REPLACE INTO `item_db` VALUES ('12747','Royal_Scroll','Royal Scroll','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','autobonus \"{bonus2 bSubRace,RC_Boss,5;}\",10000,1800000;','',''); -REPLACE INTO `item_db` VALUES ('12748','Immune_Scroll','Immune Scroll','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','autobonus \"{bonus2 bAddEle,Ele_Neutral,-5;}\",10000,1800000;','',''); -REPLACE INTO `item_db` VALUES ('12749','Mystic_Scroll','Mystic Scroll','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_start SC_PLUSMAGICPOWER,180000,5;','',''); -REPLACE INTO `item_db` VALUES ('12750','Battle_Scroll','Battle Scroll','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_start SC_ATTHASTE_POTION3,1800000,5; sc_start SC_PLUSATTACKPOWER,1800000,5;','',''); -REPLACE INTO `item_db` VALUES ('12751','Armor_Scroll','Armor Scroll','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_start SC_PROTECT_DEF,1800000,5; sc_start SC_FOOD_BASICAVOIDANCE,1800000,10;','',''); -REPLACE INTO `item_db` VALUES ('12752','Prayer_Scroll','Prayer Scroll','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_start SC_PROTECT_MDEF,1800000,5; sc_start SC_INCFLEE2,1800000,10;','',''); -REPLACE INTO `item_db` VALUES ('12753','Soul_Scroll','Soul Scroll','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_start SC_INCMHPRATE,1800000,5; sc_start SC_INCMSPRATE,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12745','Skull_Scroll','Skull Scroll','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','sc_start SC_SKELSCROLL,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12746','Destruction_Scroll','Destruction Scroll','2','20','10','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','sc_start SC_DISTRUCTIONSCROLL,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12747','Royal_Scroll','Royal Scroll','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_start SC_ROYALSCROLL,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12748','Immune_Scroll','Immune Scroll','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_start SC_IMMUNITYSCROLL,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12749','Mystic_Scroll','Mystic Scroll','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_start SC_MYSTICSCROLL,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12750','Battle_Scroll','Battle Scroll','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_start SC_BATTLESCROLL,1800000,5;','',''); +REPLACE INTO `item_db` VALUES ('12751','Armor_Scroll','Armor Scroll','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_ARMORSCROLL,1800000,5,10;','',''); +REPLACE INTO `item_db` VALUES ('12752','Prayer_Scroll','Prayer Scroll','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_FREYJASCROLL,1800000,5,10;','',''); +REPLACE INTO `item_db` VALUES ('12753','Soul_Scroll','Soul Scroll','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_start SC_SOULSCROLL,1800000,5;','',''); REPLACE INTO `item_db` VALUES ('12754','New_Year_Bun','New Year Bun','2','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','percentheal 50,50;','',''); REPLACE INTO `item_db` VALUES ('12755','Traditional_Firecrack','Traditional Firecrack','2','2','1','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','specialeffect2 EF_POK_JAP; itemskill MO_CALLSPIRITS,3; itemskill MO_FINGEROFFENSIVE,5;','',''); REPLACE INTO `item_db` VALUES ('12756','New_Gift_Envelope','New Gift Envelope','2','2','1','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','packageitem();','',''); @@ -6014,8 +6014,8 @@ REPLACE INTO `item_db` VALUES ('14317','Bacsojin_Scroll','Bacsojin Scroll','2',' REPLACE INTO `item_db` VALUES ('14343','Spiked_Scarf_Box','Spiked Scarf 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','getitem 5462,1;','',''); REPLACE INTO `item_db` VALUES ('14344','Rainbow_Scarf_Box','Rainbow Scarf 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','getitem 5463,1;','',''); REPLACE INTO `item_db` VALUES ('14345','Animal_Scroll','Animal Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); -REPLACE INTO `item_db` VALUES ('14349','Mental_Potion20_Box','Mental Potion 20 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','getitem 14600,20;','',''); -REPLACE INTO `item_db` VALUES ('14350','Mental_Potion50_Box','Mental Potion 50 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','getitem 14600,50;','',''); +REPLACE INTO `item_db` VALUES ('14349','Mental_Potion20_Box','Mental Potion 20 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','getitem Mental_Potion,20;','',''); +REPLACE INTO `item_db` VALUES ('14350','Mental_Potion50_Box','Mental Potion 50 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','getitem Mental_Potion,50;','',''); REPLACE INTO `item_db` VALUES ('14351','Tyr\'s_Blessing20_Box','Tyr\'s Blessing 20 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','getitem 14601,20;','',''); REPLACE INTO `item_db` VALUES ('14352','Tyr\'s_Blessing50_Box','Tyr\'s Blessing 50 Box','18','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','getitem 14601,50;','',''); REPLACE INTO `item_db` VALUES ('14363','Heart_Scroll','Heart Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','packageitem();','',''); @@ -6127,7 +6127,7 @@ REPLACE INTO `item_db` VALUES ('14596','Pierre_Treasurebox','Pierre\'s Treasure REPLACE INTO `item_db` VALUES ('14597','PhreeoniS','Phreeoni Scroll','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_ITEMSCRIPT,180000,4121;','',''); REPLACE INTO `item_db` VALUES ('14598','GhostringS','Ghostring Scroll','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_ITEMSCRIPT,60000,4047;','',''); REPLACE INTO `item_db` VALUES ('14599','Greed_Scroll_C','Greed Scroll','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'1',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('14600','Mental_Potion','Mental Potion','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('14600','Mental_Potion','Mental Potion','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_SPELLBREAKER; sc_start SC_TARGET_ASPD,1800000,10;','',''); REPLACE INTO `item_db` VALUES ('14601','Tyr\'s_Blessing','Tyr\'s Blessing','2','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','sc_start SC_INCFLEE,300000,30; sc_start SC_INCHIT,300000,30; sc_start SC_PLUSATTACKPOWER,300000,20; sc_start SC_PLUSMAGICPOWER,300000,20;','',''); REPLACE INTO `item_db` VALUES ('14602','TaogunkaS','Tao Gunka Scroll','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_ITEMSCRIPT,180000,4302;','',''); REPLACE INTO `item_db` VALUES ('14603','MistressS','Mistress Scroll','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_ITEMSCRIPT,180000,4132;','',''); -- cgit v1.2.3-60-g2f50