-- First full-continent batch for item 2 of PLAN.md's "Next steps" (more locations): one major
-- quest-hub town per Eastern Kingdoms zone, real coordinates -- not guessed. Each row's position is
-- a real innkeeper NPC's actual spawn (creature/creature_template, local acore_world DB), since
-- Blizzard already placed one at essentially every hub town; zone was resolved via nearest-graveyard
-- lookup (graveyard_zone/game_graveyard, populated locally, unlike the trimmed creature.zoneId
-- column) cross-checked against AreaTable.dbc, and faction was resolved from
-- creature_template.faction -> FactionTemplate.dbc's ourMask (same method core's own
-- AuctionHouseMgr.cpp uses to classify an NPC's faction).
--
-- Two notes on this batch:
-- - Hillsbrad Foothills (Southshore/Tarren Mill): the automated zone match mislabeled these two as
--   "Alterac Mountains" -- a border-proximity artifact of the nearest-graveyard heuristic, since
--   both zones sit next to each other. Corrected manually to the real zone (Hillsbrad Foothills,
--   AreaTable.dbc id 267) based on the NPC names/positions matching well-known real town locations.
-- - Revantusk Village (Hinterlands, Horde) and Menethil Harbor (Wetlands, Alliance): town names
--   inferred from the resolved zone/faction rather than read off an in-DB label -- worth a quick
--   in-game glance to confirm before relying on the label, same as any other unverified text in this
--   module (see README.md's "Known v1 limitations").
--
-- Skipped as redundant with existing capitals: Stormwind (Elwynn Forest), Ironforge (Dun Morogh),
-- Undercity (Tirisfal Glades) all had their own innkeeper match too close to the existing capital
-- destination to be worth a second entry.
DELETE FROM `mod_waygate_network_locations` WHERE `id` BETWEEN 11 AND 27;
INSERT INTO `mod_waygate_network_locations`
    (`id`, `name`, `continent`, `faction`, `map`, `zone`, `position_x`, `position_y`, `position_z`, `orientation`)
VALUES
    (11, 'Kargath',            'Eastern Kingdoms', 'Horde',    0, 3,   -6650.01, -2149.09, 245.434, 3.997),
    (12, 'Kharanos',           'Eastern Kingdoms', 'Alliance', 0, 1,   -5601.60,  -531.20, 399.737, 2.129),
    (13, 'Darkshire',          'Eastern Kingdoms', 'Alliance', 0, 10, -10516.00, -1161.21,  28.116, 4.032),
    (14, "Light's Hope Chapel",'Eastern Kingdoms', 'Neutral',  0, 139,  2300.90, -5345.09,  90.880, 2.164),
    (15, 'Goldshire',          'Eastern Kingdoms', 'Alliance', 0, 12,  -9462.66,    16.19,  57.046, 3.037),
    (16, 'Southshore',         'Eastern Kingdoms', 'Alliance', 0, 267,  -857.10,  -570.75,  11.165, 1.553),
    (17, 'Tarren Mill',        'Eastern Kingdoms', 'Horde',    0, 267,    -5.97,  -942.28,  57.162, 2.741),
    (18, 'Thelsamar',          'Eastern Kingdoms', 'Alliance', 0, 38,  -5377.91, -2973.91, 323.252, 1.780),
    (19, 'Lakeshire',          'Eastern Kingdoms', 'Alliance', 0, 44,  -9223.98, -2157.12,  64.017, 3.054),
    (20, 'The Sepulcher',      'Eastern Kingdoms', 'Horde',    0, 130,   510.92,  1636.47, 126.027, 4.311),
    (21, 'Booty Bay',          'Eastern Kingdoms', 'Neutral',  0, 33,  -14457.70,  495.35,  15.213, 3.979),
    (22, 'Stonard',            'Eastern Kingdoms', 'Horde',    0, 8,  -10487.30, -3258.84,  21.113, 0.105),
    (23, 'Aerie Peak',         'Eastern Kingdoms', 'Alliance', 0, 47,    399.73, -2119.74, 131.664, 4.930),
    (24, 'Revantusk Village',  'Eastern Kingdoms', 'Horde',    0, 47,   -622.03, -4583.40,  11.770, 5.515),
    (25, 'Brill',              'Eastern Kingdoms', 'Horde',    0, 85,   2269.51,   244.94,  34.340, 3.752),
    (26, 'Sentinel Hill',      'Eastern Kingdoms', 'Alliance', 0, 40, -10653.40,  1166.52,  34.565, 5.745),
    (27, 'Menethil Harbor',    'Eastern Kingdoms', 'Alliance', 0, 11,  -3827.93,  -831.90,  10.091, 0.401);
