aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAokromes <Aokromes@users.noreply.github.com>2024-02-15 23:23:48 +0100
committerGitHub <noreply@github.com>2024-02-15 23:23:48 +0100
commit60c572a8d58ac2e9e48ee0cefd4f80ceb08b96ce (patch)
treed80ed42dfa6ca90bfdaa6b426c6a96de043da9ed
parent66a3e96851c02b17323d72d67abeb2dba4c71eba (diff)
DB/Quest: Love is in the Air/You've Been Served quest progress & completion
closes #29704 by Legoso
-rw-r--r--sql/updates/world/3.3.5/2024_02_15_01_world.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_02_15_01_world.sql b/sql/updates/world/3.3.5/2024_02_15_01_world.sql
new file mode 100644
index 00000000000..0cf32823b9c
--- /dev/null
+++ b/sql/updates/world/3.3.5/2024_02_15_01_world.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `quest_request_items` WHERE `ID` = 14488;
+INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `CompletionText`, `VerifiedBuild`) VALUES
+(14488, 1, 0, "I don't remember ordering a cleaning service... why yes, I am Apothecary Hummel.$B$B...wait, what is the meaning of this? You think these meaningless papers can stop me? Hah!", 12340);
+
+DELETE FROM `quest_offer_reward` WHERE `ID` = 14488;
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(14488, 1, 0, 0, 0, 0, 0, 0, 0, "What we do here is none of your business...", 12340);