Scripts/Spells: Void Zone's Consumption (#27265)

(cherry picked from commit 44a6d393d7969adf3357ea74c61561c60c6c5a31)

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_22_03_world_2021_11_20_02_world.sql b/sql/updates/world/master/2022_03_22_03_world_2021_11_20_02_world.sql
new file mode 100644
index 00000000000..23d953b6199
--- /dev/null
+++ b/sql/updates/world/master/2022_03_22_03_world_2021_11_20_02_world.sql
@@ -0,0 +1,14 @@
+-- It looked like 34000 and 34001 are heroic and normal entries but they're not. Even in CreatureDifficulty they are separate entries
+-- Spell 64206 is simply not used but looks like was created for heroic, 64207 probably triggers it
+-- We'll use 64209 as trigger of 64208
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 64209;
+
+DELETE FROM `serverside_spell_effect` WHERE `SpellID`=64209;
+INSERT INTO `serverside_spell_effect` (`SpellID`, `Effect`, `EffectAura`, `EffectAuraPeriod`, `EffectChainAmplitude`, `ImplicitTarget1`) VALUES
+(64209,6,23,1000,1,1);
+
+UPDATE `spell_script_names` SET `ScriptName` = 'spell_gen_consumption' WHERE `ScriptName` = 'spell_four_horsemen_consumption';
+
+DELETE FROM `spell_script_names` WHERE `spell_id` = 64208 AND `ScriptName` = 'spell_gen_consumption';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(64208,'spell_gen_consumption');