Issue Information
-
#005904
-
0 - None Assigned
-
Fixed
Issue Confirmations
-
Yes (0)No (0)
0
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.
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);