quest_offer_reward_locale

The `quest_offer_reward_locale` table

Table Structure

Field	Type	Attribute	Key	Null	Default	Extra	Comment
ID	INT	UNSIGNED	PRI	NO	0
locale	VARCHAR(4)		PRI	NO	NULL
RewardText	text			YES	NULL
VerifiedBuild	SMALLINT			NO	0

Description of the fields

ID

Is the quest ID, obtained from quest_template

Locale / locale

It is the language in which you want to make the translation.

You can choose from the following:

ID	Language
0	enUS
1	koKR
2	frFR
3	deDE
4	zhCN
5	zhTW
6	esES
7	esMX
8	ruRU

RewardText

This is the text that is displayed when the quest is delivered. That is, before the reward is obtained.

VerifiedBuild

This field is used by the TrinityCore DB Team to determine whether a template has been verified from WDB files.

• If value is 0, it has not been parsed yet.
• If value is > 0, it has been parsed with WDB files from that specific Client Build.
• If value is -1, it is just a place holder until proper data are found on WDBs.
• If value is -Client Build, it was parsed with WDB files from that specific client build and manually edited later for some specific necessity.

Example

DELETE FROM `quest_offer_reward_locale` WHERE `ID`=2 AND `locale`='esES';
INSERT INTO `quest_offer_reward_locale` (`ID`, `locale`, `RewardText`, `VerifiedBuild`) VALUES
(2, "esES", "De lo más impresionante, $n... ¡no puede haber sido un paseo conseguir la garra de Garrafilada! ¡La Caza de Vallefresno te está yendo bien!$B$BGarrafilada lleva muchos años aterrorizando a los peones de los aserraderos cuando se trasladan a Puesto del Hachazo y se cruzan en su ruta. No lo dudes, cuando se corra la voz de que doblegaste a ese monstruo, ¡se escucharán muchas canciones alabando tu valor en los campamentos y aserraderos de todo Vallefresno!", 0);