====== mail_server_template 表 ======
----
[[数据库:characters数据库:首页|<-返回:Characters 数据库]]

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|id]]|INT|UNSIGNED|PRI|NO| |AUTO_INCREMENT| |
|[[#reqLevel|reqLevel]]|TINYINT|UNSIGNED| |NO|0| | |
|[[#reqPlayTime|reqPlayTime]]|INT|UNSIGNED| |NO|0| | |
|[[#moneyA|moneyA]]|INT|UNSIGNED| |NO|0| | |
|[[#moneyH|moneyH]]|INT|UNSIGNED| |NO|0| | |
|[[#itemA|itemA]]|INT|UNSIGNED| |NO|0| | |
|[[#itemCountA|itemCountA]]|INT|UNSIGNED| |NO|0| | |
|[[#itemH|itemH]]|INT|UNSIGNED| |NO|0| | |
|[[#itemCountH|itemCountH]]|INT|UNSIGNED| |NO|0| | |
|[[#subject|subject]]|TEXT| | |NO| | | |
|[[#body|body]]|TEXT| | |NO| | | |
|[[#active|active]]|TINYINT|UNSIGNED| |NO|1| | |



===== 字段说明 =====
----
==== 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.