From 56da44df978f83dc8b3f3c36e6f64678143d9317 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 8 Apr 2023 12:36:15 +0200 Subject: DB/Spell: Wrong stack rules in spirit/intellect buffs closes #23534 by Jildor --- sql/updates/world/3.3.5/2023_04_08_00_world.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 sql/updates/world/3.3.5/2023_04_08_00_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3