quest_template_locale
The `quest_template_locale` table
This table is used to provide to localized clients with localized string for quest templates.
Table Structure
| Field | Type | Attribute | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| locale | VARCHAR(4) | PRI | NO | ||||
| Title | text | YES | |||||
| Details | text | YES | |||||
| Objectives | text | YES | |||||
| EndText | text | YES | |||||
| CompletedText | text | YES | |||||
| ObjectiveText1 | text | YES | |||||
| ObjectiveText2 | text | YES | |||||
| ObjectiveText3 | text | YES | |||||
| ObjectiveText4 | text | YES | |||||
| VerifiedBuild | SMALLINT | YES | 0 |
Description of the fields
ID
This is the ID of the quest to be translated.
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 |
Title
The title of the quest in the respective language.
Details
Detail of the quest.
Objectives
This is the text that is displayed when it is completed.
EndText
This is the text that is displayed until the quest is completed.
ObjectiveText1
This is objective 1 of the search. In other words, it is the text that accompanies the counters.
ObjectiveText2
This is objective 2 of the search. In other words, it is the text that accompanies the counters.
ObjectiveText3
This is objective 3 of the search. In other words, it is the text that accompanies the counters.
ObjectiveText4
This is objective 4 of the search. In other words, it is the text that accompanies the counters.
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_template_locale` WHERE `ID`=62 AND `locale`="esES";
INSERT INTO `quest_template_locale` (`ID`, `locale`, `Title`, `Details`, `Objectives`, `EndText`, `CompletedText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `VerifiedBuild`) VALUES
(62, "esES", "La Mina Abisal", "¡La mina de Villanorte no es la única que tiene problemas! Según mis informes, la Mina Abisal de Elwynn también ha sido ocupada por los kóbolds.$B$BExplora la mina y comprueba la veracidad de mis informes. Luego vuelve aquí. La mina está hacia el sur de Villadorada, entre La Granja Pedregosa y la granja Maclure.", "Explora la Mina Abisal y vuelve junto al alguacil Dughan a Villadorada.", "Explora la Mina Abisal", "Vuelve con: Alguacil Dughan. Zona: Villadorada, Bosque de Elwynn.", "", "", "", "", 18019);