From 26ba4ecd5140fa13953ca7c3e1ab3f269a85ce71 Mon Sep 17 00:00:00 2001 From: Gildor Date: Sat, 4 Jul 2020 15:56:48 +0200 Subject: Core/Spells: Check a few aura effects for determining if should be negative (#24930) * Core/Spells: Check a few aura effects for determining if should be negative * Rename 9999_99_99_99_world_auras.sql to 2020_07_04_00_world.sql Co-authored-by: Giacomo Pozzoni --- sql/updates/world/3.3.5/2020_07_04_00_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_07_04_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2020_07_04_00_world.sql b/sql/updates/world/3.3.5/2020_07_04_00_world.sql new file mode 100644 index 00000000000..22e80936fa5 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_04_00_world.sql @@ -0,0 +1,8 @@ +-- +-- Baron Geddon: Ignite Mana isn't needed +DELETE FROM `spell_custom_attr` WHERE `entry`=19659; + +-- Mana-Tombs: Death Coil must be negative +DELETE FROM `spell_custom_attr` WHERE `entry`=38065; +INSERT INTO `spell_custom_attr` (`entry`,`attributes`) VALUES +(38065,8192); -- cgit v1.2.3