Scripts/NerubarPalace: Implement Ulgrax intro (#30256)

2 files changed, 74 insertions, 0 deletions

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');