Admin: Update structure and add DB structure.

2021-08-08T23:06:41Z

Update structure and add DB structure.

@@ Line 66: / Line 66: @@
+|
 |}
+<br> <big>'''DB Structure'''</big>
 <big>'''Description of the fields'''</big>

Admin: Add content

2021-08-08T23:01:14Z

Add content

New page

{| align="right"
| __TOC__
|}
{{Back-to:World_18414}}

<big>'''The `achievement_criteria_data` table'''</big>

This table contains the data that a player needs to obtain / complete in order to receive a given achievement.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#criteria_id|criteria_id]]
|mediumint(8)
|signed
|PRI
|NO
|NULL
|
|
|-
|[[#type|type]]
|tinyint(3)
|unsigned
|PRI
|NO
|0
|
|
|-
|[[#value1|value1]]
|medium(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#value2|value2]]
|medium(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#ScriptName|ScriptName]]
|char(64)
|signed
|
|NO
|
|
|
|}

<big>'''Description of the fields'''</big>

==== criteria_id ====
This is the ID from [[Achievement_Criteria.dbc_SF|Achievement_Criteria.dbc]].

==== type ====
Depending on this value, it will determine how [[achievement_criteria_data_SF#value1|value1]] and [[achievement_criteria_data_SF#value2|value2]] are used.

{| border=1 cellpadding=3 cellspacing=0
! 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 || INSTANCE_SCRIPT
|-
| 19 || TYPE_S_EQUIPED_ITEM
|-
| 20 || TYPE_MAP_ID
|-
| 21 || TYPE_S_PLAYER_CLASS_RACE
|}

==== value1 ====
* '''TYPE_T_CREATURE'''
** The target here must be a valid [[creature_template_SF#entry|entry]] from [[creature_template_SF|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 SF|AreaTable.dbc]]
 
* '''TYPE_T_AURA'''
** The spell ID of the aura that must be on the target. value2 must also be set.
 
* '''TYPE_VALUE'''
** Minimum value needed to attain achievement. This value is used in conjunction with another 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 SF|Holiday.dbc]] and [[Game_event_SF#holiday|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
 
* '''INSTANCE_SCRIPT'''
** Make instance script call for check current criteria requirements fit.
 
* '''TYPE_S_EQUIPED_ITEM'''
** [[Item_template SF#ItemLevel|Item level]]
 
* '''TYPE_MAP_ID'''
** Player must be on [[Map.dbc SF|mapId]]
 
* '''TYPE_S_PLAYER_CLASS_RACE'''
** The Source here is a valid class (paste class list). value2 must also be set

==== value2 ====
* '''TYPE_T_PLAYER_CLASS_RACE'''
* '''TYPE_S_PLAYER_CLASS_RACE'''
** The value here is a valid race ID. See [[ChrRaces.dbc SF|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_template SF#Quality|Item quality]]

Achievement criteria data 548 - Revision history

Admin: Update structure and add DB structure.

Admin: Add content