diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_10_03_world.sql | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_10_03_world.sql b/sql/updates/world/3.3.5/2024_10_10_03_world.sql new file mode 100644 index 00000000000..d8d149c8ef5 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_10_03_world.sql @@ -0,0 +1,41 @@ +-- Pathing for Rex Ashil Entry: 14475 +SET @NPC=14475; +SET @GUID=51836; +SET @PATH=@GUID * 10; +UPDATE `creature` SET `position_x`=-6630.2847,`position_y`=945.4344,`position_z`=-52.96825,`wander_distance`=0,`MovementType`=2 WHERE `guid`=@GUID; +UPDATE `creature_template` SET `MovementType`=2 WHERE `entry`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@GUID; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(@GUID, @PATH, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH,1,-6630.2847,945.4344,-52.96825,NULL,0,0,0,100,0), +(@PATH,2,-6627.747,929.4205,-53.191467,NULL,0,0,0,100,0), +(@PATH,3,-6609.186,929.8785,-53.16585,NULL,0,0,0,100,0), +(@PATH,4,-6591.815,909.97754,-48.229885,NULL,0,0,0,100,0), +(@PATH,5,-6591.289,896.8762,-44.285564,NULL,0,0,0,100,0), +(@PATH,6,-6595.7266,884.783,-44.09041,NULL,0,0,0,100,0), +(@PATH,7,-6581.963,877.2528,-44.54215,NULL,0,0,0,100,0), +(@PATH,8,-6570.469,885.4149,-43.199642,NULL,0,0,0,100,0), +(@PATH,9,-6555.0957,885.0344,-39.406754,NULL,0,0,0,100,0), +(@PATH,10,-6545.19,871.5345,-32.738403,NULL,0,0,0,100,0), +(@PATH,11,-6535.754,862.1162,-29.028198,NULL,0,0,0,100,0), +(@PATH,12,-6518.3926,866.1533,-30.434242,NULL,0,0,0,100,0), +(@PATH,13,-6512.0576,887.03265,-39.736877,NULL,0,0,0,100,0), +(@PATH,14,-6497.0356,901.76587,-41.681843,NULL,0,0,0,100,0), +(@PATH,15,-6473.988,908.0661,-41.303955,NULL,0,0,0,100,0), +(@PATH,16,-6480.6694,921.8447,-41.822407,NULL,0,0,0,100,0), +(@PATH,17,-6473.988,908.0661,-41.303955,NULL,0,0,0,100,0), +(@PATH,18,-6497.0356,901.76587,-41.681843,NULL,0,0,0,100,0), +(@PATH,19,-6512.0576,887.03265,-39.736877,NULL,0,0,0,100,0), +(@PATH,20,-6518.3926,866.1533,-30.434242,NULL,0,0,0,100,0), +(@PATH,21,-6535.754,862.1162,-29.028198,NULL,0,0,0,100,0), +(@PATH,22,-6545.19,871.5345,-32.738403,NULL,0,0,0,100,0), +(@PATH,23,-6555.0957,885.0344,-39.406754,NULL,0,0,0,100,0), +(@PATH,24,-6570.469,885.4149,-43.199642,NULL,0,0,0,100,0), +(@PATH,25,-6581.963,877.2528,-44.54215,NULL,0,0,0,100,0), +(@PATH,26,-6595.7266,884.783,-44.09041,NULL,0,0,0,100,0), +(@PATH,27,-6591.289,896.8762,-44.285564,NULL,0,0,0,100,0), +(@PATH,28,-6591.8135,909.9452,-48.222664,NULL,0,0,0,100,0), +(@PATH,29,-6609.186,929.8785,-53.16585,NULL,0,0,0,100,0), +(@PATH,30,-6627.747,929.4205,-53.191467,NULL,0,0,0,100,0); |