AzerothCore
Posts (Latest 10 updated) :
Read all

achievement_dbc

Back-to:World

The `achievement_dbc` table

Stores achievement data that is missing in Achievement.dbc

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

ID

int(10)

unsigned

PRI

NO

 

 

 

requiredFaction

int(11)

signed

 

NO

-1

 

 

mapID

int(11)

signed

 

NO

-1

 

 

points

int(10)

unsigned

 

NO

0

 

Achievement points awarded for completing the achievement, has no use serverside

flags

int(10)

unsigned

 

NO

0

 

 

count

int(10)

unsigned

 

NO

0

 

 

refAchievement

int(10)

unsigned

 

NO

0

 

 

Description of the fields

ID

This is the ID of the achievement from Achievement_Criteria.dbc (2nd column)

requiredFaction

  • Condition:
    • Both: -1,
    • Horde: 0,
    • Alliance: 1

mapID

Condition: Player must be on that map to be allowed criteria updates (-1 if not set)

points

Achievement points awarded for completing the achievement, has no use serverside

flags

Name

Value

Comment

ACHIEVEMENT_FLAG_COUNTER

0x00000001

Just count statistic (never stop and complete)

ACHIEVEMENT_FLAG_HIDDEN

0x00000002

Not sent to client - internal use only

ACHIEVEMENT_FLAG_STORE_MAX_VALUE

0x00000004

Store only max value? used only in "Reach level xx"

ACHIEVEMENT_FLAG_SUMM

0x00000008

Use summ criteria value from all reqirements (and calculate max value)

ACHIEVEMENT_FLAG_MAX_USED

0x00000010

Show max criteria (and calculate max value ??)

ACHIEVEMENT_FLAG_REQ_COUNT

0x00000020

Use not zero req count (and calculate max value)

ACHIEVEMENT_FLAG_AVERAGE

0x00000040

Show as average value (value / time_in_days) depend from other flag (by def use last criteria value)

ACHIEVEMENT_FLAG_BAR

0x00000080

Show as progress bar (value / max vale) depend from other flag (by def use last criteria value)

ACHIEVEMENT_FLAG_REALM_FIRST_REACH

0x00000100

 

ACHIEVEMENT_FLAG_REALM_FIRST_KILL

0x00000200

 

count

Should always be 1.

refAchievement

Should always be 0.