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'