diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2024-10-10 09:45:26 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-10-10 09:45:26 +0200 |
| commit | b347cb2f4d57ea17805ce360dcf0cc78dc5f6a93 (patch) | |
| tree | feccf4159a6b7220492b2bd580777a5503e45404 | |
| parent | 275436eacfe775dceb52df1b924804d31339563a (diff) | |
DB/Creature: Add waypoints to Zora
closes #30331 by CraftedRO
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_10_08_world.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_10_08_world.sql b/sql/updates/world/3.3.5/2024_10_10_08_world.sql new file mode 100644 index 00000000000..32dd1d83bb3 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_10_08_world.sql @@ -0,0 +1,17 @@ +-- Pathing for Zora:14474 +SET @NPC=14474; +SET @GUID=51835; +SET @PATH=@GUID * 10; +UPDATE `creature` SET `position_x`=-7378.239,`position_y`=1714.3088,`position_z`=-91.72752,`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,-7378.239,1714.3088,-91.72752,NULL,0,0,0,100,0), +(@PATH,2,-7393.453,1717.8257,-92.846466,NULL,0,0,0,100,0), +(@PATH,3,-7401.651,1709.8647,-92.29474,NULL,0,0,0,100,0), +(@PATH,4,-7396.23,1696.348,-92.5287,NULL,0,0,0,100,0), +(@PATH,5,-7377.1226,1687.7341,-91.2392,NULL,0,0,0,100,0), +(@PATH,6,-7368.2925,1700.2347,-86.44376,NULL,0,0,0,100,0); |