DB/Achievement Criteria

From wowdev
Revision as of 02:03, 14 July 2016 by Synric (talk | contribs)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Achievement criterias. This file has been added with WoW 3.0.1.8303

Wrath

3.0.2.8303

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 asset_id Integer Main requirement
5 quantity Integer Main requirement count
6 start_event Integer additional requirement 1 type
7 start_asset Integer additional requirement 1 value
8 fail_event Integer additional requirement 2 type
9 fail_asset Integer additional requirement 2 value
10-26 Description Loc Criteria description.
27 flags Integer
28 timer_start_event Integer
29 timer_asset_id Integer
30 timer_time Integer Complete quest in %i seconds.
31 ui_order Integer

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 asset_id Integer Main requirement
5 quantity Integer Main requirement count
6 start_event Integer additional requirement 1 type
7 start_asset Integer additional requirement 1 value
8 fail_event Integer additional requirement 2 type
9 fail_asset Integer additional requirement 2 value
10-26 Description Loc Criteria description.
27 flags Integer
28 timer_start_event Integer
29 timer_asset_id Integer
30 timer_time Integer Complete quest in %i seconds.
31 ui_order Integer

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

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