From 5712ba985109d3f741ebeaa5cd0f1eef92331864 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Wed, 6 Jan 2021 06:18:05 -0300 Subject: docs: Adding quest_mail_sender.md (#327) --- docs/quest_mail_sender.md | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 docs/quest_mail_sender.md 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) -- cgit