From 6528a82b612432b9091163e8a9074d424c7e764d Mon Sep 17 00:00:00 2001 From: Shocker Date: Mon, 13 Sep 2010 22:54:04 +0300 Subject: Core/Spells: Remove duplicate healing bonus calculation for Prayer of Mending, closes issue 3879, thanks dr.tenma --HG-- branch : trunk --- sql/base/world_database.sql | 2 +- sql/updates/9912_world_spell_bonus_data.sql | 3 +++ 2 files changed, 4 insertions(+), 1 deletion(-) create mode 100644 sql/updates/9912_world_spell_bonus_data.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index e9d3903b473..052e400092a 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -16944,7 +16944,7 @@ INSERT INTO `spell_bonus_data` (`entry`,`direct_bonus`,`dot_bonus`,`ap_bonus`,`a (53000, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 4)'), (17, 0.8068, -1, -1, -1, 'Priest - Power Word: Shield'), (596, 0.8068, -1, -1, -1, 'Priest - Prayer of Healing'), -(33110, 0.8068, -1, -1, -1, 'Priest - Prayer of Mending Heal Proc'), +(33110, 0.8068, 0, 0, 0, 'Priest - Prayer of Mending Heal Proc'), (33619, 0, 0, 0, 0, 'Priest - Reflective Shield'), (139, -1, 0.376, -1, -1, 'Priest - Renew'), (32379, 0.4296, -1, -1, -1, 'Priest - Shadow Word: Death'), diff --git a/sql/updates/9912_world_spell_bonus_data.sql b/sql/updates/9912_world_spell_bonus_data.sql new file mode 100644 index 00000000000..fe25a10be8f --- /dev/null +++ b/sql/updates/9912_world_spell_bonus_data.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_bonus_data` WHERE `entry` IN ('33110'); +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES +('33110','0.8068','0','0','0','Priest - Prayer of Mending Heal Proc'); -- cgit v1.2.3