From 89bae3b51c5208931bb3b409f8092e07c55b80e3 Mon Sep 17 00:00:00 2001 From: Liberate Date: Tue, 18 Oct 2011 23:27:39 +0200 Subject: Core/Spells: Add a new stack rule for spellgroups: SPELL_GROUP_STACK_RULE_EXCLUSIVE_SAME_EFFECT This stack rule makes the effects of the spells in the spellgroup non-stackable, but the spells/auras itself are stackable. a spell should be in only 1 group with this stack rule. Fixes #2243 --- sql/updates/world/2011_10_18_00_world_spell_group.sql | 9 +++++++++ .../world/2011_10_18_01_world_spell_group_stack_rules.sql | 3 +++ 2 files changed, 12 insertions(+) create mode 100644 sql/updates/world/2011_10_18_00_world_spell_group.sql create mode 100644 sql/updates/world/2011_10_18_01_world_spell_group_stack_rules.sql (limited to 'sql') diff --git a/sql/updates/world/2011_10_18_00_world_spell_group.sql b/sql/updates/world/2011_10_18_00_world_spell_group.sql new file mode 100644 index 00000000000..15d8886ae57 --- /dev/null +++ b/sql/updates/world/2011_10_18_00_world_spell_group.sql @@ -0,0 +1,9 @@ +DELETE FROM `spell_group` WHERE `id` = 1114; +INSERT INTO `spell_group` (`id`, `spell_id`) VALUES +(1114,1490), +(1114,60431), +(1114,60432), +(1114,60433), +(1114,51726), +(1114,51734), +(1114,51735); \ No newline at end of file diff --git a/sql/updates/world/2011_10_18_01_world_spell_group_stack_rules.sql b/sql/updates/world/2011_10_18_01_world_spell_group_stack_rules.sql new file mode 100644 index 00000000000..79e33616a0e --- /dev/null +++ b/sql/updates/world/2011_10_18_01_world_spell_group_stack_rules.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_group_stack_rules` WHERE `group_id` = 1114; +INSERT INTO `spell_group_stack_rules` (`group_id`, `stack_rule`) VALUES +(1114,3); \ No newline at end of file -- cgit v1.2.3