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
Table
count
Should always be 1.
refAchievement
Should always be 0.