Jump to content

  •  

Bug Tracker Migration

June 3rd
Good news everyone! The staff has decided that it is time to slowly kill off this Bug Tracker. We will begin the process of slowly migrating from this Bug Tracker over to our Github Issues which can be found here: https://github.com/HerculesWS/Hercules/issues

Over the next couple of days, I will be closing off any opportunity to create new reports. However, I still will keep the opportunity to reply to existing Bug Reports. Doing this will allow us to slowly fix any bug reports we have listed here so that we can easily migrate over to our Issue Tracker.

Update - June 7th 2015: Creating new bug posts has been disabled. Please use our https://github.com/HerculesWS/Hercules/issues tracker to post bugs. Users are still able to reply to existing bug posts.

- Administration

Issue Information

Issue Confirmations

  • Yes (0)No (0)
Photo

sql inserts for some of the missing matk on staffs

Posted by Hercules Bot on 02 June 2012 - 05:18 PM

Originally posted by jTynne
This isn't all of the staffs that are missing matk bonuses; it's just the ones reported to me thus far by my players. I'll shoot more up as they're reported and fixed.


INSERT INTO `item_db_re` (`id`, `name_english`, `name_japanese`, `type`, `price_buy`, `price_sell`, `weight`, `atk:matk`, `defence`, `range`, `slots`, `equip_jobs`, `equip_upper`, `equip_genders`, `equip_locations`, `weapon_level`, `equip_level`, `refineable`, `view`, `script`, `equip_script`, `unequip_script`) VALUES
(1615, 'Bone_Wand', 'Evil Bone Wand', 4, 20, NULL, 700, '40:110', NULL, 1, 0, 8487700, 7, 2, 2, 3, 24, 1, 10, 'bonus bInt,4; bonus bAtkEle,Ele_Undead; ', NULL, NULL),
(1641, 'Krieger_Onehand_Staff2', 'Glorious Cure Wand', 4, 20, NULL, 0, '70:135', NULL, 1, 0, 8487700, 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()-5)*2; } if(getrefine() > 8) bonus5 bAutoSpellOnSkill,"AL_HEAL","AL_HEAL",10,100,1; if(getrefine() > 9) { bonus bHealPower,10; }', NULL, NULL),
(1643, 'Dead_Tree_Cane', 'Dead Tree Cane', 4, 20, NULL, 100, '100:155', NULL, 1, 0, 8487700, 7, 2, 2, 4, 70, 1, 10, 'bonus bMatkRate,15; bonus bInt,4; if (getrefine()>5) { bonus bInt,getrefine()-5; bonus bMaxHP,-200; bonus bMaxSP,-100; }', NULL, NULL),
(1646, 'La''cryma_Stick', 'La''cryma Stick', 4, 20, NULL, 500, '30:180', NULL, 1, 2, 66052, 2, 2, 2, 3, 50, 1, 10, 'bonus bInt,4; bonus bMatkRate,15; bonus bMdef,1; bonus2 bSkillAtk,"WZ_STORMGUST",getrefine(); if (getrefine() > 9) bonus2 bCastRate,"WZ_STORMGUST",-8;', NULL, NULL),
(1647, 'Croce_Staff', 'Croce Staff', 4, 20, NULL, 500, '30:175', NULL, 1, 1, 33040, 2, 2, 2, 3, 50, 1, 10, 'bonus bAtkEle,Ele_Holy; bonus bMatkRate,15; bonus bInt,4; bonus4 bAutoSpellOnSkill,"AL_HEAL","AL_BLESSING",getskilllv("AL_BLESSING")>1?getskilllv("AL_BLESSING"):1,20;', NULL, NULL),
(1649, 'Rafini_Staff', 'Laphine Staff', 4, 20, NULL, 500, '30:180', NULL, 1, 0, 8487701, 7, 2, 2, 3, 100, 1, 10, '/* bonus bFixedCastRate,-getrefine(); */', NULL, NULL),
(1650, 'P_Staff1', 'Eden Staff I', 4, 0, NULL, 0, '60:125', NULL, 1, 0, 8487700, 7, 2, 2, 2, 26, 0, 10, 'bonus bInt,2;', NULL, NULL),
(1651, 'P_Staff2', 'Eden Staff II', 4, 0, NULL, 0, '60:150', NULL, 1, 0, 8487700, 7, 2, 2, 2, 40, 0, 10, ' bonus bInt,3;', NULL, NULL),
(1653, 'Staff_Of_Healing_C', 'Staff of Healing', 4, 20, NULL, 0, '10:100', NULL, 1, 0, 33040, 7, 2, 2, 3, 1, 0, 10, '/* bonus bWeaponMatk,100; */ bonus bAtkEle,Ele_Holy;', NULL, NULL),
(1654, 'Mental_Stick', 'Mental Stick', 4, 20, NULL, 500, '40:170', NULL, 1, 1, 8487701, 7, 2, 2, 3, 102, 1, 10, 'if (getrefine() > 5) { /* bonus bSkillAtk,"SO_PSYCHIC_WAVE",(getrefine()-5)*2; */ bonus bMaxHPRate,-(getrefine()-5)*2; } /* bonus2 bVariableCastTime,"SO_PSYCHIC_WAVE",-3000; bonus2 bUseSPAmount,"SO_PSYCHIC_WAVE",-60; */', NULL, 'itemheal 0,-100;'),
(1657, 'Mercy_Staff1', 'Mercy Staff I', 4, 20, NULL, 500, '30:160', NULL, 1, 2, 256, 7, 2, 2, 3, 100, 1, 10, 'bonus bInt,2; bonus bAtkEle,Ele_Holy; bonus bHealPower,10; if(isequipped(2471,2569,15029)){ bonus bHealPower,25; };', NULL, NULL),
(1658, 'P_Staff3', 'Eden Staff III', 4, 0, NULL, 0, '60:170', NULL, 1, 0, 8487700, 7, 2, 2, 3, 60, 0, 10, 'bonus bInt,4;', NULL, NULL),
(1659, 'Light_of_Recovery', 'Light of Recovery', 4, 56000, NULL, 400, '30:160', NULL, 1, 1, 256, 7, 2, 2, 4, 110, 1, 10, 'bonus bAtkEle,Ele_Holy; bonus bUnbreakableWeapon,0; bonus bHealPower,(getrefine()*3/2); bonus bUseSPrate,(getrefine()*3);', NULL, NULL),
(1660, 'Mercy_Staff2', 'Mercy Staff II', 4, 20, NULL, 500, '30:180', NULL, 1, 1, 256, 7, 2, 2, 3, 130, 1, 10, 'bonus bAtkEle,Ele_Holy; bonus bInt,4; bonus bHealPower,20; if(isequipped(2471,2569,15029)){ bonus bHealPower,45; /* bonus3 bAutoSpellWhenHit,"AB_SILENTIUM",1,10; */ };', NULL, NULL),
(1661, 'Mental_Destroyer', 'Mental Destroyer', 4, 20, NULL, 1400, '100:50', NULL, 1, 0, 512, 7, 2, 2, 4, 95, 1, 10, 'bonus bInt,10; bonus bMdef,20; bonus bUnbreakableWeapon,0; bonus2 bSPVanishRate,10000,5; if(getrefine()>5) { bonus2 bSPVanishRate,10000,5; }', NULL, NULL);


REPLACE INTO `item_db_re` VALUES (1472,'Staff_Of_Soul','Soul Staff',4,20,NULL,1400,'25:200',NULL,1,0,0x00810204,7,2,34,3,73,1,10,'bonus bInt,5; bonus bAgi,2; if(isequipped(2677) || isequipped(2711)){ bonus bMatkRate,6; bonus bDex,2; bonus bCastrate,-getrefine(); }',NULL,NULL);
REPLACE INTO `item_db_re` VALUES (1473,'Wizardy_Staff','Wizardry Staff',4,20,NULL,2400,'120:200',NULL,1,0,0x00810204,7,2,34,4,90,1,10,'bonus bInt,6; bonus bDex,2; if(isequipped(2677) || isequipped(2711)){ bonus bMatkRate,6; bonus bDex,2; bonus bCastrate,-getrefine(); }',NULL,NULL);

Originally posted by Kenpachi
Fixed in [rev=16245] and [rev=16248].