Some quest database fixes

[ralittle]

Hello all,

I finally decided to start contributing to this repack. The following are MySQL queries to update the quest_template table. The information in these queries were extracted from cata.openwow.com.


This updates all quests that have missing or incorrect RequesetItemsText (Progress) text in quest_template
http://www.mediafire.com/download/9ckplb0dzzly4c1/Global_Fixes_-_quest_template_-_RequestItemsText.sql

This updates all quests that have missing or incorrect OfferRewardText (Completion) text in quest_template
http://www.mediafire.com/download/866w1lg71acolaa/Global_Fixes_-_quest_template_-_OfferRewardText.sql

This updates all quests that have missing or incorrect NextQuestInChain entries in quest_template
http://www.mediafire.com/download/f2xa4hdca5f4m82/Global_Fixes_-_quest_template_-_NextQuestInChain.sql

This updates all quests that have missing or incorrect PrevQuestId entries in quest_template
http://www.mediafire.com/download/en2fmcbaecfi66h/Global_Fixes_-_quest_template_-_PrevQuestId.sql

Since the information was generated by automated processes, I cannot guarantee that these are 100% accurate or complete but should be real close. If anyone sees any errors please let me know so I can correct.

 

[ExO]

Seems like I never got to reply.
Thanks for your contribution, we'll review these asap

 

[KoroLion]

Thanks a lot!

 

[kambire]

Awesome,
a lot of work given to the community.

 

[tzymbal]

Thank you!