ItemDB SQL Sync

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

1 files changed, 8 insertions, 8 deletions

diff --git a/sql-files/item_db.sql b/sql-files/item_db.sql
index 0e1d1513f..e207ae8d5 100644
--- a/sql-files/item_db.sql
+++ b/sql-files/item_db.sql
@@ -1766,7 +1766,7 @@ REPLACE INTO `item_db` VALUES ('4151','Gajomart_Card','Gajomart Card','6','20','
 REPLACE INTO `item_db` VALUES ('4152','Galapago_Card','Galapago Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddItemHealRate,Apple_Juice,50; bonus2 bAddItemHealRate,Banana_Juice,50; bonus2 bAddItemHealRate,Carrot_Juice,50; bonus3 bAddMonsterDropItem,531,RC_Insect,300; bonus3 bAddMonsterDropItem,532,RC_Insect,300; bonus3 bAddMonsterDropItem,534,RC_Insect,300;','','');
 REPLACE INTO `item_db` VALUES ('4153','Crab_Card','Crab Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bBaseAtk,5; bonus2 bAddDamageClass,1266,30;','','');
 REPLACE INTO `item_db` VALUES ('4154','Rice_Cake_Boy_Card','Dumpling Child Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddItemHealRate,Candy,50; bonus2 bAddItemHealRate,Candy_Striper,50; bonus3 bAddMonsterDropItem,529,RC_DemiPlayer,300; bonus3 bAddMonsterDropItem,530,RC_DemiPlayer,100;','','');
-REPLACE INTO `item_db` VALUES ('4155','Goblin_Leader_Card','Goblin Leader Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,1,30;','','');
+REPLACE INTO `item_db` VALUES ('4155','Goblin_Leader_Card','Goblin Leader Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Goblin,30;','','');
 REPLACE INTO `item_db` VALUES ('4156','Steam_Goblin_Card','Goblin Steamrider Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritAtkRate,10; bonus2 bCriticalAddRace,RC_Formless,7;','','');
 REPLACE INTO `item_db` VALUES ('4157','Goblin_Archer_Card','Goblin Archer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritAtkRate,10; bonus2 bCriticalAddRace,RC_Undead,7;','','');
 REPLACE INTO `item_db` VALUES ('4158','Flying_Deleter_Card','Sky Deleter Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bHPrecovRate,-100; bonus bHPGainValue,100;','','');
@@ -1795,7 +1795,7 @@ REPLACE INTO `item_db` VALUES ('4180','Driller_Card','Driller Card','6','20','10
 REPLACE INTO `item_db` VALUES ('4181','Disguise_Card','Disguise Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddEffWhenHit,Eff_Silence,300+600*(readparam(bVit)>=77);','','');
 REPLACE INTO `item_db` VALUES ('4182','Diabolic_Card','Diabolic Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSPGainRace,RC_Demon,5;','','heal 0,-5;');
 REPLACE INTO `item_db` VALUES ('4183','Vagabond_Wolf_Card','Vagabond Wolf Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','4','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1;','','');
-REPLACE INTO `item_db` VALUES ('4184','Lava_Golem_Card','Lava Golem Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,4,30;','','');
+REPLACE INTO `item_db` VALUES ('4184','Lava_Golem_Card','Lava Golem Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Golem,30;','','');
 REPLACE INTO `item_db` VALUES ('4185','Rideword_Card','Rideword Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; if(BaseClass==Job_Acolyte) { bonus bInt,1; bonus bMdef,1; }','','');
 REPLACE INTO `item_db` VALUES ('4186','Raggler_Card','Raggler Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bVit,1;','','');
 REPLACE INTO `item_db` VALUES ('4187','Raydric_Archer_Card','Raydric Archer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAddMonsterDropItem,12030,RC_Demon,100;','','');
@@ -1842,7 +1842,7 @@ REPLACE INTO `item_db` VALUES ('4227','Spring_Rabbit_Card','Spring Rabbit Card',
 REPLACE INTO `item_db` VALUES ('4228','Sleeper_Card','Sleeper Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAddMonsterDropItem,12031,RC_Fish,100;','','');
 REPLACE INTO `item_db` VALUES ('4229','C_Tower_Manager_Card','Tower Keeper Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; bonus bCastrate,-5;','','');
 REPLACE INTO `item_db` VALUES ('4230','Shinobi_Card','Shinobi Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; bonus3 bAutoSpellWhenHit,AS_CLOAKING,5,100;','','');
-REPLACE INTO `item_db` VALUES ('4231','Increase_Soil_Card','Mi Gao Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace2,5,50;','','');
+REPLACE INTO `item_db` VALUES ('4231','Increase_Soil_Card','Mi Gao Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace2,RC2_Guardian,50;','','');
 REPLACE INTO `item_db` VALUES ('4232','Wild_Ginseng_Card','Hermit Plant Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddItemHealRate,Red_Herb,50; bonus2 bAddItemHealRate,Yellow_Herb,50; bonus2 bAddItemHealRate,White_Herb,50; bonus3 bAddMonsterDropItem,507,RC_Plant,300; bonus3 bAddMonsterDropItem,508,RC_Plant,200; bonus3 bAddMonsterDropItem,509,RC_Plant,100;','','');
 REPLACE INTO `item_db` VALUES ('4233','Baby_Leopard_Card','Baby Leopard Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,3; if(BaseClass==Job_Merchant) bonus bUnbreakableArmor,0;','','');
 REPLACE INTO `item_db` VALUES ('4234','Anolian_Card','Anolian Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','16','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpellWhenHit,AC_CONCENTRATION,1+9*(getskilllv(AC_CONCENTRATION)==10),30;','','');
@@ -1862,11 +1862,11 @@ REPLACE INTO `item_db` VALUES ('4247','Aster_Card','Aster Card','6','20','10','1
 REPLACE INTO `item_db` VALUES ('4248','Ancient_Mummy_Card','Ancient Mummy Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpellWhenHit,AL_CRUCIS,5,30;','','');
 REPLACE INTO `item_db` VALUES ('4249','Ancient_Worm_Card','Ancient Worm Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_Demon,-20; bonus2 bExpAddRace,RC_Demon,10;','','');
 REPLACE INTO `item_db` VALUES ('4250','Executioner_Card','Executioner Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Large,25; bonus bDef,1;','','');
-REPLACE INTO `item_db` VALUES ('4251','Elder_Card','Elder Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,5,40;','','');
+REPLACE INTO `item_db` VALUES ('4251','Elder_Card','Elder Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Guardian,40;','','');
 REPLACE INTO `item_db` VALUES ('4252','Alligator_Card','Alligator Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLongAtkDef,5;','','');
 REPLACE INTO `item_db` VALUES ('4253','Alice_Card','Alice Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubRace,RC_Boss,40; bonus2 bSubRace,RC_NonBoss,-40;','','');
 REPLACE INTO `item_db` VALUES ('4254','Tirfing_Card','Ogretooth Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','32','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubSize,Size_Medium,25; bonus bDef,1;','','');
-REPLACE INTO `item_db` VALUES ('4255','Orc_Lady_Card','Orc Lady Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,3,30;','','');
+REPLACE INTO `item_db` VALUES ('4255','Orc_Lady_Card','Orc Lady Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Orc,30;','','');
 REPLACE INTO `item_db` VALUES ('4256','Orc_Archer_Card','Orc Archer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAddMonsterDropItem,12034,RC_DemiPlayer,100;','','');
 REPLACE INTO `item_db` VALUES ('4257','Wild_Rose_Card','Wild Rose Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bAgi,1; if(BaseClass==Job_Thief) bonus bFlee2,5;','','');
 REPLACE INTO `item_db` VALUES ('4258','Wicked_Nymph_Card','Evil Nymph Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; bonus bMaxSP,50;','','');
@@ -1902,7 +1902,7 @@ REPLACE INTO `item_db` VALUES ('4287','Kapha_Card','Kapha Card','6','20','10','1
 REPLACE INTO `item_db` VALUES ('4288','Carat_Card','Carat Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','769','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2; if(getrefine()>8) bonus bMaxSP,150;','','');
 REPLACE INTO `item_db` VALUES ('4289','Caterpillar_Card','Caterpillar Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSPGainRace,RC_Plant,5;','','heal 0,-5;');
 REPLACE INTO `item_db` VALUES ('4290','Cat_O_Nine_Tail_Card','Cat O\' Nine Tails Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','64','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus bMagicDamageReturn,5;','','');
-REPLACE INTO `item_db` VALUES ('4291','Kobold_Leader_Card','Kobold Leader Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,2,30;','','');
+REPLACE INTO `item_db` VALUES ('4291','Kobold_Leader_Card','Kobold Leader Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Kobold,30;','','');
 REPLACE INTO `item_db` VALUES ('4292','Kobold_Archer_Card','Kobold Archer Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','2','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bCritAtkRate,10; bonus2 bCriticalAddRace,RC_Plant,7;','','');
 REPLACE INTO `item_db` VALUES ('4293','Cookie_Card','Cookie Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bLuk,2; bonus2 bSkillAtk,AL_HOLYLIGHT,10;','','');
 REPLACE INTO `item_db` VALUES ('4294','Quve_Card','Quve Card','6','20','10','10','0','0','0','0','0','4294967295','63','2','136','0','0',NULL,'0','0','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','if(BaseJob==Job_Novice||BaseJob==Job_SuperNovice) bonus3 bAutoSpellWhenHit,AL_INCAGI,1,100;','','');
@@ -2613,7 +2613,7 @@ REPLACE INTO `item_db` VALUES ('5462','Spiked_Scarf','Spiked Scarf','5','20','10
 REPLACE INTO `item_db` VALUES ('5463','Rainbow_Scarf','Rainbow Scarf','5','20','10','100','0','0','1','0','0','4294967295','63','2','1','0','90',NULL,'0','460','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','bonus bInt,1; bonus bMdef,2; bonus bMatkRate,1;','','');
 REPLACE INTO `item_db` VALUES ('5464','Zaha_Doll_Hat','Zaha Doll Hat','5','20','10','0','0','0','1','0','0','4294967295','63','2','256','0','0',NULL,'0','461','0','0','0','507',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2; skill PR_MAGNIFICAT, 3;','','');
 REPLACE INTO `item_db` VALUES ('5471','Hairband_Of_Reginleif','Hairband Of Reginleif','5','20','10','800','0','0','1','0','0','4294967295','63','2','512','0','50',NULL,'0','468','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bSubEle,Ele_Water,3; bonus2 bSubEle,Ele_Fire,3; bonus2 bSubEle,Ele_Undead,3; bonus2 bSubEle,Ele_Ghost,3;','','');
-REPLACE INTO `item_db` VALUES ('5476','Hairband_Of_Grandpeco','Grand Peco Hairband','5','20','10','800','0','0','2','0','0','4294967295','63','2','768','0','30',NULL,'1','473','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus bMaxHPrate,-10; bonus2 bAddRace2,3,15;','','');
+REPLACE INTO `item_db` VALUES ('5476','Hairband_Of_Grandpeco','Grand Peco Hairband','5','20','10','800','0','0','2','0','0','4294967295','63','2','768','0','30',NULL,'1','473','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus bMaxHPrate,-10; bonus2 bAddRace2,RC2_Orc,15;','','');
 REPLACE INTO `item_db` VALUES ('5477','Bro_Flag','Brazilian Flag Hat','5','20','10','100','0','0','1','0','1','4294967295','63','2','256','0','30',NULL,'1','474','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill SM_BASH, 1;','','');
 REPLACE INTO `item_db` VALUES ('5478','Classic_Hat','Classic Hat','5','20','10','500','0','0','3','0','0','4294967295','63','2','256','0','0',NULL,'1','475','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','bonus bStr,2; bonus bMaxHP,300;','','');
 REPLACE INTO `item_db` VALUES ('5479','Shaman\'s_Hair_Ornament','Shaman\'s Hair Decoration','5','20','10','300','0','0','1','0','0','4294967295','63','2','256','0','30',NULL,'1','476','0','0','0','65',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus bMaxHP,50; bonus2 bSubEle,Ele_Neutral,5;','','');
@@ -2637,7 +2637,7 @@ REPLACE INTO `item_db` VALUES ('5497','King_Tiger_Doll_Hat','King Tiger Doll Hat
 REPLACE INTO `item_db` VALUES ('5498','Wondering_Wolf_Helm','Wandering Wolf Helm','5','20','10','600','0','0','5','0','0','2147483646','63','2','768','0','50',NULL,'0','490','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bVit,5; bonus bFlee,10;','','');
 REPLACE INTO `item_db` VALUES ('5499','Pizza_Hat','Pizza Hat','5','20','10','600','0','0','0','0','0','4294967295','63','2','256','0','0',NULL,'0','487','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','skill SM_PROVOKE, 1;','','');
 REPLACE INTO `item_db` VALUES ('5500','Icecream_Hat','Icecream Hat','5','0','0','300','0','0','6','0','0','4294967295','63','2','256','0','30',NULL,'1','488','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; skill MG_FROSTDIVER, 3;','','');
-REPLACE INTO `item_db` VALUES ('5501','Pirate\'s_Pride','Pirate\'s Pride','5','0','0','100','0','0','6','0','0','4294967295','63','2','256','0','10',NULL,'0','496','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2, 6, 5; bonus2 bSubRace2, 6, 5;','','');
+REPLACE INTO `item_db` VALUES ('5501','Pirate\'s_Pride','Pirate\'s Pride','5','0','0','100','0','0','6','0','0','4294967295','63','2','256','0','10',NULL,'0','496','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Ninja,5; bonus2 bSubRace2,RC2_Ninja,5;','','');
 REPLACE INTO `item_db` VALUES ('5502','Necromencer\'s_Hood','Necromancer\'s Hood','5','0','0','500','0','0','2','0','0','4294967295','63','2','768','0','1',NULL,'1','491','0','0','0','457',NULL,'0',NULL,'0',NULL,'0','bonus5 bAutoSpellWhenHit,NPC_DARKSTRIKE,5,5,BF_WEAPON|BF_MAGIC,1;','','');
 REPLACE INTO `item_db` VALUES ('5503','Rabbit_Magic_Hat','Magic Rabit Hat','5','0','0','800','0','0','2','0','0','4294967295','63','2','256','0','0',NULL,'1','497','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bDex,2; bonus bAgi,2; bonus bMdef,1; bonus bMaxSP,50; bonus3 bAutoSpellWhenHit,MG_FIREBOLT,1,20; bonus3 bAutoSpellWhenHit,MG_COLDBOLT,1,20; bonus3 bAutoSpellWhenHit,MG_LIGHTNINGBOLT,1,20;','','');
 REPLACE INTO `item_db` VALUES ('5504','China_Wedding_Veil','Wedding Weil','5','20','10','500','0','0','5','0','0','4294967295','63','2','768','0','70',NULL,'1','489','0','0','0','73',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10;','','');