-- Fourth and final continent for item 2 of PLAN.md's "Next steps": 13 Northrend destinations (IDs
-- 62-74). Same method as the Eastern Kingdoms/Kalimdor/Outland batches (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 inferred rather than DB-confirmed (nearest named graveyard was a generic label, not a
-- settlement, but the resolved zone/faction/coordinates matched a well-known real location): Conquest
-- Hold (Grizzly Hills, Horde), K3 (The Storm Peaks, Neutral -- also the largest nearest-graveyard
-- distance in this batch, 315 yards, so lower confidence than the other two), and The Argent Stand
-- (Zul'Drak, Neutral). Worth an in-game glance before trusting these three.
--
-- Skipped, each for a real, checked reason:
-- - Crystalsong Forest: every innkeeper there matched within ~50-180 yards of the existing Dalaran
--   capital destination (Dalaran floats directly above Crystalsong Forest) -- all redundant.
-- - Icecrown: no confident position available. The one promising-looking pair (Caris Sunlance /
--   Jarin Dawnglow at the Argent Tournament Grounds, faction Alliance/Horde) turned out to resolve to
--   AreaTable.dbc zone id 4722 ("Trial of the Crusader"), which is itself tagged to map 649 -- a
--   different map entirely from Northrend's map 571 the creatures actually spawn on. That mismatch
--   is exactly the kind of red flag this module's verification method exists to catch: using zone
--   4722 for attunement matching could silently never match a real player's reported zone while
--   standing there, since it's unclear whether that's really what the client/server reports for that
--   spot. Left out rather than risk a destination that looks fine in SQL but silently never attunes.
-- - Several other zones (Howling Fjord's Basil Osgood/Bori Wintertotem/Christina Daniels/Celeste
--   Goodhutch/Caregiver Iqniq, Storm Peaks' Gunda Boldhammer/Lodge-Matron Embla/Magorn/Peon Gakra/
--   Wabada Whiteflower, Grizzly Hills' Aiyan Coldwind/Quartermaster McCarty, Zul'Drak's Pan'ya,
--   Borean Tundra's Caregiver Poallu) all matched only generic/unnamed graveyards ("North GY",
--   "Foot Steppes GY", etc.) at moderate-to-large distances -- none confident enough to name and
--   include, especially once a real DB-confirmed alternative already covered the same zone/faction.
DELETE FROM `mod_waygate_network_locations` WHERE `id` BETWEEN 62 AND 74;
INSERT INTO `mod_waygate_network_locations`
    (`id`, `name`, `continent`, `faction`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`)
VALUES
    (62, 'Valiance Keep',    'Northrend', 'Alliance', 571, 3537, 2282.29, 5210.83,  12.577, 4.259),
    (63, 'Warsong Hold',     'Northrend', 'Horde',    571, 3537, 2803.70, 6154.50,  85.246, 3.910),
    (64, "Taunka'le Village", 'Northrend', 'Neutral', 571, 3537, 3468.64, 4175.04,  17.276, 4.206),
    (65, "Agmar's Hammer",   'Northrend', 'Horde',    571, 65,   3830.37, 1485.49,  92.061, 0.838),
    (66, 'Wintergarde Keep', 'Northrend', 'Alliance', 571, 65,   3647.95, -717.20, 215.034, 3.013),
    (67, 'Wyrmrest Temple',  'Northrend', 'Neutral',  571, 65,   3546.74,  273.06,  45.663, 1.815),
    (68, 'Amberpine Lodge',  'Northrend', 'Alliance', 571, 394,  3406.96,-2788.63, 201.604, 5.480),
    (69, 'Conquest Hold',    'Northrend', 'Horde',    571, 394,  3256.43,-2202.08, 117.112, 5.794),
    (70, 'Valgarde',         'Northrend', 'Alliance', 571, 495,   599.04,-4928.18,  19.087, 4.992),
    (71, 'Vengeance Landing','Northrend', 'Horde',    571, 495,  1873.32,-6218.15,  13.184, 1.344),
    (72, 'Camp Nesingwary',  'Northrend', 'Neutral',  571, 3711, 5566.25, 5763.71, -75.142, 6.231),
    (73, 'K3',               'Northrend', 'Neutral',  571, 67,   6124.42,-1080.96, 402.624, 2.496),
    (74, 'The Argent Stand', 'Northrend', 'Neutral',  571, 66,   5462.97,-2639.05, 306.634, 2.775);