-- Second continent for item 2 of PLAN.md's "Next steps": 18 Kalimdor destinations (IDs 28-45), one
-- major quest-hub town per zone. Same method as the Eastern Kingdoms batch
-- (2026_08_15_05.sql -- real innkeeper NPC spawn = position, nearest-graveyard zone match cross-checked
-- against AreaTable.dbc = zone, creature_template.faction -> FactionTemplate.dbc's ourMask = faction),
-- refined with one extra step this time: `graveyard_zone`/`game_graveyard`'s `Comment` field often
-- already contains the real town name (e.g. "Durotar, Razor Hill"), so each innkeeper was matched
-- against the *specific* named graveyard nearest to it (not just the zone-level match) to confirm the
-- real town name directly, rather than relying on memory/general WoW knowledge for it.
--
-- Skipped, all for real reasons rather than left out arbitrarily:
-- - Durotar's "Innkeeper Gryshka" and Mulgore's "Innkeeper Pala" both matched within ~70-90 yards of
--   the existing Orgrimmar/Thunder Bluff capital destinations -- redundant, not worth a near-duplicate
--   entry.
-- - Teldrassil's "Innkeeper Saelienne" matched ~130 yards from the existing Darnassus capital --
--   same reason.
-- - Stonetalon Mountains had three innkeeper candidates, but none matched a named graveyard within a
--   confident distance (200-500 yards to the nearest, and even those were unnamed "GY" entries or
--   path/subzone labels, not clear town names) -- left out entirely rather than guess at a name.
--   Worth a manual pass later.
-- - The Barrens' "Innkeeper Kaylisk" matched a graveyard labeled just "Kargathia" -- not a name this
--   was confident enough to use, and The Barrens already has two solid, unambiguous hubs (Crossroads,
--   Camp Taurajo) from this batch.
-- - An "Alexston Chrome" NPC near Tanaris matched the Caverns of Time graveyard -- a dungeon/instance
--   portal entrance, not a real settlement; Tanaris already has Gadgetzan as its hub.
DELETE FROM `mod_waygate_network_locations` WHERE `id` BETWEEN 28 AND 45;
INSERT INTO `mod_waygate_network_locations`
    (`id`, `name`, `continent`, `faction`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`)
VALUES
    (28, 'Astranaar',            'Kalimdor', 'Alliance', 1, 331,   2781.16,  -433.00, 116.665, 2.583),
    (29, 'Auberdine',            'Kalimdor', 'Alliance', 1, 148,   6406.51,   515.37,   8.726, 1.274),
    (30, "Sar'theris Strand",    'Kalimdor', 'Horde',    1, 405,  -1592.84,  3150.27,  46.578, 4.189),
    (31, 'Razor Hill',           'Kalimdor', 'Horde',    1, 14,     340.36, -4686.29,  16.541, 4.189),
    (32, 'Brackenwall Village',  'Kalimdor', 'Horde',    1, 15,   -3165.61, -2911.76,  35.139, 0.733),
    (33, 'Mudsprocket',          'Kalimdor', 'Neutral',  1, 15,   -4629.94, -3176.12,  41.324, 6.263),
    (34, 'Theramore Isle',       'Kalimdor', 'Alliance', 1, 15,   -3616.13, -4470.82,  14.329, 2.217),
    (35, 'Camp Mojache',         'Kalimdor', 'Horde',    1, 357,  -4460.10,   242.72,  39.191, 0.506),
    (36, 'Feathermoon Stronghold','Kalimdor', 'Alliance', 1, 357, -4381.59,  3289.45,  13.627, 0.035),
    (37, 'Bloodhoof Village',    'Kalimdor', 'Horde',    1, 215,  -2365.37,  -347.31,  -8.874, 5.847),
    (38, 'Cenarion Hold',        'Kalimdor', 'Neutral',  1, 1377, -6868.04,   729.91,  45.745, 0.489),
    (39, 'Gadgetzan',            'Kalimdor', 'Neutral',  1, 440,  -7158.96, -3841.61,   8.848, 1.955),
    (40, 'Dolanaar',             'Kalimdor', 'Alliance', 1, 141,   9802.21,   982.61,1313.980, 4.800),
    (41, 'The Crossroads',       'Kalimdor', 'Horde',    1, 17,    -407.12, -2645.22,  96.306, 3.438),
    (42, 'Camp Taurajo',         'Kalimdor', 'Horde',    1, 17,   -2376.27, -1995.74,  96.788, 1.065),
    (43, 'Ratchet',              'Kalimdor', 'Neutral',  1, 17,   -1050.04, -3664.80,  23.968, 6.004),
    (44, 'Freewind Post',        'Kalimdor', 'Horde',    1, 400,  -5477.85, -2460.43,  89.367, 0.314),
    (45, 'Everlook',             'Kalimdor', 'Neutral',  1, 618,   6695.15, -4673.04, 721.650, 0.541);