blob: c77a198291791e369b41f7f07a03dbd889f200b3 (
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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
# character\_queststatus
[<-Back-to:Characters](database-characters.md)
**The \`character\_queststatus\` table**
Holds information on the quest status of each character.
**Structure**
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|-------------------|-------------|------------|-----|------|---------|-------|--------------------------|
| [guid][1] | int(10) | unsigned | PRI | NO | | | Global Unique Identifier |
| [quest][2] | int(10) | unsigned | PRI | NO | | | Quest Identifier |
| [status][3] | tinyint(3) | unsigned | | NO | | | |
| [explored][4] | tinyint(3) | unsigned | | NO | | | |
| [timer][5] | int(10) | unsigned | | NO | | | |
| [mobcount1][6] | smallint(5) | unsigned | | NO | | | |
| [mobcount2][7] | smallint(5) | unsigned | | NO | | | |
| [mobcount3][8] | smallint(5) | unsigned | | NO | | | |
| [mobcount4][9] | smallint(5) | unsigned | | NO | | | |
| [itemcount1][10] | smallint(5) | unsigned | | NO | | | |
| [itemcount2][11] | smallint(5) | unsigned | | NO | | | |
| [itemcount3][12] | smallint(5) | unsigned | | NO | | | |
| [itemcount4][13] | smallint(5) | unsigned | | NO | | | |
| [itemcount5][14] | smallint(5) | unsigned | | NO | | | |
| [itemcount6][15] | smallint(5) | unsigned | | NO | | | |
| [playercount][16] | smallint(5) | unsigned | | NO | | | |
[1]: #guid
[2]: #quest
[3]: #status
[4]: #explored
[5]: #timer
[6]: #mobcount1
[7]: #mobcount2
[8]: #mobcount3
[9]: #mobcount4
[10]: #itemcount1
[11]: #itemcount2
[12]: #itemcount3
[13]: #itemcount4
[14]: #itemcount5
[15]: #itemcount6
[16]: #playercount
**Description of the fields**
### guid
The GUID of the character. See characters.guid
### quest
The quest ID. See quest\_template.entry
### status
The current quest status.
**Possible values**
| Value | Status | Comments |
|-------|----------------------------|---------------------------------------------|
| 0 | QUEST\_STATUS\_NONE | Quest isn't shown in quest list; default |
| 1 | QUEST\_STATUS\_COMPLETE | Quest has been completed |
| 2 | QUEST\_STATUS\_UNAVAILABLE | NOT USED |
| 3 | QUEST\_STATUS\_INCOMPLETE | Quest is active in quest log but incomplete |
| 4 | QUEST\_STATUS\_AVAILABLE | NOT USED |
| 5 | QUEST\_STATUS\_FAILED | Player failed to complete the quest |
### explored
Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest.
### timer
`field-no-description|5`
### mobcount1-4
Current count of the number of kills or casts on the first creature or gameobject, if any. Corresponds with quest\_template.ReqCreatureOrGOCount
### itemcount1-6
Current item count for the first item in a delivery quest, if any. Corresponds with quest\_template.ReqItemCount
### playercount
Current player slay count. Required in quest\_template.PlayersSlain
|
