From 536240dee72a1771f9d64fab3b842bf0602e0289 Mon Sep 17 00:00:00 2001
From: Aqua Deus <95978183+aquadeus@users.noreply.github.com>
Date: Mon, 7 Oct 2024 16:47:29 +0200
Subject: Scripts/NerubarPalace: Implement Ulgrax intro (#30256)

---
 .../hotfixes/master/2204_10_07_00_hotfixes.sql     | 10 ++++
 sql/updates/world/master/2024_10_07_00_world.sql   | 64 ++++++++++++++++++++++
 2 files changed, 74 insertions(+)
 create mode 100644 sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql
 create mode 100644 sql/updates/world/master/2024_10_07_00_world.sql

(limited to 'sql')

diff --git a/sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql b/sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql
new file mode 100644
index 00000000000..174d3d09e4c
--- /dev/null
+++ b/sql/updates/hotfixes/master/2204_10_07_00_hotfixes.sql
@@ -0,0 +1,10 @@
+DELETE FROM `broadcast_text` WHERE `ID` IN (256584, 256583, 256581, 256930, 256580, 256562, 256546, 257387);
+INSERT INTO `broadcast_text` (`Text`, `Text1`, `ID`, `LanguageID`, `ConditionID`, `EmotesID`, `Flags`, `ChatBubbleDurationMs`, `VoiceOverPriorityID`, `SoundKitID1`, `SoundKitID2`, `EmoteID1`, `EmoteID2`, `EmoteID3`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `VerifiedBuild`) VALUES
+('', 'Ulgrax, feed.', 256584, 0, 0, 0, 0, 0, 4, 0, 249814, 0, 0, 0, 0, 0, 0, 56819),
+('', 'I appreciate you making the extermination of your futile resistance all the easier.', 256583, 0, 0, 0, 0, 0, 4, 0, 249813, 0, 0, 0, 0, 0, 0, 56819),
+('', 'The pathetic conspirators have finally crawled from their holes to attack my palace?', 256581, 0, 0, 0, 0, 0, 4, 0, 249812, 0, 0, 0, 0, 0, 0, 56819),
+('Invaders! Sound the alarm.', 'Invaders! Sound the alarm.', 256930, 0, 0, 0, 0, 0, 4, 246765, 253836, 0, 0, 0, 0, 0, 0, 56819),
+('Otherwise you will be encumbered with additional forces.', '', 256580, 0, 0, 0, 0, 0, 4, 249811, 0, 0, 0, 0, 0, 0, 0, 56819),
+('Dispatch these guards before they can raise an alarm.', '', 256562, 0, 0, 0, 0, 0, 4, 249810, 0, 0, 0, 0, 0, 0, 0, 56819),
+('I have redirected forces loyal to me away from the entrance.', '', 256546, 0, 0, 0, 0, 0, 4, 249808, 0, 0, 0, 0, 0, 0, 0, 56819),
+('', 'I told you that you were destined for great things. Rejoice, for you have aided the end of all things.', 257387, 0, 0, 0, 0, 0, 4, 0, 251930, 0, 0, 0, 0, 0, 0, 56819);
diff --git a/sql/updates/world/master/2024_10_07_00_world.sql b/sql/updates/world/master/2024_10_07_00_world.sql
new file mode 100644
index 00000000000..b6c793ef2d4
--- /dev/null
+++ b/sql/updates/world/master/2024_10_07_00_world.sql
@@ -0,0 +1,64 @@
+SET @ATID := 96;
+SET @ATCP := 85;
+SET @ATSPAWNID := 99;
+
+-- Creature
+UPDATE `creature_template` SET `flags_extra`=536870912, `ScriptName`='boss_ulgrax_the_devourer' WHERE `entry`=215657; -- CREATURE_FLAG_EXTRA_IGNORE_PATHFINDING must be added since the combat is on a gameobject
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=10001982;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
+(10001982,10001982,0,0,0,0,0),
+(10001982,10002001,0,0,0,0,0),
+(10001982,10001998,0,0,0,0,0),
+(10001982,10001995,0,0,0,0,0),
+(10001982,10001989,0,0,0,0,0);
+UPDATE `creature` SET `StringId`='nerubar_palace_intro_trash' WHERE `guid` IN (10001982, 10002001, 10001998, 10001995, 10001989);
+
+DELETE FROM `creature_formations` WHERE `leaderGUID`=10001991;
+INSERT INTO `creature_formations` (`leaderGUID`,`memberGUID`,`dist`,`angle`,`groupAI`,`point_1`,`point_2`) VALUES
+(10001991,10001991,0,0,0,0,0),
+(10001991,10002009,0,0,0,0,0),
+(10001991,10002016,0,0,0,0,0),
+(10001991,10002018,0,0,0,0,0),
+(10001991,10002006,0,0,0,0,0),
+(10001991,10002010,0,0,0,0,0);
+UPDATE `creature` SET `StringId`='ulgrax_intro_trash' WHERE `guid` IN (10001991, 10002009, 10002016, 10002018, 10002006, 10002010);
+
+-- Instance
+DELETE FROM `instance_template` WHERE `map`=2657;
+INSERT INTO `instance_template` (`map`, `parent`, `script`) VALUES
+(2657, 0, 'instance_nerubar_palace');
+
+-- Areatrigger
+DELETE FROM `areatrigger_template` WHERE `Id` = @ATID+0;
+INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `ActionSetId`, `ActionSetFlags`, `VerifiedBuild`) VALUES
+(@ATID+0, 1, 1, 0, 0, 0);
+
+DELETE FROM `areatrigger_create_properties` WHERE `Id` = @ATID+0;
+INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `VerifiedBuild`) VALUES
+(@ATCP+0, 1, @ATID+0, 1, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 0, 1, 30, 60, 2, 30, 60, 2, 0, 0, 'at_ulgrax_intro', 0);
+
+DELETE FROM `areatrigger` WHERE `SpawnId` = @ATID+0;
+INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerCreatePropertiesId`, `IsCustom`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `ScriptName`, `Comment`, `VerifiedBuild`) VALUES
+(@ATSPAWNID+0, @ATCP+0, 1, 2657, '14,15,16,17', -2841.09, -273.894, -1189.997, 5.509477, 0, 0, 0, '', 'Nerub\'ar Palace - Ulgrax the Devourer intro', 0);
+
+-- Conversation
+DELETE FROM `conversation_line_template` WHERE `Id` IN (66068, 66067, 66066);
+INSERT INTO `conversation_line_template` (`Id`, `UiCameraID`, `ActorIdx`, `Flags`, `ChatType`, `VerifiedBuild`) VALUES
+(66068, 0, 0, 1, 1, 56513),
+(66067, 0, 0, 1, 1, 56513),
+(66066, 0, 0, 1, 1, 56513);
+
+DELETE FROM `conversation_template` WHERE `Id` = 24332;
+INSERT INTO `conversation_template` (`Id`, `FirstLineID`, `TextureKitId`, `VerifiedBuild`) VALUES
+(24332, 66066, 0, 56513);
+
+DELETE FROM `conversation_actors` WHERE `ConversationId`=24332 AND `Idx`=0;
+INSERT INTO `conversation_actors` (`ConversationId`, `ConversationActorId`, `ConversationActorGuid`, `Idx`, `CreatureId`, `CreatureDisplayInfoId`, `NoActorObject`, `ActivePlayerObject`, `VerifiedBuild`) VALUES
+(24332, 97324, 10002046, 0, 0, 0, 0, 0, 56513);
+
+-- Spells
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (451409, 451411);
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(451409, 'spell_ulgrax_the_devourer_swallowing_darkness_intro'),
+(451411, 'spell_ulgrax_the_devourer_swallowing_darkness_teleport');
-- 
cgit v1.2.3