Minor Fixes v14 (Silverpine Forest)

[Stiga]

Quest & Spawns for quest

Steel Thunder

Recover 5 Sea Dog Crates.Speak with Admiral Hatchet to get another Orc Sea Pup if you unexpectedly lose yours. A level 5 Silverpine Forest Quest.

www.wowhead.com

There are sea dog crates (gameobjects) spawned but the quest according to the DB info and wowhead requires a npc Orc Crate.
Therefore modified the faction and spawned 5 crates. Tested & working fine. Just seems strange to use npc and not gameobjects for this.

-- https://www.wowhead.com/quest=27069/steel-thunder -- requires npc orc crate https://www.wowhead.com/npc=44915/orc-crate
UPDATE creature_template SET faction_a=14, faction_h=14 WHERE entry=44915; -- fixes faction attackable

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, 44915, 0, 130, 928, 1, 3, 0, 0, 875.159, 1817.21, 8.24336, 0.399497, 300, 0, 0, 42, 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, 44915, 0, 130, 928, 1, 3, 0, 0, 884.177, 1818.62, 8.62634, 2.86879, 300, 0, 0, 42, 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, 44915, 0, 130, 928, 1, 3, 0, 0, 879.17, 1831.32, 7.05456, 4.2236, 300, 0, 0, 42, 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, 44915, 0, 130, 928, 1, 3, 0, 0, 870.022, 1811.57, 8.4206, 0.698724, 300, 0, 0, 42, 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, 44915, 0, 130, 928, 1, 3, 0, 0, 859.731, 1829.23, 6.32373, 0.0507662, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/quest=27098/lordaeron event doesn't run animation and unable to complete. As simple accompany quest I made it auto-complete with spawn npc https://www.wowhead.com/npc=46124/lady-sylvanas-windrunner

-- https://www.wowhead.com/quest=27098/lordaeron event doesn't run animation and unable to complete
UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=27098; -- value was 44365
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=27098; -- value was 1

https://www.wowhead.com/quest=27232/the-waters-run-red unable to mount cannon 45263 -- https://www.wowhead.com/npc=45263/horde-cannon

-- https://www.wowhead.com/quest=27232/the-waters-run-red unable to mount cannon 45263 -- https://www.wowhead.com/npc=45263/horde-cannon
UPDATE creature_template SET DynamicFlags = 8 WHERE entry=45263; -- value was 0

https://www.wowhead.com/quest=27518/transdimensional-warfare-chapter-iii event doesn't activte with npc https://www.wowhead.com/npc=2120/archmage-ataeric - work-a-round solution

-- https://www.wowhead.com/quest=27518/transdimensional-warfare-chapter-iii event doesn't activte with npc https://www.wowhead.com/npc=2120/archmage-ataeric
-- work-around-fix manual spawn npc and modify quest parameters
UPDATE quest_template SET RequiredNpcOrGo1 = 2120 WHERE id=27518; -- value was 45769

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, 2120, 0, 130, 233, 1, 2, 0, 2120, -134.916, 1069.7, 66.1348, 1.7109, 300, 0, 0, 2315, 1357, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/quest=27594/on-her-majestys-secret-service missing npc and bugged event https://www.wowhead.com/npc=46027/commander-lorna-crowley

-- missing npc https://www.wowhead.com/npc=46027/commander-lorna-crowley for quest https://www.wowhead.com/quest=27594/on-her-majestys-secret-service work-a-round fix as event npc accompanying not working
UPDATE quest_template SET RequiredNpcOrGo1 = 46027 WHERE id=27594; -- value was 46002

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, 46027, 0, 130, 5480, 1, 1, 0, 0, -813.893, 1328.86, 33.8618, 0.949704, 300, 0, 0, 5808, 0, 0, 0, 0, 0, 0, 0);

https://www.wowhead.com/quest=27601/cities-in-dust -- accompany & event not working so auto complete temp fix work-a-round

UPDATE quest_template SET RequiredNpcOrGo1 = 0 WHERE id=27601; -- value was 46019
UPDATE quest_template SET RequiredNpcOrGoCount1 = 0 WHERE id=27601; -- value was 1
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, 46124, 0, 130, 5456, 1, 1, 0, 0, -691.167, 1546.26, 27.7652, 3.12836, 300, 0, 0, 2668000, 0, 0, 0, 0, 0, 0, 0);

 

[Blackvision]

Keep it coming mate

 

[warcraftlife]

Thx!

 

[ExO]

Executed in V15. Good job!