Tabelle: 'mail'

The `mail` table

This table contains main data about all mails in the game.

Structure

Description of the fields

id

This field contains unique ID of any messages.

Don't have autoincrement !!!

messageType

• 0 = Normal
• 1 doesn't exist
• 2 = Auction
• 3 = Creature
• 4 = Gameobject
• 5 = Item

stationery

This field can contain these values:

• 1 = Test
• 41 = Normal mail layout,

• 61 = GM (Blizzard)
• 62 = Auction
• 64 = VAL (???)
• 65 = CHR (???)

mailTemplateId

Id from MailTemplate.dbc

sender

In this field is entered sender character.guid.

receiver

Here is receiver's character.guid.

subject

Here is stored mail subject.

body

The text contained in the mail.

has_items

Default: 0,

When is set to 1, that mail can contain items.

For items look at mail_items table.

expire_time

Here is timestamp which stores date for auto-return mail to sender.

deliver_time

Here is timestamp which stores date of send mail.

money

The ammout of money in mail, or money to pay when is COD.

cod

Default: 0 - No COD,

when is set to 1, that field `money` stores gold for COD.

checked