-- Third continent for item 2 of PLAN.md's "Next steps": 16 Outland destinations (IDs 46-61). Same
-- method as the Kalimdor batch (2026_08_15_06.sql -- innkeeper NPC spawn = position,
-- graveyard_zone/game_graveyard's named Comment field = zone + town name, creature_template.faction
-- -> FactionTemplate.dbc's ourMask = faction).
--
-- Three names in this batch are inferred rather than DB-confirmed (the nearest named graveyard was a
-- generic label, not a settlement name), based on the resolved zone/faction plus the NPC's
-- coordinates matching well-known real town locations: Garadar (Nagrand, Horde), Allerian Stronghold
-- and Stonebreaker Hold (both Terokkar Forest). Worth an in-game glance before trusting these three,
-- same caveat as v1.11's Revantusk Village/Menethil Harbor.
--
-- Skipped, each for a real, checked reason:
-- - Several Eversong Woods innkeepers (Delaniel/Jovia/Velandra) all matched within 70-590 yards of
-- Silvermoon City -- redundant with the existing capital destination.
-- - Blade's Edge Mountains had two more candidates (Toshley's Station, Evergrove) beyond the two
-- picked -- skipped as a second Alliance entry in the same zone / a naming-confidence gap.
-- - Hellfire Peninsula's "Innkeeper Bazil Olof'tazun" resolved (by faction data) to Horde but matched
-- nearest to a graveyard real known to be an Alliance-owned outpost (Falcon Watch) -- a real
-- contradiction between the two signals this batch relies on, so left out rather than asserted
-- either way. A second Alliance candidate (Temple of Telhamat) was also skipped as redundant with
-- Honor Hold.
-- - Terokkar Forest's "Innkeeper Haelthol" and "Minalei" both matched Shattrath City at a fairly
-- large distance (600-800 yards) -- likely just zone-adjacent NPCs, not actually at the (already
-- covered, as capital ID 9) city itself, and too far to trust as "at" it either.
-- - Isle of Quel'Danas skipped entirely -- its one candidate matched a generic "Staging Area"
-- graveyard, no confident real settlement name; also a small late-added daily-quest island, lower
-- priority than a full zone hub.
-- - Azuremyst Isle's "Caregiver Breel" matched a furbolg-camp-named graveyard ("Stillpine"), not a
-- real player settlement -- the zone's real hub (Azure Watch) is already covered by "Caregiver
-- Chellan" instead.
-- - Four NPCs (Topher Loaal, Isel, Eyonix, Varah) all resolved to non-standard zone labels ("The
-- Veiled Sea", "Twisting Nether") -- almost certainly boat-crew NPCs for the Azuremyst/Bloodmyst
-- naval transports, not real quest hubs.
DELETE FROM `mod_waygate_network_locations` WHERE `id` BETWEEN 46 AND 61;
INSERT INTO `mod_waygate_network_locations`
(`id`, `name`, `continent`, `faction`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`)
VALUES
(46, 'Azure Watch', 'Outland', 'Alliance', 530, 3524, -4129.43,-12469.00, 44.185, 3.905),
(47, 'Sylvanaar', 'Outland', 'Alliance', 530, 3522, 2098.18, 6903.92, 183.313, 3.752),
(48, 'Thunderlord Stronghold','Outland', 'Horde', 530, 3522, 2404.13, 5950.76, 152.192, 1.763),
(49, 'Fairbreeze Village', 'Outland', 'Horde', 530, 3430, 8700.38, -6638.36, 72.828, 5.515),
(50, 'Tranquillien', 'Outland', 'Horde', 530, 3433, 7553.37, -6897.35, 96.110, 1.100),
(51, 'Honor Hold', 'Outland', 'Alliance', 530, 3483, -708.87, 2739.13, 94.817, 5.044),
(52, 'Thrallmar', 'Outland', 'Horde', 530, 3483, 190.88, 2610.93, 87.367, 2.426),
(53, 'Garadar', 'Outland', 'Horde', 530, 3518, -1229.58, 7161.33, 57.348, 2.478),
(54, 'Area 52', 'Outland', 'Neutral', 530, 3523, 3062.15, 3701.82, 142.562, 4.800),
(55, 'Wildhammer Stronghold', 'Outland', 'Alliance', 530, 3520, -4084.32, 2186.97, 107.585, 0.140),
(56, 'Shadowmoon Village', 'Outland', 'Horde', 530, 3520, -2965.00, 2562.00, 78.600, 2.000),
(57, 'Allerian Stronghold', 'Outland', 'Alliance', 530, 3519, -2917.88, 4021.48, 0.511, 3.665),
(58, 'Stonebreaker Hold', 'Outland', 'Horde', 530, 3519, -2621.78, 4450.30, 36.177, 4.625),
(59, 'Cenarion Refuge', 'Outland', 'Neutral', 530, 3521, -174.48, 5529.21, 29.491, 3.334),
(60, 'The Harborage', 'Outland', 'Alliance', 530, 3521, 1056.38, 7370.99, 39.667, 3.857),
(61, "Zabra'jin", 'Outland', 'Horde', 530, 3521, 228.16, 7933.88, 25.161, 5.131);