Minor Fixes v14 (Icecrown - Crusader's Pinnacle)

[kureji]

I wanted to try and fix the bugged out questline that starts your entry into Icecrown. Here are the fixes that I've applied

Quest: Scourge Tactics
The webbed crusaders had the wrong phase, easy enough fix.

-- https://www.wowhead.com/quest=13008/scourge-tactics
UPDATE creature SET phaseMask = 2 WHERE id=30273; -- fixing phasing for webbed crusaders

Quest: The Last Line of Defense
When you switched to this phase, nothing was there to fire at. Unfortunately, it's not a phasing issue so I had to manually add the NPCs. Even though the spawn timer is set to 3s, the forgotten depths slayers still have a 2 minute respawn timer which makes this quest take forever. I also suspect the cannon used might not be accurate because the videos I watched has different spells. The quest is now finishable however.

-- https://www.wowhead.com/quest=13086/the-last-line-of-defense
-- missing spawns https://www.wowhead.com/npc=30575/frostbrood-destroyer
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, 30575, 571, 210, 4504, 1, 64, 0, 0, 6247.41, 138.642, 381.605, 5.53619, 75, 15, 0, 76325, 0, 1, 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, 30575, 571, 210, 4501, 1, 64, 0, 0, 6273.84, 106.969, 385.857, 2.98521, 75, 15, 0, 76325, 0, 1, 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, 30575, 571, 210, 4501, 1, 64, 0, 0, 6322.85, 89.9498, 390.531, 3.98581, 75, 15, 0, 76325, 0, 1, 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, 30575, 571, 210, 4504, 1, 64, 0, 0, 6301.49, 167.603, 385.019, 0.508858, 75, 15, 0, 76325, 0, 1, 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, 30575, 571, 210, 4504, 1, 64, 0, 0, 6312.25, 115.148, 390.76, 3.98581, 75, 15, 0, 76325, 0, 1, 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, 30575, 571, 210, 4504, 1, 64, 0, 0, 6334.52, 168.379, 389.036, 3.55777, 75, 15, 0, 76325, 0, 1, 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, 30575, 571, 210, 4504, 1, 64, 0, 0, 6308.87, 143.976, 387.221, 1.14032, 75, 15, 0, 76325, 0, 1, 0, 0, 0, 0, 0);

-- missing spawns https://www.wowhead.com/npc=30593/forgotten-depths-slayer
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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6294.67, 170.995, 384.449, 0.421685, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6318.44, 114.26, 390.195, 0.76726, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6267.51, 145.722, 383.603, 1.16624, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6329.12, 131.733, 389.794, 1.86525, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6302.98, 95.9742, 390.882, 1.98227, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6312.06, 75.1873, 386.987, 2.45351, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6250.85, 113.568, 381.758, 2.83992, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6332.68, 69.4039, 389.259, 2.8682, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6294, 138.938, 387.104, 3.02528, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6325.95, 78.667, 389.48, 3.04492, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6335.66, 167.868, 389.113, 3.202, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6303.24, 107.928, 391.096, 3.72036, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6274.7, 108.579, 386.202, 4.27799, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6327.41, 126.533, 389.863, 4.59529, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6245.27, 135.595, 381.62, 5.74904, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6257.14, 128.571, 383.348, 5.74904, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4501, 1, 64, 0, 0, 6285.92, 111.546, 388.942, 5.74904, 3, 15, 0, 1604, 0, 1, 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, 30593, 571, 210, 4504, 1, 64, 0, 0, 6318.83, 165.279, 386.723, 5.9446, 3, 15, 0, 1604, 0, 1, 0, 0, 0, 0, 0);


-- missing spawns https://www.wowhead.com/npc=30675/argent-champion
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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6178.12, 131.878, 375.765, 0, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6313.12, 52.5355, 393.954, 0.139626, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6291.17, 58.939, 391.953, 0.418879, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6286.58, 63.4298, 391.953, 0.488692, 15, 0, 0, 126000, 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, 30675, 571, 210, 4504, 1, 64, 0, 0, 6306.08, 148.459, 386.861, 0.680678, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6181.35, 125.186, 376.17, 0.872665, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6330.74, 47.9644, 389.05, 1.5708, 15, 0, 0, 126000, 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, 30675, 571, 210, 4504, 1, 64, 0, 0, 6317.03, 143.619, 387.654, 1.88496, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6191.8, 125.276, 377.137, 2.18166, 15, 0, 0, 126000, 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, 30675, 571, 210, 4504, 1, 64, 0, 0, 6321.84, 156.141, 387.106, 3.35103, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6337.86, 57.4385, 389.557, 3.49066, 15, 0, 0, 126000, 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, 30675, 571, 210, 4501, 1, 64, 0, 0, 6329.77, 60.4153, 388.995, 4.88692, 15, 0, 0, 126000, 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, 30675, 571, 210, 4504, 1, 64, 0, 0, 6184.73, 137.875, 375.909, 5.09636, 15, 0, 0, 126000, 0, 0, 0, 0, 0, 0, 0);

Quest: The Purging of Scourgeholm
This quest had phasing issues and it was spawning the wrong type of mob (same name).

-- https://www.wowhead.com/quest=13118/the-purging-of-scourgeholme
UPDATE creature SET phaseMask = 129 WHERE id=31037; -- fixing phasing for forgotten depths high priest
UPDATE creature SET id=30543 WHERE id=31037; -- fixing wrong spawn
UPDATE creature SET phaseMask = 131 WHERE id=31039; -- fixing phasing for forgotten depths underking
UPDATE creature SET id=30541 WHERE id=31039; -- fixing wrong spawn
UPDATE creature SET phaseMask = 129 WHERE id=31043; -- fixing phasing for reanimated crusader
UPDATE creature SET id=30202 WHERE id=31043; -- fixing wrong spawn

Quest: The Restless Dead
The holy water would activate but not count the mob. Apparently the quest had the wrong activating mob, it thought you'd use it on father gustov...

-- https://www.wowhead.com/quest=13110/the-restless-dead
UPDATE quest_template SET RequiredNpcOrGo1 = 30202 WHERE id=13110; -- fixes holy water

Quest: The Air Stands Still
This fixes phasing but unfortunately the horn is still broken. I can't figure out why it isn't summoning the npcs as it should. The information in the database APPEARS correct...

-- https://www.wowhead.com/quest=13125/the-air-stands-still
UPDATE creature SET phaseMask = 130 WHERE id=30829; -- fixing phasing for Salranax
UPDATE creature SET phaseMask = 130 WHERE id=30831; -- fixing phasing for yath'amon
UPDATE creature SET phaseMask = 130 WHERE id=30830; -- fixing phasing for talonox

Quest: Light Within the Darkness
The quest couldn't be started because the chest was unselectable

-- https://www.wowhead.com/quest=13083/light-within-the-darkness
UPDATE gameobject_template SET flags = 0 WHERE entry=192833; -- allowing chest to be selectable

 

[Loupan]

Thanks for your work!
UPDATE quest_template SET RequiredNpcOrGo1 = 30202 WHERE id=13110; --fixes holy water
this one gave an error because there's no space after between -- fixes
I don't know if that's so big of a deal?

 

[kureji]

Thanks for your work!
UPDATE quest_template SET RequiredNpcOrGo1 = 30202 WHERE id=13110; --fixes holy water
this one gave an error because there's no space after between -- fixes
I don't know if that's so big of a deal?

You're right, I missed the space. Thanks! Updated.

 

[Blackvision]

Wauw mate.

 

[ExO]

Awesome contribution!

Executed in V15 (besides from the phasing 130 fix cause it needs a bit more research and fix of rest parts - ill try to check it)

 

[warcraftlife]

Thx!