DB/Boralus: Implement Quest "Ferry Pass"

+ chain quests up to "A Nation Divided"

1 files changed, 17 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_01_28_01_world.sql b/sql/updates/world/master/2024_01_28_01_world.sql
new file mode 100644
index 00000000000..7e0a83fd34a
--- /dev/null
+++ b/sql/updates/world/master/2024_01_28_01_world.sql
@@ -0,0 +1,17 @@
+-- Quest "Ferry Pass" ID: 52128
+DELETE FROM `creature_queststarter` WHERE (`id`=122370 AND `quest`=52128) OR (`id`=121235 AND `quest`=47186) OR (`id`=121235 AND `quest`=47189);
+INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(122370, 52128, 53040), -- Ferry Pass offered by Cyrus Crestfall
+(121235, 47186, 53040), -- Sanctum of the Sages offered by Taelia
+(121235, 47189, 53040); -- A Nation Divided offered by Taelia
+
+DELETE FROM `creature_questender` WHERE (`id`=122370 AND `quest`=52128) OR (`id`=121235 AND `quest`=47186) OR (`id`=121235 AND `quest`=47189);
+INSERT INTO `creature_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(122370, 52128, 53040), -- Ferry Pass ended by Cyrus Crestfall
+(121235, 47186, 53040), -- Sanctum of the Sages ended by Taelia
+(121235, 47189, 53040); -- A Nation Divided ended by Taelia
+
+DELETE FROM `quest_template_addon` WHERE `ID` IN (52128, 47186);
+INSERT INTO `quest_template_addon` (`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`, `ScriptName`) VALUES
+(52128, 0, 0, 0, 46729, 47189, -52128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
+(47186, 0, 0, 0, 46729, 47189, -52128, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');