NPC spawns
https://www.wowhead.com/npc=42114/alliance-sea-scout -- https://www.wowhead.com/quest=26125/secure-seabrush -- missing npcs
https://www.wowhead.com/npc=41908/orako -- https://www.wowhead.com/quest=26086/orako -- missing npc
Quests:
https://www.wowhead.com/quest=26122/environmental-awareness -- https://www.wowhead.com/item=56821/oil-extrusion-pump -- item not working (work-a-round)
https://www.wowhead.com/quest=26088/here-fishie-fishie -- https://www.wowhead.com/item=56813/fish-hat -- item not working (work-a-round)
https://www.wowhead.com/quest=26072/into-the-totem -- https://www.wowhead.com/item=56801/erunaks-confinement-totem -- item not working (work-a-round just kill npcs)
https://www.wowhead.com/object=203456/stonespeakers-luring-totem --gameobject not working manual spawn -- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- quest https://www.wowhead.com/quest=26111/it-will-come
https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- not hostile fix
-- https://www.wowhead.com/quest=26154/twilight-extermination -- https://www.wowhead.com/item=57172/attuned-runestone-of-binding -- item not working to bound (work-a-round kill npc instead
-- https://www.wowhead.com/quest=26194/defending-the-rift -- (horde) -- https://www.wowhead.com/quest=26193/defending-the-rift -- (alliance) -- submarine event not working (work-a-round)
-- https://www.wowhead.com/npc=44540/legionnaire-nazgrim -- (horde) -- https://www.wowhead.com/npc=44490/captain-taylor -- (alliance) -- missing spawn after event
https://www.wowhead.com/npc=42114/alliance-sea-scout -- https://www.wowhead.com/quest=26125/secure-seabrush -- missing npcs
SQL:
-- https://www.wowhead.com/npc=42114/alliance-sea-scout -- missing npc for https://www.wowhead.com/quest=26125/secure-seabrush
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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6041.74, 5859.73, -779.412, 3.51584, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -5939.96, 5906.44, -783.474, 4.25411, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -5980.89, 6066.88, -789.532, 4.7489, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6082.16, 6144.82, -797.22, 0.307462, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6059.15, 6062.09, -791.168, 5.40863, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6087.93, 6013.95, -787.892, 5.55156, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6121.82, 5962, -791.508, 1.08657, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6141.1, 5920.2, -798.947, 6.00788, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6184.52, 5930.48, -798.215, 0.203787, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6229.79, 5966.2, -795.902, 4.26744, 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, 42114, 0, 5145, 5134, 1, 1, 0, 0, -6211.4, 6000.31, -793.708, 4.7913, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
https://www.wowhead.com/npc=41908/orako -- https://www.wowhead.com/quest=26086/orako -- missing npc
SQL:
-- https://www.wowhead.com/npc=41908/orako -- https://www.wowhead.com/quest=26086/orako -- 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, 41908, 0, 5145, 4974, 1, 1, 0, 0, -6289.59, 6488.69, -865.304, 5.5524, 300, 0, 0, 37187, 0, 0, 0, 0, 0, 0, 0);
Quests:
https://www.wowhead.com/quest=26122/environmental-awareness -- https://www.wowhead.com/item=56821/oil-extrusion-pump -- item not working (work-a-round)
SQL:
-- https://www.wowhead.com/quest=26122/environmental-awareness -- item not working (work-a-round)
UPDATE quest_template SET RequiredItemID1 = 0 WHERE id=26122; -- value was 56818
UPDATE quest_template SET RequiredItemCount1 = 0 WHERE id=25972; -- value was 4
UPDATE quest_template SET RequiredItemID2 = 0 WHERE id=26122; -- value was 56819
UPDATE quest_template SET RequiredItemCount2 = 0 WHERE id=25972; -- value was 4
UPDATE quest_template SET RequiredItemID3 = 0 WHERE id=26122; -- value was 56820
UPDATE quest_template SET RequiredItemCount3 = 0 WHERE id=25972; -- value was 4
https://www.wowhead.com/quest=26088/here-fishie-fishie -- https://www.wowhead.com/item=56813/fish-hat -- item not working (work-a-round)
SQL:
-- https://www.wowhead.com/quest=26088/here-fishie-fishie -- https://www.wowhead.com/item=56813/fish-hat -- item not working (work-a-round)
UPDATE quest_template SET RequiredItemID1 = 0 WHERE id=26088; -- value was 56569
UPDATE quest_template SET RequiredItemCount1 = 0 WHERE id=26088; -- value was 30
https://www.wowhead.com/quest=26072/into-the-totem -- https://www.wowhead.com/item=56801/erunaks-confinement-totem -- item not working (work-a-round just kill npcs)
SQL:
-[URL='https://www.wowhead.com/quest=26071/clearing-the-defiled']- [/URL][URL='https://www.wowhead.com/quest=26071/clearing-the-defiled']https://www.wowhead.com/quest=26072/into-the-tot[/URL]em -[URL='https://www.wowhead.com/item=56801/erunaks-confinement-totem']- [/URL][URL='https://www.wowhead.com/item=56801/erunaks-confinement-totem']https://www.wowhead.com/item=56801/erunaks-confinement-tot[/URL]em -- item not working (work-a-round just kill npcs)
UPDATE quest_template SET RequiredNpcOrGo1 = 41644 WHERE id=26072; -- value was 42027
https://www.wowhead.com/object=203456/stonespeakers-luring-totem --gameobject not working manual spawn -- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- quest https://www.wowhead.com/quest=26111/it-will-come
https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- not hostile fix
SQL:
-- https://www.wowhead.com/object=203456/stonespeakers-luring-totem --gameobject not working manual spawn -- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- quest https://www.wowhead.com/quest=26111/it-will-come
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, 41648, 0, 5145, 5103, 1, 1, 0, 0, -5647.59, 6311.62, -1079.42, 2.81285, 300, 0, 0, 45516, 0, 0, 0, 0, 0, 0, 0);
-- https://www.wowhead.com/npc=41648/ickthys-the-unfathomable -- not hostile fix
UPDATE creature_template SET faction_a = 16 WHERE entry=41648; -- value was 35
UPDATE creature_template SET faction_h = 16 WHERE entry=41648; -- value was 35
-- https://www.wowhead.com/quest=26154/twilight-extermination -- https://www.wowhead.com/item=57172/attuned-runestone-of-binding -- item not working to bound (work-a-round kill npc instead
SQL:
-- https://www.wowhead.com/quest=26154/twilight-extermination -- https://www.wowhead.com/item=57172/attuned-runestone-of-binding -- item not working to bound (work-a-round kill npc instead)
UPDATE quest_template SET RequiredNpcOrGo1 = 47969 WHERE id=26154;-- values was 42343
-- https://www.wowhead.com/quest=26194/defending-the-rift -- (horde) -- https://www.wowhead.com/quest=26193/defending-the-rift -- (alliance) -- submarine event not working (work-a-round)
-- https://www.wowhead.com/npc=44540/legionnaire-nazgrim -- (horde) -- https://www.wowhead.com/npc=44490/captain-taylor -- (alliance) -- missing spawn after event
SQL:
-- https://www.wowhead.com/quest=26194/defending-the-rift -- (horde) -- https://www.wowhead.com/quest=26193/defending-the-rift -- (alliance) -- submarine event not working (work-a-round)
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=26194;-- value was 42565
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=26194; -- value was 1
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=26193;-- value was 42565
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=26193; -- value was 1
-- https://www.wowhead.com/npc=44540/legionnaire-nazgrim -- (horde) -- https://www.wowhead.com/npc=44490/captain-taylor -- (alliance) -- missing spawn after event
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, 44540, 0, 5145, 5047, 1, 1, 0, 0, -5847.33, 5405.84, -1221.27, 5.68217, 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, 44490, 0, 5145, 5047, 1, 1, 0, 0, -5861.2, 5381.56, -1220.97, 5.63269, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);
Last edited: