achievement_reward

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int	unsigned	PRI	NO	0
TitleA	int	unsigned		NO	0
TitleH	int	unsigned		NO	0
ItemID	int	unsigned		NO	0
Sender	int	unsigned		NO	0
Subject	varchar(255)			YES	NULL
Body	mediumtext			YES	NULL
MailTemplateID	int	unsigned		YES	0

Description of fields

ID

ID from Achievement.db2.  

TitleA

This is the ID of the title for Aliance from CharTitles.db2 if the achievement rewards a title.  

TitleH

This is the ID of the title for Horde from CharTitles.db2 if the achievement rewards a title.  

ItemID

This is the item that you get if the achievement rewards an item. You will get this item in the mail.  

Sender

This is the sender of the mail that you receive.  

Subject

This is the subject of the mail that you receive.  

Body

This is the text of the body of that mail that you receive.  

MailTemplateID

This is Id of MailTemplate from MailTemplate.db2 of that mail that you receive. Subject and Text must be empty. They are read from db2 file.