character_queststatus
Holds information on the quest status of each character.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | int | unsigned | PRI | NO | 0 | Global Unique Identifier | |
| quest | int | unsigned | PRI | NO | 0 | Quest Identifier | |
| status | tinyint | unsigned | NO | 0 | |||
| explored | tinyint | unsigned | NO | 0 | |||
| timer | int | unsigned | NO | 0 | |||
| mobcount1 | smallint | unsigned | NO | 0 | |||
| mobcount2 | smallint | unsigned | NO | 0 | |||
| mobcount3 | smallint | unsigned | NO | 0 | |||
| mobcount4 | smallint | unsigned | NO | 0 | |||
| itemcount1 | smallint | unsigned | NO | 0 | |||
| itemcount2 | smallint | unsigned | NO | 0 | |||
| itemcount3 | smallint | unsigned | NO | 0 | |||
| itemcount4 | smallint | unsigned | NO | 0 | |||
| itemcount5 | smallint | unsigned | NO | 0 | |||
| itemcount6 | smallint | unsigned | NO | 0 | |||
| playercount | smallint | unsigned | NO | 0 |
Description of fields
guid
The guid of the character.
quest
The quest ID.
status
The current quest status.enum QuestStatus
| Value | Status | Comment |
|---|---|---|
| 0 | QUEST_STATUS_NONE | Player does not have or had quest at all. He could accept it, but he did not (yet). |
| 1 | QUEST_STATUS_COMPLETE | Player fulfilled objectives, but did not hand it in yet. |
| 3 | QUEST_STATUS_INCOMPLETE | Player did not fulfill objectives yet. |
| 5 | QUEST_STATUS_FAILED | Player failed to fulfill objectives for any reason, e.g. time limit. |
| 6 | QUEST_STATUS_REWARDED | Not used in DB. |
explored
Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest.
timer
Unix Time when TimeAllowed will run out.
mobcount[1-4]
Current count of the number of kills or casts on the specified creature or gameobject, if any.
Matches RequiredNpcOrGoCount[1-4]
itemcount[1-6]
Current item count for the item in a delivery quest, if any.
Matches RequiredItemCount[1-6]
playercount
Current player slay count out of RequiredPlayerKills.
