character_queststatus
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 | ||||
| itemcount5 | smallint(5) | unsigned | NO | 0 | |||
| itemcount6 | 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
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