summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--docs/quest_mail_sender.md35
1 files changed, 35 insertions, 0 deletions
diff --git a/docs/quest_mail_sender.md b/docs/quest_mail_sender.md
new file mode 100644
index 0000000..e0bbe9b
--- /dev/null
+++ b/docs/quest_mail_sender.md
@@ -0,0 +1,35 @@
+# quest\_mail\_sender
+
+[<-Back-to:World](database-world.md)
+
+**The \`quest\_mail\_sender\` table**
+
+**Structure**
+
+| Field | Type | Attribute | Key | Null | Default | Extra | Comment |
+|----------------------------|--------|-----------|-----|------|---------|-------|---------|
+| [QuestId][1] | int(5) | unsigned | PRI | NO | 0 | | |
+| [RewardMailSenderEntry][2] | int(5) | unsigned | | NO | 0 | | |
+
+[1]: #questid
+[2]: #rewardmailsenderentry
+
+**Description of the fields**
+
+### QuestId
+
+Is the quest ID, obtained from quest_template
+
+### RewardMailSenderEntry
+
+It is the ID of the mail that must be sent to the player once it has been recommended by the quest.
+
+### Example
+```sql
+DELETE FROM `quest_mail_sender` WHERE `QuestId`=10588 AND `RewardMailSenderEntry`=18166;
+INSERT INTO `quest_mail_sender` (`QuestId`, `RewardMailSenderEntry`) VALUES
+(10588, 18166);
+```
+
+![WoWScrnShot_010521_114722](https://user-images.githubusercontent.com/2810187/103660200-18603880-4f4c-11eb-995e-e2994353532e.jpg)
+![WoWScrnShot_010521_114806](https://user-images.githubusercontent.com/2810187/103660207-19916580-4f4c-11eb-854f-e2d043127a90.jpg)