https://www.wowhead.com/quest=27511/the-thrill-of-discovery -- switch incorrect npc hidden markers for quest
Quest worked before just that the markers were reversed.
-- https://www.wowhead.com/quest=27905/tailgunner -- plane not spawned with quest -- https://www.wowhead.com/npc=47054/schnottz-bomber - solution manual spawn
Quest worked before just that the markers were reversed.
SQL:
-- https://www.wowhead.com/quest=27511/the-thrill-of-discovery -- switch incorrect npc hidden markers for quest
UPDATE creature SET id = 45760 WHERE guid= 504837; -- value was 45757 -- replace ancient mech / northern hieroglyths
UPDATE creature SET id = 45757 WHERE guid= 507732; -- value was 45760 -- replace ancient mech / northern hieroglyths-- https://www.wowhead.com/quest=27905/tailgunner -- plane not spawned with quest -- https://www.wowhead.com/npc=47054/schnottz-bomber - solution manual spawn
SQL:
-- https://www.wowhead.com/quest=27905/tailgunner -- plane not spawned -- https://www.wowhead.com/npc=47054/schnottz-bomber
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, 47054, 1, 5034, 5597, 1, 1, 0, 0, -10374.7, -303.431, 336.597, 2.7663, 300, 0, 0, 420, 0, 0, 16777216, 0, 0, 0, 0);
Last edited:
