DB/Quests: Missing completion text for Duskwood quests

Closes #23959

1 files changed, 56 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_12_17_00_world.sql b/sql/updates/world/master/2019_12_17_00_world.sql
new file mode 100644
index 00000000000..1f513cdcb55
--- /dev/null
+++ b/sql/updates/world/master/2019_12_17_00_world.sql
@@ -0,0 +1,56 @@
+-- 
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (25235, 26618, 26620, 26623, 26627, 26645, 26652, 26653, 26654, 26655, 26660, 26661, 26666, 26667, 26669, 26670, 26671, 26672, 26674, 26676, 26677, 26680, 26681, 26684, 26685, 26686, 26688, 26689, 26690, 26691, 26707, 26717, 26719, 26720, 26721, 26722, 26723, 26724, 26725, 26727, 26728, 26753, 26754, 26760, 26777, 26778, 26785, 26787, 26793, 26795, 26796, 26797, 28564);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(25235, 0, 0, 0, 0, 0, 0, 0, 0, "I saw you drop a few of them from here. Nice work.$B$BHere's your reward, on behalf of the Night Watch.", 0),
+(26618, 0, 0, 0, 0, 0, 0, 0, 0, "Don't go thinking that was too easy. Far greater dangers lurk deeper in the woods.", 0),
+(26620, 0, 0, 0, 0, 0, 0, 0, 0, "Mmm-mmm! The skirtsteak's the best part. It's not an efficient way to cook, though.$B$BHere, have this recipe. It's a little different, but flank meat's easier to come by when you really need a meal.", 0),
+(26623, 0, 0, 0, 0, 0, 0, 0, 0, "Ah yes, a nice lump you have there!  Let me just get this seasoned with my secret spices (no looking!) and get them to skittering on a skillet for a while...$B$BAnd, although Dusky Crab Cakes are my specialty and I won't give out the recipe, here's the recipe for a dish that's almost as good.", 0),
+(26627, 0, 0, 0, 0, 0, 0, 0, 0, "Ah, welcome, stranger. I'd offer you something, but there's not much here...$B$BCould I beg you to run some errands for a poor old hermit?", 0),
+(26645, 0, 0, 0, 0, 0, 0, 0, 0, "Splendid, $n.  For your service to the people of Darkshire you shall be rewarded.", 0),
+(26652, 0, 0, 0, 0, 0, 0, 0, 0, "What is this?  A comb?  It's lovely!  And it glides through my hair as if it weren't the stiff, stringy horror that it is.$B$BOh, if only I had a mirror...", 0),
+(26653, 0, 0, 0, 0, 0, 0, 0, 0, "Ah, ghost hair thread is what you need, is it?  I'm afraid I have none in stock, but I can make some for you...if you can supply the ghost hair.", 0),
+(26654, 0, 0, 0, 0, 0, 0, 0, 0, "I can make a spool of ghost hair thread with this, and have a few strands to spare.  Here are some coins for those extra strands.", 0),
+(26655, 0, 0, 0, 0, 0, 0, 0, 0, "Delightful!  This will do splendidly...$B$BHere, good $n, take this as payment for your honorable deed.", 0),
+(26660, 0, 0, 0, 0, 0, 0, 0, 0, "You need some Zombie Juice, do you?  Hmm...that's some strong stuff - I don't usually get requests for it.", 0),
+(26661, 0, 0, 0, 0, 0, 0, 0, 0, "Good,  you got the rot blossoms.$B$BI'll whip up the zombie juice... it's strong stuff, I warn you.", 0),
+(26666, 0, 0, 0, 0, 0, 0, 0, 0, "Can I help you?", 0),
+(26667, 0, 0, 0, 0, 0, 0, 0, 0, "By the Light... you actually went and got it?$B$BI'm shocked. I suppose I owe you thanks for returning it to the archives.", 0),
+(26669, 0, 0, 0, 0, 0, 0, 0, 0, "This was all you found?$B$BThat's bad news, I'm afraid...", 0),
+(26670, 0, 0, 0, 0, 0, 0, 0, 0, "You actually went and got it?!$B$BI don't know whether to call you brave or insane. But once again, my archives thank you.", 0),
+(26671, 0, 0, 0, 0, 0, 0, 0, 0, "I can't thank you enough... I had hoped for this to be a joyous reunion, but the more I learn, the less glad I am to have asked.$B$BBut I must know.", 0),
+(26672, 0, 0, 0, 0, 0, 0, 0, 0, "How interesting. It's been quite a while since I've seen such a ring...", 0),
+(26674, 0, 0, 0, 0, 0, 0, 0, 0, "Master Harris may have been right. I would have been better to leave the past behind.$B$BI've got a new life now. Whether it's that of a monster or a man is up to me.$B$BAs for you, I cannot thank you enough for your assistance, regardless of the outcome. Please, take this with my thanks.", 0),
+(26676, 0, 0, 0, 0, 0, 0, 0, 0, "A thousand thanks, $n.  You warm an old man's heart with your foolish-...I mean...with your kindness!$B$BHere you are, friend.  Take this as a token of my gratitude.", 0),
+(26677, 0, 0, 0, 0, 0, 0, 0, 0, "Ah, thanks.  These will do just the trick!", 0),
+(26680, 0, 0, 0, 0, 0, 0, 0, 0, "Thank the Nec-...well, thank YOU, $n!  You have more than earned your reward.$B$BAha!  Happy!  Happy nights ahead!!", 0),
+(26681, 0, 0, 0, 0, 0, 0, 0, 0, "<Ello looks at the letter, and immediately pales.>$B$BYou fool! You've doomed us all!", 0),
+(26684, 0, 0, 0, 0, 0, 0, 0, 0, "Most superb!  This will work perfectly.  Many thanks!", 0),
+(26685, 0, 0, 0, 0, 0, 0, 0, 0, "At last!  The stargazing device is complete!  Thank you, $n.  Now I can continue my research. . .", 0),
+(26686, 0, 0, 0, 0, 0, 0, 0, 0, "The people of Darkshire thank you, $n.  You have proven yourself to be a great ally of The Night Watch.", 0),
+(26688, 0, 0, 0, 0, 0, 0, 0, 0, "Impressive, $n. It would seem that you are capable enough to handle yourself. Perhaps a more suitable challenge could be found for one of your abilities.", 0),
+(26689, 0, 0, 0, 0, 0, 0, 0, 0, "You performed well against the Shadow Weavers, $n. But even now, years after their first arrival, there seem to be so many to replace the ones we kill.$B$BI will put my faith in Master Carevin. No doubt he will get to the bottom of the problem.", 0),
+(26690, 0, 0, 0, 0, 0, 0, 0, 0, "$n, to be honest with you, I did not believe that you would get this far, but you are clearly a $c to be reckoned with. In fact, if you wish to formally join Master Carevin's struggle, I will gladly write for you a letter of recommendation.", 0),
+(26691, 0, 0, 0, 0, 0, 0, 0, 0, "Here you go, $n. Bring this message to Master Carevin.$B$B<He quickly removes a piece of faded parchment and offers it to you.>$B$BA few more like you, and we will outnumber the Night Watch! Perhaps then we could complete the work that we few carry on today.", 0),
+(26707, 0, 0, 0, 0, 0, 0, 0, 0, "I thank you, $c... and I'm sure the worgen that may be returned to sanity with the potion this will make would thank you too.", 0),
+(26717, 0, 0, 0, 0, 0, 0, 0, 0, "Sounds like a close call! But he ran off without harming you further...$B$BHe might be still fighting it. Master Harris must know!", 0),
+(26719, 0, 0, 0, 0, 0, 0, 0, 0, "Welcome to our humble camp. I wouldn't call it pleasant, but it's at least somewhat private.$B$BBeg your pardon? A worgen at the farm?", 0),
+(26720, 0, 0, 0, 0, 0, 0, 0, 0, "You've got him!$B$BNo time to lose, then. We'll prepare to administer the serum right away.$B$BJITTERS! Get ready!", 0),
+(26721, 0, 0, 0, 0, 0, 0, 0, 0, "Oh thank you, thank you! You've saved me from having to go out in the woods with those awful things!$B$BAt least for a day, that is...", 0),
+(26722, 0, 0, 0, 0, 0, 0, 0, 0, "<In the darkest depths of this earthen tunnel, you spy the faintest gleam. The last piece is found!>", 0),
+(26723, 0, 0, 0, 0, 0, 0, 0, 0, "His clothes and bloodstains? If it's not tricks, it's something worse...", 0),
+(26724, 0, 0, 0, 0, 0, 0, 0, 0, "It's heartening to see one so recently recovered be so concerned with the plight of others. Sven spares himself suffering by not dwelling on his own misfortune.", 0),
+(26725, 0, 0, 0, 0, 0, 0, 0, 0, "<Buried in the cold dirt, you find a brilliant metal shaft. But there are holes where pieces of the artifact are clearly missing.>", 0),
+(26727, 0, 0, 0, 0, 0, 0, 0, 0, "Thank the Light, he's gone...$B$BI'll say you've made amends by helping save the lives of those here, $n.", 0),
+(26728, 0, 0, 0, 0, 0, 0, 0, 0, "You are the help that we requested?$B$B<Althea sighs.>$B$BI suppose you will have to do.", 0),
+(26753, 0, 0, 0, 0, 0, 0, 0, 0, "<In the dirt of this alcove, your eye catches the shine of brilliant metal. You've found another piece of the artifact!>", 0),
+(26754, 0, 0, 0, 0, 0, 0, 0, 0, "May the disgusting monster stay dead this time!$B$BI'll head down there and scatter his remains to ash myself, $n. You've done a great thing; perhaps in time Duskwood can return to its former peaceful state.", 0),
+(26760, 0, 0, 0, 0, 0, 0, 0, 0, "Success... Finally! I can't thank you enough for giving me the chance to work the cure myself.$B$BOur new friend may be in need of some help as well. You might want to speak with him.", 0),
+(26777, 0, 0, 0, 0, 0, 0, 0, 0, "You have brought peace to those who knew only misery, $n. Be proud.", 0),
+(26778, 0, 0, 0, 0, 0, 0, 0, 0, "The cries grow softer for now. Light bless you, $n. ", 0),
+(26785, 0, 0, 0, 0, 0, 0, 0, 0, "Tobias is staying in town still?$B$BMaster Harris warned him not to pursue his brother's fate. We all lead new lives now, after all. But the past is hard to let go of...", 0),
+(26787, 0, 0, 0, 0, 0, 0, 0, 0, "Thank you! Oh, thank you. I never thought I'd be happy to smell those brains, but I am now that I didn't have to get them!$B$BHere's your reward as promised...", 0),
+(26793, 0, 0, 0, 0, 0, 0, 0, 0, "Morgan Ladimore?$B$BAhh, yes, of course. His was a long and sorrowful tale. I knew him, well, before he left for the war, but that was the last time I saw him. A noble and good man, he was, but he suffered a bad end.$B$BHere, I should have something here that can tell the tale better than my own recollections...", 0),
+(26795, 0, 0, 0, 0, 0, 0, 0, 0, "You killed him? That's no small accomplishment, $n! On behalf of the people of Darkshire and the Night Watch, I thank you.$B$BAh... there is one small matter, however...", 0),
+(26796, 0, 0, 0, 0, 0, 0, 0, 0, "Yes? My father...$B$B<Her eyes become downcast.>$B$BI wish... there was something I could have done for him... If only I had talked to him before he...", 0),
+(26797, 0, 0, 0, 0, 0, 0, 0, 0, "<A ghostly voice sounds on the wind...>$B$BThis is...? Sarah? Could it be she's still alive? The weight is removed from my shoulders...$B$B$n. Take my sword, Archeus. As my soul is put to rest, I have no more need for it. It was forged to do good, and though I have proved myself unworthy to hold it, perhaps you will carry on the Light through it.$B$BLys, my love...", 0),
+(28564, 0, 0, 0, 0, 0, 0, 0, 0, "You are the help that we requested?$B$B<Althea sighs.>$B$BI suppose you will have to do.", 0);