From c0dda8b492d073472f1a4de9641b882ac6b90211 Mon Sep 17 00:00:00 2001
From: Shocker <none@none>
Date: Tue, 24 Aug 2010 22:47:41 +0300
Subject: * Forgotten stack rules for rev f69fb2d3e0, thanks svetilo12 * Fix a
 crash in rev a972aa682b

--HG--
branch : trunk
---
 sql/base/world_database.sql            | 10 ++++++++--
 sql/updates/9577_world_spell_group.sql |  5 +++++
 2 files changed, 13 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/9577_world_spell_group.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index bd35af3ea96..5857baec290 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -6017,7 +6017,10 @@ INSERT INTO `spell_group` (`id`, `spell_id`) VALUES
 (1109, 21562),
 -- Prayer of/Shadow Protection
 (1110, 976),
-(1110, 27683);
+(1110, 27683),
+(1006, 72586), -- Blessing of Forgotten Kings (Drums)
+(1108, 72588), -- Gift of the Wild (Drums)
+(1109, 72590); -- Fortitude (Scroll)
 
 /*!40000 ALTER TABLE `spell_group` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -7614,7 +7617,10 @@ INSERT INTO spell_group_stack_rules (`group_id`, `stack_rule`) VALUES
 (1099,1),
 (1103,1),
 (1046,1),
-(1107,1);
+(1107,1),
+(1108,1),
+(1109,1),
+(1110,1);
 
 /*!40000 ALTER TABLE `spell_group_stack_rules` ENABLE KEYS */;
 UNLOCK TABLES;
diff --git a/sql/updates/9577_world_spell_group.sql b/sql/updates/9577_world_spell_group.sql
new file mode 100644
index 00000000000..c16baa3a5fc
--- /dev/null
+++ b/sql/updates/9577_world_spell_group.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_group` WHERE `spell_id` IN (72586, 72588, 72590);
+INSERT INTO `spell_group` (`id`, `spell_id`) VALUES
+(1006, 72586), -- Blessing of Forgotten Kings (Drums)
+(1108, 72588), -- Gift of the Wild (Drums)
+(1109, 72590); -- Fortitude (Scroll)
\ No newline at end of file
-- 
cgit v1.2.3