DB/Quest: Move some Breadcrumb quests from conditions to quest_template_addon

1 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_04_10_04_world.sql b/sql/updates/world/3.3.5/2019_04_10_04_world.sql
new file mode 100644
index 00000000000..17580415692
--- /dev/null
+++ b/sql/updates/world/3.3.5/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);