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.
See characters
The quest ID.
See quest_template
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.
- no description -
Current count of the number of kills or casts on the first creature or gameobject, if any.
Taken from quest_template RequiredNpcOrGoCount1
Current count of the number of kills or casts on the first creature or gameobject, if any.
Taken from quest_template RequiredNpcOrGoCount2
Current count of the number of kills or casts on the first creature or gameobject, if any.
Taken from quest_template RequiredNpcOrGoCount3
Current count of the number of kills or casts on the first creature or gameobject, if any.
Taken from quest_template RequiredNpcOrGoCount4
Current item count for the item in a delivery quest, if any.
Taken from quest_template RequiredItemId1
Current item count for the item in a delivery quest, if any.
Taken from quest_template RequiredItemId2
Current item count for the item in a delivery quest, if any.
Taken from quest_template RequiredItemId3
Current item count for the item in a delivery quest, if any.
Taken from quest_template RequiredItemId4
Current item count for the item in a delivery quest, if any.
Taken from quest_template RequiredItemId5
Current item count for the item in a delivery quest, if any.
Taken from quest_template RequiredItemId6
Current player slay count.
Taken from quest_template RequiredPlayerKills
Back to 'character_pet_declinedname' Return to characters Go to 'character_queststatus_daily'