Achievement reward SF: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (5 intermediate revisions by 2 users 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 14: | Line 13: | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
|''' | |'''Attributes''' | ||
|'''Key''' | |||
|'''Null''' | |||
|'''Default''' | |'''Default''' | ||
|'''Comment''' | |'''Comment''' | ||
| Line 21: | Line 22: | ||
|mediumint(8) | |mediumint(8) | ||
|unsigned | |unsigned | ||
|PRI | |||
|NO | |||
|0 | |||
| | | | ||
|- | |- | ||
|[[#title_A|title_A]] | |[[#title_A|title_A]] | ||
| Line 28: | Line 31: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#title_H|title_H]] | |[[#title_H|title_H]] | ||
| Line 34: | Line 39: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#item|item]] | |[[#item|item]] | ||
| Line 40: | Line 47: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#sender|sender]] | |[[#sender|sender]] | ||
| Line 46: | Line 55: | ||
|unsigned | |unsigned | ||
| | | | ||
| | |NO | ||
|0 | |||
| | |||
|- | |- | ||
|[[#subject|subject]] | |[[#subject|subject]] | ||
| Line 52: | Line 63: | ||
|signed | |signed | ||
| | | | ||
| | |YES | ||
| | |||
| | |||
|- | |- | ||
|[[#text|text]] | |[[#text|text]] | ||
| Line 58: | Line 71: | ||
|signed | |signed | ||
| | | | ||
| | |YES | ||
| | |||
| | |||
|} | |} | ||
<br> <big>'''Description of the fields'''</big> | |||
===entry=== | |||
The ID# of the achievement. Found in [[Achievements.dbc SF|Achievements.dbc]]. | |||
===title_A=== | |||
The ID# of the title to award to Alliance players who gain the achievement. Found in [[CharTitles.dbc SF|CharTitles.dbc]]. | |||
===title_H=== | |||
The ID# of the title to award to Horde players who gain the achievement. Found in [[CharTitles.dbc SF|CharTitles.dbc]] | |||
===item=== | |||
The ID# of the item to be mailed to the player. Found in [[Item_template_SF|Item_template]]. | |||
===sender=== | |||
The ID# of the creature who sends the mail. Found in [[Creature_template_SF|Creature_template]]. | |||
===subject=== | |||
The subject of the mail to be sent. 225 character limit. | |||
===text=== | |||
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.