Back-to:Characters
The `character_queststatus` table
Holds information on the quest status of each character.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
unsigned |
PRI |
NO |
0 |
|
Global Unique Identifier |
|
int(10) |
unsigned |
PRI |
NO |
0 |
|
Quest Identifier |
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
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.
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
mobcount
Current count of the number of kills or casts on the first creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount
itemcount
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