Minor Fixes v14 (Tirisfal Glades)

[Stiga]

Quests
https://www.wowhead.com/quest=24960/the-wakening -- missing npcs

-- https://www.wowhead.com/quest=24960/the-wakening -- missing npcs
-- https://www.wowhead.com/npc=49230/marshal-redpath
-- https://www.wowhead.com/npc=38895/lilian-voss
-- https://www.wowhead.com/npc=49231/valdred-moray
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, 49231, 0, 85, 5692, 1, 1, 0, 0, 1737.09, 1702.7, 128.199, 1.57567, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);
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, 38895, 0, 85, 5692, 1, 1, 0, 0, 1764.39, 1667.3, 119.934, 4.08659, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);
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, 49230, 0, 85, 5692, 1, 1, 0, 0, 1771.07, 1630.43, 111.324, 2.8653, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);

 

[Blackvision]

:O :O
Once again, thank you mate

 

[CADIRETO]

thanks for all fixing.

 

[ExO]

Executed, thanks.

 

[warcraftlife]

Thx!