aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authormaximius <none@none>2009-11-21 02:33:20 -0800
committermaximius <none@none>2009-11-21 02:33:20 -0800
commit28113e14f26b62d56b888a877fd1be58e28f7f36 (patch)
tree0b37d9e3f75d02403808b06a623b4c384d25040d /sql/updates
parent056c6fa6809decfbdc7689c73a3b3a709c13884b (diff)
*Proper Penance coeffs, by Destalker. Closes #24
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/6337_world_spells.sql12
1 files changed, 12 insertions, 0 deletions
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)');