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.
¶ 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.
type: 24ACHIEVEMENT_CRITERIA_DATA_TYPE_NONE
- value1:
0 - value2:
0
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_CREATURE
- value1:
creature_template.entry - value2:
0
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_CLASS_RACE
- value1:
ChrClass ID - value2:
ChrRace ID
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_LESS_HEALTH
- value1:
The percentage of health that the target must reach - value2:
0
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
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
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_AREA
- value1:
AreaTable ID - value2:
0
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
ACHIEVEMENT_CRITERIA_DATA_TYPE_VALUE
- value1:
Value to compare needed to attain achievement - value2:
enum ComparisonType0 == 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
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_LEVEL
- value1:
The minimum level of the target. - value2:
0
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_GENDER
- value1:
enum GenderGENDER_MALE 0 GENDER_FEMALE 1 GENDER_NONE 2 - value2:
0
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
ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_PLAYER_COUNT
- value1:
count - value2:
0
"with less than %u people in the zone"
ACHIEVEMENT_CRITERIA_DATA_TYPE_T_TEAM
- value1:
The target must be on this team:
enum TeamALLIANCE 469 HORDE 67 - value2:
0
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_DRUNK
- value1:
How drunk the player must be:
enum DrunkenStateDRUNKEN_SOBER 0 DRUNKEN_TIPSY 1 DRUNKEN_DRUNK 2 DRUNKEN_SMASHED 3 - value2:
0
ACHIEVEMENT_CRITERIA_DATA_TYPE_HOLIDAY
- value1:
Holiday ID. Must be an active holiday - value2:
0
event in holiday time
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
ACHIEVEMENT_CRITERIA_DATA_TYPE_INSTANCE_SCRIPT
- value1:
0 - value2:
0
make instance script call for check current criteria requirements fit
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
ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_ID
- value1:
Player must be on Map ID - value2:
0
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_PLAYER_CLASS_RACE
- value1:
ChrClass ID - value2:
ChrRace ID
ACHIEVEMENT_CRITERIA_DATA_TYPE_NTH_BIRTHDAY
- value1:
N - value2:
0
login on day of N-th Birthday
ACHIEVEMENT_CRITERIA_DATA_TYPE_GAME_EVENT
- value1:
- - value2:
-
7.x only
ACHIEVEMENT_CRITERIA_DATA_TYPE_S_ITEM_QUALITY
- value1:
item_template.Quality - value2:
0
¶ ScriptName
The ScriptName for when scripting it in the core.
Back to 'access_requirement' Return to world Go to 'achievement_dbc'