Vincent-Michael/TrinityCore — comment on commit d1c05e51cf256fde99138451144afd21dde0a6b7
File:  line 0
By cezeta:

hello, I am using some Vincent's achievement fixes on my server and Pilgrim's Paunch 100% works with the lastest version of data from Vincent... the only thing that's still missing are the quest texts - you can use this to fix that:

-- Missing quest texts
-- Quest chain
-- ali
UPDATE `quest_template` SET `OfferRewardText`='Excellent. This is just what we needed. It\'s going to be a chore keeping all the tables stocked with fresh food, but it\'s well worth it.', `RequestItemsText`='We can always use more of that delicious spice bread stuffing. It\'s very popular.' WHERE `entry`=14023;
UPDATE `quest_template` SET `OfferRewardText`='The pumpkin pie\'s been a big hit up here. I\'ve never seen a dwarf get so excited about anything made from a vegetable.', `RequestItemsText`='More pumpkin pie? Just in time.' WHERE `entry`=14024;
UPDATE `quest_template` SET `OfferRewardText`='Finally, the cranberry chutney I was promised. You wouldn\'t believe how fast the celebrants go through the stuff here.', `RequestItemsText`='Is that cranberry chutney I smell?' WHERE `entry`=14028;
UPDATE `quest_template` SET `OfferRewardText`='Thanks for bringing everything. I was starting to get worried.$B$BWhile you\'re here, you should try your hand at making some candied sweet potatoes.', `RequestItemsText`='Have you come to partake of the Pilgrim\'s Bounty feast?' WHERE `entry`=14030;
UPDATE `quest_template` SET `OfferRewardText`='Ah, candied sweet potatoes! My favorite! Did Isaac tell you?', `RequestItemsText`='$N, it\'s good to see you again.' WHERE `entry`=14033;
UPDATE `quest_template` SET `OfferRewardText`='These are beautiful and just in time to feed hungry feasters. Thank you, $N. You\'ve truly mastered all the courses of a traditional Pilgrim\'s Bounty meal.', `RequestItemsText`='What brings you back to Darnassus, $N? ' WHERE `entry`=14035;
-- horde
UPDATE `quest_template` SET `OfferRewardText`='It\'s a chore keeping all these tables stocked. If you stop and think about it, it\'s strange going to so much trouble when we needn\'t eat anymore.$B$B$B$BTradition is tradition.', `RequestItemsText`='The tables could really use more of that spice bread stuffing.' WHERE `entry`=14037;
UPDATE `quest_template` SET `OfferRewardText`='The pie always goes first. I think people must be skipping the meal and going directly for the dessert. Have you given it a try yet?', `RequestItemsText`='We can always use more pumpkin pie.' WHERE `entry`=14040;
UPDATE `quest_template` SET `OfferRewardText`='Ah, more cranberry chutney! You wouldn\'t believe how fast the celebrants go through it.', `RequestItemsText`='How are you enjoying Pilgrim\'s Bounty, $C.? ' WHERE `entry`=14041;
UPDATE `quest_template` SET `OfferRewardText`='So Dokin drafted you to help with the candied sweet potatoes?$B$B$B$BIt\'s the only way he can keep up. Thanks for bringing these.', `RequestItemsText`='Welcome back, $N.' WHERE `entry`=14043;
UPDATE `quest_template` SET `OfferRewardText`='Thanks for bringing everything. Some of the tables were starting to look a little bereft of serving dishes.', `RequestItemsText`='It\'s good to see you again. $N.' WHERE `entry`=14044;
UPDATE `quest_template` SET `OfferRewardText`='These look perfect. Thank you, $N. You\'ve truly mastered all the courses of a traditional Pilgrim\'s Bounty meal.', `RequestItemsText`='What brings you back to Orgrimmar, $N?' WHERE `entry`=14047;
-- Dailies
-- ali
UPDATE `quest_template` SET `OfferRewardText`='Thanks. This looks great, and you\'re a fair bit faster than Jasper, but don\'t tell him I said so.', `RequestItemsText`='Were you able to get your hands on any cranberry chutney?' WHERE `entry`=14053;
UPDATE `quest_template` SET `OfferRewardText`='These are perfect. Thanks for helping me with this, $N. The meal will get served on time and Ellen will be happy.', `RequestItemsText`='Do you have those candied sweet potatoes?' WHERE `entry`=14055;
UPDATE `quest_template` SET `OfferRewardText`='Thank goodness! I wouldn\'t be able to serve the feast without spice bread stuffing.', `RequestItemsText`='Were you able to get that stuffing?' WHERE `entry`=14051;
UPDATE `quest_template` SET `OfferRewardText`='These are just what I need. Thanks, $N. You\'re a lifesaver. ', `RequestItemsText`='Did you manage to find those turkeys?' WHERE `entry`=14048;
UPDATE `quest_template` SET `OfferRewardText`='These are perfect. Isaac, and everyone else, will love them!', `RequestItemsText`='How are those pies coming along?' WHERE `entry`=14054;
-- horde
UPDATE `quest_template` SET `OfferRewardText`='Thanks for your help, and let me know if you ever get to the bottom of the case of the disappearing chutney.', `RequestItemsText`='Were you able to get your hands on any cranberry chutney?' WHERE `entry`=14059;
UPDATE `quest_template` SET `OfferRewardText`='Thanks, $N. Now, I can help the hostess out and still keep my word to Roberta.', `RequestItemsText`='Do you have those candied sweet potatoes?' WHERE `entry`=14058;
UPDATE `quest_template` SET `OfferRewardText`='Perfect timing! I wouldn\'t be able to serve the feast without spice bread stuffing.', `RequestItemsText`='Were you able to get that stuffing?' WHERE `entry`=14062;
UPDATE `quest_template` SET `OfferRewardText`='These turkeys are exactly what I needed. Thanks for helping me out of a tough situation.', `RequestItemsText`='How\'s your turkey hunt going?' WHERE `entry`=14061;
UPDATE `quest_template` SET `OfferRewardText`='These are great! Thank you for helping, $N.', `RequestItemsText`='How are those pies coming along?' WHERE `entry`=14060;
-- Other
-- ali
UPDATE `quest_template` SET `OfferRewardText`='If you\'d like to learn to cook Pilgrim\'s Bounty foods, I can help. If you\'re not already a cook, all you have to do is train and you\'ll be cooking in no time!' WHERE `entry`=14022;
UPDATE `quest_template` SET `OfferRewardText`='What a feast, hmmm?$B$BI\'m so glad you could celebrate the spirit of Pilgrim\'s Bounty with us.' WHERE `entry`=14064;
-- horde
UPDATE `quest_template` SET `OfferRewardText`='If you\'d like to learn to cook Pilgrim\'s Bounty foods, I can help. If you\'re not already a cook, all you have to do is train and you\'ll be cooking in no time.' WHERE `entry`=14036;
UPDATE `quest_template` SET `OfferRewardText`='What a feast, hmmm?$B$BI\'m so glad you could celebrate the spirit of Pilgrim\'s Bounty with us.' WHERE `entry`=14065;