The `achievement_reward` table
This table describes the reward that you will receive when you obtain a given achievement.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
mediumint(8) | unsigned | PRI | NO | 0 |
|
| |
mediumint(8) | unsigned |
| NO | 0 |
|
| |
mediumint(8) | unsigned |
| NO | 0 |
|
| |
mediumint(8) | unsigned |
| NO | 0 |
|
| |
mediumint(8) | unsigned |
| NO | 0 |
|
| |
varchar(255) | signed |
| YES | NULL |
|
| |
text | signed |
| YES |
|
|
| |
| Achievement reward tc2 | mediumint(8) | unsigned | YES | 0 |
Description of the fields
entry
This is the ID of the achievement from Achievement.dbc
title_ A
This is the ID of the title for Aliance from CharTitles.dbc if the achievement rewards a title.
title_H
This is the ID of the title for Horde from CharTitles.dbc if the achievement rewards a title.
item
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.
text
This is the text of the body of that mail that you receive.
mailTemplate
This is Id of MailTemplate from MailTemplate.dbc of that mail that you receive. Subject and Text must be empty. They are read from dbc file.