Difference between revisions of "Achievement reward 548"

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