[WotLK] Quest relations in Camp Oneqwah

[Darth-Postal]

There are several issues with quest flow in Camp Oneqwah (Grizzly Hills, Horde):

1) q12165 "An Intriguing Plan" should require q12195 "The Unexpected 'Guest'" to be completed. Source. Currently both quests are available right away and if you pick "An Intriguing Plan" first, you will loose access to "The Unexpected 'Guest'" forever.

2) q12073 "Pounding the Iron" and q12058 "The Runic Prophecies" should both be unlocked by q12054 "Deciphering the Journal". Source 1, Source 2, Source 3. Currently both quests are available right away.

3) q12204 "In the Name of Loken" should require BOTH q12073 "Pounding the Iron" and q12058 "The Runic Prophecies" to be completed. Source. Currently the quest available right away.

4) q12074 "An Expedient Ally" should be exclusive to q11981 "Find Kurun!" and unlock q11982 "Raining Down Destruction". Source 1, Source 2. Currently both quests can be completed, and only "Find Kurun!" unlocks "Raining Down Destruction".

Suggested fix

-- Make q12195 "The Unexpected 'Guest'" a requirement for q12165 "An Intriguing Plan"
UPDATE quest_template SET PrevQuestId = 12195 WHERE entry = 12165;

-- Make q12054 "Deciphering the Journal" a requirement for both q12073 "Pounding the Iron" and q12058 "The Runic Prophecies"
-- Make completion of both these quests unlock q12204 "In the Name of Loken"
UPDATE quest_template SET PrevQuestId = 12054, NextQuestId = 12204, ExclusiveGroup = -12058 WHERE entry IN (12058, 12073);

-- Remove q11981 "Find Kurun!" as PrevQuestId for q11982 "Raining Down Destruction"
UPDATE quest_template SET PrevQuestId = 0 WHERE entry = 11982;

-- Make q12074 "An Expedient Ally" and q11981 "Find Kurun!" exclusive
-- Make completion of either one of these quests unlock q11982 "Raining Down Destruction"
UPDATE quest_template SET NextQuestId = 11982, ExclusiveGroup = 12074 WHERE entry IN (12074, 11981);