mail

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
id	int(10)	unsigned	PRI	NO	0		Identifier
messageType	tinyint(3)	unsigned		NO	0
stationery	tinyint(3)	signed		NO	41
mailTemplateId	mediumint(5)	unsigned		NO	0
sender	int(10)	unsigned		NO	0		Character Global Unique Identifier
receiver	int(10)	unsigned		NO	0		Character Global Unique Identifier
subject	longtext	signed		YES	NULL
body	longtext	signed		YES
has_items	tinyint(3)	unsigned		NO	0
expire_time	int(10)	unsigned		NO	0
deliver_time	int(10)	unsigned		NO	0
money	int(10)	unsigned		NO	0
cod	int(10)	unsigned		NO	0
checked	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:

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.

/td