quest_template_locale

nov 26, 2017

The `quest_template_locale` table

This table is used to provide to localized clients with localized string for quest templates.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
Id	mediumint(8)	unsigned	PRI	NO
Title_loc1	text	signed		YES	NULL
Title_loc2	text	signed		YES	NULL
Title_loc3	text	signed		YES	NULL
Title_loc4	text	signed		YES	NULL
Title_loc5	text	signed		YES	NULL
Title_loc6	text	signed		YES	NULL
Title_loc7	text	signed		YES	NULL
Title_loc8	text	signed		YES	NULL
Details_loc1	text	signed		YES	NULL
Details_loc2	text	signed		YES	NULL
Details_loc3	text	signed		YES	NULL
Details_loc4	text	signed		YES	NULL
Details_loc5	text	signed		YES	NULL
Details_loc6	text	signed		YES	NULL
Details_loc7	text	signed		YES	NULL
Details_loc8	text	signed		YES	NULL
Objectives_loc1	text	signed		YES	NULL
Objectives_loc2	text	signed		YES	NULL
Objectives_loc3	text	signed		YES	NULL
Objectives_loc4	text	signed		YES	NULL
Objectives_loc5	text	signed		YES	NULL
Objectives_loc6	text	signed		YES	NULL
Objectives_loc7	text	signed		YES	NULL
Objectives_loc8	text	signed		YES	NULL
OfferRewardText_loc1	text	signed		YES	NULL
OfferRewardText_loc2	text	signed		YES	NULL
OfferRewardText_loc3	text	signed		YES	NULL
OfferRewardText_loc4	text	signed		YES	NULL
OfferRewardText_loc5	text	signed		YES	NULL
OfferRewardText_loc6	text	signed		YES	NULL
OfferRewardText_loc7	text	signed		YES	NULL
OfferRewardText_loc8	text	signed		YES	NULL
RequestItemsText_loc1	text	signed		YES	NULL
RequestItemsText_loc2	text	signed		YES	NULL
RequestItemsText_loc3	text	signed		YES	NULL
RequestItemsText_loc4	text	signed		YES	NULL
RequestItemsText_loc5	text	signed		YES	NULL
RequestItemsText_loc6	text	signed		YES

Comments

Oct 16, 2019

This definition is outdated in the build 19091 I am using . The new localisation method is based on this table with a new format containing ID + locale as the key.

It also has 2 new sub-table for reporting progress and reward for quest:

quest_offer_reward_locale (ID, locale, RewardText, VerifiedBuild)
quest_request_items_locale (ID, locale, CompletionText, VerifiedBuild)

This also means the reload quest_template_locale function should reload the 3 tables at the same time (or we need to have 3 distinct reload function)