blob: 99122c1aed9705830f91bf4a5653930b3707490f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
|
# achievement\_dbc
[<-Back-to:World](database-world.md)
**The \`achievement\_dbc\` table**
Stores achievement data that is missing in [Achievement.dbc](Achievement)
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
| -------------------- | ---- | ---------- | --- | ---- | ------- | ----- | -------------------------------------------------------------------------------- |
| [ID][1] | INT | UNSIGNED | PRI | NO | | | |
| [requiredFaction][2] | INT | SIGNED | | NO | -1 | | |
| [mapID][3] | INT | SIGNED | | NO | -1 | | |
| [points][4] | INT | UNSIGNED | | NO | 0 | | Achievement points awarded for completing the achievement, has no use serverside |
| [flags][5] | INT | UNSIGNED | | NO | 0 | | |
| [count][6] | INT | UNSIGNED | | NO | 0 | | |
| [refAchievement][7] | INT | UNSIGNED | | NO | 0 | | |
[1]: #id
[2]: #requiredfaction
[3]: #mapid
[4]: #points
[5]: #flags
[6]: #count
[7]: #refachievement
**Description of the fields**
### ID
This is the ID of the achievement from [Achievement\_Criteria.dbc](Achievement+Criteria) (2nd column)
### requiredFaction
| Condition | Faction |
| --------- | ------- |
| 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.
|
