Back to 'access_requirement' Return to world Go to 'achievement_dbc'
This table contains the data that a player needs to obtain / complete in order to receive a given achievement.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| criteria_id | mediumint | signed | PRI | NO | |||
| type | tinyint | unsigned | PRI | NO | 0 | ||
| value1 | mediumint | unsigned | NO | 0 | |||
| value2 | mediumint | unsigned | NO | 0 | |||
| ScriptName | char(64) | NO | '' |
This is the ID from Achievement_Criteria.dbc
Depending on this value, it will determine how value1 and value2 are used.
| Type | Name |
|---|---|
| 0 | TYPE_NONE |
| 1 | TYPE_T_CREATURE |
| 2 | TYPE_T_PLAYER_CLASS_RACE |
| 3 | TYPE_T_PLAYER_LESS_HEALTH |
| 4 | TYPE_T_PLAYER_DEAD |
| 5 | TYPE_S_AURA |
| 6 | TYPE_S_AREA |
| 7 | TYPE_T_AURA |
| 8 | TYPE_VALUE |
| 9 | TYPE_T_LEVEL |
| 10 | TYPE_T_GENDER |
| 11 | TYPE_SCRIPT |
| 12 | TYPE_MAP_DIFFICULTY |
| 13 | TYPE_MAP_PLAYER_COUNT |
| 14 | TYPE_T_TEAM |
| 15 | TYPE_S_DRUNK |
| 16 | TYPE_HOLIDAY |
| 17 | TYPE_BG_LOSS_TEAM_SCORE |
| 18 | TYPE_INSTANCE_SCRIPT |
| 19 | TYPE_S_EQUIPED_ITEM |
| 20 | TYPE_MAP_ID |
| 21 | TYPE_S_PLAYER_CLASS_RACE |
| 22 | TYPE_NTH_BIRTHDAY |
| 23 | TYPE_S_KNOWN_TITLE |
| 24 | TYPE_GAME_EVENT (7.x only) |
| 25 | TYPE_S_ITEM_QUALITY |
| Type | Value1 | Value 2 | Comment |
|---|---|---|---|
| TYPE_NONE | 0 | 0 | |
| TYPE_T_CREATURE | creature entry from creature_template | 0 | |
| TYPE_T_PLAYER_CLASS_RACE | class ID from ChrClasses.dbc | race ID from ChrRaces.dbc | |
| TYPE_T_PLAYER_LESS_HEALTH | The percentage of health that the target must reach | 0 | |
| TYPE_T_PLAYER_DEAD | own_team | 0 | not corpse (not released body), own_team == false if enemy team expected |
| TYPE_S_AURA | The spell ID of the aura that must be on the player (see Spell.dbc) | Effect Index of the aura | |
| TYPE_S_AREA | Area ID from AreaTable.dbc | 0 | |
| TYPE_T_AURA | The spell ID of the aura that must be on the target | Effect Index of the aura | |
| TYPE_VALUE | Value to compare needed to attain achievement | ComparisationType: COMP_TYPE_EQ = 0 COMP_TYPE_HIGH = 1 COMP_TYPE_LOW = 2 COMP_TYPE_HIGH_EQ = 3 COMP_TYPE_LOW_EQ = 4 |
value provided with achievement update must be not less that limit |
| TYPE_T_LEVEL | The minimum level of the target. | 0 | |
| TYPE_T_GENDER | 0=male; 1=female | 0 | |
| TYPE_SCRIPT | 0 | 0 | ScriptName required |
| TYPE_MAP_DIFFICULTY | Dungeon: 0=Normal 1=Heroic Raid: 0=10 Man Normal 1=25 Man Normal 2=10 Man Heroic 3=25 Man Heroic |
0 | |
| TYPE_MAP_PLAYER_COUNT | count | 0 | "with less than %u people in the zone" |
| TYPE_T_TEAM | The target must be on this team: Alliance = 469, Horde = 67 | 0 | |
| TYPE_S_DRUNK | How drunk the player must be: DRUNKEN_SOBER = 0 DRUNKEN_TIPSY = 1 DRUNKEN_DRUNK = 2 DRUNKEN_SMASHED = 3 |
0 | (enum DrunkenState) of player |
| TYPE_HOLIDAY | Holiday ID from Holiday.dbc and game_event. Must be an active holiday | 0 | event in holiday time |
| TYPE_BG_LOSS_TEAM_SCORE | min. score | max. score | player's team win bg and opposition team have team score in range |
| TYPE_INSTANCE_SCRIPT | 0 | 0 | make instance script call for check current criteria requirements fit |
| TYPE_S_EQUIPPED_ITEM | Item level | Item quality | for equipped item in slot to check item level and quality |
| TYPE_MAP_ID | Player must be on mapId (see Map.dbc) | 0 | |
| TYPE_S_PLAYER_CLASS_RACE | class ID from ChrClasses.dbc | race ID from ChrRaces.dbc | |
| TYPE_NTH_BIRTHDAY | N | 0 | login on day of N-th Birthday |
| TYPE_S_KNOWN_TITLE | Title ID from CharTitles.dbc | 0 | known (pvp) title |
| TYPE_GAME_EVENT | - | - | 7.x only |
| TYPE_S_ITEM_QUALITY | Item quality | 0 |
The ScriptName for when scripting it in the core.
This might also be 'SmartTrigger'. It will than use SmartAI.
Back to 'access_requirement' Return to world Go to 'achievement_dbc'