diff options
author | spre123 <spre123@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-10-24 00:39:23 +0000 |
---|---|---|
committer | spre123 <spre123@54d463be-8e91-2dee-dedb-b68131a5f0ec> | 2012-10-24 00:39:23 +0000 |
commit | 1362b754d9b3460887dca9bfceca0665186b80a0 (patch) | |
tree | 5b31ee001d726d0194d9204329bda8269c71b2a3 /sql-files | |
parent | b06a8c8ddef852cb9854c90f7efc222fe6c3be68 (diff) | |
download | hercules-1362b754d9b3460887dca9bfceca0665186b80a0.tar.gz hercules-1362b754d9b3460887dca9bfceca0665186b80a0.tar.bz2 hercules-1362b754d9b3460887dca9bfceca0665186b80a0.tar.xz hercules-1362b754d9b3460887dca9bfceca0665186b80a0.zip |
Fixed/Changed the rest of the RE Items with the reversed/broken bcastrate with bVariableCastrate So it actually works as intended(ONLY RE needed this update). bugreport:6548
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@16826 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'sql-files')
-rw-r--r-- | sql-files/item_db_re.sql | 102 |
1 files changed, 51 insertions, 51 deletions
diff --git a/sql-files/item_db_re.sql b/sql-files/item_db_re.sql index 6df044b98..460362569 100644 --- a/sql-files/item_db_re.sql +++ b/sql-files/item_db_re.sql @@ -568,7 +568,7 @@ REPLACE INTO `item_db_re` VALUES (1177,'Muramash','Muramash',4,20,NULL,0,'120',N REPLACE INTO `item_db_re` VALUES (1178,'Schweizersabel_','Schweizersabel',4,20,NULL,1600,'160',NULL,1,2,0x00004082,7,2,34,4,'48',1,3,'bonus bAtkEle,Ele_Wind; bonus bDef,1; bonus3 bAutoSpell,"MG_LIGHTNINGBOLT",3,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1179,'Executioner__','Executioner',4,20,NULL,2200,'155',NULL,1,1,0x00004082,7,2,34,4,'48',1,3,'bonus bIgnoreDefRace,RC_DemiHuman; bonus2 bAddRace,RC_DemiHuman,20; bonus2 bSubRace,RC_DemiHuman,-10; bonus bAtkEle,Ele_Dark;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1180,'Dragon_Slayer_','Dragon Slayer',4,20,NULL,1300,'150',NULL,1,2,0x00004082,7,2,34,4,'48',1,3,'bonus bIgnoreDefRace,RC_Dragon; bonus2 bAddRace,RC_Dragon,15;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1181,'Tae_Goo_Lyeon','Tae Goo Lyeon',4,20,NULL,2000,'250',NULL,1,2,0x00004082,2,2,34,4,'90',1,3,'bonus bFlee2,10; if(JobLevel>=70) autobonus "{bonus bBaseAtk,50;}",10,10000,BF_WEAPON,"{specialeffect2 EF_POTION_BERSERK;}"; if(getrefine()>8) { bonus bCastrate,-20; bonus bDelayRate,-20; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1181,'Tae_Goo_Lyeon','Tae Goo Lyeon',4,20,NULL,2000,'250',NULL,1,2,0x00004082,2,2,34,4,'90',1,3,'bonus bFlee2,10; if(JobLevel>=70) autobonus "{bonus bBaseAtk,50;}",10,10000,BF_WEAPON,"{specialeffect2 EF_POTION_BERSERK;}"; if(getrefine()>8) { bonus bVariableCastrate,-20; bonus bDelayRate,-20; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1182,'Bloody_Eater','Bloody Eater',4,20,NULL,1200,'200',NULL,1,2,0x00004082,7,2,34,4,'50',1,3,'bonus bAtkEle,Ele_Ghost; autobonus "{bonus bCritical,100; bonus bBaseAtk,50;}",1,5000,0,"{specialeffect2 EF_FIRESPLASHHIT;}"; bonus bHPGainValue,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1183,'BF_Two_Handed_Sword1','Brave Assaulter\'s Katzbalger',4,20,NULL,0,'200',NULL,1,NULL,0x00004082,7,2,34,3,'80',1,3,'bonus bStr,2; bonus2 bAddRace,RC_DemiHuman,55; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1184,'BF_Two_Handed_Sword2','Valorous Assaulter\'s Katzbalger',4,20,NULL,0,'200',NULL,1,NULL,0x00004082,7,2,34,3,'80',1,3,'bonus2 bAddRace,RC_DemiHuman,55; bonus bCritAtkRate,20;',NULL,NULL); @@ -905,7 +905,7 @@ REPLACE INTO `item_db_re` VALUES (1573,'Ancient_Magic','Ancient Magic',4,20,NULL REPLACE INTO `item_db_re` VALUES (1574,'BF_Book1','Brave Battle Strategy Book',4,20,NULL,0,'90:125',NULL,1,NULL,0x00410100,7,2,2,3,'80',1,15,'bonus bStr,2; bonus bInt,1; bonus bMatkRate,15; bonus2 bAddRace,RC_DemiHuman,75; bonus2 bIgnoreDefRate,RC_DemiHuman,20; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1575,'BF_Book2','Valorous Battle Strategy Book',4,20,NULL,0,'90:125',NULL,1,NULL,0x00410100,7,2,2,3,'80',1,15,'bonus bStr,2; bonus bInt,1; bonus bMatkRate,15; bonus2 bIgnoreMDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1576,'Krieger_Book1','Glorious Tablet',4,20,NULL,0,'90:115',NULL,1,NULL,0x00410100,7,2,2,4,'80',1,15,'bonus bMatkRate,15; bonus2 bAddRace,RC_DemiHuman,80; 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) autobonus "{bonus bBaseAtk,200;}",30,3000,BF_WEAPON,"{specialeffect2 EF_BASH3D;}";',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1577,'Krieger_Book2','Glorious Apocalypse',4,20,NULL,0,'90:115',NULL,1,NULL,0x00410100,7,2,2,4,'80',1,15,'bonus2 bAddRace,RC_DemiHuman,80; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) bonus2 bIgnoreDefRate,RC_DemiHuman,5; if(getrefine()>8) { bonus bMatkRate,5; bonus bCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1577,'Krieger_Book2','Glorious Apocalypse',4,20,NULL,0,'90:115',NULL,1,NULL,0x00410100,7,2,2,4,'80',1,15,'bonus2 bAddRace,RC_DemiHuman,80; bonus2 bIgnoreDefRate,RC_DemiHuman,25; bonus bUnbreakableWeapon,0; if(getrefine()>5) bonus2 bIgnoreDefRate,RC_DemiHuman,5; if(getrefine()>8) { bonus bMatkRate,5; bonus bVariableCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1578,'Book_Of_Prayer','Book Of Prayer',4,20,NULL,0,'140',NULL,1,NULL,0x00410100,7,2,2,3,NULL,NULL,15,'bonus bVit,2; bonus bMdef,2; bonus bMaxSPrate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1579,'Death_Note_M','Book of the Dead',4,20,NULL,1000,'137',NULL,1,2,0x00410100,7,2,2,4,'85',1,15,'bonus bMatkRate,15; bonus bStr,3; bonus bInt,3; bonus bLuk,-20; bonus2 bWeaponComaRace,RC_DemiHuman,10; bonus bAspdRate,getrefine(); if(BaseJob==Job_Sage) bonus3 bAutoSpell,"NPC_HELLJUDGEMENT",5,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1580,'Encyclopedia_C','Giant Encyclopedia',4,NULL,NULL,0,'145:100',NULL,1,NULL,0x00410100,7,2,2,3,NULL,NULL,15,'bonus bMatkRate,15; bonus bInt,3; bonus bDex,2; bonus bCritical,20+((readparam(bLuk)*2)/10); bonus2 bAddSize,0,40; bonus2 bAddSize,1,40; bonus2 bAddSize,2,40;',NULL,NULL); @@ -934,7 +934,7 @@ REPLACE INTO `item_db_re` VALUES (1612,'Arc_Wand__','Arc Wand',4,45000,NULL,400, REPLACE INTO `item_db_re` VALUES (1613,'Mighty_Staff','Mighty Staff',4,20,NULL,700,'130:100',NULL,1,NULL,0x00818314,7,2,2,3,'24',1,10,'bonus bStr,10; bonus bSPDrainValue,-2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1614,'Blessed_Wand','Wand of Occult',4,20,NULL,700,'75:105',NULL,1,NULL,0x00818314,7,2,2,3,'24',1,10,'bonus bInt,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1615,'Bone_Wand','Evil Bone Wand',4,20,NULL,700,'40:110',NULL,1,NULL,0x00818314,7,2,2,3,'24',1,10,'bonus bInt,4; bonus bAtkEle,Ele_Undead;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1616,'Staff_Of_Wing','Wing Staff',4,20,NULL,500,'60:115',NULL,1,NULL,0x00810204,7,2,2,4,'40',1,10,'bonus bCastrate,-5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1616,'Staff_Of_Wing','Wing Staff',4,20,NULL,500,'60:115',NULL,1,NULL,0x00810204,7,2,2,4,'40',1,10,'bonus bVariableCastrate,-5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1617,'Survival_Rod','Survivor\'s Rod',4,85000,NULL,1000,'50:120',NULL,1,NULL,0x00818314,7,2,2,3,'24',1,10,'bonus bDex,2; bonus bMaxHP,300;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1618,'Survival_Rod_','Survivor\'s Rod',4,85000,NULL,1000,'50:120',NULL,1,1,0x00818314,7,2,2,3,'24',1,10,'bonus bDex,3; bonus bMaxHP,400;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1619,'Survival_Rod2','Survivor\'s Rod',4,85000,NULL,1000,'50:120',NULL,1,NULL,0x00818314,7,2,2,3,'24',1,10,'bonus bInt,2; bonus bMaxHP,300;',NULL,NULL); @@ -958,9 +958,9 @@ REPLACE INTO `item_db_re` VALUES (1636,'Thorn_Staff','Thorn Staff of Darkness',4 REPLACE INTO `item_db_re` VALUES (1637,'Eraser','Eraser',4,20,NULL,500,'80:170',NULL,1,NULL,0x00018314,2,2,2,4,'70',1,10,'bonus bInt,3; bonus bDex,2; bonus bSPrecovRate,8; if( getrefine() > 9 ) bonus5 bAutoSpell,"NPC_WIDESOULDRAIN",3,5,BF_MAGIC,0; else bonus5 bAutoSpell,"NPC_WIDESOULDRAIN",1,5,BF_MAGIC,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1638,'Healing_Staff_C','Staff Of Healing',4,20,NULL,0,'10:125',NULL,1,NULL,0x00008110,7,2,2,3,'1',NULL,10,'bonus bAtkEle,Ele_Holy; bonus bMatkRate,15; bonus bHealPower,(getrefine()*3/2);',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1639,'N_Rod','Novice Rod',4,NULL,NULL,0,'15:32',NULL,1,3,0x00818315,7,2,2,1,'1',NULL,10,'bonus bMatkRate,16;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1640,'Krieger_Onehand_Staff1','Glorious Arc Wand',4,20,NULL,0,'70:135',NULL,1,NULL,0x00818314,7,2,2,4,'80',1,10,'bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25 + ((getrefine() > 5) ? 5 : 0); bonus bUnbreakableWeapon,0; if(getrefine() > 8) { bonus bMatkRate,5; bonus bCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1640,'Krieger_Onehand_Staff1','Glorious Arc Wand',4,20,NULL,0,'70:135',NULL,1,NULL,0x00818314,7,2,2,4,'80',1,10,'bonus2 bMagicAddRace,RC_DemiHuman,15; bonus2 bIgnoreMdefRate,RC_DemiHuman,25 + ((getrefine() > 5) ? 5 : 0); bonus bUnbreakableWeapon,0; if(getrefine() > 8) { bonus bMatkRate,5; bonus bVariableCastrate,-5; bonus bDelayRate,-5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1641,'Krieger_Onehand_Staff2','Glorious Cure Wand',4,20,NULL,0,'70:135',NULL,1,NULL,0x00818314,7,2,2,4,'80',1,10,'bonus bHealPower,14; bonus bDelayRate,-10; bonus bUnbreakableWeapon,0; if(getrefine() > 5) { bonus2 bIgnoreMdefRate,RC_DemiHuman,5; bonus bHealPower,5+(((getrefine()>14)?14:getrefine())-5)*2; } if(getrefine() > 8) bonus5 bAutoSpellOnSkill,"AL_HEAL","AL_HEAL",10,100,1; if(getrefine() > 9) { bonus bHealPower,10; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (1642,'Staff_Of_Darkness','Staff Of Darkness',4,20,NULL,0,'100:120',NULL,1,NULL,0x00818314,7,2,2,2,NULL,NULL,10,'bonus bCastrate,-5; bonus bMatkRate,15; bonus bInt,2;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (1642,'Staff_Of_Darkness','Staff Of Darkness',4,20,NULL,0,'100:120',NULL,1,NULL,0x00818314,7,2,2,2,NULL,NULL,10,'bonus bVariableCastrate,-5; bonus bMatkRate,15; bonus bInt,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1643,'Dead_Tree_Cane','Dead Tree Cane',4,20,NULL,100,'100:155',NULL,1,NULL,0x00818314,7,2,2,4,'70',1,10,'bonus bInt,4; if (getrefine()>5) { bonus bInt,getrefine()-5; bonus bMaxHP,-200; bonus bMaxSP,-100; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1644,'Piercing_Staff_M','Staff of Piercing',4,20,NULL,500,'80:145',NULL,1,NULL,0x00018314,2,2,2,3,'70',1,10,'bonus bInt,4; bonus bMatkRate,15; bonus bIgnoreMdefRate,10+getrefine();',NULL,NULL); REPLACE INTO `item_db_re` VALUES (1645,'Lich_Bone_Wand_M','Lich\'s Bone Wand',4,20,NULL,800,'60:170',NULL,1,2,0x00018314,2,2,2,3,'70',1,10,'bonus bInt,1; bonus bDex,1; bonus bAtkEle,Ele_Undead; bonus bMatkRate,20; bonus3 bAutoSpellWhenHit,"NPC_WIDECURSE",5,10+getrefine(); if(getrefine()>=9){ bonus bMatkRate,3; bonus bMaxSP,300; }',NULL,NULL); @@ -1177,7 +1177,7 @@ REPLACE INTO `item_db_re` VALUES (2012,'Aqua_Staff2','Aqua Staff II',4,20,NULL,9 REPLACE INTO `item_db_re` VALUES (2013,'Crimson_Staff2','Crimson Staff II',4,20,NULL,900,'30:270',NULL,1,1,0x00000200,7,2,34,4,'130',1,10,'bonus bAtkEle,Ele_Fire; bonus bInt,5; bonus2 bSkillAtk,"MG_FIREBOLT",30; bonus2 bSkillAtk,"MG_FIREBALL",30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2014,'Forest_Staff2','Forest Staff II',4,20,NULL,900,'30:270',NULL,1,1,0x00000200,7,2,34,4,'130',1,10,'bonus bAtkEle,Ele_Earth; bonus bInt,5; bonus2 bSkillAtk,"WZ_EARTHSPIKE",30; bonus2 bSkillAtk,"WZ_HEAVENDRIVE",30;',NULL,NULL); #2015, -REPLACE INTO `item_db_re` VALUES (2016,'Bellum_Arcwand','Bellum Arcwand',4,20,NULL,800,'110:220',NULL,1,NULL,0x00818314,7,2,34,4,'95',1,10,'bonus bUnbreakableWeapon,0; bonus2 bMagicAddRace,RC_DemiHuman,25; bonus bIgnoreMdefRate,25; if(getrefine()>5) { bonus2 bMagicAddRace,RC_DemiHuman,15; } if(getrefine()>8) { bonus bCastrate,-20; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2016,'Bellum_Arcwand','Bellum Arcwand',4,20,NULL,800,'110:220',NULL,1,NULL,0x00818314,7,2,34,4,'95',1,10,'bonus bUnbreakableWeapon,0; bonus2 bMagicAddRace,RC_DemiHuman,25; bonus bIgnoreMdefRate,25; if(getrefine()>5) { bonus2 bMagicAddRace,RC_DemiHuman,15; } if(getrefine()>8) { bonus bVariableCastrate,-20; }',NULL,NULL); # Shields # =================================================================== REPLACE INTO `item_db_re` VALUES (2101,'Guard','Guard',5,500,NULL,300,NULL,20,NULL,NULL,0xFFFFFFFF,7,2,32,NULL,NULL,1,1,NULL,NULL,NULL); @@ -1202,7 +1202,7 @@ REPLACE INTO `item_db_re` VALUES (2119,'Improved_Arm_Guard','Advanced Arm Guard' REPLACE INTO `item_db_re` VALUES (2120,'Improved_Arm_Guard_','Advanced Arm Guard',5,40000,NULL,150,NULL,45,NULL,1,0x02000000,7,2,32,NULL,'50',1,1,'bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2121,'Memorize_Book_','Memory Book',5,20,NULL,1000,NULL,25,NULL,1,0x00810204,7,2,32,NULL,NULL,1,5,'bonus bInt,1; bonus bMdef,2; if (isequipped(2717,2239)) { bonus bHPrecovRate,15; bonus bSPrecovRate,15; bonus bMatkRate,7; };',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2122,'Platinum_Shield','Platinum Shield',5,20,NULL,1200,NULL,95,NULL,NULL,0xFFFFFFFE,2,2,32,NULL,'68',1,4,'bonus bMdef,5; bonus2 bSubSize,1,15; bonus2 bSubSize,2,15; bonus2 bSubRace,RC_Undead,10; bonus5 bAutoSpellWhenHit,NPC_MAGICMIRROR,2,150,BF_MAGIC,0;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2123,'Orleans_Server','Orleans\'s Server',5,20,NULL,1000,NULL,75,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,4,'bonus bMdef,2; bonus bMagicDamageReturn,5; if (isequipped(2701)) bonus bCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2123,'Orleans_Server','Orleans\'s Server',5,20,NULL,1000,NULL,75,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,4,'bonus bMdef,2; bonus bMagicDamageReturn,5; if (isequipped(2701)) bonus bVariableCastrate,-10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2124,'Thorny_Buckler','Thorny Buckler',5,20,NULL,1000,NULL,85,NULL,1,0xFFFFFFFE,2,2,32,NULL,'55',1,2,'bonus bMdef,2; if (isequipped(2702)) { bonus bAspdRate,10; bonus bShortWeaponDamageReturn,5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2125,'Strong_Shield','Strong Shield',5,20,NULL,2500,NULL,90,NULL,1,0xFFFFFFFE,2,2,32,NULL,'75',1,4,'bonus bNoKnockback,0; bonus2 bSubEle,Ele_Neutral,-20; bonus2 bSubEle,Ele_Fire,-20; bonus2 bSubEle,Ele_Water,-20; bonus2 bSubEle,Ele_Wind,-20; bonus2 bSubEle,Ele_Earth,-20; bonus2 bSubEle,Ele_Dark,-20; bonus2 bSubEle,Ele_Holy,-20; bonus2 bSubEle,Ele_Ghost,-20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2126,'Guyak_Shield','Guyak Shield',5,20,NULL,700,NULL,3,NULL,NULL,0xFFFFFFFE,7,2,32,NULL,'1',1,2,'bonus bMdef,2; bonus bMagicDamageReturn,2; autobonus2 "{bonus bShortWeaponDamageReturn,5;}",20,1000,BF_WEAPON,"{specialeffect2 EF_REFLECTSHIELD;}";',NULL,NULL); @@ -1400,7 +1400,7 @@ REPLACE INTO `item_db_re` VALUES (2339,'G_Strings','Pantie',5,1000,NULL,100,NULL REPLACE INTO `item_db_re` VALUES (2340,'Novice_Breast','Novice Breastplate',5,89000,NULL,500,NULL,4,NULL,1,0x00000001,7,2,16,NULL,'10',1,0,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2341,'Full_Plate_Armor','Legion Plate Armor',5,94000,NULL,5500,NULL,79,NULL,NULL,0x00004000,7,2,16,NULL,'70',1,0,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2342,'Full_Plate_Armor_','Legion Plate Armor',5,102500,NULL,5500,NULL,79,NULL,1,0x00004000,7,2,16,NULL,'70',1,0,NULL,NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2343,'Robe_Of_Casting','Robe of Cast',5,124800,NULL,1100,NULL,40,NULL,NULL,0x00810200,7,2,16,NULL,'75',1,0,'bonus bCastrate,-3; bonus bMdef,4;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2343,'Robe_Of_Casting','Robe of Cast',5,124800,NULL,1100,NULL,40,NULL,NULL,0x00810200,7,2,16,NULL,'75',1,0,'bonus bVariableCastrate,-3; bonus bMdef,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2344,'Flame_Sprits_Armor','Lucius\'s Fierce Armor of Volcano',5,136000,NULL,2200,NULL,25,NULL,NULL,0x000444A2,7,2,16,NULL,'45',1,0,'bonus bDefEle,Ele_Fire;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2345,'Flame_Sprits_Armor_','Lucius\'s Fierce Armor of Volcano',5,136000,NULL,2200,NULL,25,NULL,1,0xFFFFFFFE,7,2,16,NULL,'45',1,0,'bonus bDefEle,Ele_Fire;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2346,'Water_Sprits_Armor','Saphien\'s Armor of Ocean',5,136000,NULL,2200,NULL,25,NULL,NULL,0x000444A2,7,2,16,NULL,'45',1,0,'bonus bDefEle,Ele_Water;',NULL,NULL); @@ -1417,12 +1417,12 @@ REPLACE INTO `item_db_re` VALUES (2356,'Vestment_Of_Grace','Blessed Holy Robe',5 REPLACE INTO `item_db_re` VALUES (2357,'Valkyrie_Armor','Valkyrian Armor',5,NULL,NULL,2800,NULL,55,NULL,1,0xFFFFFFFE,2,2,16,NULL,'1',1,0,'bonus bAllStats,1; bonus bUnbreakableArmor,0; 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;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2358,'Dress_Of_Angel','Angel\'s Dress',5,20,NULL,1000,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,16,NULL,'1',NULL,0,'bonus bLuk,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2359,'Ninja_Suit_','Ninja Suit',5,20,NULL,1500,NULL,58,NULL,1,0x02021040,7,2,16,NULL,'50',1,0,'bonus bAgi,1; bonus bMdef,3;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2360,'Robe_Of_Casting_','Robe of Cast',5,124800,NULL,1100,NULL,40,NULL,1,0x00810200,7,2,16,NULL,'75',1,0,'bonus bCastrate,-3; bonus bMdef,4;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2360,'Robe_Of_Casting_','Robe of Cast',5,124800,NULL,1100,NULL,40,NULL,1,0x00810200,7,2,16,NULL,'75',1,0,'bonus bVariableCastrate,-3; bonus bMdef,4;',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (2361,'Blue_Aodai','Blue Robe',5,20,NULL,500,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,16,NULL,'1',1,0,'bonus bAllStats,3; bonus bMdef,5;',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (2362,'Red_Aodai','Red Robe',5,20,NULL,500,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,16,NULL,'1',1,0,'bonus bAllStats,3; bonus bMdef,5;',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (2363,'White_Aodai','White Robe',5,20,NULL,500,NULL,NULL,NULL,NULL,0x00000001,7,2,16,NULL,'1',1,0,'bonus bAllStats,3; bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2364,'Meteo_Plate_Armor','Meteo Plate Armor',5,20,NULL,3000,NULL,85,NULL,1,0x000444A2,2,2,16,NULL,'55',1,0,'bonus2 bResEff,Eff_Stun,3000; bonus2 bResEff,Eff_Freeze,3000;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2365,'Orleans_Gown','Orleans\'s Gown',5,20,NULL,300,NULL,15,NULL,1,0xFFFFFFFE,2,2,16,NULL,'55',1,0,'bonus bCastrate,15; bonus bNoCastCancel,0;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2365,'Orleans_Gown','Orleans\'s Gown',5,20,NULL,300,NULL,15,NULL,1,0xFFFFFFFE,2,2,16,NULL,'55',1,0,'bonus bVariableCastrate,15; bonus bNoCastCancel,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2366,'Divine_Cloth','Divine Cloth',5,20,NULL,1500,NULL,50,NULL,1,0xFFFFFFFE,2,2,16,NULL,'55',1,0,'bonus2 bResEff,Eff_Curse,500; bonus2 bResEff,Eff_Silence,500; bonus2 bResEff,Eff_Stun,500; bonus2 bResEff,Eff_Stone,500; bonus2 bResEff,Eff_Sleep,500;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2367,'Sniping_Suit','Sniping Suit',5,20,NULL,750,NULL,42,NULL,1,0x00000800,2,2,16,NULL,'50',1,0,'bonus bMdef,5; bonus bCritical,6+(readparam(bLuk)/10); bonus bDelayRate,-23;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2368,'Golden_Armor','Golden Armor',5,20,NULL,2000,NULL,4,NULL,NULL,0xFFFFFFFF,7,2,16,NULL,NULL,NULL,0,'bonus bMdef,4;',NULL,NULL); @@ -1775,7 +1775,7 @@ REPLACE INTO `item_db_re` VALUES (2727,'Bowman_Scarf','Bowman Scarf',5,20,NULL,2 REPLACE INTO `item_db_re` VALUES (2728,'Cursed_Hand','Cursed Hand',5,20,NULL,50,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,136,NULL,'80',NULL,0,'bonus3 bAutoSpell,"NPC_CRITICALWOUND",1,30; bonus bHit,10; bonus bHPrecovRate,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2729,'Diabolus_Ring','Diabolus Ring',5,20,NULL,50,NULL,NULL,NULL,1,0x00CFFF80,2,2,136,NULL,NULL,NULL,0,'bonus bMaxHP,100; bonus bMaxSP,100; bonus bHealPower,5; bonus2 bAddDamageClass,1916,10; bonus2 bAddDamageClass,1917,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2730,'Morroc_Seal','Seal of Continental Guard',5,20,NULL,50,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,136,NULL,'80',NULL,0,'bonus bMaxHP,50; bonus bAspdRate,3;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2731,'Morroc_Charm_Stone','Rune Spellstone',5,20,NULL,50,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,136,NULL,'80',NULL,0,'bonus bMaxSP,50; bonus bCastRate,-1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2731,'Morroc_Charm_Stone','Rune Spellstone',5,20,NULL,50,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,136,NULL,'80',NULL,0,'bonus bMaxSP,50; bonus bVariableCastrate,-1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2732,'Morroc_Ring','Death Loop',5,20,NULL,50,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,136,NULL,'80',NULL,0,'bonus bCritical,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2733,'Medal_Gunner','Sheriff Badge',5,20,NULL,0,NULL,1,NULL,NULL,0x01000000,7,2,136,NULL,'70',NULL,0,'bonus2 bAddRace,RC_NonBoss,5; bonus2 bAddRace,RC_Boss,5; bonus bMatkRate,5; bonus bCritical,10; bonus bMaxHP,300; bonus bMaxSP,80; bonus3 bAddEff,Eff_Blind,1000,ATF_LONG;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2734,'Directive_A','Directive',5,NULL,NULL,0,NULL,1,NULL,NULL,0x00000001,7,2,136,NULL,NULL,NULL,0,NULL,NULL,NULL); @@ -1785,10 +1785,10 @@ REPLACE INTO `item_db_re` VALUES (2737,'Foot_Ring','Foot Ring',5,20,NULL,150,NUL REPLACE INTO `item_db_re` VALUES (2738,'Shiny_Coin','Shiny Coin',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus2 bAddRace,RC_NonBoss,6; bonus2 bAddRace,RC_Boss,6; bonus bMatkRate,6;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2739,'Ordinary_Coin','Ordinary Coin',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus2 bAddRace,RC_NonBoss,5; bonus2 bAddRace,RC_Boss,5; bonus bMatkRate,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2740,'Rusty_Coin','Rusty Coin',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus2 bAddRace,RC_NonBoss,3; bonus2 bAddRace,RC_Boss,3; bonus bMatkRate,3;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2741,'All_In_One_Ring','All In One Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bAllStats,1; bonus bNoCastCancel,0; bonus bCastRate,10; skill "AL_HEAL",1; skill "AL_TELEPORT",1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2741,'All_In_One_Ring','All In One Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bAllStats,1; bonus bNoCastCancel,0; bonus bVariableCastrate,10; skill "AL_HEAL",1; skill "AL_TELEPORT",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2742,'Lucky_Clip','Lucky Clip',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2743,'Angelic_Ring','Angelic Ring',5,20,NULL,100,NULL,NULL,NULL,NULL,0x00CFFF80,2,2,136,NULL,'70',NULL,0,'bonus bInt,2; bonus bDex,1; bonus bMdef,2; autobonus3 "{bonus bHealPower,20;}",50,3000,"AL_HEAL"; autobonus3 "{bonus bHealPower,20;}",50,3000,"AM_POTIONPITCHER"; autobonus3 "{bonus bHealPower,20;}",50,3000,"PR_SANCTUARY";',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2744,'Sprint_Ring','Sprint Ring',5,20,NULL,100,NULL,NULL,NULL,NULL,0x00CFFF80,2,2,136,NULL,'70',NULL,0,'bonus bCastrate,-10; bonus bDelayRate,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2744,'Sprint_Ring','Sprint Ring',5,20,NULL,100,NULL,NULL,NULL,NULL,0x00CFFF80,2,2,136,NULL,'70',NULL,0,'bonus bVariableCastrate,-10; bonus bDelayRate,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2745,'Pinguicula_Corsage','Pinguicula Corsage',5,20,NULL,200,NULL,NULL,NULL,1,0x00CFFF80,2,2,136,NULL,'70',NULL,0,'bonus bMdef,2; bonus bMaxSP,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2746,'Cold_Heart','Cold Heart',5,20,NULL,100,NULL,1,NULL,NULL,0x00001000,2,2,136,NULL,'80',NULL,0,'bonus bAgi,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2747,'Black_Cat','Black Cat',5,20,NULL,100,NULL,1,NULL,NULL,0x00020000,2,2,136,NULL,'80',NULL,0,'bonus bDex,3;',NULL,NULL); @@ -1816,7 +1816,7 @@ REPLACE INTO `item_db_re` VALUES (2768,'Mage_Figure','Mage Figure',5,NULL,NULL,0 REPLACE INTO `item_db_re` VALUES (2769,'Archer_Figure','Archer Figure',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bDex,1; if(Class==Job_Archer) bonus bBaseAtk,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2770,'Thief_Figure','Thief Figure',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bAgi,1; if(Class==Job_Thief) bonus bAspdRate,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2771,'Merchant_Figure','Merchant Figure',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bStr,1; if(Class==Job_Merchant) bonus bCritical,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2772,'Krieger_Ring1','Glorious Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'81',NULL,0,'bonus bMaxHP,300; bonus2 bSubEle,Ele_Water,10; bonus2 bSubEle,Ele_Wind,10; bonus2 bSubEle,Ele_Earth,10; bonus2 bSubEle,Ele_Fire,10; bonus bAspdRate,5; bonus bCastrate,-3; bonus bHealPower,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2772,'Krieger_Ring1','Glorious Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'81',NULL,0,'bonus bMaxHP,300; bonus2 bSubEle,Ele_Water,10; bonus2 bSubEle,Ele_Wind,10; bonus2 bSubEle,Ele_Earth,10; bonus2 bSubEle,Ele_Fire,10; bonus bAspdRate,5; bonus bVariableCastrate,-3; bonus bHealPower,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2773,'Krieger_Ring2','Glorious Mass-Production Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'61',NULL,0,'bonus bAllStats,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2774,'Krieger_Ring3','Glorious Popularized Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,NULL,NULL,0,'bonus bAllStats,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2775,'Lure','Lure',5,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,NULL,NULL,NULL); @@ -1878,7 +1878,7 @@ REPLACE INTO `item_db_re` VALUES (2830,'Magingiorde_C','Megingjard',5,20,NULL,0, REPLACE INTO `item_db_re` VALUES (2831,'Brysinggamen_C','Brisingamen',5,20,NULL,0,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,'94',NULL,0,'bonus bStr,6; bonus bInt,6; bonus bVit,6; bonus bAgi,6; bonus bLuk,10; bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2832,'Freyja_Ring','Freyja\'s Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,'1',NULL,0,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (2833,'Odin\'s_Recall','Odin\'s Recall',5,NULL,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,'1',NULL,0,'bonus bAllStats,1;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2834,'F_All_In_One_Ring','All In One Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bAllStats,1; bonus bNoCastCancel,0; bonus bCastRate,10; skill "AL_HEAL",1; skill "AL_TELEPORT",1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2834,'F_All_In_One_Ring','All In One Ring',5,20,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,NULL,NULL,0,'bonus bAllStats,1; bonus bNoCastCancel,0; bonus bVariableCastrate,10; skill "AL_HEAL",1; skill "AL_TELEPORT",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2835,'F_Critical_Ring_C','Critical Ring',5,1,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'1',NULL,0,'bonus bCritical,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2836,'F_Glove_C','Glove',5,1,NULL,0,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'1',NULL,0,'bonus bDex,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (2837,'F_Safety_Ring_C','Safety Ring',5,1,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFE,7,2,136,NULL,'1',NULL,0,'bonus bMdef,5;',NULL,NULL); @@ -1928,7 +1928,7 @@ REPLACE INTO `item_db_re` VALUES (2894,'Sura_Gauntlet','Sura Gauntlet',5,20,NULL #2896, #2897, REPLACE INTO `item_db_re` VALUES (2898,'Dark_Rosary','Dark Rosary',5,20,NULL,100,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,136,NULL,'90',NULL,0,'bonus bMdef,15;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (2899,'Sound_Amplification_Device','Sound Amplification Device',5,20,NULL,100,NULL,NULL,NULL,1,0x00080800,7,2,136,NULL,'90',NULL,0,' bonus2 bSkillAtk,"WM_METALICSOUND",25; bonus bCastrate,-50;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (2899,'Sound_Amplification_Device','Sound Amplification Device',5,20,NULL,100,NULL,NULL,NULL,1,0x00080800,7,2,136,NULL,'90',NULL,0,' bonus2 bSkillAtk,"WM_METALICSOUND",25; bonus bVariableCastrate,-50;',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (2907,'Bawaya_Symbol_Tattoo','Bawaya Symbol Tattoo',5,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,136,NULL,'1',NULL,0,'bonus bMatkRate,7; bonus bFixedCastrate,-7;',NULL,NULL); #2908, @@ -2013,7 +2013,7 @@ REPLACE INTO `item_db_re` VALUES (4073,'Pirate_Skel_Card','Pirate Skeleton Card' REPLACE INTO `item_db_re` VALUES (4074,'BigFoot_Card','Bigfoot Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubRace,RC_Insect,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4075,'Argos_Card','Argos Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bResEff,Eff_Stone,2000; bonus bDef,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4076,'Magnolia_Card','Magnolia Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddEff,Eff_Curse,500; bonus bBaseAtk,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4077,'Phen_Card','Phen Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bNoCastCancel,0; bonus bCastrate,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4077,'Phen_Card','Phen Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bNoCastCancel,0; bonus bVariableCastrate,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4078,'Savage_Card','Savage Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bVit,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4079,'Mantis_Card','Mantis Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bStr,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4080,'Flora_Card','Flora Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bAddRace,RC_Fish,20;',NULL,NULL); @@ -2081,7 +2081,7 @@ REPLACE INTO `item_db_re` VALUES (4141,'Evil_Druid_Card','Evil Druid Card',6,20, REPLACE INTO `item_db_re` VALUES (4142,'Doppelganger_Card','Doppelganger Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bAspdRate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4143,'Orc_Hero_Card','Orc Hero Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bVit,3; bonus2 bResEff,Eff_Stun,10000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4144,'Osiris_Card','Osiris Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bRestartFullRecover,0;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4145,'Berzebub_Card','Berzebub Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bCastrate,-30;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4145,'Berzebub_Card','Berzebub Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bVariableCastrate,-30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4146,'Maya_Card','Maya Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus bMagicDamageReturn,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4147,'Baphomet_Card','Baphomet Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bHit,-10; bonus bSplashRange,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4148,'Pharaoh_Card','Pharaoh Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bUseSPrate,-30;',NULL,NULL); @@ -2105,7 +2105,7 @@ REPLACE INTO `item_db_re` VALUES (4165,'Gig_Card','Gig Card',6,20,NULL,10,NULL,N REPLACE INTO `item_db_re` VALUES (4166,'Nightmare_Terror_Card','Nightmare Terror Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus2 bAddEffWhenHit,Eff_Curse,300;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4167,'Neraid_Card','Nereid Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bSPGainRace,RC_Brute,5;',NULL,'heal 0,-5;'); REPLACE INTO `item_db_re` VALUES (4168,'Dark_Lord_Card','Dark Lord Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL,NULL,NULL,'bonus3 bAutoSpellWhenHit,"WZ_METEOR",5,100;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4169,'Dark_Illusion_Card','Dark Illusion Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bMaxHPrate,-10; bonus bMaxSPrate,-10; bonus bCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4169,'Dark_Illusion_Card','Dark Illusion Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bMaxHPrate,-10; bonus bMaxSPrate,-10; bonus bVariableCastrate,-10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4170,'Dark_Frame_Card','Dark Frame Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus2 bAddEffWhenHit,Eff_Stone,600;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4171,'Dark_Priest_Card','Dark Priest Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bSPVanishRate,50,10; if(BaseJob==Job_Sage) bonus bSPDrainValue,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4172,'The_Paper_Card','The Paper Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bCritAtkRate,20; bonus2 bSPDrainValue,-1,0;',NULL,NULL); @@ -2165,7 +2165,7 @@ REPLACE INTO `item_db_re` VALUES (4225,'Stone_Shooter_Card','Stone Shooter Card' REPLACE INTO `item_db_re` VALUES (4226,'Sting_Card','Sting Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus bDef,2; if(getrefine()>8) bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4227,'Spring_Rabbit_Card','Spring Rabbit Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddItemHealRate,IG_Meat,50; bonus3 bAddMonsterDropItem,517,RC_Brute,200; bonus3 bAddMonsterDropItem,528,RC_Brute,200;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4228,'Sleeper_Card','Sleeper Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus3 bAddMonsterDropItem,12031,RC_Fish,100;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4229,'C_Tower_Manager_Card','Tower Keeper Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,1; bonus bCastrate,-5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4229,'C_Tower_Manager_Card','Tower Keeper Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,1; bonus bVariableCastrate,-5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4230,'Shinobi_Card','Shinobi Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bAgi,1; bonus3 bAutoSpellWhenHit,"AS_CLOAKING",5,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4231,'Increase_Soil_Card','Mi Gao Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubRace2,5,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4232,'Wild_Ginseng_Card','Hermit Plant Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddItemHealRate,IG_Herb,50; bonus3 bAddMonsterDropItem,507,RC_Plant,300; bonus3 bAddMonsterDropItem,508,RC_Plant,200; bonus3 bAddMonsterDropItem,509,RC_Plant,100;',NULL,NULL); @@ -2263,7 +2263,7 @@ REPLACE INTO `item_db_re` VALUES (4323,'Garm_Baby_Card','Hatii Babe Card',6,20,N REPLACE INTO `item_db_re` VALUES (4324,'Garm_Card','Hatii Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus2 bAddEffWhenHit,Eff_Freeze,5000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4325,'Harpy_Card','Harpy Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus2 bSubEle,Ele_Neutral,15; bonus2 bSkillAtk,"MG_NAPALMBEAT",5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4326,'See_Otter_Card','Sea-Otter Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddItemHealRate,IG_Fish,50; bonus3 bAddMonsterDropItem,551,RC_Fish,300; bonus3 bAddMonsterDropItem,544,RC_Fish,300;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4327,'Blood_Butterfly_Card','Bloody Butterfly Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bCastrate,30; bonus bNoCastCancel,0; bonus2 bSkillAtk,18,5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4327,'Blood_Butterfly_Card','Bloody Butterfly Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus bVariableCastrate,30; bonus bNoCastCancel,0; bonus2 bSkillAtk,18,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4328,'Hyegun_Card','Yao Jun Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus bFlee,15; bonus bCritical,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4329,'Phendark_Card','Phendark Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bSPGainRace,RC_DemiHuman,5;',NULL,'heal 0,-5;'); REPLACE INTO `item_db_re` VALUES (4330,'Dark_Snake_Lord_Card','Evil Snake Lord Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,3; bonus2 bResEff,Eff_Blind,10000; bonus2 bResEff,Eff_Curse,10000;',NULL,NULL); @@ -2301,13 +2301,13 @@ REPLACE INTO `item_db_re` VALUES (4361,'B_Harword_Card','MasterSmith Card',6,20, REPLACE INTO `item_db_re` VALUES (4362,'Harword_Card','Howard Alt-Eisen Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bAspdRate,-5; bonus bHit,30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4363,'B_Magaleta_Card','High Priest Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus5 bAutoSpellWhenHit,"HP_ASSUMPTIO",5,50,BF_WEAPON|BF_MAGIC,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4364,'Magaleta_Card','Margaretha Sorin Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,1; bonus5 bAutoSpellWhenHit,"PR_LEXDIVINA",5,150,BF_MAGIC,1;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4365,'B_Katrinn_Card','High Wizard Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bIgnoreMDefRace,RC_NonBoss; bonus bCastrate,100; bonus bSPrecovRate,-100;',NULL,'heal 0,-2000;'); -REPLACE INTO `item_db_re` VALUES (4366,'Katrinn_Card','Kathryne Keyron Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bCastrate,getrefine()*-1; if(getrefine()>=9) { bonus bMatkRate,2; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4365,'B_Katrinn_Card','High Wizard Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bIgnoreMDefRace,RC_NonBoss; bonus bVariableCastrate,100; bonus bSPrecovRate,-100;',NULL,'heal 0,-2000;'); +REPLACE INTO `item_db_re` VALUES (4366,'Katrinn_Card','Kathryne Keyron Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bVariableCastrate,getrefine()*-1; if(getrefine()>=9) { bonus bMatkRate,2; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4367,'B_Shecil_Card','Sniper Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus2 bHpDrainRate,50,20; bonus bHPrecovRate,-10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4368,'Shecil_Card','Cecil Damon Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,'bonus bAspdRate,5; bonus bHit,-30;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4369,'Venatu_Card','Venatu Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bLuk,readparam(bAgi)/18;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4370,'Dimik_Card','Dimik Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bVit,getrefine()-5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4371,'Archdam_Card','Archdam Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,10; bonus bCastrate,20;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4371,'Archdam_Card','Archdam Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,10; bonus bVariableCastrate,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4372,'Bacsojin_Card','White Lady Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bHealPower,30; bonus bUseSPrate,15;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4373,'Chung_E_Card','Green Maiden Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL,NULL,NULL,NULL,'bonus bLuk,getrefine()-5; bonus bCritical,getrefine();',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4374,'Apocalips_H_Card','Vesper Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bDex,2; bonus2 bIgnoreMdefRate,RC_Boss,30;',NULL,NULL); @@ -2348,7 +2348,7 @@ REPLACE INTO `item_db_re` VALUES (4408,'Gloom_Under_Night_Card','Gloom Under Nig REPLACE INTO `item_db_re` VALUES (4409,'Agav_Card','Agav Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bMatkRate,5; bonus bDef,-10; if(BaseClass==Job_Mage) bonus bMaxSP,100;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4410,'Echio_Card','Echio Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,15; if(BaseClass==Job_Swordman) bonus bMaxHP,500;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4411,'Vanberk_Card','Vanberk Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bStr,2; autobonus "{bonus bCritical,100;}",5,5000,0,"{specialeffect2 EF_ENHANCE;}";',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4412,'Isilla_Card','Isilla Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,2; autobonus "{bonus bCastrate,-50; bonus bFlee,30;}",50,5000,BF_MAGIC,"{specialeffect2 EF_SUFFRAGIUM;}";',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4412,'Isilla_Card','Isilla Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,769,NULL,NULL,NULL,NULL,'bonus bInt,2; autobonus "{bonus bVariableCastrate,-50; bonus bFlee,30;}",50,5000,BF_MAGIC,"{specialeffect2 EF_SUFFRAGIUM;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4413,'Hodremlin_Card','Hodremlin Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'bonus2 bSubSize,0,15; bonus2 bSubSize,1,15; bonus2 bSubSize,2,15; autobonus2 "{bonus bFlee2,30;}",3,10000,BF_WEAPON|BF_MAGIC,"{specialeffect2 EF_WIND;}";',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4414,'Seeker_Card','Seeker Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,32,NULL,NULL,NULL,NULL,'skill "MG_STONECURSE",1; bonus2 bResEff,Eff_Stone,3000; bonus bMdef,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4415,'Snowier_Card','Snowier Card',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,136,NULL,NULL,NULL,NULL,'bonus2 bAddMonsterDropItem,536,2000; bonus2 bAddItemHealRate,536,100;',NULL,NULL); @@ -2558,10 +2558,10 @@ REPLACE INTO `item_db_re` VALUES (4808,'Fighting_Lv4','Fighting Lv4',6,20,NULL,1 REPLACE INTO `item_db_re` VALUES (4809,'Fighting_Lv3','Fighting Lv3',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,12; bonus bHit,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4810,'Fighting_Lv2','Fighting Lv2',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,9; bonus bHit,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4811,'Fighting_Lv1','Fighting Lv1',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,6; bonus bHit,2;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4812,'Force_Lv4','Force Lv4',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,15; bonus bCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4813,'Force_Lv3','Force Lv3',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,12; bonus bCastrate,-8;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4814,'Force_Lv2','Force Lv2',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,9; bonus bCastrate,-6;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4815,'Force_Lv1','Force Lv1',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,6; bonus bCastrate,-4;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4812,'Force_Lv4','Force Lv4',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,15; bonus bVariableCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4813,'Force_Lv3','Force Lv3',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,12; bonus bVariableCastrate,-8;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4814,'Force_Lv2','Force Lv2',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,9; bonus bVariableCastrate,-6;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4815,'Force_Lv1','Force Lv1',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,6; bonus bVariableCastrate,-4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4816,'Sharp_Lv3','Sharp Lv3',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bCritical,12; bonus bHit,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4817,'Sharp_Lv2','Sharp Lv2',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bCritical,9; bonus bHit,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4818,'Sharp_Lv1','Sharp Lv1',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bCritical,6; bonus bHit,2;',NULL,NULL); @@ -2572,12 +2572,12 @@ REPLACE INTO `item_db_re` VALUES (4822,'Fighting_Lv7','Fighting Lv7',6,20,NULL,1 REPLACE INTO `item_db_re` VALUES (4823,'Fighting_Lv8','Fighting Lv8',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,27; bonus bHit,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4824,'Fighting_Lv9','Fighting Lv9',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,30; bonus bHit,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4825,'Fighting_Lv10','Fighting Lv10',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bBaseAtk,50; bonus bHit,15;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4826,'Force_Lv5','Force Lv5',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,18; bonus bCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4827,'Force_Lv6','Force Lv6',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,21; bonus bCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4828,'Force_Lv7','Force Lv7',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,24; bonus bCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4829,'Force_Lv8','Force Lv8',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,27; bonus bCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4830,'Force_Lv9','Force Lv9',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,30; bonus bCastrate,-10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (4831,'Force_Lv10','Force Lv10',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,50; bonus bCastrate,-20;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4826,'Force_Lv5','Force Lv5',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,18; bonus bVariableCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4827,'Force_Lv6','Force Lv6',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,21; bonus bVariableCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4828,'Force_Lv7','Force Lv7',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,24; bonus bVariableCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4829,'Force_Lv8','Force Lv8',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,27; bonus bVariableCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4830,'Force_Lv9','Force Lv9',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,30; bonus bVariableCastrate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (4831,'Force_Lv10','Force Lv10',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,' bonus bEquipmentMatk,50; bonus bVariableCastrate,-20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4832,'Archer_Lv1','Archer Lv1',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bLongAtkRate,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4833,'Archer_Lv2','Archer Lv2',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bLongAtkRate,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (4834,'Archer_Lv3','Archer Lv3',6,20,NULL,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,16,NULL,NULL,NULL,NULL,'bonus bLongAtkRate,6;',NULL,NULL); @@ -2746,7 +2746,7 @@ REPLACE INTO `item_db_re` VALUES (5134,'Pumpkin_Hat','Pumpkin-Head',5,20,NULL,20 REPLACE INTO `item_db_re` VALUES (5135,'Cyclops_Visor','Cyclop\'s Eye',5,NULL,NULL,200,NULL,NULL,NULL,NULL,0xFFFFFFFE,7,2,512,NULL,'75',NULL,207,'bonus bMaxSP,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5136,'Santa\'s_Hat_','Antonio\'s Santa Hat',5,20,NULL,100,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,20,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5137,'Alice_Doll','Alice Doll',5,20,NULL,500,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,256,NULL,'30',NULL,208,'bonus bStr,1; bonus2 bAddRace,RC_DemiHuman,10; bonus2 bAddEff2,Eff_Sleep,10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5138,'Magic_Eyes','Magic Eyes',5,20,NULL,300,NULL,1,NULL,NULL,0x00810204,7,2,256,NULL,'30',1,209,'bonus bMdef,5; bonus bCastrate,-10; bonus bUseSPrate,20;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5138,'Magic_Eyes','Magic Eyes',5,20,NULL,300,NULL,1,NULL,NULL,0x00810204,7,2,256,NULL,'30',1,209,'bonus bMdef,5; bonus bVariableCastrate,-10; bonus bUseSPrate,20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5139,'Hibiscus','Hibiscus',5,20,NULL,200,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'10',NULL,210,'bonus bDex,1; bonus bInt,1; bonus bMdef,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5140,'Charming_Ribbon','Charming Ribbon',5,20,NULL,400,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,'10',1,211,'bonus2 bSubRace,RC_Undead,5; bonus2 bSubRace,RC_Demon,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5141,'Marionette_Doll','Marionette Doll',5,20,NULL,400,NULL,NULL,NULL,1,0xFFFFFFFE,7,2,256,NULL,'30',1,212,'bonus bStr,1;',NULL,NULL); @@ -2818,7 +2818,7 @@ REPLACE INTO `item_db_re` VALUES (5206,'Romantic_White_Flower','Romantic White F REPLACE INTO `item_db_re` VALUES (5207,'Gold_Spirit_Chain','Angel Blessing',5,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,260,'bonus bLuk,1; bonus2 bSubEle,Ele_Holy,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5208,'Rideword_Hat','Rideword Hat',5,20,NULL,300,NULL,2,NULL,1,0xFFFFFFFE,7,2,256,NULL,'40',1,262,'bonus2 bHPDrainRate,50,8; bonus2 bSPDrainRate,10,4; bonus2 bHPLossRate,10,5000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5209,'Yellow_Baseball_Cap','Love Dad Cap',5,20,NULL,300,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,263,NULL,NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5210,'Flying_Angel','Flapping Angel Wing',5,20,NULL,300,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'10',1,264,'bonus bCastrate,-3; bonus bAspdRate,3; bonus bInt,1; bonus bAgi,1;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5210,'Flying_Angel','Flapping Angel Wing',5,20,NULL,300,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'10',1,264,'bonus bVariableCastrate,-3; bonus bAspdRate,3; bonus bInt,1; bonus bAgi,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5211,'Dress_Hat','Dress Hat',5,NULL,NULL,200,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'20',1,265,'bonus bMdef,7; bonus bStr,1; bonus bInt,1; bonus2 bAddRace,RC_NonBoss,2; bonus2 bAddRace,RC_Boss,2; bonus bMAtkRate,2; bonus bHealPower,5; if(getrefine()>=7) { bonus2 bAddRace,RC_NonBoss,1; bonus2 bAddRace,RC_Boss,1; bonus bMAtkRate,1; bonus bHealPower,1; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5212,'Satellite_Hairband','Satellite Hairband',5,NULL,NULL,1000,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',1,266,'bonus bMaxHP,50; bonus bMaxSP,10; skill "AL_RUWACH",1;',NULL,'sc_end SC_RUWACH;'); REPLACE INTO `item_db_re` VALUES (5213,'Black_Bunny_Band','Sheila Hairnet',5,NULL,NULL,200,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',1,267,'bonus bAgi,2; bonus bMdef,3;',NULL,NULL); @@ -2834,7 +2834,7 @@ REPLACE INTO `item_db_re` VALUES (5222,'Fish_On_Head_','Evolved Blue Fish',5,20, REPLACE INTO `item_db_re` VALUES (5223,'Big_Golden_Bell_','Evolved Big Golden Bell',5,20,NULL,200,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,768,NULL,'35',1,175,'bonus bAgi,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5224,'Orc_Hero_Helm_TW','Evolved Orc Hero Helm',5,500000,NULL,900,NULL,5,NULL,NULL,0xFFFFFFFE,7,2,768,NULL,'55',1,178,'bonus bStr,2; bonus bVit,1; bonus bMaxHPrate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5225,'Marcher_Hat','Parade Hat',5,20,NULL,200,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'10',1,269,'bonus bMdef,2; bonus bStr,2; bonus4 bAutoSpellWhenHit,"AL_ANGELUS",5,30,0; bonus4 bAutoSpellWhenHit,"HP_ASSUMPTIO",1,1,0; bonus2 bResEff,Eff_Stun,1000; if(BaseClass==Job_Acolyte) bonus4 bAutoSpellOnSkill,"AL_HEAL","PR_LEXAETERNA",1,1000;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5226,'Mini_Propeller_','Mini Propeller',5,20,NULL,200,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,270,'bonus bAgi,2; bonus bDex,1; bonus bFlee,10; bonus bCastrate,-getrefine();',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5226,'Mini_Propeller_','Mini Propeller',5,20,NULL,200,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,270,'bonus bAgi,2; bonus bDex,1; bonus bFlee,10; bonus bVariableCastrate,-getrefine();',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5227,'Red_Deviruchi_Cap','Red Deviruchi Hat',5,20,NULL,800,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'64',1,271,'bonus bStr,1; bonus bInt,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5228,'White_Deviruchi_Cap','Gray Deviruchi Hat',5,20,NULL,800,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'64',1,272,'bonus bStr,1; bonus bInt,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5229,'Gray_Deviruchi_Cap','Brown Deviruchi Hat',5,20,NULL,800,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'64',1,273,'bonus bStr,1; bonus bInt,1;',NULL,NULL); @@ -2894,7 +2894,7 @@ REPLACE INTO `item_db_re` VALUES (5282,'euRO_Baseball_Cap','Europe Baseball Cap' REPLACE INTO `item_db_re` VALUES (5283,'Chick_Hat','Chick Hat',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'10',NULL,311,'bonus bLuk,2; bonus bMaxHP,50; bonus bMaxSP,50; skill "TF_DOUBLE",2; bonus bDoubleRate,10; bonus2 bSubRace,RC_DemiHuman,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5284,'Water_Lily_Crown','Water Lily Crown',5,20,NULL,200,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',NULL,312,'bonus bDex,1; bonus bAgi,1; bonus bHPrecovRate,5; bonus bSPrecovRate,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5285,'Vane_Hairpin','Vane Hairpin',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',NULL,313,'bonus bAgi,2;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5286,'Pecopeco_Hairband','Pecopeco Hairband',5,20,NULL,0,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'70',NULL,314,'bonus bSpeedRate,25; bonus bAspdRate,-10; bonus bCastrate,25;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5286,'Pecopeco_Hairband','Pecopeco Hairband',5,20,NULL,0,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'70',NULL,314,'bonus bSpeedRate,25; bonus bAspdRate,-10; bonus bVariableCastrate,25;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5287,'Vacation_Hat','Vacation Hat',5,20,NULL,200,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',NULL,315,'bonus bVit,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5288,'Red_Glasses','Red Glasses',5,20,NULL,0,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,NULL,NULL,316,'bonus bInt,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5289,'Vanilmirth_Hat','Vanilmirth Hat',5,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'30',NULL,317,'bonus bUnbreakableHelm,0; bonus3 bAutoSpell,"MG_FIREBOLT",1,10; bonus3 bAutoSpell,"MG_COLDBOLT",1,10; bonus3 bAutoSpell,"MG_LIGHTNINGBOLT",1,10; bonus bMdef,5;',NULL,NULL); @@ -2921,7 +2921,7 @@ REPLACE INTO `item_db_re` VALUES (5309,'Mahican','Wool Mask',5,20,NULL,200,NULL, REPLACE INTO `item_db_re` VALUES (5310,'Bulb_Hairband','Shining Electric Bulb Hairband',5,20,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,332,'bonus2 bSubEle,Ele_Dark,10; skill "MG_SIGHT",1;',NULL,'sc_end SC_SIGHT;'); REPLACE INTO `item_db_re` VALUES (5311,'Large_Hibiscus','Large Hisbiscus',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,333,'bonus bMdef,15;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5312,'Ayothaya_Hat','Ayothaya King\'s Hat',5,20,NULL,100,NULL,5,NULL,1,0x000654E2,7,2,256,NULL,NULL,1,334,'bonus bStr,1; bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5313,'Diadem','Diadem',5,20,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,768,NULL,NULL,1,335,'bonus bInt,1; bonus bMatkRate,3; bonus bCastrate,-3;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5313,'Diadem','Diadem',5,20,NULL,100,NULL,3,NULL,1,0xFFFFFFFF,7,2,768,NULL,NULL,1,335,'bonus bInt,1; bonus bMatkRate,3; bonus bVariableCastrate,-3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5314,'Hockey_Mask','Hockey Mask',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,513,NULL,'50',NULL,336,'bonus2 bAddRace,RC_DemiHuman,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5315,'Observer','Observer',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'35',NULL,337,'skill "WZ_ESTIMATION",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5316,'Umbrella_Hat','Umbrella Hat',5,20,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'50',1,338,'bonus2 bSubEle,Ele_Water,3;',NULL,NULL); @@ -2962,8 +2962,8 @@ REPLACE INTO `item_db_re` VALUES (5350,'Pirate_Bandana_','Pirate Bandana',5,20,N REPLACE INTO `item_db_re` VALUES (5351,'Sunflower_','Sunflower',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,37,'bonus2 bSubRace,RC_Insect,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5352,'Poporing_Cap','Poporing Cap',5,20,NULL,700,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'38',1,361,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5353,'Helm_Of_Sun_','Hat of the Sun God',5,20,NULL,2400,NULL,4,NULL,1,0x00CFDF80,7,2,768,NULL,NULL,1,138,'bonus bStr,3; bonus bInt,2; bonus5 bAutoSpellWhenHit,"HP_ASSUMPTIO",1,1,BF_WEAPON|BF_MAGIC,0;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5354,'Muslim_Hat_M','Muslim Hat M',5,NULL,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,1,256,NULL,NULL,NULL,362,'bonus bCastrate,-5;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5355,'Muslim_Hat_F','Selendang',5,NULL,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,NULL,256,NULL,NULL,NULL,363,'bonus bCastrate,-5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5354,'Muslim_Hat_M','Muslim Hat M',5,NULL,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,1,256,NULL,NULL,NULL,362,'bonus bVariableCastrate,-5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5355,'Muslim_Hat_F','Selendang',5,NULL,NULL,100,NULL,2,NULL,NULL,0xFFFFFFFF,7,NULL,256,NULL,NULL,NULL,363,'bonus bVariableCastrate,-5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5356,'Pumpkin_Hat_H','Festival Pumpkin Hat',5,20,NULL,200,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,206,'bonus2 bSubRace,RC_Demon,5; bonus2 bAddRace,RC_Demon,5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5357,'Wings_Of_Victory','Wings Of Victory',5,20,NULL,200,NULL,10,NULL,NULL,0xFFFFFFFF,7,2,768,NULL,NULL,NULL,365,'bonus bMdef,10; bonus bUnbreakableHelm,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5358,'Pecopeco_Wing_Ears','Peco Ears',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'70',NULL,366,'bonus bAgi,1; bonus bMdef,2; bonus bUnbreakableHelm,0;',NULL,NULL); @@ -3016,14 +3016,14 @@ REPLACE INTO `item_db_re` VALUES (5404,'Blue_Ribbon','Blue Ribbon',5,10,NULL,100 REPLACE INTO `item_db_re` VALUES (5405,'Filir_Hat','Filir Hat',5,10,NULL,200,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'80',NULL,408,'bonus bShortWeaponDamageReturn,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5406,'Academy_Freshman_Hat','Academy Freshman Hat',5,NULL,NULL,500,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,409,'bonus bMaxHP,80; bonus bMaxSP,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5407,'Academy_Graduating_Cap','Academy Completion Hat',5,NULL,NULL,200,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,410,'bonus bMaxSP,30;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5408,'Old_Bandanna','Old Bandana',5,NULL,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,6,'bonus bInt,2; bonus bMaxSP,50; bonus bCastrate,10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5408,'Old_Bandanna','Old Bandana',5,NULL,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,6,'bonus bInt,2; bonus bMaxSP,50; bonus bVariableCastrate,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5409,'New_Cowboy_Hat','Purple Cowboy Hat',5,20,NULL,500,NULL,4,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,411,'bonus bInt,2; bonus bVit,2; bonus bMaxSP,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5410,'Bread_Bag2','Brown Paperbag Hat',5,20,NULL,200,NULL,6,NULL,NULL,0xFFFFFFFF,7,2,769,NULL,NULL,NULL,412,'bonus bMaxHP,100; bonus2 bResEff,Eff_Stun,400; bonus2 bSubRace,RC_DemiHuman,4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5411,'White_Snake_Hat','White Snake Hat',5,20,NULL,500,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,413,'bonus bDex,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5412,'Sweet_Candy','Sweet Candy',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,1,NULL,NULL,NULL,414,'bonus bUnbreakableHelm,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5413,'Popcorn_Hat','Pop Corn Hat',5,20,NULL,300,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,415,'bonus2 bSubEle,Ele_Wind,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5414,'Campfire_Hat','Camp Fire Hat',5,20,NULL,300,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,416,'bonus2 bSubEle,Ele_Fire,10; bonus4 bAutoSpellWhenHit,MG_FIREBALL,5,100,1;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5415,'Poring_Cake_Cap','Poring Cake Hat',5,20,NULL,1000,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'40',1,417,'bonus bMdef,5; bonus bCritical,5; bonus bFlee,5; bonus bFlee2,5; bonus bAspdRate,5; bonus bCastrate,-5; bonus bDelayRate,-5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5415,'Poring_Cake_Cap','Poring Cake Hat',5,20,NULL,1000,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'40',1,417,'bonus bMdef,5; bonus bCritical,5; bonus bFlee,5; bonus bFlee2,5; bonus bAspdRate,5; bonus bVariableCastrate,-5; bonus bDelayRate,-5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5416,'Beer_Cap','Beer Hat',5,20,NULL,600,NULL,2,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,'18',1,418,'bonus bFlee2,5; skill "SM_RECOVERY",3; skill "MG_SRECOVERY",3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5417,'Crown_Parrot','Crown Parrots',5,20,NULL,200,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,419,'bonus bInt,1; bonus2 bResEff,Eff_Silence,10000; bonus3 bAutoSpell,DC_SCREAM,1,50;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5418,'Soldier_Hat','Legionnaire Hat',5,20,NULL,400,NULL,4,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,420,'bonus bStr,1; bonus2 bAddRace,RC_NonBoss,3; bonus2 bAddRace,RC_Boss,3; bonus bUseSPrate,10;',NULL,NULL); @@ -3076,7 +3076,7 @@ REPLACE INTO `item_db_re` VALUES (5464,'Zaha_Doll_Hat','Zaha Doll Hat',5,20,NULL REPLACE INTO `item_db_re` VALUES (5465,'Celestial_Hat','Hat Of Fortune',5,20,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'40',1,462,'bonus bLuk,2; bonus bMdef,5; if(getrefine()>4) bonus bLuk,getrefine()-4;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5466,'Wind_Milestone','Wind Milestone',5,20,NULL,100,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'30',1,463,'bonus bAgi,2; skill "AL_TELEPORT",1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5467,'Helm_Of_Dragoon','Helm Of Dragon',5,20,NULL,2000,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'50',1,464,'bonus2 bAddRace,RC_Dragon,20; bonus3 bAutoSpell,"NPC_DRAGONFEAR",1,30;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5468,'Parade_Cap','Parade Hat',5,20,NULL,800,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,465,'bonus bDelayRate,-5; bonus bMdef,2; if(getrefine()>5) bonus bCastrate,-(getrefine()-5);',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5468,'Parade_Cap','Parade Hat',5,20,NULL,800,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,1,465,'bonus bDelayRate,-5; bonus bMdef,2; if(getrefine()>5) bonus bVariableCastrate,-(getrefine()-5);',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5469,'Noble_Hat','Musketeer Hat',5,20,NULL,300,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'30',1,466,'bonus bStr,2; bonus3 bAutoSpellWhenHit,"BS_ADRENALINE",1,7;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5470,'Eyes_Of_Darkness','Eye Of Darkness',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'50',NULL,467,'bonus bDex,1; bonus2 bResEff,Eff_Blind,10000;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5471,'Hairband_Of_Reginleif','Hairband Of Reginleif',5,20,NULL,800,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'50',NULL,468,'bonus2 bSubEle,Ele_Water,3; bonus2 bSubEle,Ele_Fire,3; bonus2 bSubEle,Ele_Undead,3; bonus2 bSubEle,Ele_Ghost,3;',NULL,NULL); @@ -3170,9 +3170,9 @@ REPLACE INTO `item_db_re` VALUES (5558,'Saci_Hat','Luxury Hat',5,20,NULL,100,NUL REPLACE INTO `item_db_re` VALUES (5559,'Piece_Of_White_Cloth_E','Piece Of White Cloth',5,NULL,NULL,0,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,543,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5560,'Bullock_Helm_J','Bullock Helm',5,20,NULL,3000,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'75',1,322,'bonus bMaxHP,100; bonus bNoKnockback,0; bonus2 bSubEle,Ele_Neutral,-20; bonus2 bSubEle,Ele_Fire,-20; bonus2 bSubEle,Ele_Water,-20; bonus2 bSubEle,Ele_Wind,-20; bonus2 bSubEle,Ele_Earth,-20; bonus2 bSubEle,Ele_Dark,-20; bonus2 bSubEle,Ele_Holy,-20; bonus2 bSubEle,Ele_Ghost,-20;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5561,'Rabbit_Magic_Hat_J','Magic Rabbit Hat',5,NULL,NULL,800,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,NULL,1,497,'bonus bInt,1; bonus bMaxSP,50; bonus4 bAutoSpellWhenHit,"MG_FIREBOLT",3,10,3; bonus4 bAutoSpellWhenHit,"MG_COLDBOLT",3,10,3; bonus4 bAutoSpellWhenHit,"MG_LIGHTNINGBOLT",3,10,3; bonus3 bAutoSpellWhenHit,"AL_HEAL",1,10;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5562,'Good_Wedding_Veil_J','Luxurious Wedding Veil',5,NULL,NULL,500,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,768,NULL,'45',NULL,489,'bonus bMdef,10; bonus bCastRate,-3; bonus bUseSPrate,-5;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5562,'Good_Wedding_Veil_J','Luxurious Wedding Veil',5,NULL,NULL,500,NULL,NULL,NULL,1,0xFFFFFFFF,7,2,768,NULL,'45',NULL,489,'bonus bMdef,10; bonus bVariableCastrate,-3; bonus bUseSPrate,-5;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5563,'Dolor_Hat','Dolor Hat',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,NULL,NULL,547,NULL,NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5564,'Crown_Of_Deceit','Crown of Deceit',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,768,NULL,'85',1,544,'bonus bInt,4; bonus bCastRate,-10;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5564,'Crown_Of_Deceit','Crown of Deceit',5,20,NULL,300,NULL,3,NULL,1,0xFFFFFFFF,7,2,768,NULL,'85',1,544,'bonus bInt,4; bonus bVariableCastrate,-10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5565,'Dragon_Arhat_Mask','Dragon Arhat Mask',5,NULL,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFF,7,2,513,NULL,'1',NULL,545,'bonus2 bAddRace,RC_DemiHuman,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5566,'Tiger_Arhat_Mask','Tiger Arhat Mask',5,NULL,NULL,0,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,513,NULL,'1',NULL,546,'bonus2 bAddRace,RC_DemiHuman,2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5567,'Bright_Fury','Bright Fury',5,20,NULL,300,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,548,'bonus bStr,1; bonus2 bAddRace,RC_NonBoss,2; bonus2 bAddRace,RC_Boss,2; bonus bAspdRate,2;',NULL,NULL); @@ -3263,16 +3263,16 @@ REPLACE INTO `item_db_re` VALUES (5651,'F_Brooch_C','F Brooch C',5,1,NULL,0,NULL REPLACE INTO `item_db_re` VALUES (5652,'F_Magestic_Goat_C','F Magestic Goat C',5,2,NULL,0,NULL,5,NULL,NULL,0xFFFFFFFE,7,2,256,NULL,NULL,NULL,41,'bonus bStr,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5653,'Darkness_Helm_J','Darkness Helm',5,20,NULL,500,NULL,3,NULL,1,0xFFFFFFFF,7,2,256,NULL,'70',1,586,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5654,'Holy_Marching_Hat_J','Holy Marching Hat',5,20,NULL,200,NULL,2,NULL,1,0xFFFFFFFF,7,2,256,NULL,'10',1,587,'bonus bStr,2; bonus3 bAutoSpell,"PR_ASPERSIO",2,30;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5655,'Dark_Snake_Lord_Hat_J','Evil Snake Lord Hat',5,20,NULL,500,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'60',1,372,'bonus bInt,2; bonus bAgi,2; bonus bDex,-2; autobonus "{bonus bCastrate,-50; bonus bFlee,30;}",50,5000,BF_MAGIC,"{specialeffect2 EF_SUFFRAGIUM;}";',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5655,'Dark_Snake_Lord_Hat_J','Evil Snake Lord Hat',5,20,NULL,500,NULL,2,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'60',1,372,'bonus bInt,2; bonus bAgi,2; bonus bDex,-2; autobonus "{bonus bVariableCastrate,-50; bonus bFlee,30;}",50,5000,BF_MAGIC,"{specialeffect2 EF_SUFFRAGIUM;}";',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (5656,'Scooter_Hat_J','Scooter Helmet',5,20,NULL,1000,NULL,7,NULL,1,0xFFFFFFFF,7,2,256,NULL,'50',1,588,'bonus bUnbreakableHelm,0;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5657,'Antique_Pipe_J','Captain\'s Pipe',5,20,NULL,100,NULL,NULL,NULL,NULL,0xFFFFFFFF,7,2,1,NULL,'30',NULL,383,NULL,NULL,NULL); REPLACE INTO `item_db_re` VALUES (5658,'Imp_Hat','Imp Hat',5,20,NULL,400,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',1,589,'bonus3 bAutoSpell,"SA_FLAMELAUNCHER",1,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5659,'Sleeper_Hat','Sleeper Hat',5,20,NULL,400,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',1,590,'bonus3 bAutoSpell,"SA_SEISMICWEAPON",1,10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5660,'Gryphon_Hat','Gryphon Hat',5,20,NULL,400,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',1,591,'bonus3 bAutoSpell,"SA_LIGHTNINGLOADER",1,10;',NULL,NULL); -# REPLACE INTO `item_db_re` VALUES (5661,'Red_Pirate_Bandana','Red Pirate Banada',5,NULL,NULL,0,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'10',1,592,'bonus bStr,1; bonus bDex,1; bonus bAspdRate,2; bonus bCastRate,-2; bonus3 bAutoSpell,"MO_EXTREMITYFIST",1,30;',NULL,NULL); +# REPLACE INTO `item_db_re` VALUES (5661,'Red_Pirate_Bandana','Red Pirate Banada',5,NULL,NULL,0,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'10',1,592,'bonus bStr,1; bonus bDex,1; bonus bAspdRate,2; bonus bVariableCastrate,-2; bonus3 bAutoSpell,"MO_EXTREMITYFIST",1,30;',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (5662,'Libra_Crown','Libra Crown',5,10,NULL,300,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',1,593,'bonus bDex,3;',NULL,NULL); # REPLACE INTO `item_db_re` VALUES (5663,'Libra_Diadem','Libra Diadem',5,10,NULL,300,NULL,3,NULL,NULL,0xFFFFFFFF,7,2,256,NULL,'1',1,594,'bonus bDex,3;',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5664,'Filir_Wing','Filir\'s Pinions',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'70',1,595,'bonus bAspdRate,2; bonus bCastRate,-2;',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5664,'Filir_Wing','Filir\'s Pinions',5,20,NULL,100,NULL,1,NULL,NULL,0xFFFFFFFF,7,2,512,NULL,'70',1,595,'bonus bAspdRate,2; bonus bVariableCastrate,-2;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5665,'Shaman_Hat','Shaman Hat',5,20,NULL,400,NULL,1,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,596,'bonus2 bSubEle,Ele_Neutral,3; bonus2 bSubEle,Ele_Water,3; bonus2 bSubEle,Ele_Earth,3; bonus2 bSubEle,Ele_Fire,3; bonus2 bSubEle,Ele_Wind,3; bonus2 bSubEle,Ele_Poison,3; bonus2 bSubEle,Ele_Holy,3; bonus2 bSubEle,Ele_Dark,3; bonus2 bSubEle,Ele_Ghost,3; bonus2 bSubEle,Ele_Undead,3;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5666,'Golden_Crown','Golden Crown',5,20,NULL,500,NULL,8,NULL,1,0xFFFFFFFF,7,2,256,NULL,'1',1,597,'bonus bInt,1; bonus bDex,1; bonus bLuk,1;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5667,'Skull_Hood','Skull Hood',5,20,NULL,100,NULL,1,NULL,1,0xFFFFFFFF,7,2,768,NULL,'30',1,598,NULL,NULL,NULL); @@ -3361,7 +3361,7 @@ REPLACE INTO `item_db_re` VALUES (5749,'Driver_Band','Driver Band',5,20,NULL,100 REPLACE INTO `item_db_re` VALUES (5750,'Shadow_Handicraft','Shadow Crown',5,20,NULL,100,NULL,12,NULL,1,0x00020000,8,2,256,NULL,'100',1,627,'bonus bAgi,1; bonus bInt,1; bonus bMdef,1; if(readparam(bAgi)>=120){ bonus bAtk,10; bonus bFlee,3; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5751,'Minstrel_Song_Hat','Minstrel Song Hat',5,20,NULL,100,NULL,12,NULL,1,0x00080000,8,1,256,NULL,'100',1,628,'bonus bInt,1; bonus bLuk,1; bonus bMdef,5; bonus bLongAtkRate,4; bonus bUseSPrate,-10;',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5752,'Midas_Whisper','Midas Whispers',5,20,NULL,100,NULL,12,NULL,1,0x00040000,8,2,256,NULL,'100',1,629,'bonus bStr,1; bonus bDex,1; bonus bMdef,5; if(readparam(bStr)>=120){ bonus bAtk,5; bonus bAspd,1; }',NULL,NULL); -REPLACE INTO `item_db_re` VALUES (5753,'Magic_Stone_Hat','Magic Stone Hat',5,20,NULL,100,NULL,12,NULL,1,0x00000200,8,2,256,NULL,'100',1,630,'bonus bInt,1; bonus bDex,1; bonus bMdef,5; if(readparam(bDex)>=120){ bonus bMatkRate,10; bonus bCastrate,-2; }',NULL,NULL); +REPLACE INTO `item_db_re` VALUES (5753,'Magic_Stone_Hat','Magic Stone Hat',5,20,NULL,100,NULL,12,NULL,1,0x00000200,8,2,256,NULL,'100',1,630,'bonus bInt,1; bonus bDex,1; bonus bMdef,5; if(readparam(bDex)>=120){ bonus bMatkRate,10; bonus bVariableCastrate,-2; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5754,'Blazing_Soul','Burning Spirit',5,20,NULL,100,NULL,12,NULL,1,0x00008000,8,2,256,NULL,'100',1,631,'bonus bStr,1; bonus bVit,1; bonus bMdef,5; if(readparam(bStr)>=120){ bonus bAtk,10; bonus bHit,3; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5755,'Silent_Executer','Silent Enforcer',5,20,NULL,100,NULL,12,NULL,NULL,0x00001000,8,2,513,NULL,'100',1,632,'bonus bAgi,1; bonus bMdef,5; if(readparam(bAgi)>=120){ bonus bAtk,10; bonus bFlee2,5; }',NULL,NULL); REPLACE INTO `item_db_re` VALUES (5756,'Wind_Whisper','Wispers of Wind',5,20,NULL,100,NULL,12,NULL,1,0x00010000,8,2,256,NULL,'100',1,633,'bonus bInt,1; bonus bDex,1; bonus bMdef,5; if(readparam(bInt)>=120){ bonus bMatkRate,10; bonus bFlee,3; }',NULL,NULL); |