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 from Achievement.dbc

TitleA

This is the ID of the title for Aliance 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 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.

Body

This is the text of the body of that mail that you receive.

MailTemplateID

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.