achievement_reward
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
ID
This is the ID of the achievement taken from the DBC Achievement.dbc
.
TitleA
This is the ID of the title for Alliance from CharTitles.dbc
if the achievement rewards a title.
TitleH
This is the ID of the title for Horde from CharTitles.dbc
if the achievement rewards a title.
ItemID
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.
Sender
This is the sender of the mail that the player will receive.
Subject
This is the subject of the mail that the player will receive.
Body
This is the body (text) of the mail that the player will receive.
MailTemplateID
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.
Example
ID | TitleA | TitleH | ItemID | Sender | Subject |
---|---|---|---|---|---|
13 | 0 | 0 | 41426 | 16128 | Level 80 |
45 | 0 | 0 | 43348 | 28070 | You've Been Around! |