Achievement reward SF: Difference between revisions
Jump to navigation
Jump to search
Cheapgamer (talk | contribs) No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| 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.