From 7eb5cd8fe052daafaffc537432fb8b355592703a Mon Sep 17 00:00:00 2001
From: Walter Pagani <paganiwalter@gmail.com>
Date: Wed, 6 Jan 2021 06:18:46 -0300
Subject: docs: add the `quest_offer_reward_locale` table (#326)

---
 docs/quest_offer_reward_locale.md | 55 +++++++++++++++++++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 docs/quest_offer_reward_locale.md

(limited to 'docs')

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);
+```
-- 
cgit