The `achievement_reward_locale` table
It is the table that stores the translations of the table achievement_reward, so that the game client can display the messages in different languages.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
| Locale | VARCHAR(4) | PRI | NO | ||||
| Subject | text | YES | |||||
| Text | text | YES |
Description of the fields
It is the ID of the achievement obtained from achievement_reward
This is the language of the gaming client.
| ID | Language |
|---|---|
| 0 | enUS |
| 1 | koKR |
| 2 | frFR |
| 3 | deDE |
| 4 | zhCN |
| 5 | zhTW |
| 6 | esES |
| 7 | esMX |
| 8 | ruRU |
It is the text of the column Subject of the table achievement_reward
It is the text of the column Body of the table achievement_reward
DELETE FROM `achievement_reward_locale` WHERE `ID`=13 AND `Locale`="esES"; INSERT INTO `achievement_reward_locale` (`ID`, `Locale`, `Subject`, `Text`) VALUES (13, "esES", "Nivel 80", "Alcanza el nivel 80.");