achievement_criteria_data

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

Field

Type

Attributes

Key

Null

Default

Extra

Comment

criteria_id

mediumint(8)

signed

PRI

NO

NULL

 

 

type

tinyint(3)

unsigned

PRI

NO

0

 

 

value1

medium(8)

unsigned

 

NO

0

 

 

value2

medium(8)

unsigned

 

NO

0

 

 

ScriptName

char(64)

signed

 

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

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

*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

*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

*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

*TYPE_MAP_ID

  •  

*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

 

 

value2

*TYPE_T_PLAYER_CLASS_RACE
*TYPE_S_PLAYER_CLASS_RACE

*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

*TYPE_VALUE

  • ComparisationType:

ScriptName

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