From d5e33bf4ba08b4728a06a8a90a1ebb52c831427f Mon Sep 17 00:00:00 2001
From: QAston <none@none>
Date: Sun, 1 Aug 2010 03:23:14 +0200
Subject: *Use spell_ranks table in spell scripts to not duplicate data.

--HG--
branch : trunk
---
 sql/base/world_database.sql            | 2 ++
 sql/updates/9131_world_spell_ranks.sql | 4 ++++
 2 files changed, 6 insertions(+)
 create mode 100644 sql/updates/9131_world_spell_ranks.sql

(limited to 'sql')

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);
-- 
cgit v1.2.3