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

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

22TYPE_NTH_BIRTHDAY
23TYPE_S_KNOWN_TITLE

value1

*TYPE_T_CREATURE

*TYPE_T_PLAYER_CLASS_RACE

*TYPE_T_PLAYER_LESS_HEALTH

*TYPE_T_PLAYER_DEAD

*TYPE_S_AURA

*TYPE_S_AREA

*TYPE_T_AURA

*TYPE_VALUE

*TYPE_T_LEVEL

*TYPE_T_GENDER

*TYPE_SCRIPT

*TYPE_MAP_DIFFICULTY

*TYPE_MAP_PLAYER_COUNT

*TYPE_T_TEAM

*TYPE_S_DRUNK

*TYPE_HOLIDAY

*TYPE_BG_LOSS_TEAM_SCORE

*TYPE_INSTANCE_SCRIPT

*TYPE_S_EQUIPED_ITEM

*TYPE_MAP_ID

*TYPE_S_PLAYER_CLASS_RACE

 

*TYPE_NTH_BIRTHDAY

*TYPE_S_KNOWN_TITLE

 

 

value2

*TYPE_T_PLAYER_CLASS_RACE
*TYPE_S_PLAYER_CLASS_RACE

*TYPE_S_AURA

*TYPE_T_AURA

*TYPE_BG_LOSS_TEAM_SCORE

*TYPE_S_EQUIPED_ITEM

*TYPE_VALUE

ScriptName

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