[News] Mists of Pandaria Premium Repack 6.1 is out!
What's new

Minor Fixes v14 (Twilight Highlands)

Stiga

Stiga

Gold Supporter
Veteran Member
69
2020
125
Location
France
Missing NPC spawn https://www.wowhead.com/npc=49003 -- missing npc (not necessary for quest as you can fly directly, but npc missing nevertheless)

SQL: 
-- https://www.wowhead.com/npc=49003 -- missing npc (not necessary for quest but missing nevertheless)
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, 49003, 0, 4922, 5140, 1, 2, 0, 49003, -5005.31, -6764.36, 44.3861, 5.82219, 300, 0, 0, 154980, 0, 0, 0, 0, 0, 0, 0);

Missing NPC spawns for quest https://www.wowhead.com/quest=27303/mercy-for-the-bound -- missing spawns https://www.wowhead.com/npc=45358/bound-fleshburner

SQL: 
-- https://www.wowhead.com/quest=27303/mercy-for-the-bound -- missing spawns https://www.wowhead.com/npc=45358/bound-fleshburner
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, 45358, 0, 4922, 5439, 1, 1, 0, 0, -2762.37, -4788.65, 190.285, 0.803888, 300, 0, 0, 59049, 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, 45358, 0, 4922, 5439, 1, 1, 0, 0, -2712.57, -4687.24, 189.434, 5.95002, 300, 0, 0, 59049, 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, 45358, 0, 4922, 5439, 1, 1, 0, 0, -2691.8, -4624.19, 183.767, 3.45795, 300, 0, 0, 70946, 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, 45358, 0, 4922, 5439, 1, 1, 0, 0, -2767.82, -4577.87, 183.26, 5.19369, 300, 0, 0, 70946, 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, 45358, 0, 4922, 5439, 1, 1, 0, 0, -2787.42, -4632.81, 187.59, 0.29358, 300, 0, 0, 70946, 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, 45358, 0, 4922, 5439, 1, 1, 0, 0, -2813.1, -4678.85, 191.065, 0.184401, 300, 0, 0, 70946, 0, 0, 0, 0, 0, 0, 0);

Quests

https://www.wowhead.com/quest=27508/far-from-the-nest (spell to summon eggs not working https://www.wowhead.com/item=61317/vermillion-egg) - -- work-around add eggs to npc loot template -- https://www.wowhead.com/npc=45649/twilight-abductor
SQL: 
-- https://www.wowhead.com/quest=27508/far-from-the-nest (spell to summon eggs not working https://www.wowhead.com/item=61317/vermillion-egg) -- work-around add eggs to npc loot template -- https://www.wowhead.com/npc=45649/twilight-abductor
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (45616, 61317, -100, 1, 0, 1, 1);

https://www.wowhead.com/quest=27491/korkron-drop -- missing hidden trigger npc spawn on tower
SQL: 
-- https://www.wowhead.com/quest=27491/korkron-drop -- missing hidden trigger npc spawn on tower
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, 46000, 0, 4922, 5472, 1, 65535, 0, 0, -4343.25, -4578.21, 222.937, 2.13174, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/npc=46611/magmatooth -- missing npc for quest https://www.wowhead.com/quest=27745/a-fiery-reunion
SQL: 
-- https://www.wowhead.com/npc=46611/magmatooth -- missing npc for quest https://www.wowhead.com/quest=27745/a-fiery-reunion
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, 46611, 0, 4922, 5474, 1, 1, 0, 0, -5100.2, -4356.9, 297.429, 2.49919, 300, 0, 0, 154980, 8908, 0, 0, 0, 0, 0, 0);
 
Last edited:
Thank you very much Stiga! Seeing so many improvements is really making me look foward to hitting 80. I may have to learn to add missing quest npc's too, I notice a few scattered around the world that aren't there. Is there a tool for generating the sql changes or anything? I've just been doing it manually while in the game.
 
I'm playing questing etc. and then when I encounter something I check and try to rectify it.
Apart from spawns most changes are done via HeidiSQL and even with spawns I then use HeidiSQL to export the SQL code.

Apart from that, I use wowhead as reference and my own memeory from the official (I did everything upto and including TBC before stopping playing)
 
Ok thank you. I have heidi installed so I'll look into that. Zygor guides addon is helping me find some of these quest givers that should be there when I don't remember as well.
 
You must log in or register to reply here.
Back
Top