This table contains information for server mail to be sent to players that meet the requirement. Mails are sent OnLogin.
表结构
| 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.
item_template.entry.
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
1 = Mail is active and will be sent to the players if they meet the requirement. 0 = Disabled.