DB/DalaranLegion: Script clone event for Emissary Auldbridge

1 files changed, 57 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_06_02_00_world.sql b/sql/updates/world/master/2025_06_02_00_world.sql
new file mode 100644
index 00000000000..2123e9ac45e
--- /dev/null
+++ b/sql/updates/world/master/2025_06_02_00_world.sql
@@ -0,0 +1,57 @@
+-- Creature Text
+DELETE FROM `creature_text` WHERE `CreatureID` = 111109;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(111109, 0, 0, 'The resources of Dalaran are at your disposal. From here, heroes of Alliance and Horde alike will search for the Pillars of Creation!', 12, 0, 100, 1, 0, 0, 123007, 0, 'Emissary Auldbridge to Player'),
+(111109, 1, 0, 'I\'ve heard rumors of powerful artifacts that may be of use in your campaign. Keep an eye out and a useful lead just might present itself!', 12, 0, 100, 1, 0, 0, 123008, 0, 'Emissary Auldbridge to Player'),
+(111109, 2, 0, 'Now I must attend to other visitors. Good luck, $n!', 12, 0, 100, 1, 0, 0, 123009, 0, 'Emissary Auldbridge to Player');
+
+-- Emissary Auldbridge smart ai
+SET @ENTRY := 111109;
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = @ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type` = 0 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES
+(@ENTRY, 0, 0, 0, 20, 0, 100, 0, 44184, 0, 0, 0, 0, 80, 11110900, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On player rewarded quest In the Blink of an Eye (44184) - Self: Start timed action list id #Emissary Auldbridge #0 (11110900) (update out of combat)', ''),
+(@ENTRY, 0, 1, 0, 34, 0, 100, 0, 2, 20, 0, 0, 0, 41, 2000, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 20 - Self: Despawn in 2 s', '');
+
+-- Timed list 11110900 smart ai
+SET @ENTRY := 11110900;
+DELETE FROM `smart_scripts` WHERE `source_type` = 9 AND `entryOrGuid` = @ENTRY;
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`, `Difficulties`) VALUES
+(@ENTRY, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 149, 8, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'After 0 seconds - Self: Become personal clone for Last action invoker for 0 seconds (manual despawn)', ''),
+(@ENTRY, 9, 1, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'After 3 seconds - Owner/Summoner: Talk 0 to invoker', ''),
+(@ENTRY, 9, 2, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'After 4 seconds - Owner/Summoner: Talk 1 to invoker', ''),
+(@ENTRY, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0, 0, 'After 5 seconds - Owner/Summoner: Talk 2 to invoker', ''),
+(@ENTRY, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 0, 53, 0, 11110900, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 4 seconds - Self: Start path #11110900, walk, do not repeat, Passive', '');
+
+-- Path for Emissary Auldbridge
+SET @ENTRY := 111109;
+SET @PATHOFFSET := 0;
+SET @PATH := @ENTRY * 100 + @PATHOFFSET;
+DELETE FROM `waypoint_path` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES
+(@PATH, 0, 0x0, NULL, 'Emissary Auldbridge - Scripted Path');
+
+DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH;
+INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES
+(@PATH, 0, -819.3715, 4410.2275, 737.8271, NULL, 0),
+(@PATH, 1, -809.2504, 4422.3345, 738.1977, NULL, 0),
+(@PATH, 2, -802.13367, 4432.3257, 738.4878, NULL, 0),
+(@PATH, 3, -794.15625, 4443.6704, 737.6981, NULL, 0),
+(@PATH, 4, -783.1233, 4459.316, 735.18695, NULL, 0),
+(@PATH, 5, -778.7274, 4468.6396, 734.3575, NULL, 0),
+(@PATH, 6, -776.01215, 4482.854, 732.82837, NULL, 0),
+(@PATH, 7, -781.4948, 4494.6963, 731.8157, NULL, 0),
+(@PATH, 8, -794.99304, 4508.3794, 730.99274, NULL, 0),
+(@PATH, 9, -805.8976, 4513.4673, 730.71796, NULL, 0),
+(@PATH, 10, -820.6268, 4525.252, 729.7963, NULL, 0),
+(@PATH, 11, -831.4705, 4534.684, 729.1168, NULL, 0),
+(@PATH, 12, -847.0382, 4546.311, 728.3229, NULL, 0),
+(@PATH, 13, -855.26215, 4555.4204, 727.88324, NULL, 0),
+(@PATH, 14, -859.99304, 4564.8613, 727.8631, NULL, 0),
+(@PATH, 15, -859.1875, 4572.367, 732.8302, NULL, 0),
+(@PATH, 16, -858.06946, 4582.4053, 739.97784, NULL, 0),
+(@PATH, 17, -857.46704, 4589.8394, 745.6363, NULL, 0),
+(@PATH, 18, -856.7639, 4595.3384, 748.9865, NULL, 0),
+(@PATH, 19, -855.881, 4603.6406, 749.44336, NULL, 0),
+(@PATH, 20, -854.55383, 4609.0884, 750.1897, NULL, 0),
+(@PATH, 21, -853.6228, 4616.6523, 749.64954, NULL, 0);