Quest The Lost Pilot

[Ravens62]

This quest has optional prequests:
http://www.wowhead.com/quest=26131/reinforcements-for-loch-modan
http://www.wowhead.com/quest=28567/heros-call-loch-modan

Description:
When you receive a quest http://www.wowhead.com/quest=26131/reinforcements-for-loch-modan
I will not receive the first quest in the series when I submit it http://www.wowhead.com/quest=26854/the-lost-pilot

Branch(es):

master

TrinityCore rev. c2d61e0 2018-06-29 22:38:38 +0200 (master branch) (Win32, RelWithDebInfo, Static) (worldserver-daemon)

Windows 10

Sugested fix

-- quest 26131 Reinforcements for Loch Modan
UPDATE `quest_template` SET `RewardNextQuest`= 26854 WHERE `ID`= 26131;

[Killyana]

RewardNextQuest: (Old field name: NextQuestIdChain)
The quest entry from a creature or gameobject that ends a quest and starts a new one. The result is, that if you end the quest, the new quest instantly appears from the quest giver.

26131 is a breadcrumb that must be available if the quest https://www.wowhead.com/quest=26854/the-lost-pilot is not taken/completed/rewarded

Long time ago RewardNextQuest was used to handle this cases but since then it's no longer the case, so a condition must be done in this case.

Ref #20452

[Ravens62]

But both ways are possible, one even adds a rep to Gnomeregen,
so they have to be combined in one place where there is no need to give other conditions.

And it is also possible to take this option into account:
https://wow.gamepedia.com/Loch_Modan_storyline

[ghost]

@Ravens62 , that is exactly what the reply from Killyana was about:

Killyana commented Aug 11, 2018 4:41 PM GMT+2
Long time ago RewardNextQuest was used to handle this cases but since then it's no longer the case, so a condition must be done in this case.

Before, it was handled by your suggested SQL:

-- quest 26131 Reinforcements for Loch Modan
UPDATE `quest_template` SET `RewardNextQuest`= 26854 WHERE `ID`= 26131;

But because RewardNextQuest no longer works, it must be handled by conditions instead.

[Ravens62]

So this is already beyond my poor English knowledge :-).
Even if I put it in the translator, I do not understand the table conditions yet ...

[ghost]

https://trinitycore.atlassian.net/wiki/spaces/tc/pages/2130002/conditions#conditions-SourceTypeOrReferenceId
Search (Ctrl-F) for CONDITION_SOURCE_TYPE_QUEST_AVAILABLE (19)

---

edit: See also #20452 (comment) (Click "Details" to see the list)