Back to 'character_pet_declinedname' Return to characters Go to 'character_queststatus_daily'
Holds information on the quest status of each character.
| 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 |
The guid of the character.
The quest ID.
The current quest status.
| Value | Status | Comment |
|---|---|---|
| 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 |
| 6 | QUEST_STATUS_REWARDED | Not used in DB |
Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest.
Unix Time when TimeAllowed will run out.
Current count of the number of kills or casts on the specified creature or gameobject, if any.
Matches RequiredNpcOrGoCount[1-4]
Current item count for the item in a delivery quest, if any.
Matches RequiredItemCount[1-6]
Current player slay count out of RequiredPlayerKills.
Back to 'character_pet_declinedname' Return to characters Go to 'character_queststatus_daily'