From 77211e89d4646cb9d327f6f0853a3cbbb31d1739 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 24 Feb 2024 16:25:11 +0100 Subject: DB/Quest: add missing text to "The Hero of the Day" (Winter Veil Preserved Holly) closes #29568 by Legoso --- sql/updates/world/3.3.5/2024_02_24_01_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/3.3.5/2024_02_24_01_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2024_02_24_01_world.sql b/sql/updates/world/3.3.5/2024_02_24_01_world.sql new file mode 100644 index 00000000000..db9e48fbc3f --- /dev/null +++ b/sql/updates/world/3.3.5/2024_02_24_01_world.sql @@ -0,0 +1,8 @@ +-- CompletionText +UPDATE `quest_request_items` SET `CompletionText`= '$BThe "Holly Preserver" machine looks like some sort of still at first, but a careful examination of it reveals some goblin-esque changes to it. Still, your skill at cooking seems to allow you to understand how the machine works.$B$BThere is already fresh holly in the machine - you simply need to provide some deeprock salt and five gold coins to get the machine working.' WHERE `ID` IN (8763, 8799); + +-- reward entries +DELETE FROM `quest_offer_reward` WHERE `ID` IN (8763, 8799); +INSERT INTO `quest_offer_reward` (`ID`,`Emote1`,`Emote2`,`Emote3`,`Emote4`,`EmoteDelay1`,`EmoteDelay2`,`EmoteDelay3`,`EmoteDelay4`,`RewardText`,`VerifiedBuild`) VALUES +(8763,0,0,0,0,0,0,0,0,"$BThe machine lets off a little rumble and a small amount of steam as it starts working.$B$BIt is not too long thereafter until it stops, heralded by another small jet of steam erupting from it.$B$BA door hatch opens, revealing a batch of preserved holly!$B",12340), +(8799,0,0,0,0,0,0,0,0,"$BThe machine lets off a little rumble and a small amount of steam as it starts working.$B$BIt is not too long thereafter until it stops, heralded by another small jet of steam erupting from it.$B$BA door hatch opens, revealing a batch of preserved holly!$B",12340); -- cgit v1.2.3