diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_10_06_world.sql | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_10_06_world.sql b/sql/updates/world/3.3.5/2024_10_10_06_world.sql new file mode 100644 index 00000000000..63ab4e04fc9 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_10_06_world.sql @@ -0,0 +1,60 @@ +-- Pathing for Vile Sting Entry: 5937 +SET @NPC=5937; +SET @GUID=51823; +SET @PATH=@GUID * 10; +UPDATE `creature` SET `position_x`=-5832.868,`position_y`=-3577.47,`position_z`=-58.645027,`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, 1, 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,-5832.868,-3577.47,-58.645027,NULL,0,0,0,100,0), +(@PATH,2,-5847.7896,-3578.9922,-58.62624,NULL,0,0,0,100,0), +(@PATH,3,-5879.2153,-3563.779,-58.624992,NULL,0,0,0,100,0), +(@PATH,4,-5898.626,-3563.8586,-58.624992,NULL,0,0,0,100,0), +(@PATH,5,-5906.1606,-3590.3938,-58.624973,NULL,0,0,0,100,0), +(@PATH,6,-5906.0674,-3606.6235,-58.624973,NULL,0,0,0,100,0), +(@PATH,7,-5923.0366,-3626.2664,-58.624973,NULL,0,0,0,100,0), +(@PATH,8,-5945.6016,-3613.887,-58.624954,NULL,0,0,0,100,0), +(@PATH,9,-5954.7524,-3608.444,-58.624954,NULL,0,0,0,100,0), +(@PATH,10,-5984.0244,-3598.608,-58.624954,NULL,0,0,0,100,0), +(@PATH,11,-6006.2593,-3598.7825,-58.624954,NULL,0,0,0,100,0), +(@PATH,12,-6013.32,-3605.1987,-58.624954,NULL,0,0,0,100,0), +(@PATH,13,-6023.108,-3620.3386,-58.624954,NULL,0,0,0,100,0), +(@PATH,14,-6046.9595,-3639.2556,-58.624954,NULL,0,0,0,100,0), +(@PATH,15,-6055.033,-3642.866,-58.624954,NULL,0,0,0,100,0), +(@PATH,16,-6074.136,-3629.934,-58.624954,NULL,0,0,0,100,0), +(@PATH,17,-6083.2944,-3613.5764,-58.624954,NULL,0,0,0,100,0), +(@PATH,18,-6096.364,-3598.897,-58.624954,NULL,0,0,0,100,0), +(@PATH,19,-6112.0825,-3584.047,-58.624954,NULL,0,0,0,100,0), +(@PATH,20,-6129.6,-3575.8818,-58.624954,NULL,0,0,0,100,0), +(@PATH,21,-6152.832,-3570.761,-58.624954,NULL,0,0,0,100,0), +(@PATH,22,-6167.849,-3571.4946,-58.624954,NULL,0,0,0,100,0), +(@PATH,23,-6176.987,-3576.321,-58.624954,NULL,0,0,0,100,0), +(@PATH,24,-6187.7524,-3589.2395,-58.624954,NULL,0,0,0,100,0), +(@PATH,25,-6186.82,-3620.595,-58.624954,NULL,0,0,0,100,0), +(@PATH,26,-6186.299,-3634.014,-58.624954,NULL,0,0,0,100,0), +(@PATH,27,-6171.7256,-3641.8333,-58.624954,NULL,0,0,0,100,0), +(@PATH,28,-6154.3394,-3651.0803,-58.624954,NULL,0,0,0,100,0), +(@PATH,29,-6141.6694,-3650.3577,-58.624954,NULL,0,0,0,100,0), +(@PATH,30,-6123.28,-3640.9934,-58.624954,NULL,0,0,0,100,0), +(@PATH,31,-6108.6865,-3623.8994,-58.624954,NULL,0,0,0,100,0), +(@PATH,32,-6099.0645,-3600.8455,-58.624954,NULL,0,0,0,100,0), +(@PATH,33,-6093.388,-3581.6519,-58.624954,NULL,0,0,0,100,0), +(@PATH,34,-6096.3926,-3568.4915,-58.624954,NULL,0,0,0,100,0), +(@PATH,35,-6062.2173,-3546.6702,-58.624966,NULL,0,0,0,100,0), +(@PATH,36,-6048.2134,-3538.829,-58.624966,NULL,0,0,0,100,0), +(@PATH,37,-6022.5835,-3531.2087,-58.624973,NULL,0,0,0,100,0), +(@PATH,38,-6007.369,-3528.1714,-58.624973,NULL,0,0,0,100,0), +(@PATH,39,-5996.6787,-3533.4485,-58.624973,NULL,0,0,0,100,0), +(@PATH,40,-5978.62,-3529.2083,-58.624973,NULL,0,0,0,100,0), +(@PATH,41,-5963.492,-3514.8665,-58.374992,NULL,0,0,0,100,0), +(@PATH,42,-5950.205,-3508.0159,-58.624992,NULL,0,0,0,100,0), +(@PATH,43,-5927.1836,-3500.981,-58.374992,NULL,0,0,0,100,0), +(@PATH,44,-5911.841,-3499.235,-58.158527,NULL,0,0,0,100,0), +(@PATH,45,-5883.246,-3499.5684,-58.080044,NULL,0,0,0,100,0), +(@PATH,46,-5858.184,-3506.1418,-58.24999,NULL,0,0,0,100,0), +(@PATH,47,-5847.03,-3516.6768,-58.49999,NULL,0,0,0,100,0), +(@PATH,48,-5833.535,-3534.1719,-58.62499,NULL,0,0,0,100,0), +(@PATH,49,-5827.3213,-3554.03,-58.62499,NULL,0,0,0,100,0); |