achievement_criteria_data
The `achievement_criteria_data` table
This table contains the data that a player needs to obtain / complete in order to receive a given achievement.
Structure
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
mediumint(8) | signed | PRI | NO | NULL |
|
| |
tinyint(3) | unsigned | PRI | NO | 0 |
|
| |
medium(8) | unsigned |
| NO | 0 |
|
| |
medium(8) | unsigned |
| NO | 0 |
|
| |
char(64) | signed |
| NO |
|
|
|
Description of the fields
criteria_id
This is the ID from Achievement_Criteria.dbc.
type
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 |
value1
*TYPE_T_CREATURE
The target here must be a valid entry from creature_template
*TYPE_T_PLAYER_CLASS_RACE
The target here is a valid class (paste class list). value2 must also be set
*TYPE_T_PLAYER_LESS_HEALTH
The percentage of health that the target must reach.
*TYPE_T_PLAYER_DEAD
The faction of the target player (must match player attempting achievement).
*TYPE_S_AURA
The spell ID of the aura that must be on the player. value2 must also be set.
*TYPE_S_AREA
Area ID from AreaTable.dbc
*TYPE_T_AURA
The spell ID of the aura that must be on the target. value2 must also be set.
*TYPE_VALUE
Value to compare needed to attain achievement. This value is used in conjunction with another type. (see value2 for comparisation type)
*TYPE_T_LEVEL
The minimum level that the target can be.
*TYPE_T_GENDER
Gender: 0=Male, 1=Female
*TYPE_SCRIPT
Used to disable an achievement if all requirements are not defined. Would usually be used if not all are known.
*TYPE_MAP_DIFFICULTY
Map difficulty: (for dungeons)
Normal = 0
Heroic = 1
Map difficulty: (for raids)
10 Man Normal = 0
25 Man Normal = 1
10 Man Heroic = 2
25 Man Heroic = 3
*TYPE_MAP_PLAYER_COUNT
The number of other players that must be in the zone. (not sure if it is minimum or maximum).
*TYPE_T_TEAM
The target must be on this team: Alliance = 469, Horde = 67
*TYPE_S_DRUNK
How drunk the player must be:
DRUNKEN_SOBER = 0
DRUNKEN_TIPSY = 1
DRUNKEN_DRUNK = 2
DRUNKEN_SMASHED = 3
*TYPE_HOLIDAY
Holiday ID from Holiday.dbc and game_event. Must be an active holiday.
*TYPE_BG_LOSS_TEAM_SCORE
Player's team win bg and opposition team have team score in range. // Min. score
*TYPE_INSTANCE_SCRIPT
Make instance script call for check current criteria requirements fit.
*TYPE_S_EQUIPED_ITEM
*TYPE_MAP_ID
Player must be on mapId
*TYPE_S_PLAYER_CLASS_RACE
The Source here is a valid class (paste class list). value2 must also be set
*TYPE_NTH_BIRTHDAY
Number of Birthday
*TYPE_S_KNOWN_TITLE
The value here is a valid titleId. See CharTitles.dbc
value2
*TYPE_T_PLAYER_CLASS_RACE
*TYPE_S_PLAYER_CLASS_RACE
The value here is a valid race ID. See ChrRaces.dbc
*TYPE_S_AURA
Effect Index of the aura
*TYPE_T_AURA
Effect Index of the aura
*TYPE_BG_LOSS_TEAM_SCORE
Max. score
*TYPE_S_EQUIPED_ITEM
*TYPE_VALUE
ComparisationType:
ScriptName
The ScriptName for when scripting it in the core.
This might also be 'SmartTrigger'. It will than use SmartAI.