From 20b44f8fcaff75657386783c2696ca9dc2cbc7d6 Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Tue, 8 Nov 2016 08:07:07 +0100 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 80 ++++++++++++++++++++++++------------------------ 1 file changed, 40 insertions(+), 40 deletions(-) (limited to 'sql-files') diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 9ce737181..f4af632cf 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -1027,21 +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 ('1681','Short_Foxtail_Staff','Short Foxtail Staff','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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','4','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;','',''); @@ -1190,8 +1190,8 @@ REPLACE INTO `item_db` VALUES ('1931','P_String_Inst1','Eden Group Guitar I','4' REPLACE INTO `item_db` VALUES ('1932','TE_WoE_Guitar','TE WoE Guitar','4','0','0','0','100','0','0','1','0','524288','63','1','2','3','40',NULL,'0','13','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Poison,1000;','',''); REPLACE INTO `item_db` VALUES ('1933','Thanatos_Violin','Thanatos Violin','4','20','10','2000','200','130','0','1','1','524288','56','1','2','4','120',NULL,'1','13','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 ('1934','Double_Bass','Double Bass','4','124000','62000','250','180','120','0','1','2','524288','56','1','2','3','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillCooldown,WM_RANDOMIZESPELL,-2000;','',''); -REPLACE INTO `item_db` VALUES ('1935','Ozs_New_Ukulele','Oz\'s New Ukulele','5','124000','62000','1000','160','0','0','1','2','524288','56','1','2','4','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillUseSP,MI_RUSH_WINDMILL,-20;','',''); -REPLACE INTO `item_db` VALUES ('1936','Blue_Violin','Blue Violin','5','20','10','1500','180','0','0','1','1','524288','56','1','2','3','100',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,5; bonus bVit,5;','',''); +REPLACE INTO `item_db` VALUES ('1935','Ozs_New_Ukulele','Oz\'s New Ukulele','4','124000','62000','1000','160','0','0','1','2','524288','56','1','2','4','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillUseSP,MI_RUSH_WINDMILL,-20;','',''); +REPLACE INTO `item_db` VALUES ('1936','Blue_Violin','Blue Violin','4','20','10','1500','180','0','0','1','1','524288','56','1','2','3','100',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,5; bonus bVit,5;','',''); REPLACE INTO `item_db` VALUES ('1937','Ru_Gold_Violin','Ru Gold Violin','4','20','10','1500','180','0','0','1','2','524288','56','1','2','3','120',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,8; bonus bVit,8;','',''); REPLACE INTO `item_db` VALUES ('1938','Infinity_Violin','Infinity Violin','4','20','10','500','150','0','0','1','1','524288','56','1','2','4','100',NULL,'1','13','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1939','Crimson_Violin','Crimson Violin','4','20','10','800','80','0','0','1','2','524288','63','1','2','3','70',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); if(BaseLevel>70) { bonus bAtk,(((BaseLevel-70)/10)*5); }','',''); @@ -1235,9 +1235,9 @@ REPLACE INTO `item_db` VALUES ('1985','Rosebine','Rosevine','4','20','10','1000' REPLACE INTO `item_db` VALUES ('1986','P_Tail1','Eden Group Whip I','4','0','0','0','125','0','0','2','0','524288','63','0','2','3','60',NULL,'1','14','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1987','TE_WoE_Rope','TE WoE Rope','4','0','0','0','100','0','0','2','0','524288','63','0','2','4','40',NULL,'0','14','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Blind,1000;','',''); REPLACE INTO `item_db` VALUES ('1988','Thanatos_Whip','Thanatos Whip','4','20','10','2200','200','130','0','2','1','524288','56','0','2','4','120',NULL,'1','14','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 ('1989','Rhythmic_Gymnastics_Ribbon','Rhythmic Gymnastics Ribbon','5','124000','62000','300','150','120','0','2','2','524288','56','2','2','3','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,20;','',''); -REPLACE INTO `item_db` VALUES ('1990','Bloody_Floral_Decoration_Microphone','Bloody Floral Decoration Microphone','5','124000','62000','1000','160','0','0','2','2','524288','56','2','2','4','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillUseSP,CG_MOONLIT,-20;','',''); -REPLACE INTO `item_db` VALUES ('1991','Blue_Whip','Blue Whip','5','20','10','1500','180','0','0','2','1','524288','56','2','2','3','100',NULL,'1','14','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,5; bonus bVit,5;','',''); +REPLACE INTO `item_db` VALUES ('1989','Rhythmic_Gymnastics_Ribbon','Rhythmic Gymnastics Ribbon','4','124000','62000','300','150','120','0','2','2','524288','56','1','2','3','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,20;','',''); +REPLACE INTO `item_db` VALUES ('1990','Bloody_Floral_Decoration_Microphone','Bloody Floral Decoration Microphone','4','124000','62000','1000','160','0','0','2','2','524288','56','1','2','4','130',NULL,'1','13','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillUseSP,CG_MOONLIT,-20;','',''); +REPLACE INTO `item_db` VALUES ('1991','Blue_Whip','Blue Whip','4','20','10','1500','180','0','0','2','1','524288','56','0','2','3','100',NULL,'1','14','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,5; bonus bVit,5;','',''); REPLACE INTO `item_db` VALUES ('1992','Ru_Gold_Whip','Ru Gold Whip','4','20','10','1500','180','0','0','2','2','524288','56','0','2','3','120',NULL,'1','14','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,8; bonus bVit,8;','',''); REPLACE INTO `item_db` VALUES ('1994','Infinity_Wire','Infinity Wire','4','20','10','0','100','0','0','2','1','524288','56','0','2','4','100',NULL,'1','14','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('1995','Crimson_Wire','Crimson Wire','4','20','10','800','80','0','0','2','2','524288','63','0','2','3','70',NULL,'1','14','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); if(BaseLevel>70) { bonus bAtk,(((BaseLevel-70)/10)*5); }','',''); @@ -1266,7 +1266,7 @@ REPLACE INTO `item_db` VALUES ('2020','Jormungand','Jormungand','4','20','10','3 REPLACE INTO `item_db` VALUES ('2021','Ganbantein','Ganbantein','4','20','10','2000','100','320','0','1','0','512','56','2','34','4','100',NULL,'0','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,25; bonus bDex,25; bonus5 bAutoSpell,AB_SILENTIUM,1,100,BF_MAGIC,1; bonus3 bAddEff,Eff_Poison,100,ATF_SKILL; bonus2 bAddEffWhenHit,Eff_Silence,10000; bonus bUnbreakableWeapon,0;','',''); REPLACE INTO `item_db` VALUES ('2022','Staff_Of_Geffen','Staff Of Geffen','4','20','10','1000','100','300','0','0','1','512','56','2','34','1','150',NULL,'1','10','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,20;','',''); REPLACE INTO `item_db` VALUES ('2023','Thanatos_Two-Handed_Staff','Thanatos Two-Handed Staff','4','20','10','1400','120','250','0','1','1','99092','56','2','34','4','120',NULL,'1','23','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; bonus bHealPower,18;','','heal -1000,0;'); -REPLACE INTO `item_db` VALUES ('2024','Infinity_Staff','Infinity Staff','5','20','10','500','30','170','0','0','1','8454656','56','2','34','4','100',NULL,'1','23','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('2024','Infinity_Staff','Infinity Staff','4','20','10','500','30','170','0','0','1','8454656','56','2','34','4','100',NULL,'1','23','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('2025','Staff_of_Crimson','Staff of Crimson','4','20','10','1000','100','150','0','1','2','8454660','63','2','34','3','70',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,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 ('2026','Staff_of_Vicious_Mind','Staff of Vicious Mind','4','20','10','1000','100','200','0','1','1','8454660','63','2','34','4','160',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,6; bonus bMatk,pow(min(getrefine(),15),2); bonus bUnbreakableWeapon,0;','',''); REPLACE INTO `item_db` VALUES ('2101','Guard','Guard','5','500','250','300','0','0','20','0','0','18446744073709551615','63','2','32','0','0',NULL,'1','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -2106,7 +2106,7 @@ REPLACE INTO `item_db` VALUES ('2981','Brave_Ring','Brave Ring','5','20','10','2 REPLACE INTO `item_db` VALUES ('2986','Snake_Ring','Snake Ring','5','20','10','100','0','0','2','0','1','18446744073709551615','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,3; bonus bMdef,2;','',''); REPLACE INTO `item_db` VALUES ('2987','Snake_Pendant','Snake Pendant','5','20','10','100','0','0','3','0','1','18446744073709551615','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,3; bonus bLuk,2; bonus bMdef,3;','',''); REPLACE INTO `item_db` VALUES ('2988','Ozs_New_Wing_Ring','Oz\'s New Wing Ring','5','62000','31000','100','0','0','0','0','1','524288','56','1','136','0','130',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVariableCastrate,-25;','',''); -REPLACE INTO `item_db` VALUES ('2989','Bloody_Floral_Decoration_Bracelet','Bloody Floral Decoration Bracelet','4','62000','31000','100','0','0','0','0','1','524288','56','2','136','0','130',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVariableCastrate,-25;','',''); +REPLACE INTO `item_db` VALUES ('2989','Bloody_Floral_Decoration_Bracelet','Bloody Floral Decoration Bracelet','5','62000','31000','100','0','0','0','0','1','524288','56','2','136','0','130',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVariableCastrate,-25;','',''); REPLACE INTO `item_db` VALUES ('2997','RWC_Gold_Brooch','RWC Gold Brooch','5','0','0','200','0','0','0','0','1','18446744073709551615','63','2','136','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,20; bonus bMatk,20;','',''); REPLACE INTO `item_db` VALUES ('2999','RWC_Silver_Brooch','RWC Silver Brooch','5','0','0','200','0','0','0','0','0','18446744073709551615','63','2','136','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,300; bonus bMaxSP,30;','',''); REPLACE INTO `item_db` VALUES ('4001','Poring_Card','Poring Card','6','20','10','10','0','0','0','0','0','18446744073709551615','63','2','16','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,2; bonus bFlee2,1;','',''); @@ -6812,9 +6812,9 @@ REPLACE INTO `item_db` VALUES ('13114','P_Revolver3','Eden Group Revolver III',' REPLACE INTO `item_db` VALUES ('13115','Upg_Revolver','Upgrade Revolver','4','20','10','500','35','0','0','7','1','16777216','1','2','34','3','0',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*5); bonus bLongAtkRate,(getrefine()*2); if(BaseLevel>70) { bonus bBaseAtk,(((BaseLevel-70)/10)*5); }','',''); REPLACE INTO `item_db` VALUES ('13116','Novice_Revolver','Beginner Revolver','4','0','0','500','20','0','0','7','0','16777216','1','2','34','1','0',NULL,'0','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-5;','',''); REPLACE INTO `item_db` VALUES ('13117','TE_Woe_Pistol','TE Woe Pistol','4','0','0','0','60','0','0','7','0','1090519040','63','2','34','3','40',NULL,'0','17','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Curse,1000;','',''); -REPLACE INTO `item_db` VALUES ('13120','Heaven\'s_Feather_and_Hell\'s_Fire','Heaven\'s_Feather_&_Hell\'s_Fire','5','1250000','625000','800','150','0','0','9','1','1090519040','63','2','34','3','99',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,GS_DESPERADO,20; bonus2 bSkillAtk,RL_FALLEN_ANGEL,20;','',''); -REPLACE INTO `item_db` VALUES ('13122','Altea_and_Ares','Altea & Ares','5','1450000','725000','1000','200','0','0','9','0','1073741824','63','2','34','3','140',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,5; bonus bDelayrate,10; bonus bLongAtkRate,30;','',''); -REPLACE INTO `item_db` VALUES ('13124','Altea_and_Ares_','Altea & Ares','5','1450000','725000','1000','200','0','0','9','1','1073741824','63','2','34','3','140',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,5; bonus bDelayrate,10; bonus bLongAtkRate,30;','',''); +REPLACE INTO `item_db` VALUES ('13120','Heaven\'s_Feather_and_Hell\'s_Fire','Heaven\'s_Feather_&_Hell\'s_Fire','4','1250000','625000','800','150','0','0','9','1','1090519040','63','2','34','3','99',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,GS_DESPERADO,20; bonus2 bSkillAtk,RL_FALLEN_ANGEL,20;','',''); +REPLACE INTO `item_db` VALUES ('13122','Altea_and_Ares','Altea & Ares','4','1450000','725000','1000','200','0','0','9','0','1073741824','63','2','34','3','140',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,5; bonus bDelayrate,10; bonus bLongAtkRate,30;','',''); +REPLACE INTO `item_db` VALUES ('13124','Altea_and_Ares_','Altea & Ares','4','1450000','725000','1000','200','0','0','9','1','1073741824','63','2','34','3','140',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,5; bonus bDelayrate,10; bonus bLongAtkRate,30;','',''); REPLACE INTO `item_db` VALUES ('13127','Crimson_Revolver','Crimson Revolver','4','20','10','1000','100','0','0','7','2','16777216','63','2','34','3','70',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2); if(BaseLevel>70) { bonus bAtk,(((BaseLevel-70)/10)*5); }','',''); REPLACE INTO `item_db` VALUES ('13128','Revolver_of_Vicious_Mind','Revolver of Vicious Mind','4','20','10','1500','150','0','0','7','1','16777216','63','2','34','4','160',NULL,'1','17','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtk,pow(min(getrefine(),15),2);','',''); REPLACE INTO `item_db` VALUES ('13150','Branch','Branch','4','3000','1500','500','50','0','0','9','3','16777216','1','2','34','1','0',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -6855,16 +6855,16 @@ REPLACE INTO `item_db` VALUES ('13184','TE_Woe_Rifle','TE Woe Rifle','4','0','0' REPLACE INTO `item_db` VALUES ('13185','TE_Woe_Gatling','TE Woe Gatling','4','0','0','0','100','0','0','9','0','1090519040','63','2','34','3','40',NULL,'0','19','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Stun,1000;','',''); REPLACE INTO `item_db` VALUES ('13186','TE_Woe_Shotgun','TE Woe Shotgun','4','0','0','0','100','0','0','9','0','1090519040','63','2','34','3','40',NULL,'0','20','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Poison,1000;','',''); REPLACE INTO `item_db` VALUES ('13187','TE_Woe_Grenade','TE Woe Grenade','4','0','0','0','100','0','0','9','0','1090519040','63','2','34','3','40',NULL,'0','21','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Blind,1000;','',''); -REPLACE INTO `item_db` VALUES ('13189','Color_Scope','Color Scope','5','1350000','675000','1200','240','0','0','9','2','1073741824','63','2','34','3','105',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,30; bonus bCriticalRate,30;','',''); -REPLACE INTO `item_db` VALUES ('13190','RAG203','RAG203','5','1800000','900000','1300','260','0','0','9','1','1073741824','63','2','34','3','140',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,10; bonus bCriticalRate,15; bonus4 bAutoSpell,AL_DECAGI,1,500,0;','',''); -REPLACE INTO `item_db` VALUES ('13192','Death_Fire','Death Fire','5','1250000','625000','2000','400','0','0','9','1','1073741824','63','2','34','3','108',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate,5; bonus bHit,-50; bonus bDelayrate,-10;','',''); -REPLACE INTO `item_db` VALUES ('13193','Rolling_Thunder','Rolling Thunder','5','1350000','675000','1800','280','0','0','9','1','1073741824','63','2','34','3','120',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-10; bonus bDelayrate,-10; bonus3 bAutoSpell,MG_THUNDERSTORM,5,500;','',''); -REPLACE INTO `item_db` VALUES ('13194','Peace_Breaker','Peace Breaker','5','1950000','975000','1400','250','0','0','9','0','1090519040','63','2','34','3','120',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bAspdRate,25;','',''); -REPLACE INTO `item_db` VALUES ('13195','RAG203_','RAG203','5','1800000','900000','1300','260','0','0','9','0','1073741824','63','2','34','3','140',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,10; bonus bCriticalRate,15; bonus4 bAutoSpell,AL_DECAGI,1,10,0;','',''); -REPLACE INTO `item_db` VALUES ('13196','Peace_Breaker_','Peace Breaker','5','1950000','975000','1400','250','0','0','9','1','1090519040','63','2','34','3','120',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bAspdRate,25;','',''); -REPLACE INTO `item_db` VALUES ('13197','Mini_Mei','Mini Mei','5','1600000','800000','2500','220','0','0','9','2','1090519040','63','2','34','2','106',NULL,'1','19','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('13198','Tempest','Tempest','5','2200000','1100000','2500','250','0','0','9','0','1090519040','63','2','34','2','140',NULL,'1','19','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bCritical,10; bonus bLongAtkRate,20;','',''); -REPLACE INTO `item_db` VALUES ('13199','Tempest_','Tempest','5','2200000','1100000','2500','250','0','0','9','1','1090519040','63','2','34','2','140',NULL,'1','19','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bCritical,10; bonus bLongAtkRate,20;','',''); +REPLACE INTO `item_db` VALUES ('13189','Color_Scope','Color Scope','4','1350000','675000','1200','240','0','0','9','2','1073741824','63','2','34','3','105',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,30; bonus bCriticalRate,30;','',''); +REPLACE INTO `item_db` VALUES ('13190','RAG203','RAG203','4','1800000','900000','1300','260','0','0','9','1','1073741824','63','2','34','3','140',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,10; bonus bCriticalRate,15; bonus4 bAutoSpell,AL_DECAGI,1,500,0;','',''); +REPLACE INTO `item_db` VALUES ('13192','Death_Fire','Death Fire','4','1250000','625000','2000','400','0','0','9','1','1073741824','63','2','34','3','108',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkRate,5; bonus bHit,-50; bonus bDelayrate,-10;','',''); +REPLACE INTO `item_db` VALUES ('13193','Rolling_Thunder','Rolling Thunder','4','1350000','675000','1800','280','0','0','9','1','1073741824','63','2','34','3','120',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-10; bonus bDelayrate,-10; bonus3 bAutoSpell,MG_THUNDERSTORM,5,500;','',''); +REPLACE INTO `item_db` VALUES ('13194','Peace_Breaker','Peace Breaker','4','1950000','975000','1400','250','0','0','9','0','1090519040','63','2','34','3','120',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bAspdRate,25;','',''); +REPLACE INTO `item_db` VALUES ('13195','RAG203_','RAG203','4','1800000','900000','1300','260','0','0','9','0','1073741824','63','2','34','3','140',NULL,'1','18','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,10; bonus bCriticalRate,15; bonus4 bAutoSpell,AL_DECAGI,1,10,0;','',''); +REPLACE INTO `item_db` VALUES ('13196','Peace_Breaker_','Peace Breaker','4','1950000','975000','1400','250','0','0','9','1','1090519040','63','2','34','3','120',NULL,'1','20','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bAspdRate,25;','',''); +REPLACE INTO `item_db` VALUES ('13197','Mini_Mei','Mini Mei','4','1600000','800000','2500','220','0','0','9','2','1090519040','63','2','34','2','106',NULL,'1','19','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('13198','Tempest','Tempest','4','2200000','1100000','2500','250','0','0','9','0','1090519040','63','2','34','2','140',NULL,'1','19','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bCritical,10; bonus bLongAtkRate,20;','',''); +REPLACE INTO `item_db` VALUES ('13199','Tempest_','Tempest','4','2200000','1100000','2500','250','0','0','9','1','1090519040','63','2','34','2','140',NULL,'1','19','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,-25; bonus bCritical,10; bonus bLongAtkRate,20;','',''); REPLACE INTO `item_db` VALUES ('13200','Bullet','Bullet','10','1','0','2','10','0','0','0','0','16777216','63','2','32768','0','0',NULL,'0','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle, Ele_Neutral;','',''); REPLACE INTO `item_db` VALUES ('13201','Silver_Bullet','Silver Bullet','10','15','7','2','15','0','0','0','0','16777216','63','2','32768','0','0',NULL,'0','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy;','',''); REPLACE INTO `item_db` VALUES ('13202','Shell_Of_Blood','Bloody Shell','10','30','15','2','30','0','0','0','0','16777216','63','2','32768','0','0',NULL,'0','3','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle, Ele_Neutral; bonus2 bAddEff, Eff_Bleeding, 100;','',''); @@ -8048,7 +8048,7 @@ REPLACE INTO `item_db` VALUES ('15126','Private_Doram_Suits','Private Doram Suit 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 ('15150','White_Shirt','White Shirt','5','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;','',''); @@ -9706,9 +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 ('20788','Private_Doram_Manteau','Private Doram Manteau','5','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','5','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','5','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;','',''); @@ -10041,7 +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 ('26101','Paradise_Foxtail_Staff_III','Eden Group Foxtail Staff III','4','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;','',''); -- cgit v1.2.3-70-g09d2