From bf75b4af29e8c1213ffe4019cdafe0a8325394ac Mon Sep 17 00:00:00 2001 From: "Hercules.ws" Date: Wed, 20 Jul 2016 07:21:52 +0200 Subject: ItemDB SQL Sync Signed-off-by: HerculesWSAPI --- sql-files/item_db_re.sql | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index de9bbe22d..2f7167d14 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -1247,9 +1247,9 @@ REPLACE INTO `item_db` VALUES ('2016','Velum_Arc_Wand','Vellum Arc Wand','4','20 REPLACE INTO `item_db` VALUES ('2017','Divine_Cross_','Divine Cross','4','20','10','1500','120','210','0','1','1','33024','63','2','34','4','70',NULL,'1','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus bAtkEle,Ele_Holy; bonus bDex,4;','',''); REPLACE INTO `item_db` VALUES ('2018','Metal_Staff','Metal Staff','4','20','10','0','50','70','0','1','1','8487701','63','2','34','3','0',NULL,'1','23','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; if(BaseJob==Job_Wizard) bonus bMatk,15; else if(BaseJob==Job_Sage) bonus bMatk,10; bonus bMatk,(getrefine()*5); .@val = min(BaseLevel/10, 12); if (.@val > 2) { bonus bMatk,((.@val-2)*5); }','',''); REPLACE INTO `item_db` VALUES ('2019','TE_Woe_Two_Hand_Staff','TE Woe Two Hand Staff','4','20','10','0','50','130','0','1','0','8487701','63','2','34','3','40',NULL,'0','23','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Player,20; bonus bHealPower,5; bonus2 bAddEff,Eff_Stun,1000;','',''); -REPLACE INTO `item_db` VALUES ('2020','Jormungand','Jormungand','5','20','10','3000','200','280','0','1','0','8454656','63','2','34','4','90',NULL,'0','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,20; bonus bAtkEle,Ele_Poison; bonus3 bAddEff,Eff_Poison,300,ATF_SKILL; bonus2 bAddEffWhenHit,Eff_Poison,100; bonus bUnbreakableWeapon,0;','',''); -REPLACE INTO `item_db` VALUES ('2021','Ganbantein','Ganbantein','5','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','5','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 ('2020','Jormungand','Jormungand','4','20','10','3000','200','280','0','1','0','8454656','63','2','34','4','90',NULL,'0','23','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,20; bonus bAtkEle,Ele_Poison; bonus3 bAddEff,Eff_Poison,300,ATF_SKILL; bonus2 bAddEffWhenHit,Eff_Poison,100; bonus bUnbreakableWeapon,0;','',''); +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 ('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); }','',''); @@ -2072,6 +2072,7 @@ REPLACE INTO `item_db` VALUES ('2942','Taekwon_Manual','Taekwon Tutorial','5','0 REPLACE INTO `item_db` VALUES ('2944','TE_Ring_of_Protection','TE Ring of Protection','5','0','0','0','0','0','0','0','0','18446744073709551615','63','2','136','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,100; bonus2 bAddRaceTolerance,RC_Player,5;','',''); REPLACE INTO `item_db` VALUES ('2945','TE_Ring_Of_Rage','TE Rage Of Ring','5','0','0','0','0','0','0','0','0','18446744073709551615','63','2','136','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,5; bonus2 bMagicAddRace,RC_Player,5;','',''); REPLACE INTO `item_db` VALUES ('2946','TE_Ring_Of_Defiance','TE Ring Of Defiance','5','0','0','0','0','0','0','0','0','18446744073709551615','63','2','136','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus2 bAddRaceTolerance,RC_Player,5;','',''); +REPLACE INTO `item_db` VALUES ('2949','Silversmith_Bracelet','Silversmith Bracelet','5','20','10','100','0','0','3','0','1','18446744073709551615','63','2','136','0','60',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats, 1; bonus bMdef, 3; skill SA_SPELLBREAKER,5;','',''); REPLACE INTO `item_db` VALUES ('2950','Rune_Ring','Rune Ring','5','0','0','0','0','0','0','0','0','18446744073709551615','63','2','136','0','1','100','0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace, RC_All, 10;','',''); REPLACE INTO `item_db` VALUES ('2951','Kvasir_Ring_Blue','Kvasir Ring Blue','5','20000','10000','100','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 bMaxSP,30; skill ECL_SNOWFLIP,1;','',''); REPLACE INTO `item_db` VALUES ('2952','Kvasir_Ring_Red','Kvasir Ring Red','5','20000','10000','100','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 bMaxSP,30; skill \"ECL_PEONYMAMY\",1;','',''); @@ -4543,6 +4544,10 @@ REPLACE INTO `item_db` VALUES ('6605','Muspellium','Muspellium','3','20','10','0 REPLACE INTO `item_db` VALUES ('6606','P_Cart_C','P Cart C','3','0','0','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 ('6607','Temporal_Crystal','Temporal Crystal','3','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 ('6608','Coagulated_Spell','Coagulated Spell','3','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 ('6609','Glast_Decayed_Nail','Glast Decayed Nail','3','82','41','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('6610','Glast_Horrendous_Mouth','Glast Horrendous Mouth','3','390','195','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('6612','Gold_Coin_Basket','Gold Coin Basket','3','300000','150000','200','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); +REPLACE INTO `item_db` VALUES ('6613','Colorful_Brooch','Colorful Brooch','3','100000','50000','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6615','Siege_Guild_Coin','Siege Guild Coin','3','0','0','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 ('6616','Lmtd_Manny_Card','Lmtd Manny Card','3','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 ('6617','Lmtd_Sid_Card','Lmtd Sid Card','3','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','','',''); @@ -4566,6 +4571,7 @@ REPLACE INTO `item_db` VALUES ('6674','Part_time_Receipt','Part-time Receipt','3 REPLACE INTO `item_db` VALUES ('6681','XMAS_Cookie','XMAS Cookie','3','0','0','0','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6682','Bag_Of_Selling_Goods','Bag Of Selling Goods','3','20','10','10','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('6712','Lovely_Stick','Love Wand','3','0','0','0','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 ('6755','Contaminated_Magic','Contaminated Magic','3','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 ('6804','Organic_Pumpkin','Organic Pumpkin','3','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 ('6805','Inorganic_Pumpkin','Inorganic Pumpkin','3','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 ('6821','Solo_Troops_Badge','Single Union Badge','3','0','0','0','0','0','0','0','0','18446744073709551615','63','2','0','0','0',NULL,'0','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','','',''); @@ -6768,6 +6774,7 @@ REPLACE INTO `item_db` VALUES ('13078','Mikatsuki','Mikatsuki','4','40000','2000 REPLACE INTO `item_db` VALUES ('13079','Metal_Dagger','Metal Dagger','4','20','10','0','55','0','0','1','1','33689664','1','2','2','3','0',NULL,'1','1','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*5); bonus bMatk,(getrefine()*2); .@val = min(BaseLevel/10, 12); if (.@val > 2) { bonus bBaseAtk,((.@val-2)*5); }','',''); REPLACE INTO `item_db` VALUES ('13081','Octo_kitchen_Knife','Discount knife Octopus','4','200000','100000','700','140','0','0','0','3','579821294','1','2','2','4','105',NULL,'1','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('13083','TE_Woe_Knife','T Woe Knife','4','0','0','0','100','100','0','1','0','1049583343','1','2','2','3','40',NULL,'0','1','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Player,40; bonus2 bAddEff,Eff_Silence,1000;','',''); +REPLACE INTO `item_db` VALUES ('13086','Goldsmithing_Dagger','Goldsmithing Dagger','4','20','10','500','35','25','0','1','0','41943142','56','2','2','1','0',NULL,'1','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('13092','RWC_Memory_Knife','RWC Memory Knife','4','1000','500','650','50','0','0','1','1','41943157','1','2','2','3','0',NULL,'1','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,20*(getrefine()/3); bonus bMatk,20*(getrefine()/3); if(getrefine()>=9) { .@val = 1; bonus4 bAutoSpell,BS_WEAPONPERFECT,1,20,0; } if (getrefine() >= 6) { .@rate = 5*(.@val+1); bonus2 bAddRace, RC_All, .@rate; bonus2 bMagicAddRace, RC_All, .@rate; }','',''); REPLACE INTO `item_db` VALUES ('13093','Thanatos_Dagger','Thanatos Dagger','4','20','10','800','100','130','0','1','1','941290','56','2','2','4','120',NULL,'1','1','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 ('13094','Evil_Slayer_Stabber_Dagger','Evil Slayer Stabber Dagger','4','20','10','900','120','0','0','1','1','41943157','56','2','2','3','100',NULL,'1','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Demon,10; bonus2 bAddRace,RC_Undead,10; if(getrefine()>=9) { bonus bAtkRate,5; } if(getrefine()>=12) { bonus bAtkRate,7; }','',''); @@ -6972,6 +6979,7 @@ REPLACE INTO `item_db` VALUES ('13433','Academy_Sword','Academy Sword','4','0',' REPLACE INTO `item_db` VALUES ('13434','P_Saber3','Eden Group Saber III','4','0','0','0','185','0','0','1','0','414946','63','2','2','3','60',NULL,'0','2','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('13438','Magical_Blade','Magical Blade','4','60000','30000','2000','165','110','0','1','2','414947','63','2','2','4','105',NULL,'1','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('13439','TE_Woe_Sword','TE Woe Sword','4','0','0','0','120','100','0','1','0','414947','63','2','2','3','40',NULL,'0','2','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 ('13440','Ceremonial_Sword','Ceremonial Sword','4','20','10','500','60','0','0','0','0','414947','56','2','2','1','0',NULL,'1','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Holy;','',''); REPLACE INTO `item_db` VALUES ('13442','Old_Parasol','Old Parasol','4','20','10','500','120','80','0','0','3','414946','63','2','2','3','80',NULL,'1','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMatk,getrefine(); skill MG_SOULSTRIKE,10;','',''); REPLACE INTO `item_db` VALUES ('13444','Pala','Pala','4','20','10','700','190','0','0','0','1','414946','63','2','2','3','0',NULL,'1','2','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,8;','',''); REPLACE INTO `item_db` VALUES ('13454','Crimson_Saber','Crimson Saber','4','20','10','850','85','0','0','1','2','414947','63','2','2','3','70',NULL,'1','2','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); }','',''); @@ -8008,6 +8016,7 @@ REPLACE INTO `item_db` VALUES ('15061','Egir_Armor','Aegir Armor','5','200000',' REPLACE INTO `item_db` VALUES ('15062','TE_Woe_Coat','TE Woe Coat','5','0','0','0','0','0','15','0','0','18446744073709551615','63','2','16','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,15; bonus bMaxHP,250; bonus bMaxSP,250; bonus2 bSubRace,RC_Player,10; bonus2 bResEff,Eff_Freeze,25; bonus bUnbreakableArmor,0;','',''); REPLACE INTO `item_db` VALUES ('15063','TE_Woe_Chain_Mail','TE Woe Chain Mail','5','0','0','0','0','0','25','0','0','279714','63','2','16','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus bMaxHP,450; bonus bMaxSP,50; bonus2 bSubRace,RC_Player,15; bonus2 bResEff,Eff_Freeze,25; bonus bUnbreakableArmor,0;','',''); REPLACE INTO `item_db` VALUES ('15064','TE_Woe_Mage_Coat','TE Woe Mage Coat','5','0','0','0','0','0','5','0','0','8487701','63','2','16','0','40',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,25; bonus bMaxHP,200; bonus bMaxSP,200; bonus2 bSubRace,RC_Player,5; bonus2 bResEff,Eff_Freeze,25; bonus bUnbreakableArmor,0;','',''); +REPLACE INTO `item_db` VALUES ('15066','Engraved_Armor','Engraved Armor','5','0','0','3000','0','0','120','0','1','16514','56','2','16','0','150',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,25;','',''); REPLACE INTO `item_db` VALUES ('15067','Rune_Suit','Rune Suit','5','0','0','0','0','0','0','0','0','18446744073709551615','63','2','16','0','1','100','0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bExpAddRace,RC_All,10;','',''); REPLACE INTO `item_db` VALUES ('15068','Adv_Angel\'s_Protection','Advanced Angelic Protection','5','10000','5000','600','0','0','40','0','1','1','47','2','16','0','99',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,30;','',''); REPLACE INTO `item_db` VALUES ('15073','Anti-Magic_Suit','Anti-Magic Suit','5','20','10','1500','0','0','50','0','1','18446744073709551615','63','2','16','0','99',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,5; bonus bMdef,10; if (getrefine()>6) { bonus bMdef,5; } if (getrefine()>8) { bonus bMaxHPrate,2; }','',''); -- cgit v1.2.3-70-g09d2