diff options
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 12 | ||||
| -rw-r--r-- | sql/updates/6337_world_spells.sql | 12 |
2 files changed, 20 insertions, 4 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index 7836104eb79..1feeccaedf6 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -1777,10 +1777,14 @@ INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus` (8092, 0.428, -1, -1, -1, 'Priest - Mind Blast'), (15407, 0.257, -1, -1, -1, 'Priest - Mind Flay'), (49821, 0.2861, -1, -1, -1, 'Priest - Mind Sear Trigger Rank 1'), -(47757, 1.6135, -1, -1, -1, 'Priest - Penance (Rank 1'), -(52986, 1.6135, -1, -1, -1, 'Priest - Penance (Rank 2'), -(52987, 1.6135, -1, -1, -1, 'Priest - Penance (Rank 3'), -(52988, 1.6135, -1, -1, -1, 'Priest - Penance (Rank 4'), +(47750, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 1)'), +(52983, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 2)'), +(52954, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 3)'), +(58985, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 4)'), +(47666, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 1)'), +(52998, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 2)'), +(52999, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 3)'), +(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'), diff --git a/sql/updates/6337_world_spells.sql b/sql/updates/6337_world_spells.sql new file mode 100644 index 00000000000..5fea2fcdc5a --- /dev/null +++ b/sql/updates/6337_world_spells.sql @@ -0,0 +1,12 @@ + +DELETE FROM spell_bonus_data WHERE entry IN (47757, 52986, 52987, 52988); -- Old Penance in DB +DELETE FROM spell_bonus_data WHERE entry IN (47750, 52983, 52954, 58985, 47666, 52998, 52999, 53000); +INSERT INTO spell_bonus_data (entry, direct_bonus, dot_bonus, ap_bonus, ap_dot_bonus, comments) VALUES +(47750, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 1)'), +(52983, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 2)'), +(52954, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 3)'), +(58985, 0.5362, -1, -1, -1, 'Priest - Penance Heal (Rank 4)'), +(47666, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 1)'), +(52998, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 2)'), +(52999, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 3)'), +(53000, 0.229, -1, -1, -1, 'Priest - Penance Hurt (Rank 4)'); |