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.

ACHIEVEMENT_CRITERIA_DATA_TYPE_NONE (0)

• value1:
  0
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_CREATURE (1)

• value1:
  creature_template.entry
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_CLASS_RACE (2)

• value1:
  ChrClass ID
• value2:
  ChrRace ID

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_LESS_HEALTH (3)

• value1:
  The percentage of health that the target must reach
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_PLAYER_DEAD (4)

• 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 (5)

• 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 (6)

• value1:
  AreaTable ID
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_AURA (7)

• value1:
  The Spell ID of the aura that must be on the target
• value2:
  Effect Index of the aura

ACHIEVEMENT_CRITERIA_DATA_TYPE_VALUE (8)

• value1:
  Value to compare needed to attain achievement
• value2:
  enum ComparisonType

  ID	Form	Name	Comment
  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

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_LEVEL (9)

• value1:
  The minimum level of the target.
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_GENDER (10)

• value1:
  enum Gender

  ID	Name
  0	GENDER_MALE
  1	GENDER_FEMALE
  2	GENDER_NONE

• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_SCRIPT (11)

• value1:
  0
• value2:
  0

ScriptName required

ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_DIFFICULTY (12)

• value1:
  enum Difficulty

  Value	Name
  0	RAID_DIFFICULTY_10MAN_NORMAL / DUNGEON_DIFFICULTY_NORMAL / REGULAR_DIFFICULTY
  1	RAID_DIFFICULTY_25MAN_NORMAL / DUNGEON_DIFFICULTY_HEROIC
  2	RAID_DIFFICULTY_10MAN_HEROIC
  3	RAID_DIFFICULTY_25MAN_HEROIC

• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_MAP_PLAYER_COUNT (13)

• value1:
  count
• value2:
  0

"with less than %u people in the zone"

ACHIEVEMENT_CRITERIA_DATA_TYPE_T_TEAM (14)

• value1:
  The target must be on this team:
  enum Team (a Faction ID)

  ID	Name
  67	HORDE
  469	ALLIANCE

• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_S_DRUNK (15)

• value1:
  How drunk the player must be:
  enum DrunkenState

  ID	Name
  0	DRUNKEN_SOBER
  1	DRUNKEN_TIPSY
  2	DRUNKEN_DRUNK
  3	DRUNKEN_SMASHED

• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_HOLIDAY (16)

• value1:
  Holiday ID. Must be an active holiday
• value2:
  0

event in holiday time

ACHIEVEMENT_CRITERIA_DATA_TYPE_BG_LOSS_TEAM_SCORE (17)

• 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 (18)

• value1:
  0
• value2:
  0

make instance script call for check current criteria requirements fit

ACHIEVEMENT_CRITERIA_DATA_TYPE_S_EQUIPPED_ITEM (19)

• 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 (20)

• value1:
  Player must be on Map ID
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_S_PLAYER_CLASS_RACE (21)

• value1:
  ChrClass ID
• value2:
  ChrRace ID

ACHIEVEMENT_CRITERIA_DATA_TYPE_NTH_BIRTHDAY (22)

• value1:
  N
• value2:
  0

login on day of N-th Birthday

ACHIEVEMENT_CRITERIA_DATA_TYPE_S_KNOWN_TITLE (23)

• value1:
  CharTitle ID
• value2:
  0

known (pvp) title

ACHIEVEMENT_CRITERIA_DATA_TYPE_GAME_EVENT (24)

• value1:
  game_event.eventEntry
• value2:
  0

ACHIEVEMENT_CRITERIA_DATA_TYPE_S_ITEM_QUALITY (25)

• value1:
  item_template.Quality
• value2:
  0

 

ScriptName

The ScriptName for when scripting it in the core.