Achievement reward 548
Jump to navigation
Jump to search
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 |
DB Structure
CREATE TABLE `achievement_reward` ( `entry` MEDIUMINT NOT NULL DEFAULT '0', `title_A` MEDIUMINT NOT NULL DEFAULT '0', `title_H` MEDIUMINT NOT NULL DEFAULT '0', `item` MEDIUMINT NOT NULL DEFAULT '0', `sender` MEDIUMINT NOT NULL DEFAULT '0', `subject` VARCHAR(255) NULL COLLATE 'utf8_general_ci', `text` TEXT NULL COLLATE 'utf8_general_ci', PRIMARY KEY (`entry`) USING BTREE ) COMMENT='Loot System' COLLATE='utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=FIXED ;
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.