sql inserts for some of the missing matk on staffs

Originally posted by [b]jTynne[/b]
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.

[code]

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);
[/code]