diff options
author | Hercules.ws <Hercules@efficiently.awesome> | 2015-06-24 11:04:04 +0200 |
---|---|---|
committer | HerculesWSAPI <Hercules@efficiently.awesome> | 2015-06-24 11:04:04 +0200 |
commit | d845cce855867d08a03d374d245b1df8082fc90b (patch) | |
tree | 4b1e1c3eb7c3d4a6af3757d14cad65ff339b9bac /sql-files | |
parent | d342e91c38c9e7bde68e3fac9b1013da6c707922 (diff) | |
download | hercules-d845cce855867d08a03d374d245b1df8082fc90b.tar.gz hercules-d845cce855867d08a03d374d245b1df8082fc90b.tar.bz2 hercules-d845cce855867d08a03d374d245b1df8082fc90b.tar.xz hercules-d845cce855867d08a03d374d245b1df8082fc90b.zip |
ItemDB SQL Sync
Signed-off-by: HerculesWSAPI <Hercules@efficiently.awesome>
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/item_db.sql | 16 | ||||
-rw-r--r-- | sql-files/item_db_re.sql | 20 |
2 files changed, 18 insertions, 18 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;','',''); diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index c766fa2cb..efbed6eb1 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -2221,7 +2221,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 Kid 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;','',''); @@ -2250,7 +2250,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;','',''); @@ -2297,7 +2297,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 bVariableCastrate,-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;','',''); @@ -2317,11 +2317,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;','',''); @@ -2357,7 +2357,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;','',''); @@ -2573,7 +2573,7 @@ REPLACE INTO `item_db` VALUES ('4503','Sealed_Apocalips_H_Card','Sealed Vesper C REPLACE INTO `item_db` VALUES ('4504','Sealed_Eddga_Card','Sealed Eddga 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 bMaxHPrate,((getrefine()>14)?-35:-50);','sc_start4 SC_ENDURE,60000,10,0,0,1;','sc_end SC_ENDURE;'); REPLACE INTO `item_db` VALUES ('4505','Scaraba_Card','Scaraba 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 bMatk,20; bonus bMaxSPrate,-1;','',''); REPLACE INTO `item_db` VALUES ('4506','Dolomedes_Card','Dolomedes 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 bDex,2; if(BaseClass==Job_Archer) { bonus bDex,getrefine()/3; }','',''); -REPLACE INTO `item_db` VALUES ('4507','Q_Scaraba_Card','Queen Scaraba 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,7,30; bonus2 bAddMonsterDropItem,12806,30;','',''); +REPLACE INTO `item_db` VALUES ('4507','Q_Scaraba_Card','Queen Scaraba 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_Scaraba,30; bonus2 bAddMonsterDropItem,12806,30;','',''); REPLACE INTO `item_db` VALUES ('4508','Gold_Scaraba_Card','Gold Scaraba 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 bBaseAtk,20; bonus bMaxHPrate,-1;','',''); REPLACE INTO `item_db` VALUES ('4509','Gold_Q_Scaraba_Card','Gold Queen Scaraba 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,3; bonus2 bAddRaceTolerance,RC_Insect,10; if(getrefine()>=9) { bonus2 bAddRaceTolerance,RC_Insect,5; }','',''); REPLACE INTO `item_db` VALUES ('4510','Miming_Card','Miming 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 bAddEff,Eff_Deepsleep,500;','',''); @@ -3336,7 +3336,7 @@ REPLACE INTO `item_db` VALUES ('5472','Red_White_Hat','Red White Cap','5','20',' REPLACE INTO `item_db` VALUES ('5473','Forceps_Hairpin','Crab Nipper Hat','5','20','10','500','0','0','8','0','0','4294967295','63','2','256','0','30',NULL,'1','470','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus3 bAutoSpellWhenHit,MG_COLDBOLT,1,30; bonus3 bAddMonsterDropItem,991,RC_Fish,100;','',''); REPLACE INTO `item_db` VALUES ('5474','Notice_Board','AFK Hat','5','20','10','700','0','0','4','0','0','4294967295','63','2','256','0','10',NULL,'0','471','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('5475','Cube_Mask','Quove Hat','5','20','10','100','0','0','0','0','0','4294967295','63','2','513','0','0',NULL,'0','472','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); -REPLACE INTO `item_db` VALUES ('5476','Hairband_Of_Grandpeco','Grand Peco Headdress','5','20','10','800','0','0','5','0','0','4294967295','63','2','768','0','0',NULL,'1','473','0','0','0','0',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 Headdress','5','20','10','800','0','0','5','0','0','4294967295','63','2','768','0','0',NULL,'1','473','0','0','0','0',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','2','0','1','4294967295','63','2','256','0','30',NULL,'1','474','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','','',''); REPLACE INTO `item_db` VALUES ('5478','Classic_Hat','Classic Hat','5','20','10','500','0','0','4','0','0','4294967295','63','2','256','0','0',NULL,'1','475','0','0','0','0',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','2','0','0','4294967295','63','2','256','0','0',NULL,'1','476','0','0','0','449',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus bMaxHP,50; bonus2 bSubEle,Ele_Neutral,5;','',''); @@ -3361,7 +3361,7 @@ REPLACE INTO `item_db` VALUES ('5497','King_Tiger_Doll_Hat','Edgga Doll','5','20 REPLACE INTO `item_db` VALUES ('5498','Wondering_Wolf_Helm','Vagabond Wolf Hat','5','20','10','600','0','0','5','0','1','4294967295','63','2','768','0','20',NULL,'1','490','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bVit,5; bonus bFlee,10;','',''); REPLACE INTO `item_db` VALUES ('5499','Pizza_Hat','Pizza Pie of Plenty','5','20','10','600','0','0','0','0','0','4294967295','63','2','256','0','0',NULL,'0','487','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','skill SM_PROVOKE,1;','',''); REPLACE INTO `item_db` VALUES ('5500','Icecream_Hat','Ice Cream Hat','5','20','10','300','0','0','6','0','0','4294967295','63','2','256','0','30',NULL,'1','488','0','0','0','0',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','1','4294967295','63','2','256','0','10',NULL,'0','496','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,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','1','4294967295','63','2','256','0','10',NULL,'0','496','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,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','6','0','0','4294967295','63','2','768','0','0',NULL,'1','491','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus bInt,3; bonus5 bAutoSpellWhenHit,NPC_DARKSTRIKE,5,5,BF_WEAPON|BF_MAGIC,1;','',''); REPLACE INTO `item_db` VALUES ('5503','Rabbit_Magic_Hat','Rabbit Magic Hat','5','0','0','800','0','0','4','0','0','4294967295','63','2','256','0','0',NULL,'1','497','0','0','0','0',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','RO 5th Wedding Anniversary','5','0','0','500','0','0','5','0','0','4294967295','63','2','769','0','70',NULL,'0','489','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,10;','',''); @@ -8142,7 +8142,7 @@ REPLACE INTO `item_db` VALUES ('18527','Gloomy_Pumpkin_Hat','Gloomy Pumpkin Hat' REPLACE INTO `item_db` VALUES ('18528','Tare_Neko_Cru','Drooping Neko Crew','5','20','10','100','0','0','0','0','1','4294967295','63','2','256','0','0',NULL,'1','692','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2; bonus bMdef,5;','',''); REPLACE INTO `item_db` VALUES ('18529','Drooping_Wild_Rose','Drooping Wild Rose','5','20','10','500','0','0','5','0','1','4294967295','63','2','768','0','30',NULL,'1','541','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMaxHPrate,-10; bonus bAspdRate,3;','',''); REPLACE INTO `item_db` VALUES ('18530','Tha_Despero_Mask','Thanatos Despero Mask','5','20','10','100','0','0','0','0','0','4294967295','63','2','513','0','30',NULL,'0','693','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bUnbreakableHelm,0; bonus bLuk,-5;','',''); -REPLACE INTO `item_db` VALUES ('18531','Drooping_Permeter','Drooping Permeter','5','20','10','1000','0','0','8','0','1','4294967295','63','2','256','0','10',NULL,'1','694','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,8,20;','',''); +REPLACE INTO `item_db` VALUES ('18531','Drooping_Permeter','Drooping Permeter','5','20','10','1000','0','0','8','0','1','4294967295','63','2','256','0','10',NULL,'1','694','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus2 bAddRace2,RC2_Turtle,20;','',''); REPLACE INTO `item_db` VALUES ('18532','Heart_Ribbon_Band','Heart Ribbon Hairband','5','20','10','100','0','0','0','0','1','4294967295','63','2','256','0','10',NULL,'1','708','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bInt,2;','',''); REPLACE INTO `item_db` VALUES ('18533','Honeybee_Hat','Honey Bee Hat','5','20','10','100','0','0','3','0','1','4294967295','63','2','256','0','50',NULL,'1','709','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bMdef,3; bonus2 bAddRace,RC_Insect,5; bonus2 bAddRaceTolerance,RC_Insect,5; bonus3 bAddMonsterDropItem,518,RC_Insect,50;','',''); REPLACE INTO `item_db` VALUES ('18534','Fancy_Phantom_Mask','Fancy Phantom Mask','5','20','10','1000','0','0','5','0','1','4294967295','63','2','768','0','20',NULL,'1','710','0','0','0','0',NULL,'0',NULL,'0',NULL,'0','bonus bStr,1; bonus bAtkRate,5; bonus bDelayrate,-1; bonus bMaxHP,0+(getrefine()*100); bonus2 bSkillAtk,MC_MAMMONITE,20;','',''); |