ItemDB SQL Sync

Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>

1 files changed, 14 insertions, 14 deletions

diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 5ae7fabdb..b3c602741 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -229,8 +229,8 @@ REPLACE INTO `item_db` VALUES ('674','Mithril_Coin','Mithril Coin','3','5000','2
 REPLACE INTO `item_db` VALUES ('675','Silver_Coin','Silver Roulette Coin','2','0','0','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','TmpRouletteSilver += 1;','','');
 REPLACE INTO `item_db` VALUES ('676','Silver_Coin_Moneybag','Bag of Silver Coins','3','50000','25000','400','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('677','White_Gold_Coin','Platinum Coin','3','2000','1000','40','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('678','Poison_Bottle','Poison Bottle','2','5000','2500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if(Class == Job_Assassin_Cross || Class == Job_Guillotine_Cross || Class == Job_Guillotine_Cross_T) { sc_start SC_DPOISON,60000,0; sc_start SC_ATTHASTE_INFINITY,60000,9; } else percentheal -100,-100;','','');
-REPLACE INTO `item_db` VALUES ('679','Gold_Pill','Pilule','2','5000','2500','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_DPOISON,10000,0,1000,SCFLAG_NONE; sc_start SC_POISON,50000,0;','','');
+REPLACE INTO `item_db` VALUES ('678','Poison_Bottle','Poison Bottle','2','5000','2500','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if (Class == Job_Assassin_Cross || Class == Job_Guillotine_Cross || Class == Job_Guillotine_Cross_T) { sc_start SC_DPOISON, 60000, 0; sc_start SC_ATTHASTE_INFINITY, 60000, 9; } else { percentheal -100, -100; }','','');
+REPLACE INTO `item_db` VALUES ('679','Gold_Pill','Pilule','2','5000','2500','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 50, 50;','','');
 REPLACE INTO `item_db` VALUES ('680','Magical_Carnation','Magic Carnation','0','0','0','1000','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','percentheal 0,20;','','');
 REPLACE INTO `item_db` VALUES ('681','Memory_Of_Wedding','Sweet Memory of Marriage','2','50000','25000','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','if (getpartnerid()) sc_start SC_WEDDING,600000,0;','','');
 REPLACE INTO `item_db` VALUES ('682','Realgar_Wine','Distilled Fighting Spirit','2','0','0','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','1','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_PLUSATTACKPOWER,60000,30;','','');
@@ -1634,7 +1634,7 @@ REPLACE INTO `item_db` VALUES ('2491','Bangungot_Boots','Bangungot Boots of Nigh
 REPLACE INTO `item_db` VALUES ('2492','Bayani_Bangungot_Boots','Bangungot Boots(Bayani)','5','20','10','600','0','0','10','0','1','4294967295','63','2','64','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,getrefine(); if(getrefine()>=12) { bonus bSpeedRate,25; }','','');
 REPLACE INTO `item_db` VALUES ('2493','Goibne\'s_Combat_Boots_','Goibne\'s Greaves','5','30000','15000','700','0','0','13','0','1','2147483646','63','2','64','0','54',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus bMaxHPrate,5; bonus bMaxSPrate,5;','','');
 REPLACE INTO `item_db` VALUES ('2494','Chrystal_Pumps_','Crystal Pumps','5','20','10','100','0','0','5','0','1','2147483646','63','0','64','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10; bonus bLuk,5;','','');
-REPLACE INTO `item_db` VALUES ('2495','Egir_Shoes','Aegir Shoes','5','200000','100000','300','0','0','13','0','1','4294967295','63','2','64','0','110',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(BaseClass==Job_Mage||BaseClass==Job_Archer||BaseClass==Job_Acolyte) bonus bMaxHP,BaseLevel*5; else if(BaseClass==Job_Swordman||BaseClass==Job_Merchant||BaseClass==Job_Thief) bonus bMaxSP,JobLevel*2;','','');
+REPLACE INTO `item_db` VALUES ('2495','Egir_Shoes','Aegir Shoes','5','200000','100000','300','0','0','13','0','1','4294967295','63','2','64','0','110',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if (BaseClass == Job_Mage || BaseClass == Job_Archer || BaseClass == Job_Acolyte) bonus bMaxHP, BaseLevel * 5; else if (BaseClass == Job_Swordman || BaseClass == Job_Merchant || BaseClass == Job_Thief) bonus bMaxSP, JobLevel * 2;','','');
 REPLACE INTO `item_db` VALUES ('2496','TE_WoE_Shoes','TE WoE Shoes','5','20','10','0','0','0','5','0','0','4294967295','63','2','64','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,150; bonus bMaxSP,150; bonus2 bAddRace,RC_Player,5; bonus2 bMagicAddRace,RC_Player,5; bonus2 bResEff,Eff_Freeze,2500;','','');
 REPLACE INTO `item_db` VALUES ('2497','TE_WoE_Boots','TE WoE Boots','5','20','10','0','0','0','10','0','0','16514','63','2','64','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,200; bonus bMaxSP,100; bonus2 bAddRace,RC_Player,10; bonus2 bResEff,Eff_Freeze,2500;','','');
 REPLACE INTO `item_db` VALUES ('2498','TE_WoE_Magic_Sandals','TE WoE Magic Sandals','5','20','10','0','0','0','5','0','0','8487701','63','2','64','0','40',NULL,'0','0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus bMaxHP,100; bonus bMaxSP,200; bonus2 bMagicAddRace,RC_Player,5; bonus2 bResEff,Eff_Freeze,2500;','','');
@@ -5561,8 +5561,8 @@ REPLACE INTO `item_db` VALUES ('11532','Nasi_Goreng','Nasi Goreng','0','15','7',
 REPLACE INTO `item_db` VALUES ('11533','Satay','Satay','0','15','7','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(17,23),0;','','');
 REPLACE INTO `item_db` VALUES ('11534','Coco_Juice','Coconut Juice','0','20','10','50','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(17,23),0;','','');
 REPLACE INTO `item_db` VALUES ('11535','Almond_Chocolate','Almond Chocolate','0','190','95','200','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 0,rand(8,16);','','');
-REPLACE INTO `item_db` VALUES ('11536','Cat_Hard_Biscuit','Cat\'s Ship Biscuit','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(70,110),0;','','');
-REPLACE INTO `item_db` VALUES ('11537','Rice_weevil_Bug','Weevil Bug Worm','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(100,150),0;','','');
+REPLACE INTO `item_db` VALUES ('11536','Cat_Hard_Biscuit','Cat\'s Ship Biscuit','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','.@temp = rand(1,4); if (.@temp == 1) { heal -100, 0; } else if (.@temp == 2) { showscript \"Huuph...! Yucky..! Wa, Water...!!\"; sc_start SC_STUN, 3000, 0, 50000, SCFLAG_NONE; } else if (.@temp == 3) { showscript \"Yeeyuck...!! This is rotten!!\"; sc_start SC_POISON, 50000, 0; } else { specialeffect2 EF_HIT4; showscript \"Arrrrrgggg...!! Bu, Bu, Bugggggg!!!!!\"; getitem Rice_weevil_Bug, 1; }','','');
+REPLACE INTO `item_db` VALUES ('11537','Rice_weevil_Bug','Weevil Bug Worm','0','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','.@temp = rand(1,6); if (.@temp == 1) { specialeffect2 EF_POISONHIT; showscript \"Errrgg!!! This is so.. bitter....!!\"; heal 0,-50; } else if (.@temp == 2) { specialeffect2 EF_HEAL; showscript \"....Well at least this is good for my health though.\"; percentheal 15,0; } else if (.@temp == 3) { specialeffect2 EF_POISONHIT; showscript \"Phewphew!! Arg.... Is this poisoned or what?!\"; heal 0,-100; } else if (.@temp == 4) { specialeffect2 EF_POISONHIT; showscript \"Whasdfhwkljhrtklwert....!!\"; heal 0,-200; } else if (.@temp == 5) { specialeffect2 EF_HEAL; showscript \"It\'s ok, no one sew me yet..\"; percentheal 10,0; } else { specialeffect2 EF_HEAL; showscript \"I really need something to eat... ?? Sorry, little buggy.\"; percentheal 5,0; }','','');
 REPLACE INTO `item_db` VALUES ('11538','Octupus_Leg','Fresh Octopus Legs','0','20','10','30','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal rand(35,60),rand(5,10);','','');
 REPLACE INTO `item_db` VALUES ('11539','Athale_Choco','Handmade Chocolate','0','1','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 50,50;','','');
 REPLACE INTO `item_db` VALUES ('11540','Shyai_Choco','Handmade Chocolate','0','1','0','80','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','itemheal 50,50;','','');
@@ -7738,7 +7738,7 @@ REPLACE INTO `item_db` VALUES ('14609','Spoiled_Cuisine','Spoiled Cuisine','2','
 REPLACE INTO `item_db` VALUES ('14611','M_Def_Potion','M Def Potion','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('14612','M_Mdef_Potion','M Mdef Potion','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('14613','RWC_Scroll_2012','RWC Arms Box','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('14614','Ex_Def_Potion','Special Defense Potion','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('14614','Ex_Def_Potion','Special Defense Potion','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','specialeffect2 EF_GUARD; sc_start SC_PROTECT_DEF, 1800000, 1; sc_start SC_PROTECT_MDEF, 1800000, 1;','','');
 REPLACE INTO `item_db` VALUES ('14616','STR_Biscuit_Stick','Bar of Strength','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_STR,180000,15; sc_start SC_PLUSATTACKPOWER,60000,rand(11,111);','','');
 REPLACE INTO `item_db` VALUES ('14617','VIT_Biscuit_Stick','Bar of Fitness','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_VIT,180000,15; percentheal rand(11,33),0;','','');
 REPLACE INTO `item_db` VALUES ('14618','AGI_Biscuit_Stick','Bar of Agility','11','0','0','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_AGI,180000,15; sc_start SC_FOOD_BASICAVOIDANCE,60000,rand(11,33);','','');
@@ -7807,7 +7807,7 @@ REPLACE INTO `item_db` VALUES ('15057','Pure_White_Apron','White Apron','5','20'
 REPLACE INTO `item_db` VALUES ('15058','Rider_Suit','Rider Suit','5','20','10','1000','0','0','40','0','1','1040382','58','2','16','0','55',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1;','','');
 REPLACE INTO `item_db` VALUES ('15059','2011Love_Daddy','2011Love Daddy','5','20','10','100','0','0','80','0','1','4294967295','63','2','16','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('15060','Sky_Blue_Smock','Sky-Blue Smock','5','20','10','300','0','0','1','0','1','4294967295','63','2','16','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('15061','Egir_Armor','Aegir Armor','5','200000','100000','2600','0','0','55','0','1','4294967295','63','2','16','0','110',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bVit,1; bonus bDex,1; bonus bAgi,1; bonus bLuk,1; bonus bUnbreakableArmor,0;','','');
+REPLACE INTO `item_db` VALUES ('15061','Egir_Armor','Aegir Armor','5','200000','100000','2600','0','0','55','0','1','4294967295','63','2','16','0','110',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats, 1; if (BaseClass == Job_Mage || BaseClass == Job_Archer || BaseClass == Job_Acolyte) bonus2 bResEff, Eff_Silence, 5000; else if (BaseClass == Job_Swordman || BaseClass == Job_Merchant || BaseClass == Job_Thief) bonus2 bResEff, Eff_Stun, 5000; bonus bUnbreakableArmor, 0;','','');
 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','4294967295','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; }','','');
 REPLACE INTO `item_db` VALUES ('15074','Geffen_Magic_Robe','Geffen Magic Robe','5','20','10','1000','0','0','40','0','1','4294967295','63','2','16','0','99',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUseSPrate,-10; bonus bVariableCastrate,15; bonus bNoCastCancel,0; if (getrefine()>6) { bonus bUseSPrate,-5; } if (getrefine()>8) { bonus bVariableCastrate,-5; }','','');
@@ -7818,7 +7818,7 @@ REPLACE INTO `item_db` VALUES ('15116','Armor_Of_Airship','Armor Of Airship','5'
 REPLACE INTO `item_db` VALUES ('15117','Tarlock\'s_Armor','Tarlock\'s Armor','5','20','10','750','0','0','70','0','0','4294967295','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 ('15128','Excellion_Suit','Excellion Suit','5','20','10','1000','0','0','100','0','0','4294967295','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 ('15138','Aegir_Armor','Aegir Armor','5','20','10','1600','0','0','25','0','0','4294967295','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;','','');
+REPLACE INTO `item_db` VALUES ('15138','Egir_Armor_K','Aegir Armor','5','200000','100000','1600','0','0','25','0','1','4294967295','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 ('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;','','');
@@ -8461,7 +8461,7 @@ REPLACE INTO `item_db` VALUES ('18724','Baphomet_Horns','Baphomet Horns','5','0'
 REPLACE INTO `item_db` VALUES ('18725','Rabbit_Knithat','Rabbit Knit Hat','5','1000','500','10','0','0','0','0','1','4294967295','63','2','256','0','0',NULL,'1','867','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('18726','Skymet','Skymet','5','1000','500','10','0','0','0','0','1','4294967295','63','2','256','0','0',NULL,'1','868','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('18727','Sedora_Hat','Sedora Hat','5','20','10','300','0','0','13','0','1','4294967295','63','2','256','0','10',NULL,'1','869','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db` VALUES ('18728','Egir_Helm','Aegir Helm','5','200000','100000','800','0','0','10','0','1','4294967295','63','2','256','0','110',NULL,'1','870','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,5; bonus bUnbreakableHelm,0;','','');
+REPLACE INTO `item_db` VALUES ('18728','Egir_Helm','Aegir Helm','5','200000','100000','800','0','0','10','0','1','4294967295','63','2','256','0','110',NULL,'1','870','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef, 5; bonus bUnbreakableHelm, 0;','','');
 REPLACE INTO `item_db` VALUES ('18729','MVP_Basketball','MVP Basketball Hat','5','20','10','150','0','0','6','0','1','4294967295','63','2','256','0','0',NULL,'1','871','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_DemiPlayer,10; bonus2 bAddItemHealRate,522,30; bonus bVariableCastrate,-3; if(getrefine()>=12) { bonus bVariableCastrate,-1; } if(getrefine()>=14) { bonus bVariableCastrate,-1; }','','');
 REPLACE INTO `item_db` VALUES ('18730','Criatura_Academy_Hat','Criatura Hat','5','100','50','200','0','0','2','0','1','4294967295','63','2','256','0','0',NULL,'1','872','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSP,5; bonus bMaxHP,15;','','');
 REPLACE INTO `item_db` VALUES ('18731','Valkyrie_Headgear','Valkyrie Helm','5','1000','500','0','0','0','0','0','0','4294967295','63','2','256','0','0',NULL,'1','225','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -8640,7 +8640,7 @@ REPLACE INTO `item_db` VALUES ('19021','Gigant_Helm','Gigant Helm','5','20','10'
 REPLACE INTO `item_db` VALUES ('19023','Queen_Scaraba_Crown','Queen Scaraba Crown','5','0','0','1500','0','0','0','0','1','4294967295','63','2','257','0','70',NULL,'1','1231','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDefRate,-50; bonus bMdefRate,-50; bonus2 bSubRace,RC_Insect,getrefine(); bonus3 bAutoSpell,NPC_WIDECONFUSE,2,100+(getrefine()*10); /* Custom - JRO */','','');
 REPLACE INTO `item_db` VALUES ('19024','Protect_Feathers','Protect Feathers','5','20','10','500','0','0','0','0','0','4294967295','63','2','512','0','70',NULL,'0','1232','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,2; bonus2 bAddRaceTolerance,RC_DemiPlayer,2; bonus bAspdRate,-5; if(readparam(bVit)>=108) { bonus bAspdRate,-5; bonus2 bAddRaceTolerance,RC_DemiPlayer,2; } if(readparam(bVit)>=120) { bonus bMdef,3; bonus bMaxHPrate,3; }','','');
 REPLACE INTO `item_db` VALUES ('19025','Puppy_Ears_Hat_','Puppy Ears Hat','5','0','0','200','0','0','3','0','1','4294967295','63','2','256','0','10',NULL,'1','827','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus2 bMagicAddRace,RC_Brute,5; bonus2 bAddRace,RC_Brute,5; bonus2 bAddRaceTolerance,RC_Brute,5; bonus3 bAddMonsterDropItem,7938,RC_Brute,100;','','');
-REPLACE INTO `item_db` VALUES ('19026','Aegir_Helm_','Aegir Helm','5','0','0','800','0','0','10','0','1','4294967295','63','2','256','0','110',NULL,'1','870','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db` VALUES ('19026','Egir_Helm_K','Aegir Helm','5','200000','100000','800','0','0','10','0','1','4294967295','63','2','256','0','110',NULL,'1','870','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit, 3; bonus bUnbreakableHelm, 0;','','');
 REPLACE INTO `item_db` VALUES ('19027','Type_10_Glasses','Type-10 Glasses','5','0','0','200','0','0','0','0','0','4294967295','63','2','512','0','10',NULL,'1','1237','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bMagicAddRace,RC_Brute,4; bonus2 bAddRaceTolerance,RC_Brute,5;','','');
 REPLACE INTO `item_db` VALUES ('19028','Devils_Minion','Devil\'s Minion','5','0','0','200','0','0','0','0','0','4294967295','63','2','512','0','40',NULL,'1','1036','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill AM_POTIONPITCHER,3;','','');
 REPLACE INTO `item_db` VALUES ('19029','Alice_Friesinger_Hat_69','Alice Friesinger Hat 69','5','0','0','300','0','0','0','0','0','4294967295','63','2','256','0','0',NULL,'1','1249','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_Boss,15;','','');
@@ -9431,7 +9431,7 @@ REPLACE INTO `item_db` VALUES ('20332','C_Pure_White_Ribbon','Costume Pure White
 REPLACE INTO `item_db` VALUES ('20333','C_Family_Hat','Costume Family Hat','5','0','0','0','0','0','0','0','0','4294967295','63','2','1024','0','0',NULL,'1','650','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20500','T_Archangel_Wing','T Archangel\'s Wings','5','0','0','100','0','0','0','0','0','4294967295','63','2','8192','0','0',NULL,'0','1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0;','','');
 REPLACE INTO `item_db` VALUES ('20600','Fantastic_Aura','Fantastic Aura','5','0','0','0','0','0','0','0','0','4294967295','63','2','16384','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0;','','');
-REPLACE INTO `item_db` VALUES ('20700','Egir_Manteau','Aegir Mantle','5','200000','100000','300','0','0','10','0','1','4294967295','63','2','4','0','110',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableGarment,0; bonus bUnbreakableHelm,0;','','');
+REPLACE INTO `item_db` VALUES ('20700','Egir_Manteau','Aegir Mantle','5','200000','100000','300','0','0','10','0','1','4294967295','63','2','4','0','110',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableGarment, 0; if (BaseClass == Job_Mage || BaseClass == Job_Archer || BaseClass == Job_Acolyte) bonus bFlee2, 5 + (getequiprefinerycnt(EQI_GARMENT) * 2); else if (BaseClass == Job_Swordman || BaseClass == Job_Merchant || BaseClass == Job_Thief) bonus bShortWeaponDamageReturn, 5 + (getequiprefinerycnt(EQI_GARMENT) * 2);','','');
 REPLACE INTO `item_db` VALUES ('20706','Amistr_Bag','Amistr Bag','5','0','0','500','0','0','18','0','0','4294967295','63','2','4','0','0',NULL,'1','4','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,1; bonus2 bSubEle,Ele_Neutral,5; bonus2 bSubEle,Ele_Water,5; bonus2 bSubEle,Ele_Earth,5; bonus2 bSubEle,Ele_Fire,5; bonus2 bSubEle,Ele_Wind,5; bonus2 bSubEle,Ele_Poison,5; bonus2 bSubEle,Ele_Holy,5; bonus2 bSubEle,Ele_Dark,5; bonus2 bSubEle,Ele_Ghost,5; bonus2 bSubEle,Ele_Undead,5;','','');
 REPLACE INTO `item_db` VALUES ('20707','Kirin_Wing','Kirin Wing','5','20','10','0','0','0','18','0','0','4294967295','63','2','4','0','0',NULL,'1','6','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bVit,1; bonus bDex,1; bonus bAgi,1; bonus bLuk,1;','','');
 REPLACE INTO `item_db` VALUES ('20710','Modified_Angel\'s_Cardigan','Modified Angel\'s Cardigan','5','20','10','400','0','0','6','0','1','1','47','2','4','0','99',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHPrecovRate,50;','','');
@@ -9451,7 +9451,7 @@ REPLACE INTO `item_db` VALUES ('20744','Tarlock\'s_Manteau','Tarlock\'s Manteau'
 REPLACE INTO `item_db` VALUES ('20746','C_Rudra_Wings','Costume Rudra Wings','5','0','0','0','0','0','0','0','0','4294967295','63','2','8192','0','0',NULL,'1','8','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('20748','Manteau_of_The_Fallen','Manteau of The Fallen','5','20','10','600','0','0','20','0','0','4294967295','63','2','4','0','120',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,5; bonus bFlee,10; if(readparam(bStr)>=90) { bonus bBaseAtk,10+(getrefine()*2); } if(readparam(bInt)>=90) { bonus bMatk,20+(getrefine()*3); } if(readparam(bVit)>=90) { bonus2 bSubEle,Ele_Neutral,3+((getrefine()>=8)?3:0)+((getrefine()>=10)?4:0); } if(readparam(bDex)>=90) { bonus bLongAtkRate,3+(getrefine()/2); } if(readparam(bLuk)>=90) { bonus bCriticalRate,5+getrefine(); } if(readparam(bAgi)>=90) { bonus bAspdRate,3+(getrefine()/2); bonus bAspd,((getrefine()>=10)?1:0); }','','');
 REPLACE INTO `item_db` VALUES ('20749','Manteau_of_The_Fallen_','Manteau of The Fallen','5','20','10','600','0','0','30','0','1','4294967295','63','2','4','0','170',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,5; bonus bFlee,10; bonus bMaxHPrate,getrefine()/2; bonus bMaxSPrate,getrefine()/2; if(readparam(bStr)>=90) { bonus bBaseAtk,10+(getrefine()*2); } if(readparam(bInt)>=90) { bonus bMatk,20+(getrefine()*3); } if(readparam(bVit)>=90) { bonus2 bSubEle,Ele_Neutral,3+((getrefine()>=8)?3:0)+((getrefine()>=10)?4:0); } if(readparam(bDex)>=90) { bonus bLongAtkRate,3+(getrefine()/2); } if(readparam(bLuk)>=90) { bonus bCriticalRate,5+getrefine(); } if(readparam(bAgi)>=90) { bonus bAspdRate,3+(getrefine()/2); bonus bAspd,((getrefine()>=10)?1:0); }','','');
-REPLACE INTO `item_db` VALUES ('20756','Aegir_Cloak','Aegir Cloak','5','20','10','300','0','0','10','0','0','4294967295','63','2','4','0','40',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableGarment,1; bonus bMaxHP,500; bonus bMaxSP,50;','','');
+REPLACE INTO `item_db` VALUES ('20756','Egir_Manteau_K','Aegir Cloak','5','200000','100000','300','0','0','10','0','1','4294967295','63','2','4','0','40',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP, 500; bonus bMaxSP, 50; bonus bUnbreakableGarment, 0;','','');
 REPLACE INTO `item_db` VALUES ('20757','Heavenly_Wings1','Heavenly Wings1','5','0','0','0','0','0','10','0','1','4294967295','63','2','4','0','0',NULL,'1','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,3; skill AL_INCAGI,3;','','');
 REPLACE INTO `item_db` VALUES ('20758','Heavenly_Wings2','Heavenly Wings2','5','0','0','0','0','0','10','0','1','4294967295','63','2','4','0','0',NULL,'1','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAllStats,3; skill AL_INCAGI,3;','','');
 REPLACE INTO `item_db` VALUES ('20761','C_Wing_of_Happiness','Costume Wing of Happiness','5','0','0','0','0','0','0','0','0','4294967295','63','2','8192','0','0',NULL,'1','9','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
@@ -9513,13 +9513,13 @@ REPLACE INTO `item_db` VALUES ('22044','Reinforced_Parts_Booster','Reinforced Pa
 REPLACE INTO `item_db` VALUES ('22045','Beach_Sandals','Summer Sandals','5','10','5','200','0','0','5','0','0','4294967295','63','2','64','0','0',NULL,'1','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bFlee,5; bonus3 bAutoSpellWhenHit,AL_INCAGI,10,300;','','');
 REPLACE INTO `item_db` VALUES ('22046','Boots_of_Airship','Boots of Airship','5','20','10','0','0','0','26','0','0','4294967295','63','2','64','0','125',NULL,'0','0','0','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bAspdRate,10;','','');
 REPLACE INTO `item_db` VALUES ('22047','Tarlock\'s_Boots','Tarlock\'s Boots','5','20','10','250','0','0','13','0','0','4294967295','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_','Egir Shoes','5','20','10','300','0','0','13','0','0','4294967295','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 ('22059','Egir_Shoes_K','Egir Shoes','5','200000','100000','300','0','0','13','0','1','4294967295','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','2147483646','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,0; autobonus3 \"{ }\",1000,7000,ALL_CATCRY,\"{ montransform 1505,420000; }\";','','');
 REPLACE INTO `item_db` VALUES ('22514','Candy_Holder','Candy Holder','11','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('22515','Twisted_Key_of_Time','Twisted Key of Time','3','10','5','300','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db` VALUES ('22540','Runstone_Lux','Lux Anima Rune','11','2','1','100','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','60000','475',NULL,'0',NULL,'20','1','0','itemskill RK_LUXANIMA,1;','','');
 REPLACE INTO `item_db` VALUES ('22669','HALLOWEEN_G_BOX','Halloween Box','2','0','0','20','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getrandgroupitem 22669,1;','','');
-REPLACE INTO `item_db` VALUES ('22670','DARK_INVITATION','Invitation of Darkness','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','.@r = rand(1,3); if (.@r == 1) { specialeffect2 EF_DEVIL; warp \"niflheim\",193,186; } else if (.@r == 2) { heal -500,-1000; sc_start SC_STUN,3000,0; } else { specialeffect2 EF_DEVIL; warp \"niflheim\",347,255; }','','');
+REPLACE INTO `item_db` VALUES ('22670','DARK_INVITATION','Invitation of Darkness','2','10','5','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','.@temp = rand(1,3); if (.@temp == 1) { specialeffect2 EF_DEVIL; warp \"niflheim\",193,186; } else if (.@temp == 2) { specialeffect2 EF_DEVIL; warp \"niflheim\",106,254; } else { specialeffect2 EF_DEVIL; warp \"niflheim\",347,255; }','','');
 REPLACE INTO `item_db` VALUES ('22675','Mysterious_Scroll','Mysterious Scroll','2','20','10','10','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','sc_start SC_FOOD_INT,3600000,30;','','');
 REPLACE INTO `item_db` VALUES ('22676','Hangul_Day_Event_Box','Hangul Day Event Box','2','20','10','0','0','0','0','0','0','4294967295','63','2','0','0','0',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','getitem 22675,10; getitem 607,9;','','');
 REPLACE INTO `item_db` VALUES ('22679','Death_Bin','Death Bin','18','10','5','0','0','0','0','0','0','4294967295','63','2','0','0','170',NULL,'0','0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');