Issue Information
-
#005980
-
0 - None Assigned
-
Fixed
Issue Confirmations
-
Yes (0)No (0)
0
Additional iRO headgears and two more MATK fixes
Posted by Hercules Bot on 10 June 2012 - 02:33 AM
Originally posted by jTynne
replace into `item_db` values (18539, 'Skull_Cap', 'Skull Cap', 5, 40, NULL, 200, NULL, 5, NULL, 1, 4294967295, 7, 2, 256, NULL, 10, 1, 713, 'bonus bMatkRate,2; if(getrefine() >= 5) { bonus bMatkRate,3; } if(getrefine() >= 7) { bonus bMatkRate,3; } if(isequipped(2286) || isequipped(18507)) {bonus bUseSPrate,-3;} if(isequipped(1615) || isequipped(1636)) { bonus bWeaponMatk,10*getequiprefinerycnt(EQI_HAND_R); bonus bCastRate,-10;}', NULL, NULL);
REPLACE INTO `item_db` VALUES (18656,'Witch\'s_Pumpkin_Hat','Witch\'s Pumpkin Hat',5,20,NULL,300,NULL,10,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,1,717,'bonus bMdef,10; bonus bStr,2; bonus bInt,2; bonus2 bMagicAddRace,RC_Undead,15; bonus2 bMagicAddRace,RC_Demon,15; if(isequipped(2278) {bonus2 bAddMonsterDropItem,12192,1;} if(isequipped(5176) {bonus bAspdRate,5; autobonus \"{ bonus bAtk,50; }\",5,10000,0,\"{ specialeffect2 EF_POTION_BERSERK; }\";} if(isequipped(5086) {bonus2 bAddMonsterDropItem,12192,1; bonus2 bAddMonsterDropItem,538,1; bonus2 bAddItemHealRate,12192,100; bonus2 bAddItemHealRate,538,100;} if(isequipped(2281)) {bonus bFlee,10; bonus2 bAddEff,Eff_Stun,1000;}',NULL,NULL);
replace into `item_db` values (18600, 'Cat_Ear_Beret', 'Cat Ear Beret', 5, 30, NULL, 200, NULL, 5, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 0, 1, 761, 'if(getrefine() > 5 && getrefine() <= 12) { bonus2 bAddRace,RC_DemiHuman,2*(getrefine() - 4); bonus2 bSubRace,RC_DemiHuman,2*(getrefine() - 4);}', NULL, NULL);
replace into `item_db` values (18597, 'Mercury_Riser', 'Mercury Riser', 5, 40, NULL, 200, NULL, 10, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 70, 1, 759, 'bonus bAspdRate,3; bonus bCritical,3; if(getrefine() == 7 || getrefine() == 8) { bonus bAspdRate,2; bonus bCritical,2; } if(getrefine() >= 9) { bonus bAspdRate,2; bonus bCritical,2; }', NULL, NULL);
replace into `item_db` values (18596, 'Sprout_Hat', 'Sprout Hat', 5, 20, NULL, 200, NULL, 4, NULL, 0, 0xFFFFFFFF, 7, 2, 256, NULL, 70, 1, 758, 'skill \"WZ_HEAVENDRIVE\",3;', NULL, NULL);
replace into `item_db` values (18595, 'Horn_Of_Ancient', 'Horn of Ancient', 5, 40, NULL, 200, NULL, 8, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 50, 1, 757, 'autobonus \"{ bonus bAtk,100; }\",5,10000,0,\"{ specialeffect2 EF_POTION_BERSERK; }\";', NULL, NULL);
replace into `item_db` values (18612, 'White_Musang', 'White Musang', 5, 40, NULL, 200, NULL, 3, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 0, 1, 770, 'bonus bStr,2; bonus bVit,2; bonus bLuk,1; bonus bUnbreakableHelm,0;', NULL, NULL);
replace into `item_db` values (18613, 'Black_Musang', 'Black Musang', 5, 40, NULL, 200, NULL, 3, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 0, 1, 771, 'bonus bInt,2; bonus bDex,2; bonus bAgi,1; bonus bUnbreakableHelm,0;', NULL, NULL);
replace into `item_db` values (18620, 'Heart_Eye_Patch', 'Heart Eyepatch', 5, 5, NULL, 200, NULL, 2, NULL, 0, 0xFFFFFFFF, 7, 2, 512, NULL, 20, 1, 779, NULL, NULL, NULL);
REPLACE INTO `item_db_re` VALUES (16010,'Red_Ether_Bag','Red Ether Bag',4,20,NULL,0,'15:100',NULL,1,1,0x0004C5B2,7,2,2,3,102,1,8,' if(getrefine()>=6){ bonus2 bSkillAtk,\"GN_CRAZYWEED\",20+((getrefine()-5)*2); bonus2 bSkillAtk,\"GN_DEMONIC_FIRE\",20+((getrefine()-5)*2); } else { bonus2 bSkillAtk,\"GN_CRAZYWEED\",20; bonus2 bSkillAtk,\"GN_DEMONIC_FIRE\",20; } ',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (16013,'Judgement_Mace1','Judgement Mace I',4,20,NULL,1200,'140:180',NULL,1,2,0x00000100,2,2,2,3,100,1,8,' bonus bStr,1; bonus bInt,1; autobonus \"{ bonus2 bAddRace,RC_Demon,20; }\",10,7000,BF_WEAPON|BF_MAGIC,\"{ specialeffect2 EF_BLOODDRAIN; }\"; if (isequipped(2472,2570,15030)) { bonus2 bAddRace,RC_Undead,15; bonus2 bMagicAddRace,RC_Undead,15; bonus2 bSkillAtk,\"AB_ADORAMUS\",100; };',NULL,NULL);
YOU KNOW WHAT TO DO BB!
replace into `item_db` values (18539, 'Skull_Cap', 'Skull Cap', 5, 40, NULL, 200, NULL, 5, NULL, 1, 4294967295, 7, 2, 256, NULL, 10, 1, 713, 'bonus bMatkRate,2; if(getrefine() >= 5) { bonus bMatkRate,3; } if(getrefine() >= 7) { bonus bMatkRate,3; } if(isequipped(2286) || isequipped(18507)) {bonus bUseSPrate,-3;} if(isequipped(1615) || isequipped(1636)) { bonus bWeaponMatk,10*getequiprefinerycnt(EQI_HAND_R); bonus bCastRate,-10;}', NULL, NULL);
REPLACE INTO `item_db` VALUES (18656,'Witch\'s_Pumpkin_Hat','Witch\'s Pumpkin Hat',5,20,NULL,300,NULL,10,NULL,0,0xFFFFFFFF,7,2,256,NULL,20,1,717,'bonus bMdef,10; bonus bStr,2; bonus bInt,2; bonus2 bMagicAddRace,RC_Undead,15; bonus2 bMagicAddRace,RC_Demon,15; if(isequipped(2278) {bonus2 bAddMonsterDropItem,12192,1;} if(isequipped(5176) {bonus bAspdRate,5; autobonus \"{ bonus bAtk,50; }\",5,10000,0,\"{ specialeffect2 EF_POTION_BERSERK; }\";} if(isequipped(5086) {bonus2 bAddMonsterDropItem,12192,1; bonus2 bAddMonsterDropItem,538,1; bonus2 bAddItemHealRate,12192,100; bonus2 bAddItemHealRate,538,100;} if(isequipped(2281)) {bonus bFlee,10; bonus2 bAddEff,Eff_Stun,1000;}',NULL,NULL);
replace into `item_db` values (18600, 'Cat_Ear_Beret', 'Cat Ear Beret', 5, 30, NULL, 200, NULL, 5, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 0, 1, 761, 'if(getrefine() > 5 && getrefine() <= 12) { bonus2 bAddRace,RC_DemiHuman,2*(getrefine() - 4); bonus2 bSubRace,RC_DemiHuman,2*(getrefine() - 4);}', NULL, NULL);
replace into `item_db` values (18597, 'Mercury_Riser', 'Mercury Riser', 5, 40, NULL, 200, NULL, 10, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 70, 1, 759, 'bonus bAspdRate,3; bonus bCritical,3; if(getrefine() == 7 || getrefine() == 8) { bonus bAspdRate,2; bonus bCritical,2; } if(getrefine() >= 9) { bonus bAspdRate,2; bonus bCritical,2; }', NULL, NULL);
replace into `item_db` values (18596, 'Sprout_Hat', 'Sprout Hat', 5, 20, NULL, 200, NULL, 4, NULL, 0, 0xFFFFFFFF, 7, 2, 256, NULL, 70, 1, 758, 'skill \"WZ_HEAVENDRIVE\",3;', NULL, NULL);
replace into `item_db` values (18595, 'Horn_Of_Ancient', 'Horn of Ancient', 5, 40, NULL, 200, NULL, 8, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 50, 1, 757, 'autobonus \"{ bonus bAtk,100; }\",5,10000,0,\"{ specialeffect2 EF_POTION_BERSERK; }\";', NULL, NULL);
replace into `item_db` values (18612, 'White_Musang', 'White Musang', 5, 40, NULL, 200, NULL, 3, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 0, 1, 770, 'bonus bStr,2; bonus bVit,2; bonus bLuk,1; bonus bUnbreakableHelm,0;', NULL, NULL);
replace into `item_db` values (18613, 'Black_Musang', 'Black Musang', 5, 40, NULL, 200, NULL, 3, NULL, 1, 0xFFFFFFFF, 7, 2, 256, NULL, 0, 1, 771, 'bonus bInt,2; bonus bDex,2; bonus bAgi,1; bonus bUnbreakableHelm,0;', NULL, NULL);
replace into `item_db` values (18620, 'Heart_Eye_Patch', 'Heart Eyepatch', 5, 5, NULL, 200, NULL, 2, NULL, 0, 0xFFFFFFFF, 7, 2, 512, NULL, 20, 1, 779, NULL, NULL, NULL);
REPLACE INTO `item_db_re` VALUES (16010,'Red_Ether_Bag','Red Ether Bag',4,20,NULL,0,'15:100',NULL,1,1,0x0004C5B2,7,2,2,3,102,1,8,' if(getrefine()>=6){ bonus2 bSkillAtk,\"GN_CRAZYWEED\",20+((getrefine()-5)*2); bonus2 bSkillAtk,\"GN_DEMONIC_FIRE\",20+((getrefine()-5)*2); } else { bonus2 bSkillAtk,\"GN_CRAZYWEED\",20; bonus2 bSkillAtk,\"GN_DEMONIC_FIRE\",20; } ',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (16013,'Judgement_Mace1','Judgement Mace I',4,20,NULL,1200,'140:180',NULL,1,2,0x00000100,2,2,2,3,100,1,8,' bonus bStr,1; bonus bInt,1; autobonus \"{ bonus2 bAddRace,RC_Demon,20; }\",10,7000,BF_WEAPON|BF_MAGIC,\"{ specialeffect2 EF_BLOODDRAIN; }\"; if (isequipped(2472,2570,15030)) { bonus2 bAddRace,RC_Undead,15; bonus2 bMagicAddRace,RC_Undead,15; bonus2 bSkillAtk,\"AB_ADORAMUS\",100; };',NULL,NULL);
YOU KNOW WHAT TO DO BB!
Originally posted by jTynne
Also, left out the Gozarian Mask check on the Witch's Pumpkin Hat because I haven't coded that item in yet. gaygaygay
Also, left out the Gozarian Mask check on the Witch's Pumpkin Hat because I haven't coded that item in yet. gaygaygay
Originally posted by jTynne
replace into `item_db` values (18539, 'Skull_Cap', 'Skull Cap', 5, 40, NULL, 200, NULL, 5, NULL, 1, 4294967295, 7, 2, 256, NULL, 10, 1, 713, 'bonus bMatkRate,2; if(getrefine() >= 5) { bonus bMatkRate,3; } if(getrefine() >= 7) { bonus bMatkRate,3; } if(isequipped(2286) || isequipped(18507)) {bonus bUseSPrate,-3;} if(isequipped(1615) || isequipped(1636)) { bonus bWeaponMatk,10*getequiprefinerycnt(EQI_HAND_R); bonus bCastRate,-10;}', NULL, NULL);
WHEN YOU IMPORT THESE INTO RATHENA
Please use the above Skull Cap, as I have updated/fixed the coding.
replace into `item_db` values (18539, 'Skull_Cap', 'Skull Cap', 5, 40, NULL, 200, NULL, 5, NULL, 1, 4294967295, 7, 2, 256, NULL, 10, 1, 713, 'bonus bMatkRate,2; if(getrefine() >= 5) { bonus bMatkRate,3; } if(getrefine() >= 7) { bonus bMatkRate,3; } if(isequipped(2286) || isequipped(18507)) {bonus bUseSPrate,-3;} if(isequipped(1615) || isequipped(1636)) { bonus bWeaponMatk,10*getequiprefinerycnt(EQI_HAND_R); bonus bCastRate,-10;}', NULL, NULL);
WHEN YOU IMPORT THESE INTO RATHENA
Please use the above Skull Cap, as I have updated/fixed the coding.