diff options
| author | Subv <s.v.h21@hotmail.com> | 2012-04-01 11:06:08 -0500 |
|---|---|---|
| committer | Subv <s.v.h21@hotmail.com> | 2012-04-01 11:06:08 -0500 |
| commit | 65ba081b6c6106021343c964fdc75b6c2b49100d (patch) | |
| tree | def4e3096e0289e1ba4a627eff8f94772e8708dc | |
| parent | 2987d4f40d72bf03073f79ce8292e99d364133df (diff) | |
SQL/Spells: Missing SQL from previous commit
| -rw-r--r-- | sql/updates/world/2012_04_01_02_world_spell_group_stack_rules.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_01_02_world_spell_group_stack_rules.sql b/sql/updates/world/2012_04_01_02_world_spell_group_stack_rules.sql new file mode 100644 index 00000000000..d42afd1d955 --- /dev/null +++ b/sql/updates/world/2012_04_01_02_world_spell_group_stack_rules.sql @@ -0,0 +1,9 @@ +-- Greater Blessing of Wisdom and Mana Spring Totem should not stack (hotfix) +SET @GROUP := 1117; +DELETE FROM `spell_group` WHERE id=@GROUP; +INSERT INTO `spell_group`(`id`,`spell_id`) VALUES +(@GROUP,25894), -- Greater Blessing of Wisdom +(@GROUP,5677); -- Mana Spring (cast by Mana Spring Totem) +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=@GROUP; +INSERT INTO `spell_group_stack_rules`(`group_id`,`stack_rule`) VALUES +(@GROUP,3); -- Make them SPELL_GROUP_STACK_RULE_EXCLUSIVE_SAME_EFFECT |