From 4da0a6f8e3ce3301f8ce0e2d668f361b13245866 Mon Sep 17 00:00:00 2001 From: Killyana Date: Tue, 29 Dec 2015 21:41:18 +0100 Subject: DB/Quest: Add missing text for Horns of Nez'ra By @tkrokli Closes #16078 (cherry picked from commit 99f31a2202564493751240d99e08e1044c7a9d80) --- sql/updates/world/2016_01_17_12_world_2015_12_29_08.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2016_01_17_12_world_2015_12_29_08.sql (limited to 'sql') diff --git a/sql/updates/world/2016_01_17_12_world_2015_12_29_08.sql b/sql/updates/world/2016_01_17_12_world_2015_12_29_08.sql new file mode 100644 index 00000000000..ce874d7a8d2 --- /dev/null +++ b/sql/updates/world/2016_01_17_12_world_2015_12_29_08.sql @@ -0,0 +1,8 @@ +-- +-- Update (insert) missing CompletionText for Quest 2358, Horns of Nez'ra +UPDATE `quest_request_items` SET `CompletionText`="Do you have the demon prince's horns?" WHERE `ID`= 2358; + +-- Insert completely missing `quest_offer_reward` info +DELETE FROM `quest_offer_reward` WHERE `ID`= 2358; +INSERT INTO `quest_offer_reward` (`ID`,`Emote1`,`Emote2`,`Emote3`,`Emote4`,`EmoteDelay1`,`EmoteDelay2`,`EmoteDelay3`,`EmoteDelay4`,`RewardText`,`VerifiedBuild`) VALUES +(2358, 0, 0, 0, 0, 0, 0, 0, 0, "To deny Ravenholdt the artifact, would be to deny one's own existence. Well done, $C. You may yet walk among the assassins of Ravenholdt.$B$B As a young rogue adventuring in Darkshore, I discovered a tea that replenishes energy in combat. It has served me well throughout the years and now I pass on a taste of the thistle tea to you. Drink of it when you tire, $N, and fight with vigor once more!$B$B", 0); -- cgit v1.2.3