Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • mail


    antz
     NOTE:  This page is auto-generated from the MAGNET DBDocs module,
                 Any changes made directly to this page will be lost when it is regenerated.

    Description of the 'mail' table for MaNGOSZero

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

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    id int(11) unsigned NO PRI '0'   Unique message id. Every new message gets a new auto incremented id.
    messageType tinyint(3) unsigned NO '0'   message_type.
    stationery tinyint(3) NO '41'   The StationeryID [See Stationery.dbc].
    mailTemplateId mediumint(8) unsigned NO '0'   The Mail Template Id [See MailTemplate.dbc]
    sender int(11) unsigned NO '0'   Guid of the character who sends the mail.
    receiver int(11) unsigned NO MUL '0'   Guid of the character who receives the mail.
    subject longtext YES NULL   The Subject of the mail.
    itemTextId int(11) unsigned NO '0'   The item_text ID of the massage within the mail.
    has_items tinyint(3) unsigned NO '0'   Boolean value showing whether or not atems have been sent.
    expire_time bigint(40) unsigned NO '0'   Current Unix Time + Unix Time till expiry.
    deliver_time bigint(40) unsigned NO '0'   Current Unix Time + Unix Time till delivery.
    money int(11) unsigned NO '0'   Amount of money sent.
    cod int(11) unsigned NO '0'   Amount of money needed (COD).
    checked tinyint(3) unsigned NO '0'   checked_flag.

    Description of the fields

    id int(11) unsigned

    Unique message id. Every new message gets a new auto incremented id.

    messageType tinyint(3) unsigned

    The type of the Message:

    Value Type
    0 NORMAL
    1 COD
    2 AUCTION

    stationery tinyint(3)

    The StationeryID [See Stationery.dbc].

    Value Type
    1 plain & purple scroll icon
    41 Normal Mail
    61 GM Mail
    62 Auction House
    64 Valentine's Day

    mailTemplateId mediumint(8) unsigned

    The Mail Template Id [See MailTemplate.dbc]

    sender int(11) unsigned

    Guid of the character who sends the mail.

    receiver int(11) unsigned

    Guid of the character who receives the mail.

    subject longtext

    The Subject of the mail.

    itemTextId int(11) unsigned

    The item_text ID of the massage within the mail.

    has_items tinyint(3) unsigned

    Boolean value showing whether or not atems have been sent.

    0 = no item included in the mail.
    1 = items included in the mail.

    expire_time bigint(40) unsigned

    Current Unix Time + Unix Time till expiry.
    Example:
    current unix time + 86400 (seconds for one day) = expiry date
    In this example the mail would expire after one day.

    deliver_time bigint(40) unsigned

    Current Unix Time + Unix Time till delivery.
    Example:
    current unix time + 86400 (seconds for one day) = delivery date
    In this example the mail would be delivered after one day.

    money int(11) unsigned

    Amount of money sent.
    If you want to send 100 gold 55 silver 33 copper then its 1005533

    cod int(11) unsigned

    Amount of money needed (COD).

    checked tinyint(3) unsigned

    checked_flag

    Hex Value Value Binary ENUM Name
    0x00 0 0000 0000 MAIL_CHECK_MASK_NONE
    0x01 1 0000 0001 MAIL_CHECK_MASK_READ
    0x02 2 0000 0010 MAIL_CHECK_MASK_RETURNED
    0x04 4 0000 0100 MAIL_CHECK_MASK_COPIED
    0x08 8 0000 1000 MAIL_CHECK_MASK_COD_PAYMENT
    0x10 16 0001 0000 MAIL_CHECK_MASK_HAS_BODY

    Flag Mask:
    Value ENUM Name
    4 Mail has no body (subject only) [TODO: check this behaviour]
    16 Mail was not read
    17 Mail was read



    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use