diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2023_04_08_00_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2023_04_08_00_world.sql b/sql/updates/world/3.3.5/2023_04_08_00_world.sql new file mode 100644 index 00000000000..0f99ce5d67e --- /dev/null +++ b/sql/updates/world/3.3.5/2023_04_08_00_world.sql @@ -0,0 +1,17 @@ +-- I used 1124 and 1125 seems not used +SET @GROUPID1 := 1124; +SET @GROUPID2 := 1125; + +DELETE FROM `spell_group` WHERE `id` IN (1083,1085) AND `spell_id`=-1073; +DELETE FROM `spell_group` WHERE `id`=@GROUPID1 AND `spell_id` IN (-1085,-1073); +DELETE FROM `spell_group` WHERE `id`=@GROUPID2 AND `spell_id` IN (-1083,-1073); +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(@GROUPID1,-1085), -- Spirit Buffs +(@GROUPID1,-1073), -- Fel Intelligence +(@GROUPID2,-1083), -- Intellect Buffs +(@GROUPID2,-1073); -- Fel Intelligence + +DELETE FROM `spell_group_stack_rules` WHERE `group_id` IN (@GROUPID1,@GROUPID2); +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +(@GROUPID1,3), +(@GROUPID2,3); |