diff options
author | Aokromes <Aokromes@users.noreply.github.com> | 2024-10-07 15:34:57 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2024-10-07 15:34:57 +0200 |
commit | af1f9c1edda80fcdc7cd07d70f9acb647b81808b (patch) | |
tree | 2aca5936582bb014aeb7d64099cf8c50a6f87167 | |
parent | 4e70960ded2f64c53d5d4db4622a8640bafcb2d1 (diff) |
DB/Creature: Add waypoints to Harb Foulmountain
closes #30278 by CraftedRO
-rw-r--r-- | sql/updates/world/3.3.5/2024_10_07_01_world.sql | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_07_01_world.sql b/sql/updates/world/3.3.5/2024_10_07_01_world.sql new file mode 100644 index 00000000000..695691fd7f0 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_07_01_world.sql @@ -0,0 +1,35 @@ +-- Pathing for Harb Foulmountain +SET @PATH=21564 * 10; +SET @NPC=14426; +UPDATE `creature` SET `position_x`=-4929.023,`position_y`=-2066.4766,`position_z`=85.52668,`wander_distance`=0,`MovementType`=2 WHERE `guid`=21564; +UPDATE `creature_template` SET `MovementType`= 2 WHERE `entry`=@NPC; +UPDATE `creature_template_addon` SET `PvPFlags` = 0 WHERE `entry`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=21564; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `visibilityDistanceType`, `auras`) VALUES +(21564, @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,-4929.023,-2066.4766,85.52668,NULL,0,0,0,100,0), +(@PATH,2,-4905.3555,-2069.9805,84.25914,NULL,0,0,0,100,0), +(@PATH,3,-4899.6943,-2061.0269,83.636856,NULL,0,0,0,100,0), +(@PATH,4,-4891.1626,-2039.651,83.30705,NULL,0,0,0,100,0), +(@PATH,5,-4881.945,-2017.6359,86.298546,NULL,0,0,0,100,0), +(@PATH,6,-4873.128,-1993.7965,91.65875,NULL,0,0,0,100,0), +(@PATH,7,-4878.21,-1974.4436,92.018616,NULL,0,0,0,100,0), +(@PATH,8,-4873.579,-1956.8225,90.450455,NULL,0,0,0,100,0), +(@PATH,9,-4862.9395,-1946.7357,86.90235,NULL,0,0,0,100,0), +(@PATH,10,-4834.9155,-1923.0642,84.13316,NULL,0,0,0,100,0), +(@PATH,11,-4801.48,-1895.6833,89.333145,NULL,0,0,0,100,0), +(@PATH,12,-4776.8984,-1881.0486,90.39604,NULL,0,0,0,100,0), +(@PATH,13,-4751.4434,-1865.2213,88.92392,NULL,0,0,0,100,0), +(@PATH,14,-4776.8984,-1881.0486,90.39604,NULL,0,0,0,100,0), +(@PATH,15,-4801.48,-1895.6833,89.333145,NULL,0,0,0,100,0), +(@PATH,16,-4834.9155,-1923.0642,84.13316,NULL,0,0,0,100,0), +(@PATH,17,-4862.9395,-1946.7357,86.90235,NULL,0,0,0,100,0), +(@PATH,18,-4873.579,-1956.8225,90.450455,NULL,0,0,0,100,0), +(@PATH,19,-4878.21,-1974.4436,92.018616,NULL,0,0,0,100,0), +(@PATH,20,-4873.128,-1993.7965,91.65875,NULL,0,0,0,100,0), +(@PATH,21,-4881.914,-2017.5612,86.331604,NULL,0,0,0,100,0), +(@PATH,22,-4891.1626,-2039.651,83.30705,NULL,0,0,0,100,0), +(@PATH,23,-4899.6943,-2061.0269,83.636856,NULL,0,0,0,100,0), +(@PATH,24,-4905.3555,-2069.9805,84.25914,NULL,0,0,0,100,0); |