From 28113e14f26b62d56b888a877fd1be58e28f7f36 Mon Sep 17 00:00:00 2001 From: maximius Date: Sat, 21 Nov 2009 02:33:20 -0800 Subject: *Proper Penance coeffs, by Destalker. Closes #24 --HG-- branch : trunk --- sql/FULL/world_spell_full.sql | 12 ++++++++---- sql/updates/6337_world_spells.sql | 12 ++++++++++++ 2 files changed, 20 insertions(+), 4 deletions(-) create mode 100644 sql/updates/6337_world_spells.sql (limited to 'sql') 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)'); -- cgit v1.2.3