Scripts/Baradin Hold: rewrite Argaloth encounter (#29604)

* handle all missing mechanics and visuals
* modernized instance script

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_01_22_00_world.sql b/sql/updates/world/master/2024_01_22_00_world.sql
new file mode 100644
index 00000000000..94d5c9b2132
--- /dev/null
+++ b/sql/updates/world/master/2024_01_22_00_world.sql
@@ -0,0 +1,17 @@
+UPDATE `creature_template` SET `ScriptName`= 'boss_argaloth' WHERE `ScriptName`= 'boss_pit_lord_argaloth';
+UPDATE `creature_template` SET `flags_extra`= 0x80, `AIName`= 'NullCreatureAI' WHERE `entry`= 47829;
+UPDATE `creature_template_difficulty` SET `StaticFlags1`= 0x2000306, `StaticFlags2`= 0x100000, `StaticFlags3`= 0x8400, `StaticFlags4`= 0x210 WHERE `Entry`= 47829;
+UPDATE `creature_template_addon` SET `Auras`= '' WHERE `entry`= 47829;
+
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_argaloth_meteor_slash', 'spell_argaloth_fel_firestorm_forcecast');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(88972, 'spell_argaloth_fel_firestorm'),
+(88987, 'spell_argaloth_fel_firestorm_forcecast');
+
+DELETE FROM `spell_custom_attr` WHERE `entry`= 88942;
+INSERT INTO `spell_custom_attr` (`entry`, `attributes`) VALUES
+(88942, 0x8);
+
+DELETE FROM `creature_text` WHERE `CreatureID`= 47120;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES
+(47120, 0, 0, '|TInterface\\Icons\\spell_fire_felrainoffire.blp:20|t%s begins to cast |cFFFF0000|Hspell:88972|h[Fel Firestorm]|h|r!', 41, 0, 100, 0, 0, 0, 48107, 'Argaloth - Announce Fel Firestorm');