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 |
---|---|---|---|---|---|---|---|
ID | MEDIUMINT | UNSIGNED | PRI | NO | 0 | ||
TitleA | MEDIUMINT | UNSIGNED | NO | 0 | |||
TitleH | MEDIUMINT | UNSIGNED | NO | 0 | |||
ItemID | MEDIUMINT | UNSIGNED | NO | 0 | |||
Sender | MEDIUMINT | UNSIGNED | NO | 0 | |||
Subject | VARCHAR(255) | YES | |||||
Body | text | YES | |||||
MailTemplateID | MEDIUMINT | UNSIGNED | YES | 0 |
Description of the fields
This is the ID of the achievement taken from the DBC Achievement.dbc
.
This is the ID of the title for Alliance from CharTitles.dbc
if the achievement rewards a title.
This is the ID of the title for Horde from CharTitles.dbc
if the achievement rewards a title.
This is the item that that the player will receive if the achievement rewards an item. The player will get this item in a mail.
This is the sender of the mail that the player will receive.
This is the subject of the mail that the player will receive.
This is the body (text) of the mail that the player will receive.
Id of the MailTemplate from MailTemplate.dbc
of that mail that the player will receive. To use this column, Subject
and Body
must be empty as they are loaded from the DBC file.
ID | TitleA | TitleH | ItemID | Sender | Subject |
---|---|---|---|---|---|
13 | 0 | 0 | 41426 | 16128 | Level 80 |
45 | 0 | 0 | 43348 | 28070 | You've Been Around! |