From 5f0dabffce4565da11545d7ee93c689cd2789172 Mon Sep 17 00:00:00 2001
From: Killyana <morphone1@gmail.com>
Date: Wed, 10 Apr 2019 16:03:21 +0200
Subject: DB/Quest: To Stars' Rest!

Closes #22968

(cherry picked from commit 9c9ad671309124712d47042ad8b6885756f26801)
---
 .../2021_11_27_01_world_2019_04_10_02_world.sql    | 23 ++++++++++++++++++++++
 ...2021_11_27_01_world_2019_04_10_02_world_335.sql | 23 ----------------------
 .../2021_11_27_02_world_2019_04_10_03_world.sql    |  2 ++
 3 files changed, 25 insertions(+), 23 deletions(-)
 create mode 100644 sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world.sql
 delete mode 100644 sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world_335.sql
 create mode 100644 sql/updates/world/master/2021_11_27_02_world_2019_04_10_03_world.sql

(limited to 'sql')

diff --git a/sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world.sql b/sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world.sql
new file mode 100644
index 00000000000..715a6153d79
--- /dev/null
+++ b/sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world.sql
@@ -0,0 +1,23 @@
+-- 
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19) AND `SourceEntry`IN(12451,12161,12425, 11175,11406,12182,12189,11573,11995,12469,12542,11996,12511,12208,12210);
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11176 WHERE `ID`=11175;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11269 WHERE `ID`=11406;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12000 WHERE `ID`=11995;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12328 WHERE `ID`=12161;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12188 WHERE `ID`=12182;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12188 WHERE `ID`=12189;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11984 WHERE `ID`=12208;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11984 WHERE `ID`=12210;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12328 WHERE `ID`=12425;
+UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12044 WHERE `ID`=12469;
+
+DELETE FROM `quest_template_addon` WHERE `ID` IN (11573,12542,11996,12511,12451);
+INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES
+(11573, 11504),
+(12542, 12545),
+(11996, 11999),
+(12511, 12292),
+(12451, 12195);
+
+UPDATE `quest_template_addon` SET `ExclusiveGroup`=0 WHERE `ID` IN (12208,12182,12189,12210,12161,12425);
+UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID` IN (11999,12044,12545);
diff --git a/sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world_335.sql b/sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world_335.sql
deleted file mode 100644
index 715a6153d79..00000000000
--- a/sql/updates/world/master/2021_11_27_01_world_2019_04_10_02_world_335.sql
+++ /dev/null
@@ -1,23 +0,0 @@
--- 
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19) AND `SourceEntry`IN(12451,12161,12425, 11175,11406,12182,12189,11573,11995,12469,12542,11996,12511,12208,12210);
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11176 WHERE `ID`=11175;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11269 WHERE `ID`=11406;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12000 WHERE `ID`=11995;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12328 WHERE `ID`=12161;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12188 WHERE `ID`=12182;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12188 WHERE `ID`=12189;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11984 WHERE `ID`=12208;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=11984 WHERE `ID`=12210;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12328 WHERE `ID`=12425;
-UPDATE `quest_template_addon` SET `BreadcrumbForQuestId`=12044 WHERE `ID`=12469;
-
-DELETE FROM `quest_template_addon` WHERE `ID` IN (11573,12542,11996,12511,12451);
-INSERT INTO `quest_template_addon` (`ID`,`BreadcrumbForQuestId`) VALUES
-(11573, 11504),
-(12542, 12545),
-(11996, 11999),
-(12511, 12292),
-(12451, 12195);
-
-UPDATE `quest_template_addon` SET `ExclusiveGroup`=0 WHERE `ID` IN (12208,12182,12189,12210,12161,12425);
-UPDATE `quest_template_addon` SET `PrevQuestID`=0 WHERE `ID` IN (11999,12044,12545);
diff --git a/sql/updates/world/master/2021_11_27_02_world_2019_04_10_03_world.sql b/sql/updates/world/master/2021_11_27_02_world_2019_04_10_03_world.sql
new file mode 100644
index 00000000000..98629a24bf3
--- /dev/null
+++ b/sql/updates/world/master/2021_11_27_02_world_2019_04_10_03_world.sql
@@ -0,0 +1,2 @@
+-- 
+UPDATE `quest_template_addon` SET `NextQuestID`=0, `BreadcrumbForQuestId`=12000 WHERE `ID` IN (12440);
-- 
cgit v1.2.3