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

2 files changed, 7 insertions, 0 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);