Achievement reward 548: Difference between revisions
Jump to navigation
Jump to search
(Add content) |
(Update structure and add DB structure.) |
||
Line 75: | Line 75: | ||
| | | | ||
|} | |} | ||
<br> <big>'''DB Structure'''</big> | |||
<br> | |||
{| border="1"<br> | |||
<pre style="color: red"> | |||
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 | |||
; | |||
</pre> | |||
<br> <big>'''Description of the fields'''</big> | <br> <big>'''Description of the fields'''</big> | ||
Latest revision as of 18:10, 8 August 2021
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.