Minor fixes v14 (Stratholm Crusader Square Dungeon)

[Stiga]

Missing spawns
https://classic.wowhead.com/npc=11058/fras-siabi missing npc
https://www.wowhead.com/npc=10516/the-unforgiven missing npc
https://www.wowhead.com/npc=10558/hearthsinger-forresten missing npc
https://www.wowhead.com/npc=10808/timmy-the-cruel missing npc
Unneeded spawn
https://www.wowhead.com/npc=10813/balnazzar spawn not needed as https://www.wowhead.com/npc=10812/grand-crusader-dathrohan transforms into 10813

-- https://classic.wowhead.com/npc=11058/fras-siabi missing npc
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, 11058, 329, 5916, 5916, 1, 1, 0, 0, 3479.21, -3291.66, 131.737, 5.73771, 604800, 0, 0, 17910, 0, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/npc=10516/the-unforgiven missing npc
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, 10516, 329, 5916, 5916, 1, 1, 0, 0, 3718.6, -3426.88, 131.761, 3.958, 604800, 0, 0, 29850, 0, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/npc=10558/hearthsinger-forresten missing npc
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, 10558, 329, 5916, 5916, 1, 1, 0, 10558, 3660.96, -3367.44, 126.476, 0.376586, 604800, 0, 0, 29850, 0, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/npc=10808/timmy-the-cruel missing npc
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, 10808, 329, 5916, 5916, 1, 1, 0, 0, 3740.55, -3262.65, 129.567, 3.00139, 604800, 0, 0, 49750, 0, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/npc=10813/balnazzar spawn not needed as https://www.wowhead.com/npc=10812/grand-crusader-dathrohan transforms into 10813
DELETE FROM `creature` WHERE `guid`=171284 and id=10813;

 

[ExO]

Executed, thanks!

 

[kureji]

I ran this dungeon and saw Dathorohan was level 62 and I was like... that can't be right let me check what he was in cata. So according to https://wowpedia.fandom.com/wiki/Balnazzar_(tactics) in cataclysm, they got rid of the grand crusader phase and it's just balnazaar waiting for you in strat. Check the patch notes section. so technically you shouldn't remove balnazaar you should remove dathrohan.

-- removes Dathoran
DELETE FROM `creature` WHERE `guid`=98323 and id=10812;

If you removed bal using the code above, this code can be used to hotfix it:

UPDATE creature SET id=10813, curhealth=59700, curmana=9840, modelid=10691 WHERE guid=98323 AND id=10812;

 

[Blackvision]

 

[CADIRETO]

thanks!!

 

[warcraftlife]

Thx!