diff options
Diffstat (limited to 'docs/mail_server_template.md')
| -rw-r--r-- | docs/mail_server_template.md | 90 |
1 files changed, 90 insertions, 0 deletions
diff --git a/docs/mail_server_template.md b/docs/mail_server_template.md new file mode 100644 index 0000000..76114ff --- /dev/null +++ b/docs/mail_server_template.md @@ -0,0 +1,90 @@ +# mail_server_template + +[<-Back-to:Character](database-character.md) + +**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][1] | INT | UNSIGNED | PRI | NO | | AUTO_INCREMENT | | +| [reqLevel][2] | TINYINT | UNSIGNED | | NO | 0 | | | +| [reqPlayTime][3] | INT | UNSIGNED | | NO | 0 | | | +| [moneyA][4] | INT | UNSIGNED | | NO | 0 | | | +| [moneyH][5] | INT | UNSIGNED | | NO | 0 | | | +| [itemA][6] | INT | UNSIGNED | | NO | 0 | | | +| [itemCountA][7] | INT | UNSIGNED | | NO | 0 | | | +| [itemH][8] | INT | UNSIGNED | | NO | 0 | | | +| [itemCountH][9] | INT | UNSIGNED | | NO | 0 | | | +| [subject][10] | TEXT | | | NO | | | | +| [body][11] | TEXT | | | NO | | | | +| [active][12] | TINYINT | UNSIGNED | | NO | 1 | | | + +[1]: #id +[2]: #reqlevel +[3]: #reqplaytime +[4]: #moneya +[5]: #moneyh +[6]: #itema +[7]: #itemcounta +[8]: #itemh +[9]: #itemcounth +[10]: #subject +[11]: #body +[12]: #active + +## Description of the fields + +### 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](item_template#entry) that is sent to Alliance player. + +### itemCountA + +How many of the specified [itemA](#itema) is sent. + +### itemH + +[item_template.entry](item_template#entry). + +### itemCountH + +How many of the specified [itemH](#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. |
