From 97b5de990056a2bc57315405d302c4db4adb8abf Mon Sep 17 00:00:00 2001
From: Shocker <none@none>
Date: Mon, 30 Aug 2010 11:09:55 +0300
Subject: Immolate and Unstable Affliction can't stack anymore when casted by
 same caster, thanks Karolis.Rudzevicius, fixes Issue #2246.

--HG--
branch : trunk
---
 sql/base/world_database.sql                        | 8 ++++++--
 sql/updates/9671_world_spell_group.sql             | 5 +++++
 sql/updates/9671_world_spell_group_stack_rules.sql | 3 +++
 3 files changed, 14 insertions(+), 2 deletions(-)
 create mode 100644 sql/updates/9671_world_spell_group.sql
 create mode 100644 sql/updates/9671_world_spell_group_stack_rules.sql

(limited to 'sql')

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 1b8df6a1fbf..c492b94cf11 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -6021,7 +6021,10 @@ INSERT INTO `spell_group` (`id`, `spell_id`) VALUES
 (1110, 27683),
 (1006, 72586), -- Blessing of Forgotten Kings (Drums)
 (1108, 72588), -- Gift of the Wild (Drums)
-(1109, 72590); -- Fortitude (Scroll)
+(1109, 72590), -- Fortitude (Scroll)
+-- Immolate / Unstable Affliction
+(1112, 348),
+(1112, 30108);
 
 /*!40000 ALTER TABLE `spell_group` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -7622,7 +7625,8 @@ INSERT INTO spell_group_stack_rules (`group_id`, `stack_rule`) VALUES
 (1107,1),
 (1108,1),
 (1109,1),
-(1110,1);
+(1110,1),
+(1112,2);
 
 /*!40000 ALTER TABLE `spell_group_stack_rules` ENABLE KEYS */;
 UNLOCK TABLES;
diff --git a/sql/updates/9671_world_spell_group.sql b/sql/updates/9671_world_spell_group.sql
new file mode 100644
index 00000000000..9de18ff577a
--- /dev/null
+++ b/sql/updates/9671_world_spell_group.sql
@@ -0,0 +1,5 @@
+-- Unstable Affliction / Immolate stacking from same caster
+DELETE FROM `spell_group` where `id`=1112;
+INSERT INTO spell_group (id, spell_id) VALUES
+(1112, 348),
+(1112, 30108);
diff --git a/sql/updates/9671_world_spell_group_stack_rules.sql b/sql/updates/9671_world_spell_group_stack_rules.sql
new file mode 100644
index 00000000000..9eecc6a2b49
--- /dev/null
+++ b/sql/updates/9671_world_spell_group_stack_rules.sql
@@ -0,0 +1,3 @@
+-- Unstable Affliction / Immolate stacking from same caster
+DELETE FROM `spell_group_stack_rules` where `group_id`=1112;
+INSERT INTO spell_group_stack_rules (group_id, stack_rule) VALUES (1112, 2);
-- 
cgit v1.2.3