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.
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 |
Unique ID.
Players required level to be able to recieve the mail.
Players required play time in milliseconds to recieve the mail.
Money in copper that is sent to Alliance player.
Money in copper that is sent to Horde player.
item_template.entry that is sent to Alliance player.
How many of the specified itemA is sent.
How many of the specified itemH is sent that is sent to Horde player.
The title/subject of the mail.
The body of the mail.
boolean