Achievement dbc 548
Jump to navigation
Jump to search
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.