diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 11 | ||||
| -rw-r--r-- | sql/updates/9570_world_spell_group.sql | 8 | ||||
| -rw-r--r-- | sql/updates/9570_world_spell_group_stack_rules.sql | 5 |
3 files changed, 23 insertions, 1 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 4e1bbe4e3c2..bd35af3ea96 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -6008,7 +6008,16 @@ INSERT INTO `spell_group` (`id`, `spell_id`) VALUES -- mage freezing spells (1107, 122), -- Frost Nova (1107, 33395), -- Freeze -(1107, 55080); -- Shattered Barrier +(1107, 55080), -- Shattered Barrier +-- Mark/Gift of the Wild +(1108, 1126), +(1108, 21849), +-- Power Word/Prayer of Fortitude +(1109, 1243), +(1109, 21562), +-- Prayer of/Shadow Protection +(1110, 976), +(1110, 27683); /*!40000 ALTER TABLE `spell_group` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/9570_world_spell_group.sql b/sql/updates/9570_world_spell_group.sql new file mode 100644 index 00000000000..e5dc9084f6b --- /dev/null +++ b/sql/updates/9570_world_spell_group.sql @@ -0,0 +1,8 @@ +DELETE FROM `spell_group` WHERE `id` IN (1108, 1109, 1110); +INSERT INTO `spell_group` (`id`, `spell_id`) VALUES +(1108, 1126), -- Mark of the Wild +(1108, 21849), -- Gift of the Wild +(1109, 1243), -- Power Word: Fortitude +(1109, 21562), -- Prayer of Fortitude +(1110, 976), -- Shadow Protection +(1110, 27683); -- Prayer of Shadow Protection
\ No newline at end of file diff --git a/sql/updates/9570_world_spell_group_stack_rules.sql b/sql/updates/9570_world_spell_group_stack_rules.sql new file mode 100644 index 00000000000..51fc1dc1b79 --- /dev/null +++ b/sql/updates/9570_world_spell_group_stack_rules.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (1108, 1109, 1110); +INSERT INTO `spell_group_stack_rules` (`group_id`, `stack_rule`) VALUES +(1108, 1), -- Mark/Gift of the Wild +(1109, 1), -- Power Word/Prayer of Fortitude +(1110, 1); -- Prayer of/Shadow protection
\ No newline at end of file |