blob: 49c3bff70f080546bb3365c21216ae2b068eaf00 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
# achievement\_reward\_locale
[<-Back-to:World](database-world.md)
**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][1] | MEDIUMINT | UNSIGNED | PRI | NO | 0 | | |
| [Locale][2] | VARCHAR(4) | | PRI | NO | | | |
| [Subject][3] | text | | | YES | | | |
| [Text][4] | text | | | YES | | | |
[1]: #id
[2]: #locale
[3]: #subject
[4]: #text
**Description of the fields**
### ID
It is the [ID](achievement_reward#id) of the achievement obtained from `achievement_reward`
### Locale
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 |
### Subject
It is the text of the column [Subject](achievement_reward#subject) of the table `achievement_reward`
### Text
It is the text of the column [Body](achievement_reward#body) of the table `achievement_reward`
### Example
```sql
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.");
```
|
