achievement_criteria_data
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 | int | signed | PRI | NO | |||
| type | tinyint | unsigned | PRI | NO | 0 | ||
| value1 | int | unsigned | NO | 0 | |||
| value2 | int | unsigned | NO | 0 | |||
| ScriptName | char(64) | NO | '' | ||||
Description of fields
criteria_id
This is the AchievementCriteria ID.
type
Depending on this value, it will determine how value1 and value2 are used.
Tabset
None (0)
ACHIEVEMENT_CRITERIA_DATA_TYPE_NONE
- value1:
0 - value2:
0
Target Creature (1)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_CREATURE
- value1: creature_template.entry
- value2:
0
Target Player Class+Race (2)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_CLASS_RACE
- value1: ChrClass ID
- value2: ChrRace ID
Target Player LessHealth (3)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_LESS_HEALTH
- value1: The percentage of health that the target must reach
- value2:
0
Target Player Dead (4)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_DEAD
- value1: own_team (0, 1)
- value2:
0
not corpse (not released body), own_team == false if enemy team expected
Source Aura (5)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_AURA
- value1: The Spell ID of the aura that must be on the player
- value2: Effect Index of the aura
Source Area (6)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_AREA
- value1: AreaTable ID
- value2:
0
Target Aura (7)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_AURA
- value1: The Spell ID of the aura that must be on the target
- value2: Effect Index of the aura
Value (8)
ACHIEVEMENT_CRITERIA_DATA_TYPE_VALUE
- value1: Value to compare needed to attain achievement
- value2:
enum ComparisonType|-|:-😐-|-| | 0 | == | COMP_TYPE_EQ | amount must be equal to value1 | | 1 | > | COMP_TYPE_HIGH | amount must be higher than value1 | | 2 | < | COMP_TYPE_LOW | amount must be lower than value1 | | 3 | >= | COMP_TYPE_HIGH_EQ | amount must be higher or equal to value1 | | 4 | <= | COMP_TYPE_LOW_EQ | amount must be lower or equal to value1 |
Target Level (9)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_LEVEL
- value1: The minimum level of the target.
- value2:
0
Target Gender (10)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_GENDER
- value1:
enum Gender|--|--| | GENDER_MALE | 0 | | GENDER_FEMALE | 1 | | GENDER_NONE | 2 | - value2:
0
Script (11)
ACHIEVEMENT_CRITERIA_DATA_TYPE_SCRIPT
- value1:
0 - value2:
0
ScriptName required
Map Difficulty (12)
ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_DIFFICULTY
- value1:
enum DifficultyRaid Dungeon Value RAID_DIFFICULTY_10MAN_NORMAL DUNGEON_DIFFICULTY_NORMAL 0 RAID_DIFFICULTY_25MAN_NORMAL DUNGEON_DIFFICULTY_HEROIC 1 RAID_DIFFICULTY_10MAN_HEROIC 2 RAID_DIFFICULTY_25MAN_HEROIC 3 - value2:
0
Map PlayerCount (13)
ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_PLAYER_COUNT
- value1: count
- value2:
0
"with less than %u people in the zone"
Target Team (14)
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_TEAM
- value1: The target must be on this team:
enum Team|--|--| | ALLIANCE | 469 | | HORDE | 67 | - value2:
0
Drunk (15)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_DRUNK
- value1: How drunk the player must be:
enum DrunkenState|--|--| | DRUNKEN_SOBER | 0 | | DRUNKEN_TIPSY | 1 | | DRUNKEN_DRUNK | 2 | | DRUNKEN_SMASHED | 3 | - value2:
0
Holiday (16)
ACHIEVEMENT_CRITERIA_DATA_TYPE_HOLIDAY
- value1: Holiday ID. Must be an active holiday
- value2:
0
event in holiday time
BGLoss Score (17)
ACHIEVEMENT_CRITERIA_DATA_TYPE_BG_LOSS_TEAM_SCORE
- value1: min. score
- value2: max. score
player's team win bg and opposition team have team score in range
InstanceScript (18)
ACHIEVEMENT_CRITERIA_DATA_TYPE_INSTANCE_SCRIPT
- value1:
0 - value2:
0
make instance script call for check current criteria requirements fit
Source EquippedItem (19)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_EQUIPPED_ITEM
- value1: item_template.ItemLevel
- value2: item_template.Quality
for equipped item in slot to check item level and quality
MapID (20)
ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_ID
- value1: Player must be on Map ID
- value2:
0
Source Player Class+Race (21)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_PLAYER_CLASS_RACE
- value1: ChrClass ID
- value2: ChrRace ID
Birthday (22)
ACHIEVEMENT_CRITERIA_DATA_TYPE_NTH_BIRTHDAY
- value1: N
- value2:
0
login on day of N-th Birthday
Source KnownTitle (23)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_KNOWN_TITLE
- value1: CharTitle ID
- value2:
0
known (pvp) title
GameEvent (24)
ACHIEVEMENT_CRITERIA_DATA_TYPE_GAME_EVENT
- value1: game_event.eventEntry
- value2:
0
Source ItemQuality (25)
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_ITEM_QUALITY
- value1: item_template.Quality
- value2: 0
dummy Tabset
ScriptName
The ScriptName for when scripting it in the core.