From 282767450c663886fc8797600788b8e59d46fac0 Mon Sep 17 00:00:00 2001 From: Trista Date: Tue, 11 Sep 2012 00:30:09 +0100 Subject: DB/Quests: Fix quest relations for Disharmony of Flame Closes #2653 --- sql/updates/world/2012_09_10_03_world_quest_template.sql | 3 +++ sql/updates/world/2012_09_10_03_world_quest_template.sql.sql | 3 --- sql/updates/world/2012_09_10_04_world_quest_template.sql | 2 ++ 3 files changed, 5 insertions(+), 3 deletions(-) create mode 100644 sql/updates/world/2012_09_10_03_world_quest_template.sql delete mode 100644 sql/updates/world/2012_09_10_03_world_quest_template.sql.sql create mode 100644 sql/updates/world/2012_09_10_04_world_quest_template.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_09_10_03_world_quest_template.sql b/sql/updates/world/2012_09_10_03_world_quest_template.sql new file mode 100644 index 00000000000..aae769ced71 --- /dev/null +++ b/sql/updates/world/2012_09_10_03_world_quest_template.sql @@ -0,0 +1,3 @@ +-- Grark Lorkrub should be available only when Kill On Sight: High Ranking Dark Iron Officials is complete +UPDATE `quest_template` SET `NextQuestId`=4122 WHERE `Id`=4082; +UPDATE `quest_template` SET `PrevQuestId`=4082 WHERE `Id`=4122; diff --git a/sql/updates/world/2012_09_10_03_world_quest_template.sql.sql b/sql/updates/world/2012_09_10_03_world_quest_template.sql.sql deleted file mode 100644 index aae769ced71..00000000000 --- a/sql/updates/world/2012_09_10_03_world_quest_template.sql.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Grark Lorkrub should be available only when Kill On Sight: High Ranking Dark Iron Officials is complete -UPDATE `quest_template` SET `NextQuestId`=4122 WHERE `Id`=4082; -UPDATE `quest_template` SET `PrevQuestId`=4082 WHERE `Id`=4122; diff --git a/sql/updates/world/2012_09_10_04_world_quest_template.sql b/sql/updates/world/2012_09_10_04_world_quest_template.sql new file mode 100644 index 00000000000..5805debd094 --- /dev/null +++ b/sql/updates/world/2012_09_10_04_world_quest_template.sql @@ -0,0 +1,2 @@ +-- Fix some quest requirements +UPDATE `quest_template` SET `PrevQuestId`=3906 WHERE `Id` IN (3907,7201); -- Disharmony of Fire and The Last Element are available only, if Disharmony of Flame is completed -- cgit v1.2.3