quest_request_items_locale
Table: quest_request_items_locale
Table Structure
| Field | Type | Attribute | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | INT | UNSIGNED | PRI | NO | |||
| locale | VARCHAR(4) | PRI | NO | ||||
| CompletionText | text | YES | NULL | ||||
| VerifiedBuild | SMALLINT | NO |
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 |
CompletionText
It is the text that is shown, while the quest is not completed.
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
sql
DELETE FROM `quest_request_items_locale` WHERE `ID`=2 AND `locale`='esES';
INSERT INTO `quest_request_items_locale` (`ID`, `locale`, `CompletionText`, `VerifiedBuild`) VALUES`ID`, `locale`, `CompletionText`, `VerifiedBuild`
(2, "esES", "Sí, $gpoderoso:poderosa; $c, he presentido tu llegada. Confío que tienes más noticias que darme sobre tu caza.", 0);