AzerothCore
Posts (Latest 10 updated) :
Read all

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

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. Max length is 8000 characters.

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

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

/td