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 |
---|---|---|---|---|---|---|---|
criteria_id | MEDIUMINT | PRI | NO | ||||
type | TINYINT | UNSIGNED | PRI | NO | 0 | ||
value1 | MEDIUMINT | UNSIGNED | NO | 0 | |||
value2 | MEDIUMINT | UNSIGNED | NO | 0 | |||
ScriptName | char(64) | 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 * Item level 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 * Item quality TYPE_VALUE ^ ComparisationType | | COMP_TYPE_EQ = 0 | | COMP_TYPE_HIGH = 1 | | COMP_TYPE_LOW = 2 | | COMP_TYPE_HIGH_EQ = 3 | | COMP_TYPE_LOW_EQ = 4 | ==== ScriptName ==== The ScriptName for when scripting it in the core. This might also be 'SmartTrigger'. It will than use SmartAI.