mail_server_template
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.
Works alongside
- mail_server_template_items to attach items to the mail.
- mail_server_template_conditions to create conditions to recieve the mail.
Table Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| id | INT | UNSIGNED | PRI | NO | AUTO_INCREMENT | ||
| moneyA | INT | UNSIGNED | NO | 0 | |||
| moneyH | INT | UNSIGNED | NO | 0 | |||
| subject | TEXT | NO | |||||
| body | TEXT | NO | |||||
| active | TINYINT | UNSIGNED | NO | 1 |
Description of the fields
id
Unique ID.
moneyA
Money in copper that is sent to Alliance player.
moneyH
Money in copper 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.