From 99aaed92e373d3d51a7f7f9a8d8c83cc57e9c6d1 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Sun, 25 Feb 2024 09:11:49 +0100 Subject: DB/DunMorogh: Added path for Golorn Frostbeard in Kharanos Closes #29729 --- sql/updates/world/master/2024_02_25_03_world.sql | 26 ++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/master/2024_02_25_03_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2024_02_25_03_world.sql b/sql/updates/world/master/2024_02_25_03_world.sql new file mode 100644 index 00000000000..d0ec4230fd6 --- /dev/null +++ b/sql/updates/world/master/2024_02_25_03_world.sql @@ -0,0 +1,26 @@ +-- Pathing for Golorn Frostbeard Entry: 1692 +SET @NPC := 1692; +SET @PATH := @NPC * 100; + +-- UPDATE `creature_template` SET `flags_extra`=536870912 WHERE `entry`=1692; -- disable pathfinding as it adversely affects path + +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`,`MoveType`,`Flags`,`Comment`) VALUES +(@PATH,0,0,'Golorn Frostbeard - Idle'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path_node` (`PathId`,`NodeId`,`PositionX`,`PositionY`,`PositionZ`,`Orientation`,`Delay`) VALUES +(@PATH,0,-5636.061,-495.83292,396.67853,NULL,0), +(@PATH,1,-5640.068,-496.73785,396.66605,NULL,0), +(@PATH,2,-5641.3994,-498.89606,396.66736,NULL,0), +(@PATH,3,-5640.8315,-501.3918,396.66876,NULL,19000), -- sniffed 17s to 20s on official +(@PATH,4,-5641.3994,-498.89606,396.66736,NULL,0), +(@PATH,5,-5640.068,-496.73785,396.66605,NULL,0), +(@PATH,6,-5636.061,-495.83292,396.67853,NULL,0), +(@PATH,8,-5633.44,-496.477,396.69183,2.199115,35000); -- sniffed 30s to 40s on offical + +UPDATE `creature` SET `MovementType`=2 WHERE `guid`=306365; + +DELETE FROM `creature_addon` WHERE `guid`=306365; +INSERT INTO `creature_addon` (`guid`,`PathId`,`mount`,`StandState`,`SheathState`,`emote`,`visibilityDistanceType`,`auras`) VALUES +(306365,@PATH,0,0,1,0,0, ''); -- cgit v1.2.3