From 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd Mon Sep 17 00:00:00 2001 From: "Julio A. Leyva Osorio" Date: Fri, 16 Jul 2021 16:23:43 -0400 Subject: chore: characters (#584) * Update account_data.md * Update account_instance_times.md * Update account_tutorial.md * Update addons.md * Update arena_team.md * Fix arena_team.md * Update arena_team_member.md * Update auctionhouse.md * Update banned_addons.md * Update battleground_deserters.md * Update bugreport.md * Update calendar_events.md * fix calendar_events.md * fix * fix * fix3 * update calendar_invites.md * update channels.md * fix channels.md * fix channels.md * update channels_bans.md * update channels_bans.md * update petition.md * fix 4 * Update characters.md * Update worlstates.md * Update gm_ticket.md * + Update * + update 2.md * + update 3 * update + characters.md * + update 4.md * + update 5.md * update characters, thanks @r-o-b-o-t-o * fix + * + Update 6 * + Update 7 * + Update 8 * + Update 9 * Fix + @Kitzunu --- docs/mail.md | 32 +++++++++++++++++++------------- 1 file changed, 19 insertions(+), 13 deletions(-) (limited to 'docs/mail.md') diff --git a/docs/mail.md b/docs/mail.md index e0bea50..b477a1c 100644 --- a/docs/mail.md +++ b/docs/mail.md @@ -8,22 +8,23 @@ This table contains main data about all mails in the game. **Structure** -| Field | Type | Attributes | Key | Null | Default | Extra | Comment | -|---------------------|--------------|------------|-----|------|---------|-------|------------------------------------| +| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +| ------------------- | -------- | ---------- | --- | ---- | ------- | ----- | ---------------------------------- | | [id][1] | INT | UNSIGNED | PRI | NO | 0 | | Identifier | -| [messageType][2] | TINYINT | UNSIGNED | | NO | 0 | | | -| [stationery][3] | TINYINT | SIGNED | | NO | 41 | | | -| [mailTemplateId][4] | MEDIUMINT | UNSIGNED | | NO | 0 | | | +| [messageType][2] | TINYINT | UNSIGNED | | NO | 0 | | | +| [stationery][3] | TINYINT | UNSIGNED | | NO | 41 | | | +| [mailTemplateId][4] | SMALLINT | UNSIGNED | | NO | 0 | | | | [sender][5] | INT | UNSIGNED | | NO | 0 | | Character Global Unique Identifier | | [receiver][6] | INT | UNSIGNED | | NO | 0 | | Character Global Unique Identifier | -| [subject][7] | longtext | SIGNED | | YES | NULL | | | -| [body][8] | longtext | SIGNED | | YES | | | | -| [has_items][9] | TINYINT | UNSIGNED | | NO | 0 | | | +| [subject][7] | LONGTEXT | SIGNED | | YES | | | | +| [body][8] | LONGTEXT | SIGNED | | YES | | | | +| [has_items][9] | TINYINT | UNSIGNED | | NO | 0 | | | | [expire_time][10] | INT | UNSIGNED | | NO | 0 | | | | [deliver_time][11] | INT | UNSIGNED | | NO | 0 | | | | [money][12] | INT | UNSIGNED | | NO | 0 | | | | [cod][13] | INT | UNSIGNED | | NO | 0 | | | -| [checked][14] | TINYINT | UNSIGNED | | NO | 0 | | | +| [checked][14] | TINYINT | UNSIGNED | | NO | 0 | | | +| [auctionId][14] | INT | UNSIGNED | | NO | 0 | | | [1]: #id [2]: #messagetype @@ -39,6 +40,7 @@ This table contains main data about all mails in the game. [12]: #money [13]: #cod [14]: #checked +[15]: #auctionid **Description of the fields** @@ -74,11 +76,11 @@ Id from MailTemplate.dbc ### sender -In this field is entered sender [character.guid.](2129969.html#characters(table)-guid) +In this field is entered sender [character.guid](character#guid). ### receiver -Here is receiver's [character.guid.](2129969.html#characters(table)-guid) +Here is receiver's [character.guid](character#guid). ### subject @@ -94,7 +96,7 @@ Default: 0, When is set to 1, that mail can contain items. -For items look at [mail_items](mail_items) table. +For items look at [mail\_items](mail_items) table. ### expire\_time @@ -117,10 +119,14 @@ when is set to 1, that field \`money\` stores gold for COD. ### checked | Flag | Comment | -|------|-----------------------------| +| ---- | --------------------------- | | 0 | MAIL_CHECK_MASK_NONE | | 1 | MAIL_CHECK_MASK_READ | | 2 | MAIL_CHECK_MASK_RETURNED | | 4 | MAIL_CHECK_MASK_COPIED | | 8 | MAIL_CHECK_MASK_COD_PAYMENT | | 16 | MAIL_CHECK_MASK_HAS_BODY | + +### auctionId + +`field-no-description|14` \ No newline at end of file -- cgit