aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2021-09-21 19:49:22 +0200
committerGitHub <noreply@github.com>2021-09-21 19:49:22 +0200
commit0d2ddcbbb3970633f5d09897162d629c80c13825 (patch)
tree8c17cf8419313d89f2e22b76c4ec325f6a22c40c
parent0d1f7718589d87daff0e99a577233e82743ec66d (diff)
DB/Quests: implemented A Fistful of Slivers and Thirst Unending (bloodelf startzone)
closes #26933 by mdX7
-rw-r--r--sql/updates/world/master/2021_09_21_06_world.sql19
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_09_21_06_world.sql b/sql/updates/world/master/2021_09_21_06_world.sql
new file mode 100644
index 00000000000..d633c8e7153
--- /dev/null
+++ b/sql/updates/world/master/2021_09_21_06_world.sql
@@ -0,0 +1,19 @@
+--
+DELETE FROM `quest_template_addon` WHERE `ID` IN(37440, 37439);
+INSERT INTO `quest_template_addon`(`ID`, `PrevQuestID`) VALUES
+(37440, 8326), -- A Fistful of Slivers
+(37439, 8326); -- Thirst Unending
+
+DELETE FROM `creature_queststarter` WHERE (`id`=15296 AND `quest`=37440) OR (`id`=15297 AND `quest`=37439);
+INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
+(15296, 37440), -- A Fistful of Slivers
+(15297, 37439); -- Thirst Unending
+
+DELETE FROM `creature_questender` WHERE (`id`=15296 AND `quest`=37440) OR (`id`=15297 AND `quest`=37439);
+INSERT INTO `creature_questender` (`id`, `quest`) VALUES
+(15296, 37440), -- A Fistful of Slivers
+(15297, 37439); -- Thirst Unending
+
+DELETE FROM `quest_request_items` WHERE `ID`=37439;
+INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES
+(37439, 0, 25, 0, 0, 'It is not an option or a choice... you must quench your magical thirst. To fail in this is to fail as a blood elf. Those who thought they could control their needs without tutoring now find themselves as one of the Wretched.$B$BYou do NOT want to end up as an insane addict. Believe me.', 40120); -- Thirst Unending