diff options
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 |