DB/NorthernBarrens: Update path and script for Dorak

Closes #30360

Co-authored-by: Naddley <64811442+Naddley@users.noreply.github.com>

1 files changed, 29 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_11_09_02_world.sql b/sql/updates/world/master/2024_11_09_02_world.sql
new file mode 100644
index 00000000000..d9772563f75
--- /dev/null
+++ b/sql/updates/world/master/2024_11_09_02_world.sql
@@ -0,0 +1,29 @@
+-- Dorak
+DELETE FROM `waypoint_path` WHERE `PathId` = 274273;
+DELETE FROM `waypoint_path_node` WHERE `PathId` = 274273;
+
+SET @MOVERGUID := 304070;
+SET @ENTRY := 34284;
+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, 1, 0x0, NULL, 'Dorak - 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, 69.16949, -3618.468, 28.68636, 3.612831592559814453, 4258),
+(@PATH, 1, 66.85916, -3643.826, 27.43744, NULL, 0),
+(@PATH, 2, 66.50076, -3653.195, 27.26537, 2.670353651046752929, 5482);
+
+UPDATE `creature` SET `position_x`= 66.85916, `position_y`= -3643.826, `position_z`= 27.43744, `orientation`= 0, `MovementType`= 2 WHERE `guid`=@MOVERGUID;
+DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES
+(@MOVERGUID, @PATH, 1);
+
+-- Dorak smart ai
+SET @ENTRY := 34284;
+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, 34, 0, 100, 0, 2, 0, 0, 0, 0, 5, 15, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On movement of type WAYPOINT_MOTION_TYPE inform, point 0 - Self: Play emote 15', '');