Achievement dbc 548

Back to world database list of tables.

The `achievement_reward` table

Stores achievement data that is missing in Achievement.dbc

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int(10)	unsigned	PRI	NO	0
title_A	int(11)	signed		NO	-1
mapID	int(11)	signed		NO	-1
points	int(10)	unsigned		NO	0		Achievement points awarded for completing the achievement, has no use serverside.
flags	int(10)	unsigned		NO	0
count	int(10)	unsigned		NO	0
refAchievement	int(10)	unsigned		NO	0

DB Structure

CREATE TABLE `achievement_dbc` (
	`ID` INT NOT NULL,
	`requiredFaction` INT NOT NULL DEFAULT -1,
	`mapID` INT NOT NULL DEFAULT -1,
	`points` INT NOT NULL DEFAULT '0',
	`flags` INT NOT NULL DEFAULT '0',
	`count` INT NOT NULL DEFAULT '0',
	`refAchievement` INT NOT NULL DEFAULT '0',
	PRIMARY KEY (`ID`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;

Description of the fields

ID

This is the ID of the achievement from Achievement_Criteria.dbc (2nd column)

requiredFaction

Condition:

       Both: -1,
       Horde: 0,
       Alliance: 1

mapID

Condition: Player must be on that map to be allowed criteria updates (-1 if not set)

points

Achievement points awarded for completing the achievement, has no use serverside.

flags

Name	Value	Content
ACHIEVEMENT_FLAG_AVERAGE	0x00000040	Show as average value (value / time_in_days) depend from other flag (by def use last criteria value)
ACHIEVEMENT_FLAG_BAR	0x00000080	Show as progress bar (value / max vale) depend from other flag (by def use last criteria value)
ACHIEVEMENT_FLAG_COUNTER	0x00000001	Just count statistic (never stop and complete)
ACHIEVEMENT_FLAG_HIDDEN	0x00000002	Not sent to client - internal use only
ACHIEVEMENT_FLAG_MAX_USED	0x00000010	Show max criteria (and calculate max value ??)
ACHIEVEMENT_FLAG_REALM_FIRST_KILL	0x00000200
ACHIEVEMENT_FLAG_REALM_FIRST_REACH	0x00000100
ACHIEVEMENT_FLAG_REQ_COUNT	0x00000020	Use not zero req count (and calculate max value)
ACHIEVEMENT_FLAG_STORE_MAX_VALUE	0x00000004	Store only max value? used only in "Reach level xx"
ACHIEVEMENT_FLAG_SUMM	0x00000008	Use summ criteria value from all reqirements (and calculate max value)

count

Should always be 1.

refAchievement

Should always be 0.