AzerothCore
Pages :

achievement_reward

<-Back-to:World

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!