Fix the bug that mage's some freezing spells can stack with each other.

Frost Nova, Freeze and Shattered Barrier can't stack with each other.

Patch based on darkshines' patch.

Closes issue #1063.

--HG--
branch : trunk

3 files changed, 14 insertions, 2 deletions

diff --git a/sql/updates/8216_world_spell_group.sql b/sql/updates/8216_world_spell_group.sql
new file mode 100644
index 00000000000..5c0c749afca
--- /dev/null
+++ b/sql/updates/8216_world_spell_group.sql
@@ -0,0 +1,5 @@
+DELETE FROM spell_group WHERE id = 1107;
+INSERT INTO spell_group (id, spell_id) VALUES
+(1107, 122), -- Frost Nova
+(1107, 33395), -- Freeze
+(1107, 55080); -- Shattered Barrier
diff --git a/sql/updates/8216_world_spell_group_stack_rules.sql b/sql/updates/8216_world_spell_group_stack_rules.sql
new file mode 100644
index 00000000000..fa3ff809f83
--- /dev/null
+++ b/sql/updates/8216_world_spell_group_stack_rules.sql
@@ -0,0 +1,2 @@
+DELETE FROM spell_group_stack_rules WHERE group_id = 1107;
+INSERT INTO spell_group_stack_rules (group_id, stack_rule) VALUES (1107, 1);
diff --git a/sql/world.sql b/sql/world.sql
index d5d1e43087e..870aa267a8e 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -5780,7 +5780,11 @@ INSERT INTO `spell_group` (`id`, `spell_id`) VALUES
 -- Cast Speed Slow
 (1103,-1100),
 (1103,-1001),
-(1103,-1002);
+(1103,-1002),
+-- mage freezing spells
+(1107, 122), -- Frost Nova
+(1107, 33395), -- Freeze
+(1107, 55080); -- Shattered Barrier
 
 /*!40000 ALTER TABLE `spell_group` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -7286,7 +7290,8 @@ INSERT INTO spell_group_stack_rules (`group_id`, `stack_rule`) VALUES
 (1096,1),
 (1099,1),
 (1103,1),
-(1046,1);
+(1046,1),
+(1107,1);
 
 /*!40000 ALTER TABLE `spell_group_stack_rules` ENABLE KEYS */;
 UNLOCK TABLES;