diff options
| author | Julio A. Leyva Osorio <tony931023@gmail.com> | 2021-07-16 16:23:43 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-07-16 22:23:43 +0200 |
| commit | 9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd (patch) | |
| tree | cc7fe36188f6d9144baaddecdc35ed77a2eb1a36 /docs/mail.md | |
| parent | 535ad2787b77d2ffd79b6788e38156ec5144ca7f (diff) | |
| download | wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.gz wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.tar.bz2 wiki-9fd9a07f1c51200cdaf4fd5e13e7cec24fe3bbcd.zip | |
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
Diffstat (limited to 'docs/mail.md')
| -rw-r--r-- | docs/mail.md | 32 |
1 files changed, 19 insertions, 13 deletions
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 |