mail_server_template 表

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
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.