Difference between revisions of "DB/Achievement Criteria"

From wowdev
Jump to: navigation, search
(information about different types of criteria)
m (flags from client, comments from trinity)
 
(25 intermediate revisions by 8 users not shown)
Line 1: Line 1:
Achievement criterias. This file has been added with WoW 3.0.1.8303
+
__FORCETOC__
 +
Achievement criterias.  
  
== Structure ==
+
{{Template:Sandbox/VersionRange|min_expansionlevel=3|max_expansionlevel=5}}
 +
 
 +
==3.0.2.8303-3.3.5.12340==
 +
===Table===
 
{| style="background:#FCFCFC; color:black"
 
{| style="background:#FCFCFC; color:black"
 
|-  
 
|-  
Line 15: Line 19:
 
| 3 || Type || Integer || Which type is this criteria? This defines the rows below. See below.
 
| 3 || Type || Integer || Which type is this criteria? This defines the rows below. See below.
 
|-
 
|-
| 4 || Requirement_1 || Integer ||  
+
| 4 || ReqAssetID || Integer || Main requirement
 +
|-
 +
| 5 || ReqAmount || Integer || Main requirement count
 
|-
 
|-
| 5 || Value_1 || Integer ||  
+
| 6 || StartEvent || Integer || additional requirement 1 type
 
|-
 
|-
| 6 || Requirement_2 || Integer ||  
+
| 7 || StartAssetID || Integer || additional requirement 1 value
 
|-
 
|-
| 7 || Value_2 || Integer ||
+
| 8 || FailEvent || Integer || additional requirement 2 type
 
|-
 
|-
| 8 || Requirement_3 || Integer ||  
+
| 9 || FailAssetID || Integer || additional requirement 2 value
 
|-
 
|-
| 9 || Value_3 || Integer ||
+
| 10-26 || Description || [[Loc]] || Criteria description.
 
|-
 
|-
| 10 || Description || [[Loc]] || Criteria description.
+
| 27 || Flags || Integer ||  
 
|-
 
|-
| 27 || CompletionFlag || Integer ||  
+
| 28 || TimerStartEvent || Integer ||  
 
|-
 
|-
| 28 || GroupFlag || Integer ||  
+
| 29 || TimerAssetID || Integer ||  
 
|-
 
|-
| 29 || Unknown || Integer ||  
+
| 30 || TimerTime || Integer || Complete quest in %i seconds.
 
|-
 
|-
| 30 || Timelimit || Integer || Complete quest in %i seconds.
+
| 31 || OrderInUI || Integer || Order of criteria in achievement's description.
 +
|}
 +
 
 +
===Flags===
 +
{| style="background:#FCFCFC; color:black"
 
|-
 
|-
| 31 || Order || Integer ||  
+
! width="80" | Value
|}
+
! width="250" | Description
 +
! width="300" | Comment
 +
|-
 +
| 0x01 || CRITERIA_FLAG_PROGRESS_BAR      ||
 +
|-
 +
| 0x02 || CRITERIA_FLAG_HIDDEN            ||
 +
|-
 +
| 0x04 || CRITERIA_FLAG_FAIL_ACHIEVEMENT  || achievement is failed if criteria is not met
 +
|-
 +
| 0x08 || CRITERIA_FLAG_RESET_ON_START    || criteria counters reset each restart
 +
|-
 +
| 0x10 || CRITERIA_FLAG_IS_DATE            || is a date requirement
 +
|-
 +
| 0x20 || CRITERIA_FLAG_IS_MONEY          || counter shows currency
 +
|-
 +
| 0x40 || CRITERIA_FLAG_IS_ACHIEVEMENT_ID  ||
 +
|-
 +
| 0x80 || CRITERIA_FLAG_QUANTITY_IS_CAPPED ||  
 +
|}
  
==Information by type==
+
==Information by Type==
 
This describes rows 3 to 9 by type (row 2). There may be more types. Unlisted fields are zero.  
 
This describes rows 3 to 9 by type (row 2). There may be more types. Unlisted fields are zero.  
 
This information is retrieved from TrinityCore's [http://dev.trinitycore.org/trinitycore2/src/561ac59c59ac/src/game/DBCStructure.h DBCStructure.h].
 
  
 
====KILL_CREATURE = 0 ====
 
====KILL_CREATURE = 0 ====
Line 255: Line 281:
 
| 4 || castCount || Integer
 
| 4 || castCount || Integer
 
|}      
 
|}      
 +
 +
====BG_OBJECTIVE_CAPTURE            = 30 ====
 +
{| style="background:#FCFCFC; color:black"
 +
|-
 +
! width="80" | Column
 +
! width="180" | Field
 +
! width="80" | Type
 +
! width="500" | Notes
 +
|-
 +
| 3 || unknow || Integer ||                  // value 42 = capture the flag
 +
|-
 +
| 4 || count(?) || Integer ||                  // how many captures required
 +
|}
  
 
====HONORABLE_KILL_AT_AREA = 31 ====
 
====HONORABLE_KILL_AT_AREA = 31 ====
Line 358: Line 397:
  
 
====EXPLORE_AREA          = 43 ====
 
====EXPLORE_AREA          = 43 ====
''This areaReference is '''NOT''' the index from [[AreaTable.dbc]]''
+
''This areaReference is '''NOT''' the index from [[AreaTable.dbc]] but from {{DBRef|table=WorldMapOverlay}}''
 
{| style="background:#FCFCFC; color:black"
 
{| style="background:#FCFCFC; color:black"
 
|-  
 
|-  
Line 366: Line 405:
 
|-
 
|-
 
| 3 || areaReference || Integer         
 
| 3 || areaReference || Integer         
|}
+
|}
  
 
====OWN_RANK              = 44 ====
 
====OWN_RANK              = 44 ====
Line 661: Line 700:
 
|-    
 
|-    
 
| 4 || killCount || Integer  
 
| 4 || killCount || Integer  
|}          
+
|}
 +
 
 +
====ACCEPTED_SUMMONS    = 114 ====
 +
{| style="background:#FCFCFC; color:black"
 +
|-
 +
! width="80" | Column
 +
! width="180" | Field
 +
! width="80" | Type
 +
|-
 +
| 3 || unused || Integer
 +
|-  
 +
| 4 || Here comes a 1 in, because it's a Statistic|| Integer
 +
|}
  
 +
====ACHIVEMENTPOINTS_REACHED  = 115 ====
 +
{| style="background:#FCFCFC; color:black"
 +
|-
 +
! width="80" | Column
 +
! width="180" | Field
 +
! width="80" | Type
 +
|-
 +
| 3 || unused || Integer
 +
|-  
 +
| 4 || unused || Integer
 +
|}
 +
//This thing really confuses me... Maybe it is only used for "Over Ninethousand", because nowhere AchPoints are Specified
  
[[Category:DBC]][[Category:3.0.2.8905]]
+
====RANDOM_DUNGEON_PLAYERCOUNT  = 119 ====
 +
{| style="background:#FCFCFC; color:black"
 +
|-
 +
! width="80" | Column
 +
! width="180" | Field
 +
! width="80" | Type
 +
|-
 +
| 3 || unused || Integer
 +
|-  
 +
| 4 || PlayerCount || Integer
 +
|}
  
__NOTOC__
+
[[Category:DBC]][[Category:DBC_WotLK]]

Latest revision as of 12:18, 16 April 2019

Achievement criterias.

Wrath … Mists

Contents

3.0.2.8303-3.3.5.12340

Table

Column Field Type Notes
1 ID Integer
2 Achievement iRefID References the achievement this criteria is needed for.
3 Type Integer Which type is this criteria? This defines the rows below. See below.
4 ReqAssetID Integer Main requirement
5 ReqAmount Integer Main requirement count
6 StartEvent Integer additional requirement 1 type
7 StartAssetID Integer additional requirement 1 value
8 FailEvent Integer additional requirement 2 type
9 FailAssetID Integer additional requirement 2 value
10-26 Description Loc Criteria description.
27 Flags Integer
28 TimerStartEvent Integer
29 TimerAssetID Integer
30 TimerTime Integer Complete quest in %i seconds.
31 OrderInUI Integer Order of criteria in achievement's description.

Flags

Value Description Comment
0x01 CRITERIA_FLAG_PROGRESS_BAR
0x02 CRITERIA_FLAG_HIDDEN
0x04 CRITERIA_FLAG_FAIL_ACHIEVEMENT achievement is failed if criteria is not met
0x08 CRITERIA_FLAG_RESET_ON_START criteria counters reset each restart
0x10 CRITERIA_FLAG_IS_DATE is a date requirement
0x20 CRITERIA_FLAG_IS_MONEY counter shows currency
0x40 CRITERIA_FLAG_IS_ACHIEVEMENT_ID
0x80 CRITERIA_FLAG_QUANTITY_IS_CAPPED

Information by Type

This describes rows 3 to 9 by type (row 2). There may be more types. Unlisted fields are zero.

KILL_CREATURE = 0

Also used for player deaths..

Column Field Type
3 creatureID Integer
4 Integer

WIN_BG = 1

There are further criterias instead just winning

Column Field Type
3 Map iRefID
4 winCount Integer

REACH_LEVEL = 5

Column Field Type
3 unused Integer
4 level Integer

REACH_SKILL_LEVEL = 7

Column Field Type Notes
3 skillID iRefID SkillLine.dbc or what?
4 skillLevel Integer

COMPLETE_ACHIEVEMENT = 8

Column Field Type
3 Achievement iRefID

COMPLETE_QUEST_COUNT = 9

Column Field Type
3 unused Integer
4 totalQuestCount Integer

COMPLETE_DAILY_QUEST_DAILY = 10

Column Field Type
3 unused Integer
4 numberOfDays Integer

COMPLETE_QUESTS_IN_ZONE = 11

Column Field Type
3 zoneID Integer
4 questCount Integer

COMPLETE_DAILY_QUEST = 14

Column Field Type
3 unused Integer
4 questCount Integer

COMPLETE_BATTLEGROUND = 15

DEATH_AT_MAP = 16

Column Field Type
3 Map iRefID

DEATH_IN_DUNGEON = 18

Column Field Type
3 manLimit Integer

COMPLETE_RAID = 19

Column Field Type Notes
3 groupSize Integer can be 5, 10 or 25

KILLED_BY_CREATURE = 20

Column Field Type
3 creatureEntry Integer

FALL_WITHOUT_DYING = 24

Column Field Type
3 unused Integer
4 fallHeight Integer

DEATHS_FROM = 26

Column Field Type
3 EnvironmentalDamage iRefID

COMPLETE_QUEST = 27

Column Field Type
3 questID Integer
4 questCount Integer

BE_SPELL_TARGET = 28

BE_SPELL_TARGET2 = 69

Column Field Type
3 Spell iRefID
4 spellCount Integer

CAST_SPELL = 29

CAST_SPELL2 = 110

Column Field Type
3 Spell iRefID
4 castCount Integer

BG_OBJECTIVE_CAPTURE = 30

Column Field Type Notes
3 unknow Integer // value 42 = capture the flag
4 count(?) Integer // how many captures required

HONORABLE_KILL_AT_AREA = 31

Column Field Type
3 Area iRefID
4 killCount Integer

WIN_ARENA = 32

PLAY_ARENA = 33

Column Field Type
3 Map iRefID

LEARN_SPELL = 34

Column Field Type
3 Spell iRefID

WIN_RATED_ARENA = 37

Column Field Type Notes
3 unused Integer
4 count Integer
5 flag Integer 4=in a row

HIGHEST_TEAM_RATING = 38

Column Field Type Notes
3 teamtype Integer {2,3,5}

REACH_TEAM_RATING = 39

Column Field Type Notes
3 teamtype Integer {2,3,5}
4 teamrating Integer

LEARN_SKILL_LEVEL = 40

Column Field Type Notes
3 skillID iRefID SkillLine.dbc or what?
4 skillLevel Integer apprentice=1, journeyman=2, expert=3, artisan=4, master=5, grand master=6

OWN_ITEM = 36

USE_ITEM = 41

LOOT_ITEM = 42

EQUIP_ITEM = 57

Column Field Type
3 Item iRefID
4 itemCount Integer

EXPLORE_AREA = 43

This areaReference is NOT the index from AreaTable.dbc but from WorldMapOverlayRec

Column Field Type
3 areaReference Integer

OWN_RANK = 44

This rank is NOT the index from CharTitles.dbc

Column Field Type
3 rank Integer

BUY_BANK_SLOT = 45

Column Field Type
3 unused Integer
4 numberOfSlots Integer

GAIN_REPUTATION = 46

Column Field Type Notes
3 Faction iRefID
4 reputationAmount Integer Total reputation amount, so 42000 = exalted

GAIN_EXALTED_REPUTATION= 47

Column Field Type
3 unused Integer
4 numberOfExaltedFactions Integer

VISIT_BARBER_SHOP = 48

Column Field Type
3 unused Integer
4 numberOfVisits Integer

EQUIP_EPIC_ITEM = 49

Where is the required itemlevel stored?

Column Field Type
3 itemSlot Integer

ROLL_NEED_ON_LOOT = 50

ROLL_GREED_ON_LOOT = 51

Column Field Type
3 rollValue Integer
4 count Integer

HK_CLASS = 52

Column Field Type
3 Class iRefID
4 count Integer

HK_RACE = 53

Column Field Type
3 Race iRefID
4 count Integer

DO_EMOTE = 54

where is the information about the target stored?

Column Field Type Notes
3 Emote iRefID
4 count Integer count of emotes, always required special target or requirements

DAMAGE_DONE = 13

HEALING_DONE = 55

GET_KILLING_BLOWS = 56

Column Field Type Notes
3 unused Integer
4 count Integer
5 flag Integer 3 for battleground healing
6 Map iRefID

MONEY_FROM_QUEST_REWARD= 62

LOOT_MONEY = 67

Column Field Type
3 unused Integer
4 goldInCopper Integer

USE_GAMEOBJECT = 68

Column Field Type
3 goEntry Integer
4 useCount Integer

SPECIAL_PVP_KILL = 70

Are those special criteria stored in the dbc?

Column Field Type
3 unused Integer
4 killCount Integer

FISH_IN_GAMEOBJECT = 72

Column Field Type
3 goEntry Integer
4 lootCount Integer

LEARN_SKILLLINE_SPELLS = 75

Column Field Type
3 SkillLine iRefID
4 spellCount Integer

WIN_DUEL = 76

Column Field Type
3 unused Integer
4 duelCount Integer

HIGHEST_POWER = 96

Column Field Type Notes
3 powerType Integer 0=mana, 1=rage, 3=energy, 6=runic power

HIGHEST_STAT = 97

Column Field Type Notes
3 statType Integer 4=spirit, 3=int, 2=stamina, 1=agi, 0=strength

HIGHEST_SPELLPOWER = 98

Column Field Type Notes
3 spellSchool iRefID SkillLine or Resistances ?

HIGHEST_RATING = 100

Column Field Type
3 ratingType Integer

LOOT_TYPE = 109

Column Field Type Notes
3 lootType Integer 3=fishing, 2=pickpocket, 4=disentchant
4 lootTypeCount Integer

LEARN_SKILL_LINE = 112

Column Field Type
3 SkillLine iRefID
4 spellCount Integer

EARN_HONORABLE_KILL = 113

Column Field Type
3 unused Integer
4 killCount Integer

ACCEPTED_SUMMONS = 114

Column Field Type
3 unused Integer
4 Here comes a 1 in, because it's a Statistic Integer

ACHIVEMENTPOINTS_REACHED = 115

Column Field Type
3 unused Integer
4 unused Integer

//This thing really confuses me... Maybe it is only used for "Over Ninethousand", because nowhere AchPoints are Specified

RANDOM_DUNGEON_PLAYERCOUNT = 119

Column Field Type
3 unused Integer
4 PlayerCount Integer