mailbox

This table contains the mails for the characters.

Structure

Field Type Default Comment
message_id int(30) 0  
message_type int(30) 0  
player_guid int(30) 0  
sender_guid bigint(30) 0  
subject varchar(255) Empty String  
body longtext    
money int(30) 0  
attached_item_guids varchar(200) Empty String  
cod int(30) 0  
stationary int(30) 0  
expiry_time int(30) 0  
delivery_time int(30) 0  
checked_flag int(30) 0  
deleted_flag int(30) 0  

message_id

The unique ID of the message/mail.

message_type

0 = Normal     (sender is a character)
1 = COD        (sender will recieve money before the mail will be delivered)
2 = Auction    (sender is the auctionshouse)
3 = Creature   (sender is a NPC)
4 = Gameobject 
5 = Item       (mail includes items)

player_guid

The character guid of the reviever from characters table.

sender_guid

The character guid of the sender from characters table.

subject

The subject of the mail.

body

The text of this mail.

money

The attached money in copper.

attached_item_guids

The item entry IDs from playeritems table. You can attach up to 12 items. Form stack itemguid, stack2 itemguid2, …

cod

Amount of money (in copper) needed to recieve this message.

stationary

0  = Standard
<strike>1  = Test 1
41 = Test 2</strike>
61 = Gamemaster
62 = Auction
64 = Valentines day
65 = Chrismas

expiry_time

The time in seconds when the mail would be expired (for example unix time now + seconds to expire = expiry time).

delivery_time

The time in seconds for the delivery (for example unix time now + seconds to delivery = deliver time).

checked_flag

0  = None
1  = Readed      (this mail is already readed)
2  = Returned    (this mail was already returned)
4  = Copied      (this mail is just a copy of the text, not of the items!)
8  = COD Payment (this mail cost to revieve it)
16 = Has body    (this mail has text)

deleted_flag

1 = Mail is deleted
0 = Mail is not deleted (default)