Achievement reward 548

From Project Skyfire
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.