Emucoach Announcement | MoP Premium 4 Release Date | Cataclysm VIP 17 Release Date | Happy New Years!
What's new

Minor Fixes v14 (Twilight Highlands)

Stiga

Stiga

Gold Supporter
Veteran Member
66
2020
123
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:
GravityFails

GravityFails

Gold Supporter
Veteran Member
42
2021
17
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.
 
Stiga

Stiga

Gold Supporter
Veteran Member
66
2020
123
Location
France
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)
 
GravityFails

GravityFails

Gold Supporter
Veteran Member
42
2021
17
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.
Top