From 5eac5ee2dbee289acbde48506b04ef35a0b1d5b2 Mon Sep 17 00:00:00 2001
From: offl <11556157+offl@users.noreply.github.com>
Date: Sat, 20 Nov 2021 21:49:56 +0200
Subject: Scripts/Spells: Void Zone's Consumption (#27265)

(cherry picked from commit 44a6d393d7969adf3357ea74c61561c60c6c5a31)
---
 .../master/2022_03_22_03_world_2021_11_20_02_world.sql     | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 sql/updates/world/master/2022_03_22_03_world_2021_11_20_02_world.sql

(limited to 'sql')

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');
-- 
cgit v1.2.3