-- "The Ironbound Sentinel" -- the new combat objective for quest 912001 (see 2026_08_16_01.sql).
-- A Titan-built earthen guardian, older than the Ley Wardens' own network, that wakes near the
-- Uldaman dig site to stop the player from surfacing the old ley magic buried beneath it.
--
-- Stats modeled directly on Mor'Ladim (creature_template entry 522, Duskwood's real, unique,
-- solo-able open-world elite) rather than invented: minlevel=maxlevel=30, rank=1 (elite),
-- unit_class=1 (Warrior), HealthModifier=3, DamageModifier=2.4, BaseAttackTime/RangeAttackTime
-- 2000 -- creature_template only stores multipliers, base HP/damage come from
-- creature_classlevelstats by level+class, so this reuses Mor'Ladim's proven soloable-elite tuning
-- rather than guessing flat numbers. faction=21 (Mor'Ladim's own faction) reused too -- checked
-- first since its only other users in this DB are undead (Flesh Eater, Skeletal Warrior, etc.), but
-- faction here governs hostility, not flavor, and Mor'Ladim himself isn't a skeleton either; the
-- same faction being shared across unrelated creature families is normal in this engine. type=4
-- (Elemental) -- real Uldaman earthen constructs are inconsistent in Blizzard's own data
-- (Archaedas is Giant, Ironaya is Not Specified, the Earthen Guardian is Humanoid), so there's no
-- single "correct" precedent to copy; Elemental is the closest real category for a non-organic,
-- non-mechanical guardian.
--
-- Display: 6026, the real "Earthen Guardian" creature's own display (creature_template entry 7076)
-- -- confirmed present in this server's actual CreatureDisplayInfo.dbc. That real creature only
-- ever spawns inside the Uldaman instance (map 70), never in the open world, so reusing its display
-- for this new, open-world-only entry has no collision/confusion risk. Not reusing real Uldaman
-- boss names (Archaedas, Ironaya) for this creature's own name, to avoid confusion with actual
-- dungeon content.
--
-- MovementType 0 (stationary) -- a guardian keeping watch, not a patrol. spawntimesecs 600,
-- matching Mor'Ladim's own real respawn timer. No loot table -- purely a kill-credit objective.
DELETE FROM `creature_template` WHERE `entry` = 911007;
INSERT INTO `creature_template`
    (`entry`, `name`, `subname`, `minlevel`, `maxlevel`, `faction`, `npcflag`,
     `speed_walk`, `speed_run`, `rank`, `DamageModifier`, `BaseAttackTime`, `RangeAttackTime`,
     `unit_class`, `type`, `AIName`, `MovementType`, `HealthModifier`, `ManaModifier`, `ArmorModifier`,
     `RegenHealth`, `ScriptName`)
VALUES
    (911007, 'The Ironbound Sentinel', 'Titanforged Guardian', 30, 30, 21, 0,
     0.88889, 1.14286, 1, 2.4, 2000, 2000,
     1, 4, 'SmartAI', 0, 3, 1, 1,
     1, '');

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

-- Placed deeper in the dig site than Borin Ironquill's camp (~25 yards south), guarding the older
-- excavation rather than standing among the friendly Explorers' League NPCs.
DELETE FROM `creature` WHERE `id` = 911007;
INSERT INTO `creature`
    (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`)
VALUES
    (911007, 0, 1, 1, -4715.0, -1300.0, 503.4, 0.48, 600);