quest_request_items_locale
Table: quest_request_items_locale
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
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
Example
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);