aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSubv <s.v.h21@hotmail.com>2012-10-09 11:22:46 -0500
committerSubv <s.v.h21@hotmail.com>2012-10-09 11:22:46 -0500
commit5eccf9f4da29d2006e2f07a1e5ec0c01173a9c4a (patch)
tree277ce04ef49da1296d41e3c886b7f487c5bd79d5
parentcce014a2ba48460722e4308bfdcf632e2a2817ec (diff)
SQL/StackRules: Added one more stack rule.
Blood Frenzy (Warrior) and Savage Combat should not stack. ref #7667
-rw-r--r--sql/updates/world/2012_10_09_01_world_spell_groups.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_10_09_01_world_spell_groups.sql b/sql/updates/world/2012_10_09_01_world_spell_groups.sql
new file mode 100644
index 00000000000..75c57d0f77f
--- /dev/null
+++ b/sql/updates/world/2012_10_09_01_world_spell_groups.sql
@@ -0,0 +1,11 @@
+-- Blood Frenzy (Warrior) and Savage Combat effect should not stack
+DELETE FROM `spell_group` WHERE `id`=1119;
+INSERT INTO `spell_group`(`id`,`spell_id`) VALUES
+(1119,30069),
+(1119,58684);
+
+DELETE FROM `spell_group_stack_rules` WHERE `group_id`=1119;
+INSERT INTO `spell_group_stack_rules`(`group_id`,`stack_rule`) VALUES (1119,3);
+
+-- Remove invalid spell_groups
+DELETE FROM `spell_group` WHERE `id` IN (1038,1039);