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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
# quest\_template\_locale
[<-Back-to:World](database-world.md)
**The \`quest\_template\_locale\` table**
This table is used to provide to localized clients with localized string for quest templates.
**Structure**
| Field | Type | Attribute | Key | Null | Default | Extra | Comment |
|----------------------|--------------|-----------|-----|------|---------|-------|---------|
| [ID][1] | mediumint(8) | unsigned | PRI | NO | 0 | | |
| [locale][2] | varchar(4) | | PRI | NO | | | |
| [Title][3] | text | | | YES | | | |
| [Details][4] | text | | | YES | | | |
| [Objectives][5] | text | | | YES | | | |
| [EndText][6] | text | | | YES | | | |
| [CompletedText][7] | text | | | YES | | | |
| [ObjectiveText1][8] | text | | | YES | | | |
| [ObjectiveText2][9] | text | | | YES | | | |
| [ObjectiveText3][10] | text | | | YES | | | |
| [ObjectiveText4][11] | text | | | YES | | | |
| [VerifiedBuild][12] | smallint(5) | | | YES | 0 | | |
[1]: #id
[2]: #locale
[3]: #title
[4]: #details
[5]: #objectives
[6]: #endtext
[7]: #completedtext
[8]: #objectivetext1
[9]: #objectivetext2
[10]: #objectivetext3
[11]: #objectivetext4
[12]: #verifiedbuild
**Description of the fields**
### ID
This is the ID of the quest to be translated.
### locale
| 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
### Example
```sql
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);
```
|
