AzerothCore
Pages :
Add new Edit Delete History Source

mail_server_template

<-Back-to:Character

The `mail_server_template` table

This table contains information for server mail to be sent to players that meet the requirement. Mails are sent OnLogin.

Table Structure

Field Type Attributes Key Null Default Extra Comment
id INT UNSIGNED PRI NO AUTO_INCREMENT
reqLevel TINYINT UNSIGNED NO 0
reqPlayTime INT UNSIGNED NO 0
moneyA INT UNSIGNED NO 0
moneyH INT UNSIGNED NO 0
itemA INT UNSIGNED NO 0
itemCountA INT UNSIGNED NO 0
itemH INT UNSIGNED NO 0
itemCountH INT UNSIGNED NO 0
subject TEXT NO
body TEXT NO
active TINYINT UNSIGNED NO 1

Description of the fields

id

Unique ID.

reqLevel

Players required level to be able to recieve the mail.

reqPlayTime

Players required play time in milliseconds to recieve the mail.

moneyA

Money in copper that is sent to Alliance player.

moneyH

Money in copper that is sent to Horde player.

itemA

item_template.entry that is sent to Alliance player.

itemCountA

How many of the specified itemA is sent.

itemH

item_template.entry.

itemCountH

How many of the specified itemH is sent that is sent to Horde player.

subject

The title/subject of the mail.

body

The body of the mail.

active

boolean

  • 1 = Mail is active and will be sent to the players if they meet the requirement.
  • 0 = Disabled.