Minor fixes v14 (Simmering Expanse)

Stiga · May 23, 2021

Please note I did this on a horde character and I hope that in certain quests the phasing mask is ok for the alliance.
I will test later with an alliance character but long quest chain before.

Missing creature spawns:-
Info Format: NPC / related quest

https://www.wowhead.com/object=203390/ranger-valarian-statue -- https://www.wowhead.com/quest=25954/an-occupation-of-time -- missing gameobject (same for alliance quest)

SQL:

-- https://www.wowhead.com/object=203390/ranger-valarian-statue -- missing for quest
SELECT MAX(guid)+1 into @var FROM gameobject;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES (@var, 203390, 0, 5144, 5089, 1, 1, -6750.86, 4819.05, -603.907, 1.40043, 0, 0, 0.644384, 0.764702, 300, 0, 1);

https://www.wowhead.com/npc=41770/fiasco-sizzlegrin -- https://www.wowhead.com/quest=25968/desperate-plan -- missing npc

SQL:

-- https://www.wowhead.com/npc=41770/fiasco-sizzlegrin -- https://www.wowhead.com/quest=25968/desperate-plan -- 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, 41770, 0, 5144, 4966, 1, 17, 0, 0, -7311.76, 4241.23, -269.284, 5.75856, 300, 0, 0, 420, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/object=203409/horde-survival-kit - spawned but not visible > phasemask issue

SQL:

-- https://www.wowhead.com/object=203409/horde-survival-kit
UPDATE gameobject SET phasemask = 17 WHERE id = 203409; -- value was 1

https://www.wowhead.com/npc=40921/blood-guard-toldrek -- https://www.wowhead.com/quest=25973/welcome-news -- missing npc

SQL:

-- https://www.wowhead.com/npc=40921/blood-guard-toldrek -- https://www.wowhead.com/quest=25973/welcome-news -- 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, 40921, 0, 5144, 4966, 1, 17, 0, 0, -7308.9, 4237.85, -269.454, 2.64486, 300, 0, 0, 446790, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/npc=40921/blood-guard-toldrek -- https://www.wowhead.com/quest=25973/welcome-news -- missing npc

SQL:

-- https://www.wowhead.com/npc=41566/muckskin-scrounger -- https://www.wowhead.com/quest=25969/hostile-waters -- 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7544.41, 4314.58, -224.13, 0.267525, 300, 0, 0, 30951, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7547.05, 4280.4, -226.946, 0.833009, 300, 0, 0, 37187, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7481.31, 4318.79, -233.175, 3.96282, 300, 0, 0, 37187, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7470.94, 4339.12, -234.522, 1.26497, 300, 0, 0, 37187, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7493.66, 4335.53, -244.445, 4.67361, 300, 0, 0, 30951, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7470.18, 4350.92, -252.746, 0.166977, 300, 0, 0, 30951, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7408.74, 4395.48, -272.91, 5.83754, 300, 0, 0, 37187, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7441.85, 4381.44, -260.698, 1.12515, 300, 0, 0, 30951, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7418.77, 4309.99, -261.065, 0.634273, 300, 0, 0, 30951, 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, 41566, 0, 5144, 4966, 1, 17, 0, 0, -7450.96, 4252.25, -238.456, 0.850258, 300, 0, 0, 30951, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/npc=42410/legionnaire-nazgrim -- https://www.wowhead.com/quest=26006/a-breath-of-fresh-air -- missing npc

SQL:

-- https://www.wowhead.com/npc=42410/legionnaire-nazgrim -- https://www.wowhead.com/quest=26006/a-breath-of-fresh-air -- 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, 42410, 0, 5146, 5144, 1, 1, 0, 0, -6901.57, 4277.01, 5.06549, 5.26162, 300, 0, 0, 446790, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/npc=41281/injured-assault-volunteers-rescued -- https://www.wowhead.com/quest=25964/fallen-but-not-forgotten -- missing npcs

SQL:

-- https://www.wowhead.com/npc=41281/injured-assault-volunteers-rescued -- https://www.wowhead.com/quest=25964/fallen-but-not-forgotten -- missing npcs
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, 41281, 0, 5144, 5090, 1, 8, 0, 0, -7457.11, 5003.18, -426.722, 1.92624, 300, 0, 0, 89358, 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, 41281, 0, 5144, 5090, 1, 8, 0, 0, -7464.28, 4948.78, -426.722, 1.9718, 300, 0, 0, 89358, 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, 41281, 0, 5144, 5090, 1, 8, 0, 0, -7450.67, 4914.44, -426.722, 2.15244, 300, 0, 0, 89358, 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, 41281, 0, 5144, 5090, 1, 8, 0, 0, -7400.53, 4937.54, -426.722, 2.68651, 300, 0, 0, 89358, 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, 41281, 0, 5144, 5090, 1, 8, 0, 0, -7391.5, 4890.42, -426.722, 2.4179, 300, 0, 0, 89358, 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, 41281, 0, 5144, 5090, 1, 8, 0, 0, -7351.82, 4891.26, -426.721, 2.59541, 300, 0, 0, 89358, 0, 0, 0, 0, 0, 0, 0);

Quests:

https://www.wowhead.com/quest=25890/nespirah -- event not working so work-a-round
https://www.wowhead.com/quest=25900/making-contact -- event not working so work-a-round
https://www.wowhead.com/quest=25990/breaking-through -- event not working so work-a-round

SQL:

-- https://www.wowhead.com/quest=25890/nespirah -- event not working so work-a-round
UPDATE quest_template SET SpecialFlags = 0 WHERE id=25890; -- value was 2
-- https://www.wowhead.com/quest=25900/making-contact -- event not working so work-a-round
UPDATE quest_template SET SpecialFlags = 0 WHERE id=25900; -- value was 2
-- https://www.wowhead.com/quest=25990/breaking-through -- event not working so work-a-round
UPDATE quest_template SET SpecialFlags = 0 WHERE id=25990; -- value was 2

https://www.wowhead.com/quest=25963/swift-action -- event seahorse not working work-a-round (in fact seahorse works but the event location on arrival doesn't)

SQL:

-- https://www.wowhead.com/quest=25963/swift-action -- event seahorse not working work-a-round
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=25963; -- value was 40639
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=25963; -- value was 1
UPDATE quest_template SET RequiredNpcOrGo2 = 0 WHERE id=25963; -- value was 41249
UPDATE quest_template SET RequiredNpcOrGoCount2 = 0 WHERE id=25963; -- value was 100
UPDATE quest_template SET RequiredNpcOrGo3 = 0 WHERE id=25963; -- value was 41250
UPDATE quest_template SET RequiredNpcOrGoCount3 = 0 WHERE id=25963; -- value was 20
UPDATE quest_template SET RequiredNpcOrGo4 = 0 WHERE id=25963; -- value was 42549
UPDATE quest_template SET RequiredNpcOrGoCount4 = 0 WHERE id=25963; -- value was 12

Blackvision · May 23, 2021

Once again, thank you mate

Jenniy · May 24, 2021

Thank you again for more great edits!

CADIRETO · May 24, 2021

Thank you!! great!

Kein666 · May 24, 2021

Great, tnx!

warcraftlife · May 27, 2021

ExO · Jun 7, 2021

Executed in the upcoming V15 DB.
Thanks for your contribution!

Minor fixes v14 (Simmering Expanse)

Stiga

Blackvision

Jenniy

I collect profile flairs.

CADIRETO

Kein666

warcraftlife

ExO