diff options
| author | Killyana <morphone1@gmail.com> | 2016-05-31 17:05:45 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2016-05-31 17:05:45 +0200 |
| commit | 2a9732031f49bcec389501f7d94c614f8e0e76e8 (patch) | |
| tree | 0f94ec4398b386425c37cd330b79da58828f8106 | |
| parent | 73b51bb15fe4f4862a77c7cdcbb15d0f00996e38 (diff) | |
DB/Quest: correct some quests' availability in K3, Storm Peaks
Closes #17235
By SnapperRy
| -rw-r--r-- | sql/updates/world/3.3.5/2016_05_31_05_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_05_31_05_world.sql b/sql/updates/world/3.3.5/2016_05_31_05_world.sql new file mode 100644 index 00000000000..18bbf61baa4 --- /dev/null +++ b/sql/updates/world/3.3.5/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); |