[Dun Morogh] New Tinkertown Quest Chain

[Frostem]

WoW Freakz link: Withdraw to the Loading Room!, Decontamination, The Future of Gnomeregan (Mage, Priest, Warlock, Warrior, Rogue, Monk, Hunter), What''s Left Behind, Dealing with the Fallout, What''s Keeping Jessup, Missing in Action, Get Me Explosives Back!, No Tanks!, Staging in Brewmall, On to Kharanos

Bug description: The Gnome starting zone quest chain has some missing prerequisites, resulting in a broken chain. A player may take quests in the wrong order, skipping whole parts and not following storyline as intended.
The list of quests (and IDs) with missing prerequisites:

* Withdraw to the Loading Room! (ID: 28169) - Missing Prerequisite Quest 27671
* Decontamination (ID: 27635) - Missing Prerequisite Quest 28169
* The Future of Gnomeregan (IDs: 26197, 26199, 26202, 26203, 26206, 31135, 41217) - Missing Prerequisite Quest 27674
* What's Left Behind (ID: 26264) - Missing Prerequisite Quest 26222
* Dealing with the Fallout (ID: 26265) - Missing Prerequisite Quest 26222
* What's Keeping Jessup? (ID: 26316) - Missing Prerequisite Quest 26265
* Missing in Action (ID: 26284) - Missing Prerequisite Quest 26316
* Get Me Explosives Back! (ID: 26285) - Missing Prerequisite Quest 26316
* No Tanks! (ID: 26333) - Missing Prerequisite Quest 26329
* Staging in Brewmall (ID: 26339) - Missing Prerequisite Quest 26331
* On to Kharanos (ID: 26373) - Missing Prerequisite Quest 26364

Proof: https://imgur.com/a/TJarQ

Fix:
Assuming that you are using TrinityCore DB, the following query should fix the problem.

Spoiler:

-- Delete is just for clean up
DELETE FROM `quest_template_addon` where `ID` IN
(28169, 27635, 26197, 26199, 26202, 26203, 26206, 31135, 41217, 26264, 26265, 26316, 26284, 26285, 26318, 26333, 26339, 26373)

INSERT INTO `quest_template_addon` (`ID`,`AllowableClasses`,`PrevQuestID`,`SpecialFlags`) VALUES
(26197,128,27674,4), -- The Future of Gnomeregan
(26199,16,27674,4), -- The Future of Gnomeregan
(26202,256,27674,4), -- The Future of Gnomeregan
(26203,1,27674,4), -- The Future of Gnomeregan
(26206,8,27674,4), -- The Future of Gnomeregan
(26264,0,26222,4), -- What's Left Behind
(26265,0,26222,0), -- Dealing with the Fallout
(26284,0,26316,0), -- Missing in Action
(26285,0,26316,0), -- Get Me Explosives Back!
(26316,0,26265,0), -- What's Keeping Jessup?
(26333,0,26329,4), -- No Tanks!
(26339,0,26331,0), -- Staging in Brewmall
(26373,0,26364,4), -- On to Kharanos
(27635,0,28169,6), -- Decontamination
(28169,0,27671,4), -- Withdraw to the Loading Room!
(31135,512,27674,4), -- The Future of Gnomeregan
(41217,4,27674,4); -- The Future of Gnomeregan