Difference between revisions of "Achievement reward SF"

From Project Skyfire
Jump to navigation Jump to search
Line 3: Line 3:
 
|}
 
|}
 
{{Back-to:World}}
 
{{Back-to:World}}
[[Category: SkyFire World database tables]]
+
[[DB:World|Return to world database structure]]
  
 
<big>'''The `achievement_reward` table'''</big>
 
<big>'''The `achievement_reward` table'''</big>

Revision as of 06:09, 9 January 2013

Back to world database list of tables. Return to world database structure

The `achievement_reward` table

This table holds the information for awarding items to players via in-game mail when the earn certain achievements.


Structure

Field Type Attributes Key Null Default Comment
entry mediumint(8) unsigned PRI NO 0
title_A mediumint(8) unsigned NO 0
title_H mediumint(8) unsigned NO 0
item mediumint(8) unsigned NO 0
sender mediumint(8) unsigned NO 0
subject varchar(225) signed YES
text text signed YES


Description of the fields

entry

The ID# of the achievement. Found in Achievements.dbc.

title_A

The ID# of the title to award to Alliance players who gain the achievement. Found in CharTitles.dbc.

title_H

The ID# of the title to award to Horde players who gain the achievement. Found in CharTitles.dbc

item

The ID# of the item to be mailed to the player. Found in Item_template.

sender

The ID# of the creature who sends the mail. Found in Creature_template.

subject

The subject of the mail to be sent. 225 character limit.

text

The text contained in the mail to be sent.