diff options
| -rw-r--r-- | sql/updates/7270_world_spell_required.sql | 6 | ||||
| -rw-r--r-- | sql/world.sql | 4 |
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; |