achievement_criteria_data

<-Back-to:World

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

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.

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

ScriptName

The ScriptName for when scripting it in the core. This might also be 'SmartTrigger'. It will than use SmartAI.