aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorLiberate <tbaart@gmail.com>2011-10-18 23:27:39 +0200
committerLiberate <tbaart@gmail.com>2011-10-18 23:27:39 +0200
commit89bae3b51c5208931bb3b409f8092e07c55b80e3 (patch)
tree9930536057d02cb16abe5bedb931c5cb0624c1f9 /sql
parentfd45c111b05e4f9b34db11330d7876b093e801fb (diff)
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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_10_18_00_world_spell_group.sql9
-rw-r--r--sql/updates/world/2011_10_18_01_world_spell_group_stack_rules.sql3
2 files changed, 12 insertions, 0 deletions
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