quests
https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer -- missing npc https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer (pc will rephase later but not spawned in first phase)
https://www.wowhead.com/quest=27462/to-take-the-barracks -- missing npc https://www.wowhead.com/npc=16112/crusade-commander-korfax (pc will rephase later but not spawned in first phase)
Note: I went for a quick spawn fix. However, it may be better to see if the spawn phase can be activated when taking the quest to speak to them. When you turn in those quests my spawns rephase/respawn. Will look when more time.
https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer -- missing npc https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer (pc will rephase later but not spawned in first phase)
https://www.wowhead.com/quest=27462/to-take-the-barracks -- missing npc https://www.wowhead.com/npc=16112/crusade-commander-korfax (pc will rephase later but not spawned in first phase)
Note: I went for a quick spawn fix. However, it may be better to see if the spawn phase can be activated when taking the quest to speak to them. When you turn in those quests my spawns rephase/respawn. Will look when more time.
SQL:
-- https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer -- missing npc https://www.wowhead.com/npc=16115/crusade-commander-eligor-dawnbringer
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 16115, 0, 139, 2266, 1, 1, 0, 0, 1742.46, -5378.29, 80.2948, 2.4876, 300, 0, 0, 244200, 12170, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/quest=27462/to-take-the-barracks -- missing npc https://www.wowhead.com/npc=16112/crusade-commander-korfax
SELECT MAX(guid)+1 into @var FROM creature;
INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (@var, 16112, 0, 139, 2266, 1, 2, 0, 16112, 1657.69, -5326.12, 74.3648, 6.14756, 300, 0, 0, 610400, 0, 0, 0, 0, 0, 0, 0);