From af3c0657e901150efa17d3fc46035ac358e7c831 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Sat, 22 Oct 2016 02:32:38 +0200 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db.sql | 1 + sql-files/item_db_re.sql | 46 ++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 47 insertions(+) diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql index 640258d4f..c0ef7ee09 100644 --- a/sql-files/item_db.sql +++ b/sql-files/item_db.sql @@ -4326,6 +4326,7 @@ REPLACE INTO `item_db` VALUES ('11528','Kanafeh','Kanafeh','0','1500','750','200 REPLACE INTO `item_db` VALUES ('11529','MAAMOUL_','Maamoul','0','500','250','100','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 120,60;','',''); REPLACE INTO `item_db` VALUES ('11530','Jujube','Jujube','0','10','5','100','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 30,0;','',''); REPLACE INTO `item_db` VALUES ('11531','Coffee','Coffee','0','10','5','100','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,10;','',''); +REPLACE INTO `item_db` VALUES ('11602','Catnip_Fruit','Catnip Fruit','0','15','7','1','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(10, 40), 0;','',''); REPLACE INTO `item_db` VALUES ('11701','Girl_Bunch_Of_Flower','Girl\'s Bouquet','0','20','10','50','0','0','0','0','0','18446744073709551615','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','18446744073709551615','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','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(25,35);','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 4569bd6b1..1ee78f4bd 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -1027,6 +1027,21 @@ REPLACE INTO `item_db` VALUES ('1669','Thanatos_Staff','Thanatos Staff','4','20' REPLACE INTO `item_db` VALUES ('1670','RWC_Memory_Staff','RWC Memory Staff','4','20','10','500','25','30','0','1','1','8487700','63','2','2','3','0',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bMatk,30*(getrefine()/3); if (getrefine()>=7) { .@val = 1; bonus4 bAutoSpell,HW_MAGICPOWER,1,10,0; } if (getrefine() >= 4) { bonus2 bMagicAddRace, RC_All, 5*(.@val+1); }','',''); REPLACE INTO `item_db` VALUES ('1671','Evil_Slayer_Vanquisher_Staff','Evil Slayer Vanquisher Staff','4','20','10','800','30','155','0','1','1','8487700','56','2','2','3','0',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Demon,10; bonus2 bAddRace,RC_Undead,10; bonus2 bMagicAddRace,RC_Demon,10; bonus2 bMagicAddRace,RC_Undead,10; if(getrefine()>=9){ bonus bMatkRate,5; } if(getrefine()>=12){ bonus bMatkRate,7; }','',''); REPLACE INTO `item_db` VALUES ('1680','Crimson_Rod','Crimson Rod','4','20','10','600','60','70','0','1','2','8487701','63','2','2','3','70',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,5; bonus bMatk,pow(min(getrefine(),15),2); if(BaseLevel>70) { bonus bMatk,(((BaseLevel-70)/10)*5); }','',''); +REPLACE INTO `item_db` VALUES ('1681','Short_Foxtail_Staff','Short Foxtail Staff','5','20','10','0','30','0','0','1','0','0','63','2','2','1','1',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('1683','Enriched_Foxtail_Staff','Enriched Foxtail Staff','5','20','10','200','50','70','0','1','1','0','7','2','2','2','12',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP, 50;','',''); +REPLACE INTO `item_db` VALUES ('1684','Long_Foxtail_Staff','Long Foxtail Staff','5','20','10','200','50','0','0','2','1','0','63','2','2','2','12',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate, 5; bonus bMaxHP, 200;','',''); +REPLACE INTO `item_db` VALUES ('1685','Dragonfly_Sitting_Foxtail_Staff','Dragonfly Sitting Foxtail Staff','5','20','10','300','70','100','0','1','1','0','7','2','2','2','20',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt, 1; bonus bMaxHP, 100; bonus bMaxSP, 150;','',''); +REPLACE INTO `item_db` VALUES ('1686','Large_Foxtail_Staff','Large Foxtail Staff','5','20','10','300','70','0','0','1','1','0','63','2','2','2','20',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate, 8; bonus bDex, 1; bonus bMaxHP, 200; bonus bMaxSP, 100;','',''); +REPLACE INTO `item_db` VALUES ('1687','Beginner_Foxtail_Staff','Beginner Foxtail Staff','5','20','10','100','40','15','0','1','1','0','7','2','2','1','3',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 100;','',''); +REPLACE INTO `item_db` VALUES ('1690','Mysterious_Foxtail_Staff','Mysterious Foxtail Staff','5','20','10','400','80','180','0','1','3','0','7','2','2','2','60',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP, 10 * (getrefine() / 3) + 50; bonus bMatk, 10 * (getrefine() / 3);','',''); +REPLACE INTO `item_db` VALUES ('1691','Strange_God_Foxtail_Staff','Strange God Foxtail Staff','5','20','10','500','100','240','0','1','2','0','7','2','2','3','100',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP, 100; bonus bMatkRate, 2 * (getrefine() / 3); bonus bMaxSPrate, getrefine() / 3; if (getrefine() >= 7) { .@r = min(getrefine(), 10) - 7; bonus bWeaponAtkRate,(20 * .@r) + 40; bonus bWeaponMatkRate,(20 * .@r) + 40; }','',''); +REPLACE INTO `item_db` VALUES ('1692','Magical_Foxtail_Staff','Magical Foxtail Staff','5','20','10','600','120','260','0','1','2','0','7','2','2','3','140',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP, 100; bonus bMatkRate, 2 * (getrefine() / 3); bonus bMaxSPrate, getrefine() / 3; if (getrefine() >= 7) { .@r = min(getrefine(), 10) - 7; bonus bWeaponAtkRate, (20 * .@r) + 40; bonus bWeaponMatkRate, (20 * .@r) + 40; }','',''); +REPLACE INTO `item_db` VALUES ('1693','Magical_Yellow_Foxtail_Staff','Magical Yellow Foxtail Staff','5','20','10','700','140','280','0','1','1','0','7','2','2','4','175',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatkRate, 3 * (getrefine() / 2); bonus4 bAutoSpellOnSkill, SU_FRESHSHRIMP, SU_ARCLOUSEDASH, max(1, getskilllv(SU_ARCLOUSEDASH)), 200; bonus4 bAutoSpellOnSkill, SU_SV_STEMSPEAR, SU_FRESHSHRIMP, max(1, getskilllv(SU_FRESHSHRIMP)), 200; if (getrefine() >= 7) { .@r = min(getrefine(), 10) - 7; bonus bWeaponAtkRate, (20 * .@r) + 40; bonus bWeaponMatkRate, (20 * .@r) + 40; }','',''); +REPLACE INTO `item_db` VALUES ('1694','Foxtail_Model','Foxtail Model','5','20','10','300','150','0','0','1','3','0','63','2','2','2','60',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate, 8; bonus bMaxHP, 100; bonus bDex, (getrefine() / 3) * 2; bonus bMaxSP, (getrefine() / 3) * 10;','',''); +REPLACE INTO `item_db` VALUES ('1695','Delicate_Foxtail_Model','Delicate Foxtail Model','5','20','10','300','195','0','0','1','2','0','63','2','2','3','100',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate, 8; bonus bMaxHP, 200; bonus bDex, (getrefine() / 3) * 3; bonus bMaxSP, (getrefine() / 3) * 15; if (getrefine() >= 7) { .@r = min(getrefine(), 10) - 7; bonus bWeaponAtkRate, (20 * .@r) + 40; bonus bWeaponMatkRate, (20 * .@r) + 40; }','',''); +REPLACE INTO `item_db` VALUES ('1696','Exquisite_Foxtail_Model','Exquisite Foxtail Model','5','20','10','300','240','0','0','1','2','0','63','2','2','3','140',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate, 8; bonus bMaxHPrate, 5; bonus bDex, (getrefine() / 2) * 3; bonus bMaxSP, (getrefine() / 2) * 15; if (getrefine() >= 7) { .@r = min(getrefine(), 10) - 7; bonus bWeaponAtkRate, (20 * .@r) + 40; bonus bWeaponMatkRate, (20 * .@r) + 40; }','',''); +REPLACE INTO `item_db` VALUES ('1697','Exquisite_Yellow_Foxtail_Model','Exquisite Yellow Foxtail Model','5','20','10','300','270','0','0','1','1','0','63','2','2','4','175',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate, 9; bonus bMaxHPrate, 7; bonus bLongAtkRate, getrefine() / 2; bonus bMaxSP, (getrefine() / 2) * 20; bonus4 bAutoSpellOnSkill, SU_PICKYPECK, SU_FRESHSHRIMP, max(1, getskilllv(SU_FRESHSHRIMP)), 200; if (getrefine() >= 7) { .@r = min(getrefine(), 10) - 7; bonus bWeaponAtkRate, (20 * .@r) + 40; bonus bWeaponMatkRate, (20 * .@r) + 40; }','',''); +REPLACE INTO `item_db` VALUES ('1699','Paradise_Foxtail_Staff_I','Eden Group Foxtail I','5','20','10','0','120','135','0','1','0','0','7','2','2','2','26',NULL,'0','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex, 3; bonus bInt, 3; bonus bLongAtkRate, 5;','',''); REPLACE INTO `item_db` VALUES ('1701','Bow','Bow','4','1000','500','500','15','0','0','5','3','657480','63','2','34','1','4',NULL,'1','11','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1702','Bow_','Bow','4','1000','500','500','15','0','0','5','4','657480','63','2','34','1','4',NULL,'1','11','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1703','Bow__','Bow','4','0','0','0','15','0','0','5','0','657480','63','2','34','1','4',NULL,'0','11','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddDamageClass,1002,500; bonus2 bAddDamageClass,1113,500; bonus2 bAddDamageClass,1031,500; bonus2 bAddDamageClass,1242,500;','',''); @@ -5744,6 +5759,7 @@ REPLACE INTO `item_db` VALUES ('11592','Trance_Candy_R','Red Transform Candy','0 REPLACE INTO `item_db` VALUES ('11593','Trance_Candy_B','Blue Transform Candy','0','0','0','30','0','0','0','0','0','18446744073709551615','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','18446744073709551615','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','18446744073709551615','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 ('11602','Catnip_Fruit','Catnip Fruit','0','15','7','1','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(10,40),0;','',''); REPLACE INTO `item_db` VALUES ('11701','Girl_Bunch_Of_Flower','Girl\'s Bouquet','0','20','10','50','0','0','0','0','0','18446744073709551615','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','18446744073709551615','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','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(25,35);','',''); @@ -8028,8 +8044,13 @@ REPLACE INTO `item_db` VALUES ('15091','Gray_Robe','Gray Robe','5','0','0','1300 REPLACE INTO `item_db` VALUES ('15116','Armor_Of_Airship','Armor Of Airship','5','20','10','700','0','0','100','0','0','18446744073709551615','63','2','16','0','125',NULL,'1','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,1000; bonus bMaxSP,100; bonus bMdef,10; bonus bAllStats,1;','',''); REPLACE INTO `item_db` VALUES ('15117','Tarlock\'s_Armor','Tarlock\'s Armor','5','20','10','750','0','0','70','0','0','18446744073709551615','63','2','16','0','125',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,500; bonus bMaxSP,50; bonus bMdef,10; bonus bAllStats,1; if (getrefine()>=7) { bonus bMaxHP,500; bonus bMaxSP,50; } if (getrefine()>=9) { bonus bMaxHP,200; bonus bMaxSP,20; } if (getrefine()>=12) { bonus bMaxHP,300; bonus bMaxSP,30; }','',''); REPLACE INTO `item_db` VALUES ('15123','Whikebain_Suit','Whikebain Suit','5','10','5','9000','0','0','56','0','1','4096','56','2','16','0','105',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpell,DC_WINKCHARM,1,20; /* Custom - IDRO */ if(getrefine()>4) { bonus bCritAtkRate,4; } if(getrefine()>6) { bonus bCritAtkRate,6; }','',''); +REPLACE INTO `item_db` VALUES ('15126','Private_Doram_Suits','Private Doram Suits','4','20','10','700','0','0','80','0','1','0','63','2','16','0','100',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 100; bonus bDex, getrefine() / 3; bonus bInt, getrefine() / 3;','',''); REPLACE INTO `item_db` VALUES ('15128','Excellion_Suit','Excellion Suit','5','20','10','1000','0','0','100','0','0','18446744073709551615','63','2','16','0','99',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,6; bonus bMaxHPrate,(getrefine()/3)*4; if(BaseLevel>130) { bonus bVit,4; }','',''); +REPLACE INTO `item_db` VALUES ('15129','Luxury_Doram_Suit','Luxury Doram Suit','4','20','10','800','0','0','100','0','1','0','63','2','16','0','140',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 10; bonus bMaxSPrate, 10; bonus bDex, getrefine() / 2; bonus bInt, getrefine() / 2;','',''); REPLACE INTO `item_db` VALUES ('15138','Egir_Armor_K','Aegir Armor','5','200000','100000','1600','0','0','25','0','1','18446744073709551615','63','2','16','0','40',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 50; bonus bUnbreakableArmor, 0;','',''); +REPLACE INTO `item_db` VALUES ('15150','White_Shirt','White Shirt','4','20','10','50','0','0','25','0','1','0','63','2','16','0','6',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,70; bonus bFlee,5;','',''); +REPLACE INTO `item_db` VALUES ('15151','White_Eco-Shirt','White Eco-Shirt','4','20','10','100','0','0','40','0','1','0','63','2','16','0','15',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,150; bonus bFlee,10;','',''); +REPLACE INTO `item_db` VALUES ('15156','Elegant_Doram_Suit','Elegant Doram Suit','4','20','10','900','0','0','120','0','1','0','63','2','16','0','175',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 15; bonus bMaxSPrate, 15; bonus bDex, getrefine(); bonus bInt, getrefine(); if (getrefine() > 9) bonus bUseSPrate, -5;','',''); REPLACE INTO `item_db` VALUES ('16000','Erde','Erde','4','20','10','500','130','0','0','1','2','312754','58','2','2','3','50',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,AM_ACIDTERROR,20; bonus2 bSkillAtk,AM_DEMONSTRATION,20; bonus bMaxSP,50; bonus bHealPower,10;','',''); REPLACE INTO `item_db` VALUES ('16001','Red_Square_Bag','Red Square Bag','4','20','10','500','130','0','0','1','2','312754','58','2','2','3','50',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,200; bonus2 bSkillAtk,AM_ACIDTERROR,20; bonus2 bSkillAtk,AM_DEMONSTRATION,20; bonus2 bAddMonsterDropItem,501,50; bonus2 bAddMonsterDropItem,502,20; bonus2 bAddMonsterDropItem,503,20; bonus2 bAddMonsterDropItem,504,20; bonus2 bAddMonsterDropItem,505,10; if(readparam(bStr)>=95) { bonus2 bAddEff,Eff_Stun,500; }','',''); REPLACE INTO `item_db` VALUES ('16002','Stunner_C','Stunner','4','0','0','0','175','0','0','1','0','33040','63','2','2','3','0',NULL,'0','8','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddEff,Eff_Stun,1000; bonus2 bAddSize,Size_Small,40; bonus2 bAddSize,Size_Medium,40; bonus2 bAddSize,Size_Large,40;','',''); @@ -9685,6 +9706,9 @@ REPLACE INTO `item_db` VALUES ('20765','C_Archangel_Wing','Costume Archangel Win REPLACE INTO `item_db` VALUES ('20768','Arch_Angel_Wing','Arch Angel Wing','5','0','0','200','0','0','18','0','0','18446744073709551615','63','2','4','0','0',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('20773','Excellion_Wing','Excellion Wing','5','20','10','900','0','0','40','0','0','18446744073709551615','63','2','4','0','99',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee2,8; bonus bFlee,getrefine()*2; if(BaseLevel>130) { bonus bFlee2,2; }','',''); REPLACE INTO `item_db` VALUES ('20778','Crimson_Stole','Crimson Stole','5','20','10','700','0','0','8','0','0','18446744073709551615','63','2','4','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus bMaxSPrate,10; bonus bUseSPrate,-(1+2*(getrefine()/3)); if (getrefine() >= 10) { bonus bSPGainValue, 20; }','',''); +REPLACE INTO `item_db` VALUES ('20788','Private_Doram_Manteau','Private Doram Manteau','4','20','10','300','0','0','20','0','1','0','63','2','4','0','100',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,5; bonus2 bSubEle,Ele_Neutral,2; bonus bFlee2,getrefine()/3;','',''); +REPLACE INTO `item_db` VALUES ('20789','Luxury_Doram_Manteau','Luxury Doram Manteau','4','20','10','400','0','0','25','0','1','0','63','2','4','0','140',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee, 7; bonus2 bSubEle,Ele_Neutral, 3; bonus bFlee2, getrefine() / 3; bonus bLuk, getrefine() / 3;','',''); +REPLACE INTO `item_db` VALUES ('20790','Elegant_Doram_Manteau','Elegant Doram Manteau','4','20','10','500','0','0','30','0','1','0','63','2','4','0','175',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee, 10; bonus2 bSubEle,Ele_Neutral, 5; bonus bFlee2, getrefine() / 2; bonus bInt, getrefine() / 2; bonus bDex, getrefine() / 2; bonus bLuk, getrefine() / 2;','',''); REPLACE INTO `item_db` VALUES ('21000','Upg_Twohand_Sword','Upgrade Two-Hand Sword','4','20','10','1500','100','0','0','1','1','16514','63','2','34','3','0',NULL,'1','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*12); bonus bMatk,(getrefine()*5); if(BaseLevel>70) { bonus bBaseAtk,(((BaseLevel-70)/10)*10); }','',''); REPLACE INTO `item_db` VALUES ('21001','Velum_Claymore','Vellum Claymore','4','20','10','3500','260','0','0','2','0','16514','63','2','34','4','95',NULL,'1','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiPlayer,80; bonus2 bIgnoreDefRate,RC_DemiPlayer,30; if(getrefine()>=6) { bonus2 bAddRace,RC_DemiPlayer,40; } if(getrefine()>=9) { autobonus2 \"{ bonus bShortWeaponDamageReturn,20; bonus bMagicDamageReturn,20; }\",200,1000,BF_WEAPON,\"{ specialeffect2 EF_REFLECTSHIELD; }\"; }','',''); REPLACE INTO `item_db` VALUES ('21002','Velum_Katzbalger','Vellum Katzbalger','4','20','10','2500','100','0','0','1','0','16514','63','2','34','4','95',NULL,'1','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bHPVanishRate, 1000, 8, BF_NORMAL;','',''); @@ -9739,6 +9763,11 @@ REPLACE INTO `item_db` VALUES ('22046','Boots_of_Airship','Boots of Airship','5' REPLACE INTO `item_db` VALUES ('22047','Tarlock\'s_Boots','Tarlock\'s Boots','5','20','10','250','0','0','13','0','0','18446744073709551615','63','2','64','0','125',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bAspdRate,5; if(getrefine()>6) { bonus bAgi,1; bonus bAspdRate,5; } if(getrefine()>8) { bonus bAgi,1; bonus bAspdRate,5; } if(getrefine()>11) { bonus bAspd,1; }','',''); REPLACE INTO `item_db` VALUES ('22059','Egir_Shoes_K','Egir Shoes','5','200000','100000','300','0','0','13','0','1','18446744073709551615','63','2','64','0','40',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 50; bonus bUnbreakableShoes, 0;','',''); REPLACE INTO `item_db` VALUES ('22067','Witch_Shoes','Witch Shoes','5','3500','1750','400','0','0','10','0','0','18446744073709551614','63','2','64','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill ALL_CATCRY, 1; bonus bUnbreakableShoes, 1; autobonus3 \"{ }\", 1000, 7000, ALL_CATCRY, \"{ montransform LOLI_RURI, 420000; }\";','',''); +REPLACE INTO `item_db` VALUES ('22076','Wooden_Slipper','Wooden Slipper','4','20','10','50','0','0','10','0','1','0','63','2','64','0','9',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bHPRegenRate,2,10000;','',''); +REPLACE INTO `item_db` VALUES ('22077','Red_Eco-Friendly_Shoes','Red Eco-Friendly Shoes','4','20','10','100','0','0','20','0','1','0','63','2','64','0','18',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritical,5; bonus2 bHPRegenRate,4,10000; bonus2 bSPRegenRate,1,10000;','',''); +REPLACE INTO `item_db` VALUES ('22083','Private_Doram_Shoes','Private Doram Shoes','4','20','10','500','0','0','25','0','1','0','63','2','64','0','100',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 100; bonus bMaxSP, 50; bonus bHPrecovRate, getrefine() * 10 / 3; bonus bSPrecovRate, getrefine() * 10 / 3;','',''); +REPLACE INTO `item_db` VALUES ('22084','Luxury_Doram_Shoes','Luxury Doram Shoes','4','20','10','600','0','0','30','0','1','0','63','2','64','0','140',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 300; bonus bMaxSP, 100; bonus bHPrecovRate, 20 * getrefine() / 3; bonus bSPrecovRate, 20 * getrefine() / 3;','',''); +REPLACE INTO `item_db` VALUES ('22085','Elegant_Doram_Shoes','Elegant Doram Shoes','4','20','10','700','0','0','35','0','1','0','63','2','64','0','175',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate, 10; bonus bMaxSPrate, 5; bonus bMaxHP, 100 * getrefine() / 2; bonus bMaxSP, 20 * getrefine() / 2; if ((getrefine() / 2) >= 4) bonus2 bSkillUseSP, SU_LOPE, 5;','',''); REPLACE INTO `item_db` VALUES ('22508','Para_Team_Mark_','Eden Group Mark','11','0','0','0','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','1200000','507',NULL,'0',NULL,'0',NULL,'0','unitskilluseid getcharid(CHAR_ID_ACCOUNT), \"AL_TELEPORT\", 3;','',''); REPLACE INTO `item_db` VALUES ('22514','Candy_Holder','Candy Holder','11','20','10','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('22515','Twisted_Key_of_Time','Twisted Key of Time','3','10','5','300','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -10012,6 +10041,7 @@ REPLACE INTO `item_db` VALUES ('24242','Caster_Shadow_Armor','Caster Shadow Armo REPLACE INTO `item_db` VALUES ('24243','Reload_Shadow_Shoes','Reload Shadow Shoes','5','10','5','0','0','0','0','0','0','18446744073709551615','63','2','524288','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDelayrate,-1; if (getrefine()>=7) { bonus bDelayrate,-1; } if (getrefine()>=9) { bonus bDelayrate,-1; }','',''); REPLACE INTO `item_db` VALUES ('24244','Reload_Shadow_Shield','Reload Shadow Shield','5','10','5','0','0','0','0','0','0','18446744073709551615','63','2','262144','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDelayrate,-1; if (getrefine()>=7) { bonus bDelayrate,-1; } if (getrefine()>=9) { bonus bDelayrate,-1; }','',''); REPLACE INTO `item_db` VALUES ('24245','Reload_Shadow_Armor','Reload Shadow Armor','5','10','5','0','0','0','0','0','0','18446744073709551615','63','2','65536','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDelayrate,-1; if (getrefine()>=7) { bonus bDelayrate,-1; } if (getrefine()>=9) { bonus bDelayrate,-1; }','',''); +REPLACE INTO `item_db` VALUES ('26101','Paradise_Foxtail_Staff_III','Eden Group Foxtail Staff III','5','20','10','0','150','195','0','1','0','0','7','2','2','3','60',NULL,'0','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,5; bonus bInt,5; bonus bLongAtkRate,7;','',''); REPLACE INTO `item_db` VALUES ('28000','Thanatos_Katar','Thanatos Katar','4','20','10','1800','220','80','0','1','1','4096','56','2','34','4','120',NULL,'1','16','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,6; bonus bVit,6; bonus bLuk,-6; bonus2 bSPDrainRate,10,5; bonus2 bHPDrainRate,10,5; bonus2 bHPLossRate,100,10000;','','heal -1000,0;'); REPLACE INTO `item_db` VALUES ('28001','Evil_Slayer_Ripper_Katar','Evil Slayer Ripper Katar','4','20','10','1200','120','0','0','1','1','4096','56','2','34','3','100',NULL,'1','16','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Demon,10; bonus2 bAddRace,RC_Undead,10; if(getrefine()>8) { bonus bAtkRate,5; } if(getrefine()>11) { bonus bAtkRate,7; }','',''); REPLACE INTO `item_db` VALUES ('28002','Half_BF_Katar2','Half BF Katar2','4','20','10','0','130','0','0','1','0','4096','63','2','34','3','80',NULL,'1','16','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bDex,1; bonus bLuk,1; bonus2 bAddRace,RC_DemiPlayer,35; bonus bCritAtkRate,10; bonus bAspdRate,3; bonus bUnbreakableWeapon,0;','',''); @@ -10043,6 +10073,22 @@ REPLACE INTO `item_db` VALUES ('28365','Vit_Gloves','Vit Gloves','5','0','0','10 REPLACE INTO `item_db` VALUES ('28366','Dex_Gloves','Dex Gloves','5','0','0','100','0','0','0','0','1','18446744073709551615','63','2','136','0','120',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bVariableCastrate,-5;','',''); REPLACE INTO `item_db` VALUES ('28367','Luk_Gloves','Luk Gloves','5','0','0','100','0','0','0','0','1','18446744073709551615','63','2','136','0','120',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,2; bonus bFlee2,5;','',''); REPLACE INTO `item_db` VALUES ('28372','Imperial_Ring','Imperial Ring','5','0','0','500','0','0','3','0','1','18446744073709551615','63','2','136','0','50',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bMaxHPrate,3; bonus bMaxSPrate,3;','',''); +REPLACE INTO `item_db` VALUES ('28374','Foxtail_Ring','Foxtail Ring','4','20','10','100','0','0','0','0','0','0','63','2','136','0','1',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace,RC_All,5; .@lvl = min(BaseLevel/5,10); bonus bAtk,2*.@lvl; bonus bMatk,2*.@lvl; bonus bMaxHP,10*.@lvl; bonus bMaxSP,5*.@lvl;','',''); +REPLACE INTO `item_db` VALUES ('28380','Fresh_Grass_Necklace','Fresh Grass Necklace','4','20','10','100','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee2,5; bonus2 bSkillCooldown,SU_SCAROFTAROU,-5000;','',''); +REPLACE INTO `item_db` VALUES ('28381','Cute_Grass_Necklace','Cute Grass Necklace','4','20','10','10','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHealPower,5; bonus2 bSkillCooldown,SU_TUNAPARTY,-7000;','',''); +REPLACE INTO `item_db` VALUES ('28382','Charm_Grass_Necklace','Charm Grass Necklace','4','20','10','10','0','0','0','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bVariableCastrate,SU_CN_METEOR,-1000;','',''); +REPLACE INTO `item_db` VALUES ('28413','Lesser_Mackerel_Talisman','Lesser Mackerel Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1;','',''); +REPLACE INTO `item_db` VALUES ('28414','Intermediate_Mackerel_Talisman','Intermediate Mackerel Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,2;','',''); +REPLACE INTO `item_db` VALUES ('28415','Greater_Mackerel_Talisman','Greater Mackerel Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,3;','',''); +REPLACE INTO `item_db` VALUES ('28416','Lesser_Leaf_Talisman','Lesser Leaf Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1;','',''); +REPLACE INTO `item_db` VALUES ('28417','Intermediate_Leaf_Talisman','Intermediate Leaf Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2;','',''); +REPLACE INTO `item_db` VALUES ('28418','Greater_Leaf_Talisman','Greater Leaf Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,3;','',''); +REPLACE INTO `item_db` VALUES ('28419','Lesser_Rabbit_Talisman','Lesser Rabbit Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,1;','',''); +REPLACE INTO `item_db` VALUES ('28420','Intermediate_Rabbit_Talisman','Intermediate Rabbit Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','140',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2;','',''); +REPLACE INTO `item_db` VALUES ('28421','Greater_Rabbit_Talisman','Greater Rabbit Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','175',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,3;','',''); +REPLACE INTO `item_db` VALUES ('28422','Shiny_Branch_Talisman','Shiny Branch Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bVariableCastrate,SU_SV_STEMSPEAR,-50; bonus2 bSkillAtk,SU_SV_STEMSPEAR,(readparam(bInt)/2)+(20 * getskilllv(SU_SV_STEMSPEAR)); //Need to confirm damage formula','',''); +REPLACE INTO `item_db` VALUES ('28423','Fresh_Tuna_Talisman','Fresh Tuna Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillCooldown,SU_TUNAPARTY,-5000; bonus3 bAutoSpellWhenHit,SU_TUNAPARTY,max(1,getskilllv(SU_TUNAPARTY)),10;','',''); +REPLACE INTO `item_db` VALUES ('28424','Chubby_Worm_Talisman','Chubby Worm Talisman','4','0','0','100','0','0','1','0','1','0','63','2','136','0','100',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bVariableCastrate,SU_PICKYPECK,-50; bonus2 bSkillAtk,SU_PICKYPECK,(readparam(bDex)/2)+(20 * getskilllv(SU_PICKYPECK)); //Need to confirm damage formula','',''); REPLACE INTO `item_db` VALUES ('28604','Crimson_Bible','Crimson Bible','4','20','10','450','45','0','0','1','2','4260096','63','2','2','3','70',NULL,'1','15','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAtk,pow(min(getrefine(),15),2); bonus bMatk,pow(min(getrefine(),15),2)/2; if(BaseLevel>70) { bonus bAtk,(((BaseLevel-70)/10)*5); }','',''); REPLACE INTO `item_db` VALUES ('28605','Book_of_Vicious_Mind','Book of Vicious Mind','4','20','10','950','95','0','0','1','1','4260096','63','2','2','4','160',NULL,'1','15','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); bonus bMatk,pow(min(getrefine(),15),2); bonus bUnbreakableWeapon,0;','',''); REPLACE INTO `item_db` VALUES ('28703','Infinity_Dagger','Infinity Dagger','4','20','10','500','125','100','0','1','1','579821295','63','2','2','4','100',NULL,'1','1','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); -- cgit v1.2.3-70-g09d2