From 75a5192c31390deca490dada3bdb0e89dcafdf8d Mon Sep 17 00:00:00 2001 From: Gildor Date: Thu, 25 Jul 2019 14:44:56 +0200 Subject: Spells/Priest: Fix Power Infusion, shouldn't stack with Arcane Power (Mage) (#23619) * Spells/Priest: Fix Power Infusion, shouldn't stack with Arcane Power (Mage) * delete unnecessary comments * make @Aokromes happy ;) * update group_id * Rename 9999_99_99_99_world_335.sql to 2019_07_25_00_world_335.sql --- sql/updates/world/3.3.5/2019_07_25_00_world_335.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/3.3.5/2019_07_25_00_world_335.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2019_07_25_00_world_335.sql b/sql/updates/world/3.3.5/2019_07_25_00_world_335.sql new file mode 100644 index 00000000000..04c1de08b90 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_07_25_00_world_335.sql @@ -0,0 +1,14 @@ +-- +SET @GROUP_ID := 1123; -- Change with the proper ID if this is in use +DELETE FROM `spell_group` WHERE `id`=@GROUP_ID AND `spell_id` IN (10060,12042); +INSERT INTO `spell_group` (`id`,`spell_id`) VALUES +(@GROUP_ID,10060), -- Priest - Power Infusion +(@GROUP_ID,12042); -- Mage - Arcane Power + +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=@GROUP_ID; +INSERT INTO `spell_group_stack_rules` (`group_id`,`stack_rule`) VALUES +(@GROUP_ID,1); + +DELETE FROM `spell_script_names` WHERE `spell_id`=10060 AND `ScriptName`='spell_pri_power_infusion'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(10060,'spell_pri_power_infusion'); -- cgit v1.2.3