-- NPC roster changes for the Ley Wardens redesign (see 2026_08_16_01.sql for the quest content
-- itself). Aemos (911002), Windcaller Tyese (911004), and The First Warden (911006) keep their
-- name/model/role and only relocate. Echo of the Ley Wardens (911003) is repurposed in place into
-- a new Uldaman contact, Borin Ironquill -- an independent Explorers' League researcher who
-- stumbled onto the truth, replacing the "spectral echo" concept that no longer fits (an echo of
-- the Ley Wardens themselves wouldn't know about a network *older* than their own order). Nazrek
-- the Bent (911005, the old Outland contact) is retired entirely with no replacement -- the new
-- geography only needs three intermediate nodes, not four.
--
-- Coordinates, verified against real terrain/landmarks in the local DB, not guessed:
-- - Aemos: Hillsbrad Foothills no-man's-land between Southshore and Tarren Mill (map 0). Real
--   ambient wildlife here (Starving Mountain Lion/Vicious Gray Bear, creature.sql) is levelled
--   20-23, matching the chain's target pace; position/z chosen clear of every spawn point.
-- - Borin Ironquill: Badlands, a few yards from the real Explorers' League dig camp at Uldaman's
--   entrance (High Explorer Magellas et al, creature.sql, all at z=503.465) -- close enough to
--   read as "part of the camp" without sitting on top of any real NPC.
-- - Windcaller Tyese: Ashenvale, reusing Waygate destination 28's zone (Astranaar) but offset ~4
--   yards from Innkeeper Kimlya (creature.id 6738), who sits at destination 28's exact coordinates
--   -- same overlap this module already fixed once for the Waygate Stones (2026_08_15_12.sql).
-- - The First Warden: Stonetalon Mountains, a few yards from the real Horde outpost Windshear Crag
--   (Innkeeper Jayka, creature.id 7731), clear of both her and the nearby Stonetalon Grunt patrol.
DELETE FROM `creature` WHERE `id` = 911002;
INSERT INTO `creature`
    (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`)
VALUES
    (911002, 0, 1, 1, -472.0, -768.0, 53.4, 0.9, 300);

DELETE FROM `creature` WHERE `id` = 911004;
INSERT INTO `creature`
    (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`)
VALUES
    (911004, 1, 1, 1, 2785.16, -433.0, 116.665, 3.14, 300);

DELETE FROM `creature` WHERE `id` = 911006;
INSERT INTO `creature`
    (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`)
VALUES
    (911006, 1, 1, 1, 900.0, 935.0, 106.364, 3.98, 300);

-- Borin Ironquill: display 1665, the real "Chief Archaeologist Greywhisker" model (creature_template
-- entry 2912) -- reused from a real NPC that spawns nowhere near Uldaman (Winterspring, map 1), so
-- no local visual clash with the actual Explorers' League roster standing a few yards away.
DELETE FROM `creature_template` WHERE `entry` = 911003;
INSERT INTO `creature_template`
    (`entry`, `name`, `subname`, `minlevel`, `maxlevel`, `faction`, `npcflag`,
     `speed_walk`, `speed_run`, `unit_class`, `type`, `RegenHealth`, `ScriptName`)
VALUES
    (911003, 'Borin Ironquill', 'Explorers'' League', 80, 80, 35, 3, 1, 1.14286, 1, 7, 1, '');

DELETE FROM `creature_template_model` WHERE `CreatureID` = 911003;
INSERT INTO `creature_template_model`
    (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`)
VALUES
    (911003, 0, 1665, 1, 1);

DELETE FROM `creature` WHERE `id` = 911003;
INSERT INTO `creature`
    (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`)
VALUES
    (911003, 0, 1, 1, -4661.0, -1272.0, 503.465, 2.41, 300);

DELETE FROM `quest_greeting` WHERE `ID` = 911003 AND `type` = 0;
INSERT INTO `quest_greeting` (`ID`, `type`, `Greeting`) VALUES
    (911003, 0, 'Careful where you dig around here. Some of us learned that the hard way.');

-- Nazrek the Bent: retired entirely, no replacement.
DELETE FROM `creature_template` WHERE `entry` = 911005;
DELETE FROM `creature_template_model` WHERE `CreatureID` = 911005;
DELETE FROM `creature` WHERE `id` = 911005;
DELETE FROM `quest_greeting` WHERE `ID` = 911005 AND `type` = 0;