Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field

Type

Attributes

Key

Null

Default

Extra

Comment

Mail tc2id

int(10)

unsigned

PRI

NO

0

 

Identifier

Mail tc2messageType

tinyint(3)

unsigned

 

NO

0

 

 

Mail tc2stationery

tinyint(3)

signed

 

NO

41

 

 

mailTemplateId

mediumint(5)

unsigned

 

NO

0

 

 

Mail tc2sender

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

Mail tc2receiver

int(10)

unsigned

 

NO

0

 

Character Global Unique Identifier

Mail tc2subject

longtext

signed

 

YES

NULL

 

 

Mail tc2body

longtext

signed

 

YES

   

Mail tc2has_items

tinyint(3)

unsigned

 

NO

0

  

Mail tc2expire_time

int(10)

unsigned

 

NO

0

  

Mail tc2deliver_time

int(10)

unsigned

 

NO

0

  

Mail tc2money

int(10)

unsigned

 

NO

0

  

Mail tc2cod

int(10)

unsigned

 

NO

0

  

Mail tc2checked

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:

...

  • 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

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