From f04a7bc8641af0b64a880bd08848bd7dc6a84ff2 Mon Sep 17 00:00:00 2001 From: Killyana Date: Wed, 10 Apr 2019 17:52:05 +0200 Subject: DB/Quest: Move some Breadcrumb quests from conditions to quest_template_addon (cherry picked from commit 1238115e1c3dbe671cf8c1c937f74e7f07c32547) --- .../master/2021_11_27_03_world_2019_04_10_04_world.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 sql/updates/world/master/2021_11_27_03_world_2019_04_10_04_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2021_11_27_03_world_2019_04_10_04_world.sql b/sql/updates/world/master/2021_11_27_03_world_2019_04_10_04_world.sql new file mode 100644 index 00000000000..17580415692 --- /dev/null +++ b/sql/updates/world/master/2021_11_27_03_world_2019_04_10_04_world.sql @@ -0,0 +1,14 @@ +-- +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19) AND `SourceEntry`IN (1275,1841, 1846, 1840, 1844, 1839, 1842, 2865, 6383, 13226, 13227); + +DELETE FROM `quest_template_addon` WHERE `ID` IN (3765,2864,13226,13227); +INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES +(3765, 1275), +(2864, 2865), +(13226,13036), +(13227,13036); + +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=1846 WHERE `ID` IN (1841); +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=1844 WHERE `ID` IN (1840); +UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=1842 WHERE `ID` IN (1839); +UPDATE `quest_template_addon` SET `PrevQuestID`=0,`ExclusiveGroup`=0, `BreadcrumbForQuestId`=6383 WHERE `ID` IN (742,6382,235); -- cgit v1.2.3