ItemDB SQL Sync

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

1 files changed, 7 insertions, 7 deletions

diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql
index 4d1d8de97..90643a6bf 100644
--- a/sql-files/item_db_re.sql
+++ b/sql-files/item_db_re.sql
@@ -815,13 +815,13 @@ REPLACE INTO `item_db_re` VALUES ('1480','Gae_Bolg_','Gae Bolg','4','20','10','2
 REPLACE INTO `item_db_re` VALUES ('1481','Zephyrus_','Zephyrus','4','20','10','2000','170','0','0','3','3','16514','63','2','34','4','48',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAtkEle,Ele_Wind; bonus2 bAddEff,Eff_Silence,200; bonus3 bAutoSpell,MG_THUNDERSTORM,3,100;','','');
 REPLACE INTO `item_db_re` VALUES ('1482','BF_Lance1','Assaulter Lance','4','20','10','0','160','0','0','3','0','16514','63','2','34','3','80',NULL,'1','5','0','0','0','467',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus2 bAddRace,RC_DemiHuman,25; bonus bIgnoreDefRace,RC_DemiHuman; bonus bUnbreakableWeapon,0;','','');
 REPLACE INTO `item_db_re` VALUES ('1483','Ivory_Lance','Ivory Lance','4','20','10','1000','160','0','0','3','1','16514','58','2','34','3','50',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,2; bonus bAspdRate,3; bonus2 bAddEff,Eff_Bleeding,300; bonus3 bAutoSpell,NPC_CRITICALWOUND,1,30; skill KN_SPEARSTAB,5;','','');
-REPLACE INTO `item_db_re` VALUES ('1484','Cardo','Cardo','4','20','10','5600','150','0','0','3','1','16512','58','2','34','4','70',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,-10; bonus bDef,getrefine()/2;','','');
+REPLACE INTO `item_db_re` VALUES ('1484','Cardo','Cardo','4','20','10','5600','150','0','0','3','1','128','58','2','34','4','70',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspdRate,-10; bonus bDef,getrefine()/2;','','');
 REPLACE INTO `item_db_re` VALUES ('1485','Battle_Fork','Battle Fork','4','20','10','700','112','0','0','3','4','16514','58','2','34','2','50',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db_re` VALUES ('1486','Krieger_Twohand_Spear1','Glorious Lance','4','20','10','0','220','0','0','3','0','16514','63','2','34','4','80',NULL,'1','5','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,70; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) { bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2); bonus2 bIgnoreDefRate,RC_DemiHuman,5; } if(getrefine()>8) { if(BaseJob==Job_Knight) bonus4 bAutoSpellOnSkill,KN_PIERCE,NPC_CRITICALWOUND,2,200; else if(BaseJob==Job_Crusader) bonus3 bAutoSpell,PA_PRESSURE,5,200; }','','');
 REPLACE INTO `item_db_re` VALUES ('1487','Lance_C','Lance','4','0','0','0','220','0','0','3','0','16514','63','2','34','3','0',NULL,'0','5','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus2 bAddSize,Size_Small,50; bonus2 bAddSize,Size_Medium,50; bonus2 bAddSize,Size_Large,50;','','');
 REPLACE INTO `item_db_re` VALUES ('1488','Ahlspiess_C','Ahlspiess','4','20','10','0','135','0','0','3','0','16512','63','2','34','4','0',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bIgnoreDefRace,RC_NonBoss; bonus bIgnoreDefRace,RC_Boss; bonus2 bAddRace,RC_DemiHuman,10; bonus3 bAutoSpell,KN_PIERCE,5,30;','','');
 REPLACE INTO `item_db_re` VALUES ('1489','Spearfish_','Marlin','4','0','0','0','220','0','0','3','0','16514','63','2','34','1','50',NULL,'0','5','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableWeapon,0; bonus3 bAddEffOnSkill,KN_PIERCE,Eff_Bleeding,1000; bonus3 bAddEffOnSkill,LK_SPIRALPIERCE,Eff_Bleeding,1000; bonus2 bSkillAtk,LK_SPIRALPIERCE,100; bonus2 bSkillAtk,LG_INSPIRATION,50; if(BaseLevel>99) { bonus bBaseAtk,30; }','','');
-REPLACE INTO `item_db_re` VALUES ('1490','Giant_Lance','Giant Lance','4','20','10','20000','20','0','0','3','0','16512','56','2','34','4','140',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,-10; bonus2 bSkillCooldown,LK_SPIRALPIERCE,20000; if(readparam(bStr)>=120) { bonus bBaseAtk,300; }','','heal 0,-600;');
+REPLACE INTO `item_db_re` VALUES ('1490','Giant_Lance','Giant Lance','4','20','10','20000','20','0','0','3','0','128','56','2','34','4','140',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAspd,-10; bonus2 bSkillCooldown,LK_SPIRALPIERCE,20000; if(readparam(bStr)>=120) { bonus bBaseAtk,300; }','','heal 0,-600;');
 REPLACE INTO `item_db_re` VALUES ('1491','Upg_Lance','Upgrade Spear','4','20','10','1500','105','0','0','3','1','16514','63','2','34','3','0',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*12); if(BaseLevel>70) bonus bBaseAtk,(((BaseLevel-70)/10)*10);','','');
 REPLACE INTO `item_db_re` VALUES ('1492','Velum_Glaive','Vellum Glaive','4','20','10','4500','250','0','0','3','0','16514','63','2','34','4','95',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,80; if(getrefine()>=6) { bonus2 bSkillAtk,LK_SPIRALPIERCE,100; bonus2 bSkillAtk,KN_SPEARBOOMERANG,50; } if(getrefine()>=9) { autobonus2 \"{ bonus bShortWeaponDamageReturn,20; bonus bMagicDamageReturn,20; }\",100,2000,BF_WEAPON|BF_MAGIC,\"{ specialeffect2 EF_REFLECTSHIELD; }\"; }','','');
 REPLACE INTO `item_db_re` VALUES ('1493','Metal_Lance','Metal Lance','4','20','10','0','100','0','0','3','1','16514','63','2','34','3','0',NULL,'1','5','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,(getrefine()*6); set .@i,((BaseLevel/10)>12)?12:(BaseLevel/10); if(.@i>2) bonus bBaseAtk,((.@i-2)*5);','','');
@@ -1212,7 +1212,7 @@ REPLACE INTO `item_db_re` VALUES ('2136','Cracked_Buckler','Cracked Buckler','5'
 REPLACE INTO `item_db_re` VALUES ('2137','Valkyrja\'s_Shield_C','Neo Valkyrja\'s Shield','5','0','0','0','0','0','110','0','0','1040382','58','2','32','0','95',NULL,'0','4','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Water,20; bonus2 bSubEle,Ele_Fire,20; bonus2 bSubEle,Ele_Dark,20; bonus2 bSubEle,Ele_Undead,20; bonus bMdef,5;','','');
 REPLACE INTO `item_db_re` VALUES ('2138','Bradium_Shield','Bradium Shield','5','20','10','1800','0','0','98','0','1','1040256','58','2','32','0','65',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSkillAtk,CR_SHIELDBOOMERANG,60; bonus bAgi,-1; bonus bMaxHP,500;','','');
 REPLACE INTO `item_db_re` VALUES ('2139','Flame_Thrower','Flame Thrower','5','20000','10000','2000','0','0','60','0','0','1024','56','2','32','0','99',NULL,'0','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db_re` VALUES ('2140','Energy_Rune_Guard','Energy Rune Guard','5','20','10','0','0','0','70','0','1','16512','56','2','32','0','99',NULL,'1','4','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSPrate,2;','','');
+REPLACE INTO `item_db_re` VALUES ('2140','Energy_Rune_Guard','Energy Rune Guard','5','20','10','0','0','0','70','0','1','128','56','2','32','0','99',NULL,'1','4','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bMaxSPrate,2;','','');
 REPLACE INTO `item_db_re` VALUES ('2141','Freyja_SShield7','Freya Soul Shield','5','0','0','300','0','0','5','0','0','4294967295','63','2','32','0','20',NULL,'0','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Medium,25;','','');
 REPLACE INTO `item_db_re` VALUES ('2142','Freyja_SShield30','Freya Soul Shield','5','0','0','300','0','0','5','0','0','4294967295','63','2','32','0','20',NULL,'0','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Medium,25;','','');
 REPLACE INTO `item_db_re` VALUES ('2143','Freyja_SShield60','Freya Soul Shield','5','0','0','300','0','0','5','0','0','4294967295','63','2','32','0','20',NULL,'0','1','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Medium,25;','','');
@@ -1827,7 +1827,7 @@ REPLACE INTO `item_db_re` VALUES ('2790','Bradium_Brooch','Bradium Brooch','5','
 REPLACE INTO `item_db_re` VALUES ('2791','Just_Got_Fish','Fresh Fish','5','20','10','500','0','0','0','0','1','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHit,3;','','');
 REPLACE INTO `item_db_re` VALUES ('2792','Ring_Of_Flame_Lord_I','Ring of Flame Lord','5','0','0','0','0','0','0','0','0','1040256','58','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus bVit,1; bonus bBaseAtk,15; bonus2 bSubEle,Ele_Fire,10; bonus3 bAutoSpell,CH_SOULCOLLECT,1,30; bonus3 bAutoSpell,MO_EXPLOSIONSPIRITS,1,10; bonus3 bAutoSpell,PA_PRESSURE,2,30; bonus3 bAutoSpell,MG_FIREBALL,1,150; bonus3 bAutoSpell,KN_BOWLINGBASH,5,20;','','');
 REPLACE INTO `item_db_re` VALUES ('2793','Ring_Of_Resonance_I','Ring of Resonance','5','0','0','0','0','0','2','0','0','1040256','58','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,2; bonus bVit,1; bonus bMdef,2; bonus4 bAutoSpellWhenHit,WZ_QUAGMIRE,1,50,0; bonus3 bAutoSpellWhenHit,AS_SPLASHER,10,20; bonus3 bAutoSpellWhenHit,AL_HEAL,10,30; bonus3 bAutoSpellWhenHit,HP_ASSUMPTIO,3,20; bonus3 bAutoSpellWhenHit,CG_TAROTCARD,5,20;','','');
-REPLACE INTO `item_db_re` VALUES ('2794','Magic_Stone_Ring','Magic Stone Ring','5','0','0','0','0','0','0','0','1','16512','56','2','136','0','99',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2;','','');
+REPLACE INTO `item_db_re` VALUES ('2794','Magic_Stone_Ring','Magic Stone Ring','5','0','0','0','0','0','0','0','1','128','56','2','136','0','99',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2;','','');
 REPLACE INTO `item_db_re` VALUES ('2795','Green_Apple_Ring','Green Apple Ring','5','0','0','0','0','0','0','0','0','1040256','56','2','136','0','99',NULL,'0','0','0','0','0','499',NULL,'0',NULL,'0',NULL,'0','if(JobLevel<30) { bonus bAllStats,6-(JobLevel/5); }','','');
 REPLACE INTO `item_db_re` VALUES ('2796','Magical_Stone','Magical Stone','5','0','0','200','0','0','0','0','0','8454660','63','2','136','0','99',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddDamageClass,2047,10; bonus2 bAddDefClass,2048,-10; bonus3 bAddClassDropItem,6152,2047,70;','','');
 REPLACE INTO `item_db_re` VALUES ('2797','Magical_Stone_','Magical Stone','5','0','0','200','0','0','0','0','0','8454660','63','2','136','0','99',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddDamageClass,2049,10; bonus2 bAddDefClass,2050,-10; bonus3 bAddClassDropItem,6151,2049,70;','','');
@@ -3447,7 +3447,7 @@ REPLACE INTO `item_db_re` VALUES ('5742','Rudolf_Santa_Hat','Rudolf Santa Hat','
 REPLACE INTO `item_db_re` VALUES ('5743','Orange_Stem_Hat','Orange Stem Hat','5','20','10','100','0','0','0','0','0','4294967295','63','2','256','0','0',NULL,'0','620','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0; bonus bLuk,3;','','');
 REPLACE INTO `item_db_re` VALUES ('5744','Capricon_Crown','Capricorn Crown','5','20','10','300','0','0','3','0','1','4294967295','63','2','256','0','0',NULL,'1','621','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,2; bonus bDex,2;','','');
 REPLACE INTO `item_db_re` VALUES ('5745','Capricon_Diadem','Capricorn Diadem','5','20','10','300','0','0','3','0','0','4294967295','63','2','256','0','0',NULL,'1','622','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bMdef,5;','','');
-REPLACE INTO `item_db_re` VALUES ('5746','Rune_Circlet','Rune Circlet','5','20','10','100','0','0','12','0','1','16512','56','2','256','0','100',NULL,'1','623','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bMdef,5; if(readparam(bStr)>=120) { bonus bBaseAtk,10; bonus bMatk,5; }','','');
+REPLACE INTO `item_db_re` VALUES ('5746','Rune_Circlet','Rune Circlet','5','20','10','100','0','0','12','0','1','128','56','2','256','0','100',NULL,'1','623','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bInt,1; bonus bMdef,5; if(readparam(bStr)>=120) { bonus bBaseAtk,10; bonus bMatk,5; }','','');
 REPLACE INTO `item_db_re` VALUES ('5747','Mitra','Mitra','5','20','10','100','0','0','12','0','1','256','56','2','256','0','100',NULL,'1','624','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bVit,1; bonus bInt,1; bonus bMdef,5; bonus bHealPower,5; if(readparam(bInt)>=120) { bonus bMatk,10; }','','');
 REPLACE INTO `item_db_re` VALUES ('5748','Sniper_Goggle','Sniper Goggle','5','20','10','100','0','0','12','0','1','2048','56','2','768','0','100',NULL,'1','625','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus bDex,1; bonus bMdef,5; if(readparam(bAgi)>=120) { bonus bLongAtkRate,4; bonus bAspd,1; }','','');
 REPLACE INTO `item_db_re` VALUES ('5749','Driver_Band','Driver Band','5','20','10','100','0','0','12','0','1','1024','56','2','256','0','100',NULL,'1','626','0','0','0','475',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bDex,1; bonus bMdef,5; if(readparam(bStr)>=120) { bonus bBaseAtk,10; bonus bCritical,3; }','','');
@@ -7428,7 +7428,7 @@ REPLACE INTO `item_db_re` VALUES ('14617','VIT_Biscuit_Stick','Bar of Fitness','
 REPLACE INTO `item_db_re` 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',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db_re` VALUES ('15000','Bone_Plate','Bone Plate','5','20','10','1000','0','0','60','0','1','414946','58','2','16','0','0',NULL,'1','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bMdef,3; bonus2 bIgnoreDefRate,RC_DemiHuman,10; bonus2 bIgnoreDefRate,RC_Brute,10; bonus3 bAutoSpellWhenHit,NPC_WIDEBLEEDING,1,10;','','');
 REPLACE INTO `item_db_re` VALUES ('15001','Odin\'s_Blessing_I','Odin\'s Blessing','5','0','0','0','0','0','10','0','0','2147483646','63','2','16','0','0',NULL,'0','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db_re` VALUES ('15002','Rune_Plate','Rune Plate','5','0','0','0','0','0','95','0','1','16512','56','2','16','0','99',NULL,'1','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db_re` VALUES ('15002','Rune_Plate','Rune Plate','5','0','0','0','0','0','95','0','1','128','56','2','16','0','99',NULL,'1','0','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db_re` VALUES ('15003','Freyja_SRobe7','Freya Soul Robe','5','0','0','300','0','0','7','0','0','4294967295','63','2','16','0','20',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,700;','','');
 REPLACE INTO `item_db_re` VALUES ('15004','Freyja_SRobe30','Freya Soul Robe','5','0','0','300','0','0','7','0','0','4294967295','63','2','16','0','20',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,700;','','');
 REPLACE INTO `item_db_re` VALUES ('15005','Freyja_SRobe60','Freya Soul Robe','5','0','0','300','0','0','7','0','0','4294967295','63','2','16','0','20',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHP,700;','','');
@@ -8347,7 +8347,7 @@ REPLACE INTO `item_db_re` VALUES ('21000','Upg_Twohand_Sword','Upgrade Two-Hand
 REPLACE INTO `item_db_re` 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',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace,RC_DemiHuman,80; bonus2 bIgnoreDefRate,RC_DemiHuman,30; if(getrefine()>=6) { bonus2 bAddRace,RC_DemiHuman,40; } if(getrefine()>=9) { autobonus2 \"{ bonus bShortWeaponDamageReturn,20; bonus bMagicDamageReturn,20; }\",200,1000,BF_WEAPON,\"{ specialeffect2 EF_REFLECTSHIELD; }\"; }','','');
 REPLACE INTO `item_db_re` 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',NULL,'0',NULL,'0',NULL,'0','bonus3 bSPVanishRate,10000,8,BF_NORMAL;','','');
 REPLACE INTO `item_db_re` VALUES ('21003','Muramasa_','Muramasa','4','20','10','1000','155','0','0','1','2','16514','63','2','34','4','48',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
-REPLACE INTO `item_db_re` VALUES ('21004','Alca_Bringer_','Alca Bringer','4','20','10','3400','280','0','0','2','2','16512','56','2','34','3','100',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
+REPLACE INTO `item_db_re` VALUES ('21004','Alca_Bringer_','Alca Bringer','4','20','10','3400','280','0','0','2','2','128','56','2','34','3','100',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db_re` VALUES ('21005','Metal_Two_Hand_Sword','Metal Two-Handed Sword','4','20','10','0','95','0','0','1','1','16514','63','2','34','3','0',NULL,'1','3','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db_re` 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',NULL,'0',NULL,'0',NULL,'0','','','');
 REPLACE INTO `item_db_re` 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','60000','0',NULL,'0',NULL,'20','1','0','itemskill RK_LUXANIMA,1;','','');