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

-- v1.23's manual repositioning pass (2026_08_21_02.sql) fixed where each Waygate Stone stands, but
-- `mod_waygate_network_locations` -- the table `.waygate` actually teleports players to -- was never
-- updated to match. It still held each destination's *original* coordinates (the same ones the
-- stones themselves used to spawn on top of, back before v1.17's offset), so a character travelling
-- to e.g. Stormwind City would land at the old spot, not next to the stone they can see on the map.
--
-- Fixed by computing, for each of the 74 destinations, a point 1 yard directly in front of its
-- (now-corrected) stone -- along the stone's own saved `orientation` (`new_x = stone_x + cos(o)`,
-- `new_y = stone_y + sin(o)`) -- with the arrival orientation facing back toward the stone
-- (`stone_o + pi`, normalized to [0, 2*pi)). Computed from the real, current `gameobject` rows for
-- entries 913001-913074 (id - 913000 = destination id), not re-asked of the user -- this offset is a
-- deterministic function of data already gathered during v1.23, unlike the stone positions
-- themselves, which needed a real walkthrough.
UPDATE `mod_waygate_network_locations` SET `position_x` = -8856.6883, `position_y` = 643.9119, `position_z` = 96.6600, `orientation` = 2.119657 WHERE `id` = 1;
UPDATE `mod_waygate_network_locations` SET `position_x` = -4898.5201, `position_y` = -965.0195, `position_z` = 501.4470, `orientation` = 5.394023 WHERE `id` = 2;
UPDATE `mod_waygate_network_locations` SET `position_x` = 1563.0639, `position_y` = 218.9333, `position_z` = -43.1036, `orientation` = 3.931464 WHERE `id` = 3;
UPDATE `mod_waygate_network_locations` SET `position_x` = 9858.4407, `position_y` = 2448.4108, `position_z` = 1316.6000, `orientation` = 2.795567 WHERE `id` = 4;
UPDATE `mod_waygate_network_locations` SET `position_x` = 1544.1893, `position_y` = -4380.9728, `position_z` = 1.2638, `orientation` = 5.146653 WHERE `id` = 5;
UPDATE `mod_waygate_network_locations` SET `position_x` = -1206.3161, `position_y` = 58.4236, `position_z` = 131.3540, `orientation` = 5.870703 WHERE `id` = 6;
UPDATE `mod_waygate_network_locations` SET `position_x` = -4158.1624, `position_y` = -11609.8736, `position_z` = -139.4570, `orientation` = 2.758657 WHERE `id` = 7;
UPDATE `mod_waygate_network_locations` SET `position_x` = 9573.8494, `position_y` = -7135.1553, `position_z` = 15.2165, `orientation` = 3.176342 WHERE `id` = 8;
UPDATE `mod_waygate_network_locations` SET `position_x` = -1888.1837, `position_y` = 5491.7032, `position_z` = -12.4269, `orientation` = 0.858377 WHERE `id` = 9;
UPDATE `mod_waygate_network_locations` SET `position_x` = 5821.6511, `position_y` = 642.4830, `position_z` = 648.0000, `orientation` = 0.046057 WHERE `id` = 10;
UPDATE `mod_waygate_network_locations` SET `position_x` = -6703.7848, `position_y` = -2208.0991, `position_z` = 249.4230, `orientation` = 4.087281 WHERE `id` = 11;
UPDATE `mod_waygate_network_locations` SET `position_x` = -5618.0644, `position_y` = -526.8643, `position_z` = 403.2910, `orientation` = 5.508173 WHERE `id` = 12;
UPDATE `mod_waygate_network_locations` SET `position_x` = -10545.4013, `position_y` = -1199.0800, `position_z` = 27.2318, `orientation` = 3.191621 WHERE `id` = 13;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2307.6578, `position_y` = -5345.4358, `position_z` = 91.5743, `orientation` = 2.385955 WHERE `id` = 14;
UPDATE `mod_waygate_network_locations` SET `position_x` = -9475.9841, `position_y` = 78.0010, `position_z` = 57.3304, `orientation` = 0.392167 WHERE `id` = 15;
UPDATE `mod_waygate_network_locations` SET `position_x` = -788.6112, `position_y` = -553.9634, `position_z` = 19.2759, `orientation` = 5.542813 WHERE `id` = 16;
UPDATE `mod_waygate_network_locations` SET `position_x` = -49.5432, `position_y` = -934.9030, `position_z` = 54.9493, `orientation` = 5.415283 WHERE `id` = 17;
UPDATE `mod_waygate_network_locations` SET `position_x` = -5288.7753, `position_y` = -2968.8109, `position_z` = 351.8530, `orientation` = 1.196827 WHERE `id` = 18;
UPDATE `mod_waygate_network_locations` SET `position_x` = -9246.0610, `position_y` = -2185.9462, `position_z` = 63.9336, `orientation` = 0.589827 WHERE `id` = 19;
UPDATE `mod_waygate_network_locations` SET `position_x` = 470.1911, `position_y` = 1571.4511, `position_z` = 127.2400, `orientation` = 4.199073 WHERE `id` = 20;
UPDATE `mod_waygate_network_locations` SET `position_x` = -14463.0788, `position_y` = 454.2790, `position_z` = 3.6956, `orientation` = 4.385433 WHERE `id` = 21;
UPDATE `mod_waygate_network_locations` SET `position_x` = -10431.9030, `position_y` = -3240.7475, `position_z` = 20.6485, `orientation` = 3.063977 WHERE `id` = 22;
UPDATE `mod_waygate_network_locations` SET `position_x` = 265.4453, `position_y` = -2050.9874, `position_z` = 170.3470, `orientation` = 6.119833 WHERE `id` = 23;
UPDATE `mod_waygate_network_locations` SET `position_x` = -626.4543, `position_y` = -4617.7018, `position_z` = 9.2111, `orientation` = 3.392455 WHERE `id` = 24;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2280.9173, `position_y` = 253.5901, `position_z` = 34.1314, `orientation` = 4.957563 WHERE `id` = 25;
UPDATE `mod_waygate_network_locations` SET `position_x` = -10572.2248, `position_y` = 1053.4390, `position_z` = 36.5986, `orientation` = 5.523123 WHERE `id` = 26;
UPDATE `mod_waygate_network_locations` SET `position_x` = -3731.0967, `position_y` = -848.4880, `position_z` = 12.1629, `orientation` = 2.454817 WHERE `id` = 27;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2800.7980, `position_y` = -376.4476, `position_z` = 108.2100, `orientation` = 4.303033 WHERE `id` = 28;
UPDATE `mod_waygate_network_locations` SET `position_x` = 6425.3002, `position_y` = 458.0098, `position_z` = 8.4823, `orientation` = 2.265567 WHERE `id` = 29;
UPDATE `mod_waygate_network_locations` SET `position_x` = -1646.6999, `position_y` = 3142.6935, `position_z` = 25.6984, `orientation` = 1.159357 WHERE `id` = 30;
UPDATE `mod_waygate_network_locations` SET `position_x` = 301.1524, `position_y` = -4627.4173, `position_z` = 20.6418, `orientation` = 1.954517 WHERE `id` = 31;
UPDATE `mod_waygate_network_locations` SET `position_x` = -3105.0936, `position_y` = -2926.7770, `position_z` = 44.6116, `orientation` = 6.169913 WHERE `id` = 32;
UPDATE `mod_waygate_network_locations` SET `position_x` = -4607.3381, `position_y` = -3154.3180, `position_z` = 34.9249, `orientation` = 0.209537 WHERE `id` = 33;
UPDATE `mod_waygate_network_locations` SET `position_x` = -3762.3710, `position_y` = -4393.5774, `position_z` = 11.0999, `orientation` = 5.081723 WHERE `id` = 34;
UPDATE `mod_waygate_network_locations` SET `position_x` = -4373.0802, `position_y` = 251.3282, `position_z` = 27.2254, `orientation` = 1.550547 WHERE `id` = 35;
UPDATE `mod_waygate_network_locations` SET `position_x` = -4416.7418, `position_y` = 3272.2473, `position_z` = 13.2425, `orientation` = 5.308963 WHERE `id` = 36;
UPDATE `mod_waygate_network_locations` SET `position_x` = -2297.2200, `position_y` = -396.3248, `position_z` = -8.8222, `orientation` = 6.277013 WHERE `id` = 37;
UPDATE `mod_waygate_network_locations` SET `position_x` = -6835.4260, `position_y` = 822.9256, `position_z` = 49.6286, `orientation` = 1.474697 WHERE `id` = 38;
UPDATE `mod_waygate_network_locations` SET `position_x` = -7148.8971, `position_y` = -3693.3766, `position_z` = 9.9350, `orientation` = 3.727994 WHERE `id` = 39;
UPDATE `mod_waygate_network_locations` SET `position_x` = 9904.5035, `position_y` = 949.0088, `position_z` = 1313.1800, `orientation` = 1.238207 WHERE `id` = 40;
UPDATE `mod_waygate_network_locations` SET `position_x` = -490.3707, `position_y` = -2683.4897, `position_z` = 96.8085, `orientation` = 4.121307 WHERE `id` = 41;
UPDATE `mod_waygate_network_locations` SET `position_x` = -2335.4079, `position_y` = -1916.7368, `position_z` = 97.0273, `orientation` = 0.354207 WHERE `id` = 42;
UPDATE `mod_waygate_network_locations` SET `position_x` = -1052.9144, `position_y` = -3690.0163, `position_z` = 26.7908, `orientation` = 3.235480 WHERE `id` = 43;
UPDATE `mod_waygate_network_locations` SET `position_x` = -5495.8298, `position_y` = -2455.7777, `position_z` = 89.1580, `orientation` = 3.714771 WHERE `id` = 44;
UPDATE `mod_waygate_network_locations` SET `position_x` = 6694.7792, `position_y` = -4694.3140, `position_z` = 722.1560, `orientation` = 4.623103 WHERE `id` = 45;
UPDATE `mod_waygate_network_locations` SET `position_x` = -4131.5303, `position_y` = -12490.0756, `position_z` = 43.9000, `orientation` = 1.792257 WHERE `id` = 46;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2039.9410, `position_y` = 6868.3616, `position_z` = 175.6900, `orientation` = 4.841733 WHERE `id` = 47;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2260.3049, `position_y` = 6010.3521, `position_z` = 143.6660, `orientation` = 4.837803 WHERE `id` = 48;
UPDATE `mod_waygate_network_locations` SET `position_x` = 8768.3833, `position_y` = -6677.9691, `position_z` = 69.3030, `orientation` = 6.202223 WHERE `id` = 49;
UPDATE `mod_waygate_network_locations` SET `position_x` = 7563.6910, `position_y` = -6812.4673, `position_z` = 87.2233, `orientation` = 4.591093 WHERE `id` = 50;
UPDATE `mod_waygate_network_locations` SET `position_x` = -791.3629, `position_y` = 2738.6715, `position_z` = 116.5090, `orientation` = 1.319227 WHERE `id` = 51;
UPDATE `mod_waygate_network_locations` SET `position_x` = 132.2875, `position_y` = 2604.3316, `position_z` = 98.7696, `orientation` = 4.340403 WHERE `id` = 52;
UPDATE `mod_waygate_network_locations` SET `position_x` = -1222.9716, `position_y` = 7207.8620, `position_z` = 58.1420, `orientation` = 0.704957 WHERE `id` = 53;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3005.8135, `position_y` = 3694.5511, `position_z` = 136.6440, `orientation` = 4.263973 WHERE `id` = 54;
UPDATE `mod_waygate_network_locations` SET `position_x` = -3990.8400, `position_y` = 2113.3882, `position_z` = 105.1440, `orientation` = 4.459673 WHERE `id` = 55;
UPDATE `mod_waygate_network_locations` SET `position_x` = -2978.9348, `position_y` = 2640.9961, `position_z` = 77.1177, `orientation` = 0.933807 WHERE `id` = 56;
UPDATE `mod_waygate_network_locations` SET `position_x` = -2943.1845, `position_y` = 3991.6421, `position_z` = -0.5584, `orientation` = 4.949113 WHERE `id` = 57;
UPDATE `mod_waygate_network_locations` SET `position_x` = -2626.9641, `position_y` = 4397.9571, `position_z` = 34.8465, `orientation` = 3.309439 WHERE `id` = 58;
UPDATE `mod_waygate_network_locations` SET `position_x` = -221.6757, `position_y` = 5597.2968, `position_z` = 19.2509, `orientation` = 0.932647 WHERE `id` = 59;
UPDATE `mod_waygate_network_locations` SET `position_x` = 992.7017, `position_y` = 7378.4748, `position_z` = 36.1411, `orientation` = 5.683053 WHERE `id` = 60;
UPDATE `mod_waygate_network_locations` SET `position_x` = 275.2345, `position_y` = 7821.4828, `position_z` = 19.4389, `orientation` = 3.679982 WHERE `id` = 61;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2294.0302, `position_y` = 5249.9716, `position_z` = 11.4044, `orientation` = 4.200093 WHERE `id` = 62;
UPDATE `mod_waygate_network_locations` SET `position_x` = 2770.7907, `position_y` = 6086.1160, `position_z` = 77.7049, `orientation` = 6.136643 WHERE `id` = 63;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3486.6041, `position_y` = 4104.7500, `position_z` = 17.9141, `orientation` = 2.366177 WHERE `id` = 64;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3779.9132, `position_y` = 1619.9024, `position_z` = 87.1180, `orientation` = 2.218357 WHERE `id` = 65;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3841.7537, `position_y` = -726.0790, `position_z` = 221.3270, `orientation` = 2.310047 WHERE `id` = 66;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3536.0535, `position_y` = 303.9621, `position_z` = 47.2876, `orientation` = 2.959707 WHERE `id` = 67;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3420.9379, `position_y` = -2840.2652, `position_z` = 202.1290, `orientation` = 0.125537 WHERE `id` = 68;
UPDATE `mod_waygate_network_locations` SET `position_x` = 3236.2944, `position_y` = -2273.6894, `position_z` = 108.6130, `orientation` = 1.535147 WHERE `id` = 69;
UPDATE `mod_waygate_network_locations` SET `position_x` = 530.7693, `position_y` = -4995.1537, `position_z` = 10.5720, `orientation` = 3.672528 WHERE `id` = 70;
UPDATE `mod_waygate_network_locations` SET `position_x` = 1911.8067, `position_y` = -6151.9150, `position_z` = 18.7469, `orientation` = 5.347573 WHERE `id` = 71;
UPDATE `mod_waygate_network_locations` SET `position_x` = 5537.9952, `position_y` = 5773.1766, `position_z` = -77.3146, `orientation` = 1.455777 WHERE `id` = 72;
UPDATE `mod_waygate_network_locations` SET `position_x` = 6085.7486, `position_y` = -1038.5759, `position_z` = 405.5590, `orientation` = 5.910503 WHERE `id` = 73;
UPDATE `mod_waygate_network_locations` SET `position_x` = 5426.3551, `position_y` = -2593.0236, `position_z` = 303.9540, `orientation` = 4.797413 WHERE `id` = 74;
🍯 Glaze

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