Achievement reward SF: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 3: | Line 3: | ||
|} | |} | ||
{{Back-to:World}} | {{Back-to:World}} | ||
<big>'''The `achievement_reward` table'''</big> | <big>'''The `achievement_reward` table'''</big> | ||
Line 106: | Line 105: | ||
The text contained in the mail to be sent. | The text contained in the mail to be sent. | ||
[[DB:World|Return to world database structure]] |
Latest revision as of 01:09, 9 January 2013
Back to world database list of tables.
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.