AzerothCore
Posts (Latest 10 updated) :
Read all

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

ID

mediumint(8)

unsigned

PRI

NO

0

 

TitleA

mediumint(8)

unsigned

 

NO

0

 

TitleH

mediumint(8)

unsigned

 

NO

0

 

ItemID

mediumint(8)

unsigned

 

NO

0

 

Sender

mediumint(8)

unsigned

 

NO

0

 

Subject

varchar(255)

signed

 

YES

NULL

 

Body

text

signed

 

YES

 

 

MailTemplateID mediumint(8) 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.