Trinitycore: [DEV]Core/Quest: Breadcrumb quests requirements
Description: RewardNextQuest was used to handle the availability of Breadcrumb quests, but it's no longer the case since some changes done years ago, example:
Quest A and Quest B are Breadcrumb for quest C, in this case we put RewardNextQuest=C for A and B.
But RewardNextQuest isn't supposed to handle this kind of requirements:
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.
So we need a new field on quest_template_addon called Breadcrumb, that makes the quest not available if the quest on Breadcrumb is taken/completed/rewarded.
PS: I know there's the table conditions that could handle this, but it's not the correct way.
Ref: https://github.com/TrinityCore/TrinityCore/issues/20452 https://github.com/TrinityCore/TrinityCore/issues/22216
Branch(es): both
TC rev. hash/commit: rev. 41982aa30026
Killyana
All 12 comments
@Killyana, I have been working for a while on fixing many breadcrumb quests using conditions (all based on wowhead comments). I was waiting for the new feature to be implemented to adapt the script into it and then post it, but since I don't know how long could that take, I wonder if maybe you could use it as a temporal fix, or maybe you would want to wait more time?
Anyway, this is what I've done this far:
``sql
-- BreadCrumb Quest "Assisting Arch Druid Runetotem"
UPDATEquest_template_addonSETNextQuestID=0 WHEREIDIN (936,3762,3784);
DELETE FROMconditionsWHERESourceTypeOrReferenceId=19 ANDSourceEntryIN (936,3762,3784,3761);
INSERT INTOconditions(SourceTypeOrReferenceId,SourceGroup,SourceEntry,SourceId,ElseGroup,ConditionTypeOrReference,ConditionTarget,ConditionValue1,ConditionValue2,ConditionValue3,NegativeCondition,ErrorType,ErrorTextId,ScriptName,Comment`) VALUES
(19,0,936,0,0,14,0,3761,0,0,0,0,0,"","Quest 'Assisting Arch Druid Runetotem' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,3762,0,0,14,0,3761,0,0,0,0,0,"","Quest 'Assisting Arch Druid Runetotem' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,3784,0,0,14,0,3761,0,0,0,0,0,"","Quest 'Assisting Arch Druid Runetotem' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,3761,0,0,28,0,936,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Runetotem' is not completed"),
(19,0,3761,0,0,28,0,3762,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Runetotem' is not completed"),
(19,0,3761,0,0,28,0,3784,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Runetotem' is not completed");
-- BreadCrumb Quest "Assisting Arch Druid Staghelm"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (3763,3789,3790,10520,3764);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,3763,0,0,14,0,3764,0,0,0,0,0,"","Quest 'Assisting Arch Druid Staghelm' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,3789,0,0,14,0,3764,0,0,0,0,0,"","Quest 'Assisting Arch Druid Staghelm' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,3790,0,0,14,0,3764,0,0,0,0,0,"","Quest 'Assisting Arch Druid Staghelm' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,10520,0,0,14,0,3764,0,0,0,0,0,"","Quest 'Assisting Arch Druid Staghelm' can only be taken if quest 'Un'Goro Soil' is not taken"),
(19,0,3764,0,0,28,0,3763,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Staghelm' is not completed"),
(19,0,3764,0,0,28,0,3789,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Staghelm' is not completed"),
(19,0,3764,0,0,28,0,3790,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Staghelm' is not completed"),
(19,0,3764,0,0,28,0,10520,0,0,1,0,0,"","Quest 'Un'Goro Soil' can only be taken if quest 'Assisting Arch Druid Staghelm' is not completed");
-- BreadCrumb Quest "Lost Deathstalkers"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=429;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (428,429);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,428,0,0,14,0,429,0,0,0,0,0,"","Quest 'Lost Deathstalkers' can only be taken if quest 'Wild Hearts' is not taken"),
(19,0,429,0,0,28,0,428,0,0,1,0,0,"","Quest 'Wild Hearts' can only be taken if quest 'Lost Deathstalkers' is not completed");
-- BreadCrumb Quest "On Guard in Stonetalon"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1070,1085);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1070,0,0,14,0,1085,0,0,0,0,0,"","Quest 'On Guard in Stonetalon (Part 1)' can only be taken if quest 'On Guard in Stonetalon (Part 2)' is not taken"),
(19,0,1085,0,0,28,0,1070,0,0,1,0,0,"","Quest 'On Guard in Stonetalon (Part 2)' can only be taken if quest 'On Guard in Stonetalon (Part 1)' is not completed");
-- BreadCrumb Quest "The Crown of Will"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=518;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (495,518);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,495,0,0,14,0,518,0,0,0,0,0,"","Quest 'The Crown of Will (Part 1)' can only be taken if quest 'The Crown of Will (Part 2)' is not taken"),
(19,0,518,0,0,28,0,495,0,0,1,0,0,"","Quest 'The Crown of Will (Part 2)' can only be taken if quest 'The Crown of Will (Part 1)' is not completed");
-- BreadCrumb Quest "Camp Mojache"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=7489;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (7492,7489);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,7492,0,0,14,0,7489,0,0,0,0,0,"","Quest 'Camp Mojache' can only be taken if quest 'Lethtendris's Web' is not taken"),
(19,0,7489,0,0,28,0,7492,0,0,1,0,0,"","Quest 'Lethtendris's Web' can only be taken if quest 'Camp Mojache' is not completed");
-- BreadCrumb Quest "Feathermoon Stronghold"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=7488;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (7494,7488);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,7494,0,0,14,0,7488,0,0,0,0,0,"","Quest 'Feathermoon Stronghold' can only be taken if quest 'Lethtendris's Web' is not taken"),
(19,0,7488,0,0,28,0,7494,0,0,1,0,0,"","Quest 'Lethtendris's Web' can only be taken if quest 'Feathermoon Stronghold' is not completed");
-- BreadCrumb Quest "Journey to Stonetalon Peak"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1056,1057);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1056,0,0,14,0,1057,0,0,0,0,0,"","Quest 'Journey to Stonetalon Peak' can only be taken if quest 'Reclaiming the Charred Vale' is not taken"),
(19,0,1057,0,0,28,0,1056,0,0,1,0,0,"","Quest 'Reclaiming the Charred Vale' can only be taken if quest 'Journey to Stonetalon Peak' is not completed");
-- BreadCrumb Quest "Halgar's Summons"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1478,1473);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1478,0,0,14,0,1473,0,0,0,0,0,"","Quest 'Halgar's Summons' can only be taken if quest 'Creature of the Void' is not taken"),
(19,0,1473,0,0,28,0,1478,0,0,1,0,0,"","Quest 'Creature of the Void' can only be taken if quest 'Halgar's Summons' is not completed");
-- BreadCrumb Quest "Castpipe's Task"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2931,2930);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2931,0,0,14,0,2930,0,0,0,0,0,"","Quest 'Castpipe's Task' can only be taken if quest 'Data Rescue' is not taken"),
(19,0,2930,0,0,28,0,2931,0,0,1,0,0,"","Quest 'Data Rescue' can only be taken if quest 'Castpipe's Task' is not completed");
-- BreadCrumb Quest "Kayneth Stillwind"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1011;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4581,1011);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4581,0,0,14,0,1011,0,0,0,0,0,"","Quest 'Kayneth Stillwind' can only be taken if quest 'Forsaken Diseases' is not taken"),
(19,0,1011,0,0,28,0,4581,0,0,1,0,0,"","Quest 'Forsaken Diseases' can only be taken if quest 'Kayneth Stillwind' is not completed");
-- BreadCrumb Quest "Carendin Summons"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (10605,1472);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,10605,0,0,14,0,1472,0,0,0,0,0,"","Quest 'Carendin Summons' can only be taken if quest 'Devourer of Souls' is not taken"),
(19,0,1472,0,0,28,0,10605,0,0,1,0,0,"","Quest 'Devourer of Souls' can only be taken if quest 'Carendin Summons' is not completed");
-- BreadCrumb Quest "Seeking Strahad (Horde)"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (3001,2996,1801);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,3001,0,0,14,0,1801,0,0,0,0,0,"","Quest 'Seeking Strahad' can only be taken if quest 'Tome of the Cabal' is not taken"),
(19,0,2996,0,0,14,0,1801,0,0,0,0,0,"","Quest 'Seeking Strahad' can only be taken if quest 'Tome of the Cabal' is not taken"),
(19,0,1801,0,0,28,0,3001,0,0,1,0,0,"","Quest 'Tome of the Cabal' can only be taken if quest 'Seeking Strahad' is not completed"),
(19,0,1801,0,0,28,0,2996,0,0,1,0,0,"","Quest 'Tome of the Cabal' can only be taken if quest 'Seeking Strahad' is not completed");
-- BreadCrumb Quest "Seeking Strahad (Alliance)"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1758;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1798,1758);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1798,0,0,14,0,1758,0,0,0,0,0,"","Quest 'Seeking Strahad' can only be taken if quest 'Tome of the Cabal' is not taken"),
(19,0,1758,0,0,28,0,1798,0,0,1,0,0,"","Quest 'Tome of the Cabal' can only be taken if quest 'Seeking Strahad' is not completed");
-- BreadCrumb Quest "A Helping Hand"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (9533,9517);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,9533,0,0,14,0,9517,0,0,0,0,0,"","Quest 'A Helping Hand' can only be taken if quest 'A Shameful Waste' is not taken"),
(19,0,9517,0,0,28,0,9533,0,0,1,0,0,"","Quest 'A Shameful Waste' can only be taken if quest 'A Helping Hand' is not completed");
-- BreadCrumb Quest "Trouble In Darkshore?"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (730,729);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,730,0,0,14,0,729,0,0,0,0,0,"","Quest 'Trouble In Darkshore?' can only be taken if quest 'The Absent Minded Prospector' is not taken"),
(19,0,729,0,0,28,0,730,0,0,1,0,0,"","Quest 'The Absent Minded Prospector' can only be taken if quest 'Trouble In Darkshore?' is not completed");
-- BreadCrumb Quest "Yorus Barleybrew"
UPDATE quest_template_addon SET NextQuestID=0 WHERE ExclusiveGroup=1698;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1698,10371,1699);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1698,0,0,14,0,1699,0,0,0,0,0,"","Quest 'Yorus Barleybrew' can only be taken if quest 'The Rethban Gauntlet' is not taken"),
(19,0,10371,0,0,14,0,1699,0,0,0,0,0,"","Quest 'Yorus Barleybrew' can only be taken if quest 'The Rethban Gauntlet' is not taken"),
(19,0,1699,0,0,28,0,1698,0,0,1,0,0,"","Quest 'The Rethban Gauntlet' can only be taken if quest 'Yorus Barleybrew' is not completed"),
(19,0,1699,0,0,28,0,10371,0,0,1,0,0,"","Quest 'The Rethban Gauntlet' can only be taken if quest 'Yorus Barleybrew' is not completed");
-- BreadCrumb Quest "Speak with Ruga"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1824;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1823,1824);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1823,0,0,14,0,1824,0,0,0,0,0,"","Quest 'Speak with Ruga' can only be taken if quest 'Trial at the Field of Giants' is not taken"),
(19,0,1824,0,0,28,0,1823,0,0,1,0,0,"","Quest 'Trial at the Field of Giants' can only be taken if quest 'Speak with Ruga' is not completed");
-- BreadCrumb Quest "A Strange One"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6605,4505);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6605,0,0,14,0,4505,0,0,0,0,0,"","Quest 'A Strange One' can only be taken if quest 'Well of Corruption' is not taken"),
(19,0,4505,0,0,28,0,6605,0,0,1,0,0,"","Quest 'Well of Corruption' can only be taken if quest 'A Strange One' is not completed");
-- BreadCrumb Quest "A Call to Arms: The Plaguelands!"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (5093,5094,5095,10374,5096);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,5093,0,0,14,0,5096,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Scarlet Diversions' is not taken"),
(19,0,5094,0,0,14,0,5096,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Scarlet Diversions' is not taken"),
(19,0,5095,0,0,14,0,5096,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Scarlet Diversions' is not taken"),
(19,0,10374,0,0,14,0,5096,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Scarlet Diversions' is not taken"),
(19,0,5096,0,0,28,0,5093,0,0,1,0,0,"","Quest 'Scarlet Diversions' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed"),
(19,0,5096,0,0,28,0,5094,0,0,1,0,0,"","Quest 'Scarlet Diversions' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed"),
(19,0,5096,0,0,28,0,5095,0,0,1,0,0,"","Quest 'Scarlet Diversions' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed"),
(19,0,5096,0,0,28,0,10374,0,0,1,0,0,"","Quest 'Scarlet Diversions' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed");
-- BreadCrumb Quest "A Call to Arms: The Plaguelands!"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (5066,5090,5091,10373,5092);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,5066,0,0,14,0,5092,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Clear the Way' is not taken"),
(19,0,5090,0,0,14,0,5092,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Clear the Way' is not taken"),
(19,0,5091,0,0,14,0,5092,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Clear the Way' is not taken"),
(19,0,10373,0,0,14,0,5092,0,0,0,0,0,"","Quest 'A Call to Arms: The Plaguelands!' can only be taken if quest 'Clear the Way' is not taken"),
(19,0,5092,0,0,28,0,5066,0,0,1,0,0,"","Quest 'Clear the Way' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed"),
(19,0,5092,0,0,28,0,5090,0,0,1,0,0,"","Quest 'Clear the Way' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed"),
(19,0,5092,0,0,28,0,5091,0,0,1,0,0,"","Quest 'Clear the Way' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed"),
(19,0,5092,0,0,28,0,10373,0,0,1,0,0,"","Quest 'Clear the Way' can only be taken if quest 'A Call to Arms: The Plaguelands!' is not completed");
-- BreadCrumb Quest "Trouble in Winterspring!"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6603,5082);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6603,0,0,14,0,5082,0,0,0,0,0,"","Quest 'Trouble in Winterspring!' can only be taken if quest 'Threat of the Winterfall' is not taken"),
(19,0,5082,0,0,28,0,6603,0,0,1,0,0,"","Quest 'Threat of the Winterfall' can only be taken if quest 'Trouble in Winterspring!' is not completed");
-- BreadCrumb Quest "Neeka Bloodscar"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1418,1420);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1418,0,0,14,0,1420,0,0,0,0,0,"","Quest 'Neeka Bloodscar' can only be taken if quest 'Report to Helgrum' is not taken"),
(19,0,1420,0,0,28,0,1418,0,0,1,0,0,"","Quest 'Report to Helgrum' can only be taken if quest 'Neeka Bloodscar' is not completed");
-- BreadCrumb Quest "Taking Back Silithus"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (8275,8276,8280);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,8275,0,0,14,0,8280,0,0,0,0,0,"","Quest 'Taking Back Silithus' can only be taken if quest 'Securing the Supply Lines' is not taken"),
(19,0,8276,0,0,14,0,8280,0,0,0,0,0,"","Quest 'Taking Back Silithus' can only be taken if quest 'Securing the Supply Lines' is not taken"),
(19,0,8280,0,0,28,0,8275,0,0,1,0,0,"","Quest 'Securing the Supply Lines' can only be taken if quest 'Taking Back Silithus' is not completed"),
(19,0,8280,0,0,28,0,8276,0,0,1,0,0,"","Quest 'Securing the Supply Lines' can only be taken if quest 'Taking Back Silithus' is not completed");
-- BreadCrumb Quests "To Winterspring!" & "Starfall"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (5249,5250,5244);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,5249,0,0,14,0,5244,0,0,0,0,0,"","Quest 'To Winterspring!' can only be taken if quest 'The Ruins of Kel'Theril' is not taken"),
(19,0,5250,0,0,14,0,5244,0,0,0,0,0,"","Quest 'Starfall' can only be taken if quest 'The Ruins of Kel'Theril' is not taken"),
(19,0,5244,0,0,28,0,5249,0,0,1,0,0,"","Quest 'The Ruins of Kel'Theril' can only be taken if quest 'To Winterspring!' is not completed"),
(19,0,5244,0,0,28,0,5250,0,0,1,0,0,"","Quest 'The Ruins of Kel'Theril' can only be taken if quest 'Starfall' is not completed");
-- BreadCrumb Quest "Tinkee Steamboil"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=4734;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4907,4734);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4907,0,0,14,0,4734,0,0,0,0,0,"","Quest 'Tinkee Steamboil' can only be taken if quest 'Egg Freezing' is not taken"),
(19,0,4734,0,0,28,0,4907,0,0,1,0,0,"","Quest 'Egg Freezing' can only be taken if quest 'Tinkee Steamboil' is not completed");
-- BreadCrumb Quest "Westbrook Garrison Needs Help!"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=11;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (239,11);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,239,0,0,14,0,11,0,0,0,0,0,"","Quest 'Westbrook Garrison Needs Help!' can only be taken if quest 'Riverpaw Gnoll Bounty' is not taken"),
(19,0,11,0,0,28,0,239,0,0,1,0,0,"","Quest 'Riverpaw Gnoll Bounty' can only be taken if quest 'Westbrook Garrison Needs Help!' is not completed");
-- BreadCrumb Quest "Elmore's Task"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=353;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1097,353);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1097,0,0,14,0,353,0,0,0,0,0,"","Quest 'Elmore's Task' can only be taken if quest 'Stormpike's Delivery' is not taken"),
(19,0,353,0,0,28,0,1097,0,0,1,0,0,"","Quest 'Stormpike's Delivery' can only be taken if quest 'Elmore's Task' is not completed");
-- BreadCrumb Quest "Brother Anton"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6141,261);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6141,0,0,14,0,261,0,0,0,0,0,"","Quest 'Brother Anton' can only be taken if quest 'Down the Scarlet Path' is not taken"),
(19,0,261,0,0,28,0,6141,0,0,1,0,0,"","Quest 'Down the Scarlet Path' can only be taken if quest 'Brother Anton' is not completed");
-- BreadCrumb Quest "Chillwind Camp"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=8414;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (8415,8414);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,8415,0,0,14,0,8414,0,0,0,0,0,"","Quest 'Chillwind Camp' can only be taken if quest 'Dispelling Evil' is not taken"),
(19,0,8414,0,0,28,0,8415,0,0,1,0,0,"","Quest 'Dispelling Evil' can only be taken if quest 'Chillwind Camp' is not completed");
-- BreadCrumb Quest "Report to Jennea"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1919,1920);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1919,0,0,14,0,1920,0,0,0,0,0,"","Quest 'Report to Jennea' can only be taken if quest 'Investigate the Blue Recluse' is not taken"),
(19,0,1920,0,0,28,0,1919,0,0,1,0,0,"","Quest 'Investigate the Blue Recluse' can only be taken if quest 'Report to Jennea' is not completed");
-- BreadCrumb Quest "High Sorcerer Andromath"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1939,1938);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1939,0,0,14,0,1938,0,0,0,0,0,"","Quest 'High Sorcerer Andromath' can only be taken if quest 'Ur's Treatise on Shadow Magic' is not taken"),
(19,0,1938,0,0,28,0,1939,0,0,1,0,0,"","Quest 'Ur's Treatise on Shadow Magic' can only be taken if quest 'High Sorcerer Andromath' is not completed");
-- BreadCrumb Quest "Vital Supplies"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1395;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1477,1395);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1477,0,0,14,0,1395,0,0,0,0,0,"","Quest 'Vital Supplies' can only be taken if quest 'Supplies for Nethergarde' is not taken"),
(19,0,1395,0,0,28,0,1477,0,0,1,0,0,"","Quest 'Supplies for Nethergarde' can only be taken if quest 'Vital Supplies' is not completed");
-- BreadCrumb Quest "Tabetha's Task"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2861,2846);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2861,0,0,14,0,2846,0,0,0,0,0,"","Quest 'Tabetha's Task' can only be taken if quest 'Tiara of the Deep' is not taken"),
(19,0,2846,0,0,28,0,2861,0,0,1,0,0,"","Quest 'Tiara of the Deep' can only be taken if quest 'Tabetha's Task' is not completed");
-- BreadCrumb Quest "James Hyal"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1302;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1301,1302);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1301,0,0,14,0,1302,0,0,0,0,0,"","Quest 'James Hyal (Part 1)' can only be taken if quest 'James Hyal (Part 2)' is not taken"),
(19,0,1302,0,0,28,0,1301,0,0,1,0,0,"","Quest 'James Hyal (Part 2)' can only be taken if quest 'James Hyal (Part 1)' is not completed");
-- BreadCrumb Quest "Morgan Stern"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1204;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1260,1204);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1260,0,0,14,0,1204,0,0,0,0,0,"","Quest 'Morgan Stern' can only be taken if quest 'Mudrock Soup and Bugs' is not taken"),
(19,0,1204,0,0,28,0,1260,0,0,1,0,0,"","Quest 'Mudrock Soup and Bugs' can only be taken if quest 'Morgan Stern' is not completed");
-- BreadCrumb Quest "Mayara Brightwing"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=4764;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4766,4764);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4766,0,0,14,0,4764,0,0,0,0,0,"","Quest 'Mayara Brightwing' can only be taken if quest 'Doomrigger's Clasp' is not taken"),
(19,0,4764,0,0,28,0,4766,0,0,1,0,0,"","Quest 'Doomrigger's Clasp' can only be taken if quest 'Mayara Brightwing' is not completed");
-- BreadCrumb Quest "Tinkmaster Overspark"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=2922;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2923,2922);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2923,0,0,14,0,2922,0,0,0,0,0,"","Quest 'Tinkmaster Overspark' can only be taken if quest 'Save Techbot's Brain!' is not taken"),
(19,0,2922,0,0,28,0,2923,0,0,1,0,0,"","Quest 'Save Techbot's Brain!' can only be taken if quest 'Tinkmaster Overspark' is not completed");
-- BreadCrumb Quest "SI:7" / "Erion's Behest" / "Kingly Shakedown"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2300,2281,2260,2298);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2300,0,0,14,0,2281,0,0,0,0,0,"","Quest 'SI:7' can only be taken if quest 'Redridge Rendezvous' is not taken"),
(19,0,2260,0,0,14,0,2281,0,0,0,0,0,"","Quest 'Erion's Behest' can only be taken if quest 'Redridge Rendezvous' is not taken"),
(19,0,2298,0,0,14,0,2281,0,0,0,0,0,"","Quest 'Kingly Shakedown' can only be taken if quest 'Redridge Rendezvous' is not taken"),
(19,0,2281,0,0,28,0,2300,0,0,1,0,0,"","Quest 'Redridge Rendezvous' can only be taken if quest 'SI:7' is not completed"),
(19,0,2281,0,0,28,0,2260,0,0,1,0,0,"","Quest 'Redridge Rendezvous' can only be taken if quest 'Erion's Behest' is not completed"),
(19,0,2281,0,0,28,0,2298,0,0,1,0,0,"","Quest 'Kingly Shakedown' can only be taken if quest 'Erion's Behest' is not completed");
-- BreadCrumb Quest "Knowledge of the Orb of Orahil"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4965,4967,4968,4969,1799);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4965,0,0,14,0,1799,0,0,0,0,0,"","Quest 'Knowledge of the Orb of Orahil' can only be taken if quest 'Fragments of the Orb of Orahil' is not taken"),
(19,0,4967,0,0,14,0,1799,0,0,0,0,0,"","Quest 'Knowledge of the Orb of Orahil' can only be taken if quest 'Fragments of the Orb of Orahil' is not taken"),
(19,0,4968,0,0,14,0,1799,0,0,0,0,0,"","Quest 'Knowledge of the Orb of Orahil' can only be taken if quest 'Fragments of the Orb of Orahil' is not taken"),
(19,0,4969,0,0,14,0,1799,0,0,0,0,0,"","Quest 'Knowledge of the Orb of Orahil' can only be taken if quest 'Fragments of the Orb of Orahil' is not taken"),
(19,0,1799,0,0,28,0,4965,0,0,1,0,0,"","Quest 'Fragments of the Orb of Orahil' can only be taken if quest 'Knowledge of the Orb of Orahil' is not completed"),
(19,0,1799,0,0,28,0,4967,0,0,1,0,0,"","Quest 'Fragments of the Orb of Orahil' can only be taken if quest 'Knowledge of the Orb of Orahil' is not completed"),
(19,0,1799,0,0,28,0,4968,0,0,1,0,0,"","Quest 'Fragments of the Orb of Orahil' can only be taken if quest 'Knowledge of the Orb of Orahil' is not completed"),
(19,0,1799,0,0,28,0,4969,0,0,1,0,0,"","Quest 'Fragments of the Orb of Orahil' can only be taken if quest 'Knowledge of the Orb of Orahil' is not completed");
-- BreadCrumb Quest "In Search of Menara Voidrender"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4736,4737,4738,4739,1796);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4736,0,0,14,0,1796,0,0,0,0,0,"","Quest 'In Search of Menara Voidrender' can only be taken if quest 'Components for the Enchanted Gold Bloodrobe' is not taken"),
(19,0,4737,0,0,14,0,1796,0,0,0,0,0,"","Quest 'In Search of Menara Voidrender' can only be taken if quest 'Components for the Enchanted Gold Bloodrobe' is not taken"),
(19,0,4738,0,0,14,0,1796,0,0,0,0,0,"","Quest 'In Search of Menara Voidrender' can only be taken if quest 'Components for the Enchanted Gold Bloodrobe' is not taken"),
(19,0,4739,0,0,14,0,1796,0,0,0,0,0,"","Quest 'In Search of Menara Voidrender' can only be taken if quest 'Components for the Enchanted Gold Bloodrobe' is not taken"),
(19,0,1796,0,0,28,0,4736,0,0,1,0,0,"","Quest 'Components for the Enchanted Gold Bloodrobe' can only be taken if quest 'In Search of Menara Voidrender' is not completed"),
(19,0,1796,0,0,28,0,4737,0,0,1,0,0,"","Quest 'Components for the Enchanted Gold Bloodrobe' can only be taken if quest 'In Search of Menara Voidrender' is not completed"),
(19,0,1796,0,0,28,0,4738,0,0,1,0,0,"","Quest 'Components for the Enchanted Gold Bloodrobe' can only be taken if quest 'In Search of Menara Voidrender' is not completed"),
(19,0,1796,0,0,28,0,4739,0,0,1,0,0,"","Quest 'Components for the Enchanted Gold Bloodrobe' can only be taken if quest 'In Search of Menara Voidrender' is not completed");
-- BreadCrumb Quest "Gakin's Summons" / "The Slaughtered Lamb"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1685,1688,1715);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1685,0,0,14,0,1688,0,0,0,0,0,"","Quest 'Gakin's Summons' can only be taken if quest 'Surena Caledon' is not taken"),
(19,0,1715,0,0,14,0,1688,0,0,0,0,0,"","Quest 'The Slaughtered Lamb' can only be taken if quest 'Surena Caledon' is not taken"),
(19,0,1688,0,0,28,0,1685,0,0,1,0,0,"","Quest 'Surena Caledon' can only be taken if quest 'Gakin's Summons' is not completed"),
(19,0,1688,0,0,28,0,1715,0,0,1,0,0,"","Quest 'Surena Caledon' can only be taken if quest 'The Slaughtered Lamb' is not completed");
-- BreadCrumb Quest "Gakin's Summons"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1716;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1717,1716);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1717,0,0,14,0,1716,0,0,0,0,0,"","Quest 'Gakin's Summons' can only be taken if quest 'Devourer of Souls' is not taken"),
(19,0,1716,0,0,28,0,1717,0,0,1,0,0,"","Quest 'Devourer of Souls' can only be taken if quest 'Gakin's Summons' is not completed");
-- BreadCrumb Quest "Jonespyre's Request"
UPDATE quest_template_addon SET PrevQuestID=3785 WHERE ID=3791;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (3787,3791,3788);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,3787,0,0,14,0,3791,0,0,0,0,0,"","Quest 'Jonespyre's Request' can only be taken if quest 'The Mystery of Morrowgrain' is not taken"),
(19,0,3788,0,0,14,0,3791,0,0,0,0,0,"","Quest 'Jonespyre's Request' can only be taken if quest 'The Mystery of Morrowgrain' is not taken"),
(19,0,3791,0,0,28,0,3787,0,0,1,0,0,"","Quest 'The Mystery of Morrowgrain' can only be taken if quest 'Jonespyre's Request' is not completed"),
(19,0,3791,0,0,28,0,3788,0,0,1,0,0,"","Quest 'The Mystery of Morrowgrain' can only be taken if quest 'Jonespyre's Request' is not completed");
-- BreadCrumb Quest "Malin's Request"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=691;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (690,691);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,690,0,0,14,0,691,0,0,0,0,0,"","Quest 'Malin's Request' can only be taken if quest 'Worth Its Weight in Gold' is not taken"),
(19,0,691,0,0,28,0,690,0,0,1,0,0,"","Quest 'Worth Its Weight in Gold' can only be taken if quest 'Malin's Request' is not completed");
-- BreadCrumb Quest "Report to Anastasia"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1959,1960);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1959,0,0,14,0,1960,0,0,0,0,0,"","Quest 'Report to Anastasia' can only be taken if quest 'Investigate the Alchemist Shop' is not taken"),
(19,0,1960,0,0,28,0,1959,0,0,1,0,0,"","Quest 'Investigate the Alchemist Shop' can only be taken if quest 'Report to Anastasia' is not completed");
-- BreadCrumb Quest "Speak with Deino"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1943,1944);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1943,0,0,14,0,1944,0,0,0,0,0,"","Quest 'Speak with Deino' can only be taken if quest 'Waters of Xavian' is not taken"),
(19,0,1944,0,0,28,0,1943,0,0,1,0,0,"","Quest 'Waters of Xavian' can only be taken if quest 'Speak with Deino' is not completed");
-- BreadCrumb Quest "Speak with Un'thuwa"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=1884;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1883,1884);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1883,0,0,14,0,1884,0,0,0,0,0,"","Quest 'Speak with Un'thuwa' can only be taken if quest 'Ju-Ju Heaps' is not taken"),
(19,0,1884,0,0,28,0,1883,0,0,1,0,0,"","Quest 'Ju-Ju Heaps' can only be taken if quest 'Speak with Un'thuwa' is not completed");
-- BreadCrumb Quest "Torwa Pathfinder"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=9052;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (9063,9052);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,9063,0,0,14,0,9052,0,0,0,0,0,"","Quest 'Torwa Pathfinder' can only be taken if quest 'Bloodpetal Poison' is not taken"),
(19,0,9052,0,0,28,0,9063,0,0,1,0,0,"","Quest 'Bloodpetal Poison' can only be taken if quest 'Torwa Pathfinder' is not completed");
-- BreadCrumb Quest "The Hermit"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=148;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (165,148);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,165,0,0,14,0,148,0,0,0,0,0,"","Quest 'The Hermit' can only be taken if quest 'Supplies from Darkshire' is not taken"),
(19,0,148,0,0,28,0,165,0,0,1,0,0,"","Quest 'Supplies from Darkshire' can only be taken if quest 'The Hermit' is not completed");
-- BreadCrumb Quest "Deliveries to Sven"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (164,95);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,164,0,0,14,0,95,0,0,0,0,0,"","Quest 'Deliveries to Sven' can only be taken if quest 'Sven's Revenge' is not taken"),
(19,0,95,0,0,28,0,164,0,0,1,0,0,"","Quest 'Sven's Revenge' can only be taken if quest 'Deliveries to Sven' is not completed");
-- BreadCrumb Quest "Raven Hill"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=5;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (163,5);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,163,0,0,14,0,5,0,0,0,0,0,"","Quest 'Raven Hill' can only be taken if quest 'Jitters' Growling Gut' is not taken"),
(19,0,5,0,0,28,0,163,0,0,1,0,0,"","Quest 'Jitters' Growling Gut' can only be taken if quest 'Raven Hill' is not completed");
-- BreadCrumb Quest "Enraged Wildkin"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6604,4861);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6604,0,0,14,0,4861,0,0,0,0,0,"","Quest 'Enraged Wildkin (Part 1)' can only be taken if quest 'Enraged Wildkin (Part 2)' is not taken"),
(19,0,4861,0,0,28,0,6604,0,0,1,0,0,"","Quest 'Enraged Wildkin (Part 2)' can only be taken if quest 'Enraged Wildkin (Part 1)' is not completed");
-- BreadCrumb Quest "Ironband's Excavation"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (436,297);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,436,0,0,14,0,297,0,0,0,0,0,"","Quest 'Ironband's Excavation' can only be taken if quest 'Gathering Idols' is not taken"),
(19,0,297,0,0,28,0,436,0,0,1,0,0,"","Quest 'Gathering Idols' can only be taken if quest 'Ironband's Excavation' is not completed");
-- BreadCrumb Quest "Stonegear's Search"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=466;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (467,466);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,467,0,0,14,0,466,0,0,0,0,0,"","Quest 'Stonegear's Search' can only be taken if quest 'Search for Incendicite' is not taken"),
(19,0,466,0,0,28,0,467,0,0,1,0,0,"","Quest 'Search for Incendicite' can only be taken if quest 'Stonegear's Search' is not completed");
-- BreadCrumb Quest "Mountaineer Stormpike's Task"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (1339,1338);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,1339,0,0,14,0,1338,0,0,0,0,0,"","Quest 'Mountaineer Stormpike's Task' can only be taken if quest 'Stormpike's Order' is not taken"),
(19,0,1338,0,0,28,0,1339,0,0,1,0,0,"","Quest 'Stormpike's Order' can only be taken if quest 'Mountaineer Stormpike's Task' is not completed");
-- BreadCrumb Quest "Report to Mountaineer Rockgar"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=455;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (468,455);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,468,0,0,14,0,455,0,0,0,0,0,"","Quest 'Report to Mountaineer Rockgar' can only be taken if quest 'The Algaz Gauntlet' is not taken"),
(19,0,455,0,0,28,0,468,0,0,1,0,0,"","Quest 'The Algaz Gauntlet' can only be taken if quest 'Report to Mountaineer Rockgar' is not completed");
-- BreadCrumb Quest "Find Bingles"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2039,2038);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2039,0,0,14,0,2038,0,0,0,0,0,"","Quest 'Find Bingles' can only be taken if quest 'Bingles' Missing Supplies' is not taken"),
(19,0,2038,0,0,28,0,2039,0,0,1,0,0,"","Quest 'Bingles' Missing Supplies' can only be taken if quest 'Find Bingles' is not completed");
-- BreadCrumb Quest "The Greenwarden"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (463,276);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,463,0,0,14,0,276,0,0,0,0,0,"","Quest 'The Greenwarden' can only be taken if quest 'Tramping Paws' is not taken"),
(19,0,276,0,0,28,0,463,0,0,1,0,0,"","Quest 'Tramping Paws' can only be taken if quest 'The Greenwarden' is not completed");
-- BreadCrumb Quest "Rejold's New Brew"
UPDATE quest_template_addon SET PrevQuestID=315 WHERE ID=413;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (415,413);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,415,0,0,14,0,413,0,0,0,0,0,"","Quest 'Rejold's New Brew' can only be taken if quest 'Shimmer Stout' is not taken"),
(19,0,413,0,0,28,0,415,0,0,1,0,0,"","Quest 'Shimmer Stout' can only be taken if quest 'Rejold's New Brew' is not completed");
-- BreadCrumb Quest "Klockmort's Essentials"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2925,2924);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2925,0,0,14,0,2924,0,0,0,0,0,"","Quest 'Klockmort's Essentials' can only be taken if quest 'Essential Artificials' is not taken"),
(19,0,2924,0,0,28,0,2925,0,0,1,0,0,"","Quest 'Essential Artificials' can only be taken if quest 'Klockmort's Essentials' is not completed");
-- BreadCrumb Quest "Speak with Shoni"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2041,2040);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2041,0,0,14,0,2040,0,0,0,0,0,"","Quest 'Speak with Shoni' can only be taken if quest 'Underground Assault' is not taken"),
(19,0,2040,0,0,28,0,2041,0,0,1,0,0,"","Quest 'Underground Assault' can only be taken if quest 'Speak with Shoni' is not completed");
-- BreadCrumb Quest "Imperial Plate Armor"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (10891,10892,7652);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,10891,0,0,14,0,7652,0,0,0,0,0,"","Quest 'Imperial Plate Armor' can only be taken if quest 'A Blue Light Bargain' is not taken"),
(19,0,10892,0,0,14,0,7652,0,0,0,0,0,"","Quest 'Imperial Plate Armor' can only be taken if quest 'A Blue Light Bargain' is not taken"),
(19,0,7652,0,0,28,0,10891,0,0,1,0,0,"","Quest 'A Blue Light Bargain' can only be taken if quest 'Imperial Plate Armor' is not completed"),
(19,0,7652,0,0,28,0,10892,0,0,1,0,0,"","Quest 'A Blue Light Bargain' can only be taken if quest 'Imperial Plate Armor' is not completed");
-- BreadCrumb Quest "I Know A Guy..." / "To Gadgetzan You Go!"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6612,6611,6610);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6612,0,0,14,0,6610,0,0,0,0,0,"","Quest 'I Know A Guy...' can only be taken if quest 'Clamlette Surprise' is not taken"),
(19,0,6611,0,0,14,0,6610,0,0,0,0,0,"","Quest 'To Gadgetzan You Go!' can only be taken if quest 'Clamlette Surprise' is not taken"),
(19,0,6610,0,0,28,0,6612,0,0,1,0,0,"","Quest 'Clamlette Surprise' can only be taken if quest 'I Know A Guy...' is not completed"),
(19,0,6610,0,0,28,0,6611,0,0,1,0,0,"","Quest 'Clamlette Surprise' can only be taken if quest 'To Gadgetzan You Go!' is not completed");
-- BreadCrumb Quest "Alliance Trauma"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6625,6624);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6625,0,0,14,0,6624,0,0,0,0,0,"","Quest 'Alliance Trauma' can only be taken if quest 'Triage' is not taken"),
(19,0,6624,0,0,28,0,6625,0,0,1,0,0,"","Quest 'Triage' can only be taken if quest 'Alliance Trauma' is not completed");
-- BreadCrumb Quest "To Hulfdan!"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (2299,2298);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,2299,0,0,14,0,2298,0,0,0,0,0,"","Quest 'To Hulfdan!' can only be taken if quest 'Kingly Shakedown' is not taken"),
(19,0,2298,0,0,28,0,2299,0,0,1,0,0,"","Quest 'Kingly Shakedown' can only be taken if quest 'To Hulfdan!' is not completed");
-- BreadCrumb Quest "I Got Nothin' Left!"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6609,6607);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6609,0,0,14,0,6607,0,0,0,0,0,"","Quest 'I Got Nothin' Left!' can only be taken if quest 'Nat Pagle, Angler Extreme' is not taken"),
(19,0,6607,0,0,28,0,6609,0,0,1,0,0,"","Quest 'Nat Pagle, Angler Extreme' can only be taken if quest 'I Got Nothin' Left!' is not completed");
-- BreadCrumb Quest "Trollbane"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=639;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (638,639);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,638,0,0,14,0,639,0,0,0,0,0,"","Quest 'Trollbane' can only be taken if quest 'Sigil of Strom' is not taken"),
(19,0,639,0,0,28,0,638,0,0,1,0,0,"","Quest 'Sigil of Strom' can only be taken if quest 'Trollbane' is not completed");
-- BreadCrumb Quest "Horde Trauma"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (6623,6622);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,6623,0,0,14,0,6622,0,0,0,0,0,"","Quest 'Horde Trauma' can only be taken if quest 'Triage' is not taken"),
(19,0,6622,0,0,28,0,6623,0,0,1,0,0,"","Quest 'Triage' can only be taken if quest 'Horde Trauma' is not completed");
-- BreadCrumb Quest "The Hermit of Witch Hill" / "The Hermit of Swamplight Manor"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (11225,11177,1218);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,11225,0,0,14,0,1218,0,0,0,0,0,"","Quest 'The Hermit of Witch Hill' can only be taken if quest 'Marsh Frog Legs' is not taken"),
(19,0,11177,0,0,14,0,1218,0,0,0,0,0,"","Quest 'The Hermit of Swamplight Manor' can only be taken if quest 'Marsh Frog Legs' is not taken"),
(19,0,1218,0,0,28,0,11225,0,0,1,0,0,"","Quest 'Marsh Frog Legs' can only be taken if quest 'The Hermit of Witch Hill' is not completed"),
(19,0,1218,0,0,28,0,11177,0,0,1,0,0,"","Quest 'Marsh Frog Legs' can only be taken if quest 'The Hermit of Swamplight Manor' is not completed");
-- BreadCrumb Quest "Vivian Lagrave"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=4134;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4133,4134);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4133,0,0,14,0,4134,0,0,0,0,0,"","Quest 'Vivian Lagrave' can only be taken if quest 'Lost Thunderbrew Recipe' is not taken"),
(19,0,4134,0,0,28,0,4133,0,0,1,0,0,"","Quest 'Lost Thunderbrew Recipe' can only be taken if quest 'Vivian Lagrave' is not completed");
-- BreadCrumb Quest "Vivian Lagrave and the Darkstone Tablet"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=4768;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4769,4768);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4769,0,0,14,0,4768,0,0,0,0,0,"","Quest 'Vivian Lagrave and the Darkstone Tablet' can only be taken if quest 'The Darkstone Tablet' is not taken"),
(19,0,4768,0,0,28,0,4769,0,0,1,0,0,"","Quest 'The Darkstone Tablet' can only be taken if quest 'Vivian Lagrave and the Darkstone Tablet' is not completed");
-- BreadCrumb Quest "Yuka Screwspigot"
UPDATE quest_template_addon SET PrevQuestID=0 WHERE ID=4136;
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (4324,4136);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,4324,0,0,14,0,4136,0,0,0,0,0,"","Quest 'Yuka Screwspigot' can only be taken if quest 'Ribbly Screwspigot' is not taken"),
(19,0,4136,0,0,28,0,4324,0,0,1,0,0,"","Quest 'Ribbly Screwspigot' can only be taken if quest 'Yuka Screwspigot' is not completed");
-- BreadCrumb Quest "Help Watcher Biggs"
DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceEntry IN (9609,1396);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19,0,9609,0,0,14,0,1396,0,0,0,0,0,"","Quest 'Help Watcher Biggs' can only be taken if quest 'Encroaching Wildlife' is not taken"),
(19,0,1396,0,0,28,0,9609,0,0,1,0,0,"","Quest 'Encroaching Wildlife' can only be taken if quest 'Help Watcher Biggs' is not completed");
ZenoX92
on 13 Oct 2018
Impressive. That is a good amount of work.
illfated
on 13 Oct 2018
For this reason I don't like using conditions for BreadCrumb Quest, instead of putting just a value on quest_template_addon, we end with a wall of sql, also we will not have a good visibility about the chaining, it's better to wait for someone to implement it on quest template addon.
Killyana
on 13 Oct 2018
OK. I will continue searching for more breadcrumb quests so, when the feature is implemented, we could have a full list of all of them.
ZenoX92
on 13 Oct 2018
RewardNextQuest was changed here: https://github.com/TrinityCore/TrinityCore/commit/a82a12b5ef5c466496c314b5a1eb6838dc598b15
This part of coded must be used for a new DB fiel on quest_template_addon called "breadcrumb"
Killyana
on 19 Dec 2018
Adding more to the list:
https://www.wowhead.com/quest=12795/taking-a-stand#comments:id=731421
https://www.wowhead.com/quest=12885/the-exiles-of-ulduar
https://www.wowhead.com/quest=12930/rare-earth
Breadcrumb Quests:
https://www.wowhead.com/quest=11038/assist-exarch-orelis [-> Distraction at Manaforge B'naar]
https://www.wowhead.com/quest=10183/off-to-area-52 [-> You're Hired!]
https://www.wowhead.com/quest=11036/out-of-this-world-produce [-> You're Hired!]
https://www.wowhead.com/quest=11037/a-strange-vision [-> You're Hired!]
https://www.wowhead.com/quest=11040/parts-for-the-rocket-chief [-> You're Hired!]
https://www.wowhead.com/quest=11042/a-mystifying-vision [-> You're Hired!]
https://www.wowhead.com/quest=12973/the-brothers-bronzebeard
https://www.wowhead.com/quest=12880/the-master-explorer
Aokromes
on 6 Jan 2019
A breadcrumb quest meets the following requirements:
Example
-Quest A (Breadcrumb)
-Quest B
- Quest A is taken/completed -> Quest B not available
- Quest A is not taken/rewarded -> Quest B available
- Quest B is taken/completed/rewarded -> Quest A not available
meji46
on 9 Jan 2019
No @meji46 this is wrong
Killyana
on 9 Jan 2019
Hero's Call Board quests worked in that way
meji46
on 9 Jan 2019
Oh you are right, I misunderstand the first condition.
Killyana
on 9 Jan 2019
There are special cases with false breadcrumbs like quest 25316.
meji46
on 9 Jan 2019
5ed7711
Aokromes
on 10 Apr 2019
Related issues
daddycaddy
路
3Comments
Tatara902
路
3Comments
Rushor
路
3Comments
chilito
路
3Comments
Lopfest
路
3Comments
Most helpful comment
OK. I will continue searching for more breadcrumb quests so, when the feature is implemented, we could have a full list of all of them.