2026_08_15_12.sql · mod-waygate-network · main

-- Cosmetic position fix, confirmed needed by in-game testing of the Waygate Stones (v1.16) and the
-- Ley Wardens NPCs (v1.15): both reused destination coordinates verbatim, which themselves were
-- originally sourced by copying a real landmark NPC's exact position -- so every stone (and 3 of the
-- 5 quest NPCs, which additionally share those same coordinates with their corresponding stone) was
-- spawning clipped inside/underneath an existing NPC, and in three spots, inside each other too.
--
-- Stones: nudged 3 yards along each destination's own saved `orientation` (`new_x = x + 3*cos(o)`,
-- `new_y = y + 3*sin(o)`) -- a heuristic, not individually terrain-verified (no vmap/LOS data
-- available from this tool), but a small, low-risk move in the direction the reference point already
-- faces, matching the offset approach agreed for this fix.
--
-- Ley Wardens NPCs: only the three that shared *exact* coordinates with a destination (and therefore
-- with that destination's own stone) needed a change -- Echo of the Ley Wardens (911003, Light's
-- Hope Chapel / destination 14), Windcaller Tyese (911004, Cenarion Hold / destination 38), The First
-- Warden (911006, Wyrmrest Temple / destination 67). Each moved the *opposite* 3 yards from its
-- corresponding stone (`new_x = x - 3*cos(o)`, `new_y = y - 3*sin(o)`), so the original landmark NPC
-- stays exactly where it always was, the stone sits 3 yards to one side of it, and the quest NPC sits
-- 3 yards to the other -- 6 yards apart from each other, symmetric around the original point. Aemos
-- (911002) and Nazrek the Bent (911005) were already manually offset ~9-11 yards from their own
-- landmark references back in v1.15 and don't need any change here.
UPDATE `gameobject` SET `position_x` = -8831.927, `position_y` = 631.253 WHERE `id` = 913001;
UPDATE `gameobject` SET `position_x` = -4916.922, `position_y` = -942.679 WHERE `id` = 913002;
UPDATE `gameobject` SET `position_x` = 1587.137, `position_y` = 240.433 WHERE `id` = 913003;
UPDATE `gameobject` SET `position_x` = 9949.485, `position_y` = 2287.209 WHERE `id` = 913004;
UPDATE `gameobject` SET `position_x` = 1627.302, `position_y` = -4375.223 WHERE `id` = 913005;
UPDATE `gameobject` SET `position_x` = -1275.905, `position_y` = 122.186 WHERE `id` = 913006;
UPDATE `gameobject` SET `position_x` = -3963.725, `position_y` = -11651.342 WHERE `id` = 913007;
UPDATE `gameobject` SET `position_x` = 9490.669, `position_y` = -7279.554 WHERE `id` = 913008;
UPDATE `gameobject` SET `position_x` = -1835.323, `position_y` = 5300.814 WHERE `id` = 913009;
UPDATE `gameobject` SET `position_x` = 5807.695, `position_y` = 591.473 WHERE `id` = 913010;
UPDATE `gameobject` SET `position_x` = -6651.978, `position_y` = -2151.355 WHERE `id` = 913011;
UPDATE `gameobject` SET `position_x` = -5603.189, `position_y` = -528.655 WHERE `id` = 913012;
UPDATE `gameobject` SET `position_x` = -10517.887, `position_y` = -1163.542 WHERE `id` = 913013;
UPDATE `gameobject` SET `position_x` = 2299.223, `position_y` = -5342.603 WHERE `id` = 913014;
UPDATE `gameobject` SET `position_x` = -9465.644, `position_y` = 16.503 WHERE `id` = 913015;
UPDATE `gameobject` SET `position_x` = -857.047, `position_y` = -567.750 WHERE `id` = 913016;
UPDATE `gameobject` SET `position_x` = -8.732, `position_y` = -941.110 WHERE `id` = 913017;
UPDATE `gameobject` SET `position_x` = -5378.533, `position_y` = -2970.975 WHERE `id` = 913018;
UPDATE `gameobject` SET `position_x` = -9226.968, `position_y` = -2156.858 WHERE `id` = 913019;
UPDATE `gameobject` SET `position_x` = 509.748, `position_y` = 1633.708 WHERE `id` = 913020;
UPDATE `gameobject` SET `position_x` = -14459.708, `position_y` = 493.121 WHERE `id` = 913021;
UPDATE `gameobject` SET `position_x` = -10484.317, `position_y` = -3258.526 WHERE `id` = 913022;
UPDATE `gameobject` SET `position_x` = 400.378, `position_y` = -2122.669 WHERE `id` = 913023;
UPDATE `gameobject` SET `position_x` = -619.872, `position_y` = -4585.484 WHERE `id` = 913024;
UPDATE `gameobject` SET `position_x` = 2267.052, `position_y` = 243.220 WHERE `id` = 913025;
UPDATE `gameobject` SET `position_x` = -10650.824, `position_y` = 1164.982 WHERE `id` = 913026;
UPDATE `gameobject` SET `position_x` = -3825.168, `position_y` = -830.729 WHERE `id` = 913027;
UPDATE `gameobject` SET `position_x` = 2778.616, `position_y` = -431.410 WHERE `id` = 913028;
UPDATE `gameobject` SET `position_x` = 6407.387, `position_y` = 518.239 WHERE `id` = 913029;
UPDATE `gameobject` SET `position_x` = -1594.339, `position_y` = 3147.672 WHERE `id` = 913030;
UPDATE `gameobject` SET `position_x` = 338.861, `position_y` = -4688.888 WHERE `id` = 913031;
UPDATE `gameobject` SET `position_x` = -3163.380, `position_y` = -2909.753 WHERE `id` = 913032;
UPDATE `gameobject` SET `position_x` = -4626.941, `position_y` = -3176.181 WHERE `id` = 913033;
UPDATE `gameobject` SET `position_x` = -3617.936, `position_y` = -4468.425 WHERE `id` = 913034;
UPDATE `gameobject` SET `position_x` = -4457.476, `position_y` = 244.174 WHERE `id` = 913035;
UPDATE `gameobject` SET `position_x` = -4378.592, `position_y` = 3289.555 WHERE `id` = 913036;
UPDATE `gameobject` SET `position_x` = -2362.651, `position_y` = -348.577 WHERE `id` = 913037;
UPDATE `gameobject` SET `position_x` = -6865.392, `position_y` = 731.319 WHERE `id` = 913038;
UPDATE `gameobject` SET `position_x` = -7160.084, `position_y` = -3838.829 WHERE `id` = 913039;
UPDATE `gameobject` SET `position_x` = 9802.472, `position_y` = 979.622 WHERE `id` = 913040;
UPDATE `gameobject` SET `position_x` = -409.989, `position_y` = -2646.096 WHERE `id` = 913041;
UPDATE `gameobject` SET `position_x` = -2374.816, `position_y` = -1993.116 WHERE `id` = 913042;
UPDATE `gameobject` SET `position_x` = -1047.156, `position_y` = -3665.627 WHERE `id` = 913043;
UPDATE `gameobject` SET `position_x` = -5474.997, `position_y` = -2459.503 WHERE `id` = 913044;
UPDATE `gameobject` SET `position_x` = 6697.722, `position_y` = -4671.495 WHERE `id` = 913045;
UPDATE `gameobject` SET `position_x` = -4131.597, `position_y` = -12471.074 WHERE `id` = 913046;
UPDATE `gameobject` SET `position_x` = 2095.722, `position_y` = 6902.200 WHERE `id` = 913047;
UPDATE `gameobject` SET `position_x` = 2403.557, `position_y` = 5953.705 WHERE `id` = 913048;
UPDATE `gameobject` SET `position_x` = 8702.538, `position_y` = -6640.444 WHERE `id` = 913049;
UPDATE `gameobject` SET `position_x` = 7554.731, `position_y` = -6894.676 WHERE `id` = 913050;
UPDATE `gameobject` SET `position_x` = -707.893, `position_y` = 2736.293 WHERE `id` = 913051;
UPDATE `gameobject` SET `position_x` = 188.616, `position_y` = 2612.898 WHERE `id` = 913052;
UPDATE `gameobject` SET `position_x` = -1231.943, `position_y` = 7163.178 WHERE `id` = 913053;
UPDATE `gameobject` SET `position_x` = 3062.412, `position_y` = 3698.832 WHERE `id` = 913054;
UPDATE `gameobject` SET `position_x` = -4081.349, `position_y` = 2187.389 WHERE `id` = 913055;
UPDATE `gameobject` SET `position_x` = -2966.248, `position_y` = 2564.728 WHERE `id` = 913056;
UPDATE `gameobject` SET `position_x` = -2920.478, `position_y` = 4019.980 WHERE `id` = 913057;
UPDATE `gameobject` SET `position_x` = -2622.042, `position_y` = 4447.311 WHERE `id` = 913058;
UPDATE `gameobject` SET `position_x` = -177.425, `position_y` = 5528.636 WHERE `id` = 913059;
UPDATE `gameobject` SET `position_x` = 1054.116, `position_y` = 7369.022 WHERE `id` = 913060;
UPDATE `gameobject` SET `position_x` = 229.379, `position_y` = 7931.139 WHERE `id` = 913061;
UPDATE `gameobject` SET `position_x` = 2280.976, `position_y` = 5208.133 WHERE `id` = 913062;
UPDATE `gameobject` SET `position_x` = 2801.543, `position_y` = 6152.415 WHERE `id` = 913063;
UPDATE `gameobject` SET `position_x` = 3467.185, `position_y` = 4172.416 WHERE `id` = 913064;
UPDATE `gameobject` SET `position_x` = 3832.377, `position_y` = 1487.720 WHERE `id` = 913065;
UPDATE `gameobject` SET `position_x` = 3644.975, `position_y` = -716.815 WHERE `id` = 913066;
UPDATE `gameobject` SET `position_x` = 3546.015, `position_y` = 275.971 WHERE `id` = 913067;
UPDATE `gameobject` SET `position_x` = 3409.043, `position_y` = -2790.789 WHERE `id` = 913068;
UPDATE `gameobject` SET `position_x` = 3259.078, `position_y` = -2203.490 WHERE `id` = 913069;
UPDATE `gameobject` SET `position_x` = 599.868, `position_y` = -4931.063 WHERE `id` = 913070;
UPDATE `gameobject` SET `position_x` = 1873.995, `position_y` = -6215.227 WHERE `id` = 913071;
UPDATE `gameobject` SET `position_x` = 5569.246, `position_y` = 5763.554 WHERE `id` = 913072;
UPDATE `gameobject` SET `position_x` = 6122.024, `position_y` = -1079.155 WHERE `id` = 913073;
UPDATE `gameobject` SET `position_x` = 5460.169, `position_y` = -2637.975 WHERE `id` = 913074;

UPDATE `creature` SET `position_x` = 2302.577, `position_y` = -5347.577 WHERE `id` = 911003;
UPDATE `creature` SET `position_x` = -6870.688, `position_y` = 728.501 WHERE `id` = 911004;
UPDATE `creature` SET `position_x` = 3547.465, `position_y` = 270.149 WHERE `id` = 911006;
🍯 Glaze

/ mod-waygate-network / data / sql / db-world / updates / 2026_08_15_12.sql
