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

Minor Fixes v14 (Deepholm)

Stiga

Stiga

Gold Supporter
Veteran Member
66
2020
123
Location
France
Quests

https://www.wowhead.com/quest=26312/crumbling-defenses quest missing npcs -- https://www.wowhead.com/npc=42788/hargoth-dimblaze-relieved missing npc -- https://www.wowhead.com/npc=44352/tawn-winterbluff-relieved missing npc

SQL: 
-- https://www.wowhead.com/quest=26312/crumbling-defenses quest
-- https://www.wowhead.com/npc=42788/hargoth-dimblaze-relieved missing npc
-- https://www.wowhead.com/npc=44352/tawn-winterbluff-relieved 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, 44352, 646, 5042, 5291, 1, 1, 0, 0, 1419.17, 821.857, -56.2436, 4.75433, 300, 0, 0, 464940, 106896, 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, 42788, 646, 5042, 5291, 1, 1, 0, 0, 1332.22, 621.816, -65.9296, 2.673, 300, 0, 0, 464940, 106896, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/quest=26577/rocky-upheaval -- https://www.wowhead.com/npc=42472/gorsik-the-tumultuous not able to interact

SQL: 
-- https://www.wowhead.com/quest=26577/rocky-upheaval -- https://www.wowhead.com/npc=42472/gorsik-the-tumultuous not able to interact
UPDATE creature_template SET faction_a=35, faction_h=35 WHERE entry=42472; -- fixes faction

https://www.wowhead.com/quest=26656/dont-stop-moving -- missing trigger at end -- https://www.wowhead.com/npc=43597/rockcandy-credit
missing npc spawn credit but trigger not working so quick quest work-a-round (I included the trigger spawn anyway)

SQL: 
-- https://www.wowhead.com/quest=26656/dont-stop-moving -- missing trigger at end -- https://www.wowhead.com/npc=43597/rockcandy-credit
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, 43597, 646, 5042, 5295, 1, 1, 0, 0, 2286.06, 443.97, 167.018, 5.06067, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);
UPDATE quest_template SET RequiredNpcOrGo2 = 0 WHERE id=26656; -- value was 43597 -- temp fix as trigger not working (spawn above)
UPDATE quest_template SET RequiredNpcOrGoCount2 = 0 WHERE id=26656; -- value was 1 -- temp fix as trigger not working (spawn above)

https://www.wowhead.com/quest=26584/shaken-and-stirred -- missing a few npc spawns https://www.wowhead.com/npc=43513/verlok-pillartumbler

SQL: 
-- https://www.wowhead.com/quest=26584/shaken-and-stirred -- missing a few npc spawns https://www.wowhead.com/npc=43513/verlok-pillartumbler
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, 43513, 646, 5042, 5300, 1, 1, 0, 43513, 1923.2, -417.276, 244.493, 0.0795678, 300, 0, 0, 53681, 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, 43513, 646, 5042, 5300, 1, 1, 0, 43513, 1929.1, -413.49, 244.417, 5.26713, 300, 0, 0, 53681, 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, 43513, 646, 5042, 5300, 1, 1, 0, 43513, 1934.02, -412.605, 244.395, 4.46995, 300, 0, 0, 53681, 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, 43513, 646, 5042, 5300, 1, 1, 0, 43513, 1965.73, -426.32, 245.178, 5.31819, 300, 0, 0, 53681, 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, 43513, 646, 5042, 5300, 1, 1, 0, 43513, 1970.22, -429.027, 244.931, 4.09297, 300, 0, 0, 53681, 0, 0, 0, 0, 0, 0, 0);

-- *** attention this corrects the quest but may have impacts elsewhere when removing script *** ---
-- https://www.wowhead.com/quest=26750/at-the-stonemothers-call -- unable to access some quests with -- https://www.wowhead.com/npc=42465/therazane

SQL: 
-- *** attention this corrects the quest but may have impats elsewhere when removing script *** ---
-- https://www.wowhead.com/quest=26750/at-the-stonemothers-call -- unable to access some quests with -- https://www.wowhead.com/npc=42465/therazane
UPDATE creature_template SET ScriptName="" WHERE entry=42465; -- fixes quests but possible impacts untested

-- https://www.wowhead.com/quest=26752/audience-with-the-stonemother -- work-a-round as event not running (maybe linked to script above)
Note I added the spawn for the trigger but that doesn't work. Therefore no need to spawn it. The quest work-a-round works without it. I added the spawn in case the event (not working) didn't spawn it (or do something else with it)

SQL: 
-- https://www.wowhead.com/quest=26752/audience-with-the-stonemother -- work-a-round as event not running (maybe linked to script above)
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=26752; -- value was 44051 -- temp fix as trigger not working (spawn below)
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=26752; -- value was 1 -- temp fix as trigger not working (spawn below)

-- OPTIONAL NOT NEEDED TO DATE https://www.wowhead.com/npc=44051/therazane-audience-credit -- optional > probably spawned via script but neither manual spawn or event working
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, 44051, 646, 5042, 5296, 1, 1, 0, 0, 2386.27, 178.816, 182.319, 0.0740952, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);
 
Last edited:
ExO

ExO

Admin
5,088
2014
1,451
Thanks as always Stiga! :)
Parts of it has been executed. But the stonemother part needs more research.
 
You must log in or register to reply here.
Top