aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2015-12-29 21:41:18 +0100
committerMitchesD <majklprofik@seznam.cz>2016-01-17 14:00:59 +0100
commit4da0a6f8e3ce3301f8ce0e2d668f361b13245866 (patch)
tree4d064ed9e48a1f83bc6ebe47bedc7f6c008c5d60
parent6aa8ab86a8f75b880c422e719920fa1e2afc42aa (diff)
DB/Quest: Add missing text for Horns of Nez'ra
By @tkrokli Closes #16078 (cherry picked from commit 99f31a2202564493751240d99e08e1044c7a9d80)
-rw-r--r--sql/updates/world/2016_01_17_12_world_2015_12_29_08.sql8
1 files changed, 8 insertions, 0 deletions
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);