diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2019_08_05_03_world.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_08_05_03_world.sql b/sql/updates/world/3.3.5/2019_08_05_03_world.sql new file mode 100644 index 00000000000..cb76bfe7245 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_08_05_03_world.sql @@ -0,0 +1,36 @@ +-- +UPDATE `quest_template_addon` SET `PrevQuestID`=13225 WHERE `ID`=13300; -- Slaves to Saronite requires The Skybreaker +UPDATE `quest_template_addon` SET `PrevQuestID`=13225 WHERE `ID`=13336; -- Blood of the Chosen requires The Skybreaker +UPDATE `quest_template_addon` SET `PrevQuestID`=13287 WHERE `ID`=13288; -- That's Abominable (non-daily) requires Poke and Prod +UPDATE `quest_template_addon` SET `PrevQuestID`=13288 WHERE `ID`=13289; -- That's Abominable (daily) requires That's Abominable (non-daily) +UPDATE `quest_template_addon` SET `PrevQuestID`=13231 WHERE `ID`=13233; -- No Mercy! requires The Broken Front +UPDATE `quest_template_addon` SET `PrevQuestID`=13332 WHERE `ID`=13314; -- Get the Message requires Raise the Barricades +UPDATE `quest_template_addon` SET `PrevQuestID`=13314 WHERE `ID`=13333; -- Capture More Dispatches requires Get the Message +UPDATE `quest_template_addon` SET `PrevQuestID`=13295 WHERE `ID`=13297; -- Neutralizing the Plague requires Basic Chemistry +UPDATE `quest_template_addon` SET `PrevQuestID`=13315 WHERE `ID`=13320; -- Cannot Reproduce requires Sneak Preview +UPDATE `quest_template_addon` SET `PrevQuestID`=13318 WHERE `ID`=13323; -- Drag and Drop (daily) requires Drag and Drop (non-daily) +UPDATE `quest_template_addon` SET `PrevQuestID`=13318 WHERE `ID`=13342; -- Not a Bug (non-daily) requires Drag and Drop (non-daily) +UPDATE `quest_template_addon` SET `PrevQuestID`=13342 WHERE `ID`=13344; -- Not a Bug (daily) requires Not a Bug (non-daily) +UPDATE `quest_template_addon` SET `PrevQuestID`=13345 WHERE `ID`=13332; -- Raise the Barricades requires Need More Info +UPDATE `quest_template_addon` SET `PrevQuestID`=13346 WHERE `ID`=13350; -- No Rest For The Wicked (daily) requires No Rest For The Wicked (non-daily) +UPDATE `quest_template_addon` SET `PrevQuestID`=13334 WHERE `ID`=13335; -- Before the Gate of Horror requires Bloodspattered Banners +UPDATE `quest_template_addon` SET `PrevQuestID`=13332 WHERE `ID`=13337; -- The Ironwall Rampart requires Raise the Barricades +UPDATE `quest_template_addon` SET `PrevQuestID`=13321 WHERE `ID`=13322; -- Retest Now (daily) requires Retest Now (non-daily) +UPDATE `quest_template_addon` SET `PrevQuestID`=13341 WHERE `ID` IN (13284, 13309); -- Assault by Air and Assault by Ground require Joining the Assault + +DELETE FROM `quest_template_addon` WHERE `ID` IN (13294, 13231, 13296, 13286, 13290, 13298, 13315, 13319, 13318, 13334, 13339, 13338, 13345, 13341); +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`) VALUES +(13294, 13287), -- Against the Giants requires Poke and Prod +(13231, 13225), -- The Broken Front requires The Skybreaker +(13296, 13225), -- Get to Ymirheim! requires The Skybreaker +(13286, 13231), -- ...All the Help We Can Get. requires The Broken Front +(13290, 13231), -- Your Attention, Please requires The Broken Front +(13298, 13294), -- Coprous the Defiled requires Against the Giants +(13315, 13288), -- Sneak Preview requires That's Abominable! (non-daily) +(13319, 13315), -- Chain of Command requires Sneak Preview +(13318, 13315), -- Drag and Drop (non-daily) requires Sneak Preview +(13334, 13332), -- Bloodspattered Banners requires Raise the Barricades +(13339, 13335), -- Shatter the Shards requires Before the Gate of Horror +(13338, 13335), -- The Guardians of Corp'rethar requires Before the Gate of Horror +(13345, 13318), -- Need More Info requires Drag and Drop (non-daily) +(13341, 13225); -- Joining the Assault requires The Skybreaker |