diff options
| author | Killyana <morphone1@gmail.com> | 2016-05-31 17:05:45 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-01-11 23:02:17 +0100 |
| commit | 37e632968ab7572e974a18e57d04d24279982966 (patch) | |
| tree | 0abda5618d6e28ca5db5fff5d32a947d8917b444 | |
| parent | 75d37defd7b78b60d5f71a941da2f0f90359554d (diff) | |
DB/Quest: correct some quests' availability in K3, Storm Peaks
Closes #17235
By SnapperRy
(cherry picked from commit 2a9732031f49bcec389501f7d94c614f8e0e76e8)
| -rw-r--r-- | sql/updates/world/master/2017_01_11_09_world_2016_05_31_05_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_01_11_09_world_2016_05_31_05_world.sql b/sql/updates/world/master/2017_01_11_09_world_2016_05_31_05_world.sql new file mode 100644 index 00000000000..18bbf61baa4 --- /dev/null +++ b/sql/updates/world/master/2017_01_11_09_world_2016_05_31_05_world.sql @@ -0,0 +1,12 @@ +-- +UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `Id`=12836; + +DELETE FROM `conditions` WHERE `SourceEntry`=12828 AND `SourceTypeOrReferenceId` IN (19, 20); +INSERT INTO `conditions` VALUES +(19, 0, 12828, 0, 0, 8, 0, 12827, 0, 0, 0, 0, 0, "", "Show mark for quest 'Ample Inspiration' only if quest 'Reclaimed Rations' is rewarded"), +(20, 0, 12828, 0, 0, 8, 0, 12827, 0, 0, 0, 0, 0, "", "Can accept quest 'Ample Inspiration' only if quest 'Reclaimed Rations' is rewarded"); + +DELETE FROM `quest_template_addon` WHERE `ID` IN (12862, 13060); +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestId`) VALUES +(12862, 12824), +(13060, 12824); |