diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_10_02_world.sql | 77 |
1 files changed, 77 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_10_02_world.sql b/sql/updates/world/3.3.5/2024_10_10_02_world.sql new file mode 100644 index 00000000000..3568360f779 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_10_02_world.sql @@ -0,0 +1,77 @@ +-- Pathing for Murderous Blisterpaw Entry: 8208 +SET @NPC=8208; +SET @GUID=51825; +SET @PATH=@GUID * 10; +UPDATE `creature` SET `position_x`=-7025.515,`position_y`=-3491.132,`position_z`=9.274621,`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,-7025.515,-3491.132,9.274621,NULL,0,0,0,100,0), +(@PATH,2,-7057.585,-3499.684,10.376134,NULL,0,0,0,100,0), +(@PATH,3,-7083.3726,-3521.9758,11.747719,NULL,0,0,0,100,0), +(@PATH,4,-7116.227,-3516.6216,10.375974,NULL,0,0,0,100,0), +(@PATH,5,-7143.2266,-3517.4648,10.078375,NULL,0,0,0,100,0), +(@PATH,6,-7172.1216,-3513.6719,11.342711,NULL,0,0,0,100,0), +(@PATH,7,-7202.048,-3508.731,11.024831,NULL,0,0,0,100,0), +(@PATH,8,-7247.1226,-3513.0464,11.260182,NULL,0,0,0,100,0), +(@PATH,9,-7277.5615,-3524.6765,12.185095,NULL,0,0,0,100,0), +(@PATH,10,-7302.512,-3540.7358,8.5952,NULL,0,0,0,100,0), +(@PATH,11,-7328.6494,-3568.7114,10.502499,NULL,0,0,0,100,0), +(@PATH,12,-7341.257,-3601.2178,9.939367,NULL,0,0,0,100,0), +(@PATH,13,-7362.0376,-3633.9546,11.387863,NULL,0,0,0,100,0), +(@PATH,14,-7383.2837,-3658.7517,10.012263,NULL,0,0,0,100,0), +(@PATH,15,-7396.5024,-3698.1814,9.407527,NULL,0,0,0,100,0), +(@PATH,16,-7405.75,-3719.763,9.256791,NULL,0,0,0,100,0), +(@PATH,17,-7420.3613,-3750.827,12.278984,NULL,0,0,0,100,0), +(@PATH,18,-7414.9087,-3767.6528,12.649624,NULL,0,0,0,100,0), +(@PATH,19,-7396.8125,-3813.4487,10.233704,NULL,0,0,0,100,0), +(@PATH,20,-7385.053,-3851.4045,10.949272,NULL,0,0,0,100,0), +(@PATH,21,-7363.6816,-3878.0642,11.944022,NULL,0,0,0,100,0), +(@PATH,22,-7366.593,-3917.8196,14.590536,NULL,0,0,0,100,0), +(@PATH,23,-7368.6016,-3951.2683,11.180499,NULL,0,0,0,100,0), +(@PATH,24,-7388.428,-3989.5295,9.057527,NULL,0,0,0,100,0), +(@PATH,25,-7419.9297,-4017.759,10.126763,NULL,0,0,0,100,0), +(@PATH,26,-7455.046,-3985.4866,11.490533,NULL,0,0,0,100,0), +(@PATH,27,-7484.066,-3945.0916,10.125787,NULL,0,0,0,100,0), +(@PATH,28,-7518.1597,-3916.549,10.933404,NULL,0,0,0,100,0), +(@PATH,29,-7545.4316,-3950.7153,10.655572,NULL,0,0,0,100,0), +(@PATH,30,-7549.514,-3973.414,12.167756,NULL,0,0,0,100,0), +(@PATH,31,-7550.2954,-4013.2153,12.256833,NULL,0,0,0,100,0), +(@PATH,32,-7552.7324,-4045.1523,11.282222,NULL,0,0,0,100,0), +(@PATH,33,-7549.6675,-4078.2886,11.486598,NULL,0,0,0,100,0), +(@PATH,34,-7547.963,-4113.612,10.832579,NULL,0,0,0,100,0), +(@PATH,35,-7549.6675,-4078.2886,11.486598,NULL,0,0,0,100,0), +(@PATH,36,-7552.731,-4045.2805,11.270747,NULL,0,0,0,100,0), +(@PATH,37,-7550.2954,-4013.2153,12.256833,NULL,0,0,0,100,0), +(@PATH,38,-7549.514,-3973.414,12.167756,NULL,0,0,0,100,0), +(@PATH,39,-7545.4316,-3950.7153,10.655572,NULL,0,0,0,100,0), +(@PATH,40,-7518.1597,-3916.549,10.933404,NULL,0,0,0,100,0), +(@PATH,41,-7484.066,-3945.0916,10.125787,NULL,0,0,0,100,0), +(@PATH,42,-7455.046,-3985.4866,11.490533,NULL,0,0,0,100,0), +(@PATH,43,-7419.9297,-4017.759,10.126763,NULL,0,0,0,100,0), +(@PATH,44,-7388.428,-3989.5295,9.057527,NULL,0,0,0,100,0), +(@PATH,45,-7368.6074,-3951.3164,11.189776,NULL,0,0,0,100,0), +(@PATH,46,-7366.593,-3917.8196,14.590536,NULL,0,0,0,100,0), +(@PATH,47,-7363.6816,-3878.0642,11.944022,NULL,0,0,0,100,0), +(@PATH,48,-7385.053,-3851.4045,10.949272,NULL,0,0,0,100,0), +(@PATH,49,-7396.8125,-3813.4487,10.233704,NULL,0,0,0,100,0), +(@PATH,50,-7414.9087,-3767.6528,12.649624,NULL,0,0,0,100,0), +(@PATH,51,-7420.3613,-3750.827,12.278984,NULL,0,0,0,100,0), +(@PATH,52,-7405.75,-3719.763,9.256791,NULL,0,0,0,100,0), +(@PATH,53,-7396.5024,-3698.1814,9.407527,NULL,0,0,0,100,0), +(@PATH,54,-7383.2837,-3658.7517,10.012263,NULL,0,0,0,100,0), +(@PATH,55,-7362.0376,-3633.9546,11.387863,NULL,0,0,0,100,0), +(@PATH,56,-7341.257,-3601.2178,9.939367,NULL,0,0,0,100,0), +(@PATH,57,-7328.6494,-3568.7114,10.502499,NULL,0,0,0,100,0), +(@PATH,58,-7302.512,-3540.7358,8.5952,NULL,0,0,0,100,0), +(@PATH,59,-7277.5615,-3524.6765,12.185095,NULL,0,0,0,100,0), +(@PATH,60,-7247.1226,-3513.0464,11.260182,NULL,0,0,0,100,0), +(@PATH,61,-7202.048,-3508.731,11.024831,NULL,0,0,0,100,0), +(@PATH,62,-7172.1216,-3513.6719,11.342711,NULL,0,0,0,100,0), +(@PATH,63,-7143.2637,-3517.452,10.110113,NULL,0,0,0,100,0), +(@PATH,64,-7116.227,-3516.6216,10.375974,NULL,0,0,0,100,0), +(@PATH,65,-7083.3726,-3521.9758,11.747719,NULL,0,0,0,100,0), +(@PATH,66,-7057.585,-3499.684,10.376134,NULL,0,0,0,100,0); |