* Add spell required data for Totem of Wrath ranks 2-4

* Thanks Wladass

--HG--
branch : trunk

2 files changed, 10 insertions, 0 deletions

diff --git a/sql/updates/7270_world_spell_required.sql b/sql/updates/7270_world_spell_required.sql
new file mode 100644
index 00000000000..828e1d22333
--- /dev/null
+++ b/sql/updates/7270_world_spell_required.sql
@@ -0,0 +1,6 @@
+-- adding spell requied for Totem of Wrath-Rank 2,3,4
+DELETE FROM `spell_required` WHERE `spell_id` IN (57720,57721,57722);
+INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES
+(57720,30706), -- Totem of Wrath rank 2 (must know rank 1)
+(57721,57720), -- Totem of Wrath rank 3 (must know rank 2)
+(57722,57721); -- Totem of Wrath rank 4 (must know rank 3)
diff --git a/sql/world.sql b/sql/world.sql
index 27bc5244405..f272b47d750 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -6654,6 +6654,10 @@ CREATE TABLE `spell_required` (
 
 LOCK TABLES `spell_required` WRITE;
 /*!40000 ALTER TABLE `spell_required` DISABLE KEYS */;
+INSERT INTO `spell_required` (`spell_id`,`req_spell`) VALUES
+(57720,30706), -- Totem of Wrath rank 2 (must know rank 1)
+(57721,57720), -- Totem of Wrath rank 3 (must know rank 2)
+(57722,57721); -- Totem of Wrath rank 4 (must know rank 3)
 /*!40000 ALTER TABLE `spell_required` ENABLE KEYS */;
 UNLOCK TABLES;