|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'mail' table for MaNGOSThree
This table contains main data about all mails in the game.
Table Notes
This table uses the 'InnoDB' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| id | int(11) unsigned | NO | PRI | '0' | Unique message id. Every new message gets a new auto incremented id. | |
| messageType | tinyint(3) unsigned | NO | '0' | message_type. | ||
| stationery | tinyint(3) | NO | '41' | The StationeryID [See Stationery.dbc]. | ||
| mailTemplateId | mediumint(8) unsigned | NO | '0' | The Mail Template Id [See MailTemplate.dbc] | ||
| sender | int(11) unsigned | NO | '0' | Guid of the character who sends the mail. | ||
| receiver | int(11) unsigned | NO | MUL | '0' | Guid of the character who receives the mail. | |
| subject | longtext | YES | NULL | The Subject of the mail. | ||
| body | longtext | YES | NULL | |||
| has_items | tinyint(3) unsigned | NO | '0' | Boolean value showing whether or not atems have been sent. | ||
| expire_time | bigint(40) unsigned | NO | '0' | Current Unix Time + Unix Time till expiry. | ||
| deliver_time | bigint(40) unsigned | NO | '0' | Current Unix Time + Unix Time till delivery. | ||
| money | bigint(40) unsigned | NO | '0' | Amount of money sent. | ||
| cod | bigint(40) unsigned | NO | '0' | Amount of money needed (COD). | ||
| checked | tinyint(3) unsigned | NO | '0' | checked_flag. |
Description of the fields
id int(11) unsigned
Unique message id. Every new message gets a new auto incremented id.
messageType tinyint(3) unsigned
The type of the Message:
| Value | Type |
|---|---|
| 0 | NORMAL |
| 1 | COD |
| 2 | AUCTION |
stationery tinyint(3)
The StationeryID [See Stationery.dbc].
| Value | Type |
|---|---|
| 1 | plain & purple scroll icon |
| 41 | Normal Mail |
| 61 | GM Mail |
| 62 | Auction House |
| 64 | Valentine's Day |
mailTemplateId mediumint(8) unsigned
The Mail Template Id [See MailTemplate.dbc]
sender int(11) unsigned
Guid of the character who sends the mail.
receiver int(11) unsigned
Guid of the character who receives the mail.
subject longtext
The Subject of the mail.
body longtext
has_items tinyint(3) unsigned
Boolean value showing whether or not atems have been sent.
0 = no item included in the mail.
1 = items included in the mail.
expire_time bigint(40) unsigned
Current Unix Time + Unix Time till expiry.
Example:
current unix time + 86400 (seconds for one day) = expiry date
In this example the mail would expire after one day.
deliver_time bigint(40) unsigned
Current Unix Time + Unix Time till delivery.
Example:
current unix time + 86400 (seconds for one day) = delivery date
In this example the mail would be delivered after one day.
money bigint(40) unsigned
Amount of money sent.
If you want to send 100 gold 55 silver 33 copper then its 1005533
cod bigint(40) unsigned
Amount of money needed (COD).
checked tinyint(3) unsigned
checked_flag
| Hex Value | Value | Binary | ENUM Name |
|---|---|---|---|
| 0x00 | 0 | 0000 0000 | MAIL_CHECK_MASK_NONE |
| 0x01 | 1 | 0000 0001 | MAIL_CHECK_MASK_READ |
| 0x02 | 2 | 0000 0010 | MAIL_CHECK_MASK_RETURNED |
| 0x04 | 4 | 0000 0100 | MAIL_CHECK_MASK_COPIED |
| 0x08 | 8 | 0000 1000 | MAIL_CHECK_MASK_COD_PAYMENT |
| 0x10 | 16 | 0001 0000 | MAIL_CHECK_MASK_HAS_BODY |
Flag Mask:
| Value | ENUM Name |
|---|---|
| 4 | Mail has no body (subject only) [TODO: check this behaviour] |
| 16 | Mail was not read |
| 17 | Mail was read |
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now