Back-to:Characters
The `mail` table
This table contains main data about all mails in the game.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(10) | unsigned | PRI | NO | 0 |
| Identifier | |
tinyint(3) | unsigned |
| NO | 0 |
|
| |
tinyint(3) | signed |
| NO | 41 |
|
| |
mediumint(5) | unsigned |
| NO | 0 |
|
| |
int(10) | unsigned |
| NO | 0 |
| Character Global Unique Identifier | |
int(10) | unsigned |
| NO | 0 |
| Character Global Unique Identifier | |
longtext | signed |
| YES | NULL |
|
| |
longtext | signed |
| YES | ||||
tinyint(3) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
int(10) | unsigned | NO | 0 | ||||
tinyint(3) | unsigned | NO | 0 |
Description of the fields
This field contains unique ID of any messages.
Don't have autoincrement !!!
This field can contain these values:
Id from MailTemplate.dbc
In this field is entered sender character.guid.
Here is receiver's character.guid.
Here is stored mail subject.
The text contained in the mail.
Default: 0,
When is set to 1, that mail can contain items.
For items look at mail_items table.
Here is timestamp which stores date for auto-return mail to sender.
Here is timestamp which stores date of send mail.
The ammout of money in mail, or money to pay when is COD.
Default: 0 - No COD,
when is set to 1, that field `money` stores gold for COD.
Flag | Comment | ||
---|---|---|---|
0 | MAIL_CHECK_MASK_NONE | 0x00 |
|
1 | MAIL_CHECK_MASK_READ | 0x01 |
|
2 | MAIL_CHECK_MASK_RETURNED | 0x02 | This mail was returned. Do not allow returning mail back again. |
4 | MAIL_CHECK_MASK_COPIED | 0x04 | This mail was copied. Do not allow making a copy of items in mail. |
8 | MAIL_CHECK_MASK_COD_PAYMENT | 0x08 |
|
16 | MAIL_CHECK_MASK_HAS_BODY | 0x10 | This mail has body text. |