From 8d5120093d8fefb0f05e7670fb9457419f4c42b2 Mon Sep 17 00:00:00 2001 From: Wyreth Date: Mon, 2 Oct 2017 15:24:05 +0200 Subject: DB/Quest: Fix chaining for some quests in Venomspite Closes #20511 --- sql/updates/world/3.3.5/2017_10_02_06_world.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/updates/world/3.3.5/2017_10_02_06_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2017_10_02_06_world.sql b/sql/updates/world/3.3.5/2017_10_02_06_world.sql new file mode 100644 index 00000000000..2c5976c7bf1 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_10_02_06_world.sql @@ -0,0 +1,9 @@ +-- +UPDATE `quest_template` SET `RewardNextQuest`=12211 WHERE `ID`=12206; +UPDATE `quest_template_addon` SET `PrevQuestID`=12206 WHERE `ID`=12211; +UPDATE `quest_template_addon` SET `PrevQuestID`=12230 WHERE `ID`=12240; +DELETE FROM `quest_template_addon` WHERE `ID` IN (12230, 12234, 12214); +INSERT INTO `quest_template_addon` (`ID`, `PrevQuestID`) VALUES +(12230, 12211), +(12234, 12230), +(12214, 12209); -- cgit v1.2.3