blob: 851304767b9e2a87f7f9ed7fa2a2c782b136e908 (
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
|
# quest\_offer\_reward\_locale
[<-Back-to:World](database-world.md)
**The \`quest\_offer\_reward\_locale\` table**
**Structure**
| Field | Type | Attribute | Key | Null | Default | Extra | Comment |
|--------------------|-------------|-----------|-----|------|---------|-------|---------|
| [ID][1] | INT | UNSIGNED | PRI | NO | 0 | | |
| [locale][2] | VARCHAR(4) | | PRI | NO | NULL | | |
| [RewardText][3] | text | | | YES | NULL | | |
| [VerifiedBuild][4] | SMALLINT | | | NO | 0 | | |
[1]: #id
[2]: #locale
[3]: #rewardtext
[4]: #verifiedbuild
**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 |
### RewardText
This is the text that is displayed when the quest is delivered. That is, before the reward is obtained.
### VerifiedBuild
### Example
```sql
DELETE FROM `quest_offer_reward_locale` WHERE `ID`=2 AND `locale`='esES';
INSERT INTO `quest_offer_reward_locale` (`ID`, `locale`, `RewardText`, `VerifiedBuild`) VALUES
(2, "esES", "De lo más impresionante, $n... ¡no puede haber sido un paseo conseguir la garra de Garrafilada! ¡La Caza de Vallefresno te está yendo bien!$B$BGarrafilada lleva muchos años aterrorizando a los peones de los aserraderos cuando se trasladan a Puesto del Hachazo y se cruzan en su ruta. No lo dudes, cuando se corra la voz de que doblegaste a ese monstruo, ¡se escucharán muchas canciones alabando tu valor en los campamentos y aserraderos de todo Vallefresno!", 0);
```
|
