*Use spell_ranks table in spell scripts to not duplicate data.

--HG--
branch : trunk

2 files changed, 6 insertions, 0 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 8d8119d49a1..0e9f59ea65e 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -13940,6 +13940,8 @@ INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
  -- Penance
 (47757, 47757, 1),
 (47757, 52986, 2),
+(47757, 52987, 3),
+(47757, 52988, 4),
  -- Savage Rend
 (50498, 50498, 1),
 (50498, 53578, 2),
diff --git a/sql/updates/9131_world_spell_ranks.sql b/sql/updates/9131_world_spell_ranks.sql
new file mode 100644
index 00000000000..7343f38c895
--- /dev/null
+++ b/sql/updates/9131_world_spell_ranks.sql
@@ -0,0 +1,4 @@
+DELETE FROM spell_ranks WHERE `spell_id` IN (52987, 52988);
+INSERT INTO spell_ranks (`first_spell_id`, `spell_id`, `rank`) VALUES
+(47757, 52987, 3),
+(47757, 52988, 4);