diff options
| -rw-r--r-- | docs/quest_offer_reward_locale.md | 55 |
1 files changed, 55 insertions, 0 deletions
diff --git a/docs/quest_offer_reward_locale.md b/docs/quest_offer_reward_locale.md new file mode 100644 index 0000000..e690755 --- /dev/null +++ b/docs/quest_offer_reward_locale.md @@ -0,0 +1,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(10) | unsigned | PRI | NO | 0 | | | +| [locale][2] | varchar(4) | | PRI | NO | NULL | | | +| [RewardText][3] | text | | | YES | NULL | | | +| [VerifiedBuild][4] | smallint(6) | | | 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); +``` |