diff options
| -rw-r--r-- | sql/base/world_database.sql | 8 | ||||
| -rw-r--r-- | sql/updates/9671_world_spell_group.sql | 5 | ||||
| -rw-r--r-- | sql/updates/9671_world_spell_group_stack_rules.sql | 3 |
3 files changed, 14 insertions, 2 deletions
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); |