diff options
| author | nelegalno <nelegalno@yopmail.com> | 2012-02-19 00:06:54 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-02-19 00:06:54 +0000 |
| commit | 465b6a09785492127f950d81cf23acdf1348e231 (patch) | |
| tree | c143ed74be747b1893186e5cac9b33507a3b16cb | |
| parent | e48290d2ccf0a3ba56451b73f2c971711edba45b (diff) | |
DB/Quests: Proper required races and quest relations for Shadowmourne quest line
Closes #4775
| -rw-r--r-- | sql/updates/world/2012_02_19_00_world_quest_template.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2012_02_19_00_world_quest_template.sql b/sql/updates/world/2012_02_19_00_world_quest_template.sql new file mode 100644 index 00000000000..76ab51f803b --- /dev/null +++ b/sql/updates/world/2012_02_19_00_world_quest_template.sql @@ -0,0 +1,14 @@ +-- Shadowmourne quest chain fix by nelegalno + +-- Limit quests to Warrior, Paladin and Death Knight classes +UPDATE `quest_template` SET `RequiredClasses` = 35 WHERE `Id` IN (24545, 24743, 24547, 24749, 24756, 24757, 24548, 24748); + +-- Quest relations +UPDATE `quest_template` SET `NextQuestId` = 24743 WHERE `Id` = 24545; -- The Sacred and the Corrupt +UPDATE `quest_template` SET `NextQuestId` = 24547 WHERE `Id` = 24743; -- Shadow's Edge +UPDATE `quest_template` SET `NextQuestId` = 24749 WHERE `Id` = 24547; -- A Feast of Souls +UPDATE `quest_template` SET `NextQuestId` = 24756 WHERE `Id` = 24749; -- Unholy Infusion +UPDATE `quest_template` SET `NextQuestId` = 24757 WHERE `Id` = 24756; -- Blood Infusion +UPDATE `quest_template` SET `NextQuestId` = 24548 WHERE `Id` = 24757; -- Frost Infusion +UPDATE `quest_template` SET `NextQuestId` = 24549 WHERE `Id` = 24548; -- The Splintered Throne +UPDATE `quest_template` SET `NextQuestId` = 24748 WHERE `Id` = 24549; -- Shadowmourne... to The Lich King's Last Stand |