Tabelle: 'character_queststatus'
The `character_queststatus` tableHolds information on the quest status of each character. StructureField | Type | Attributes | Key | Null | Default | Extra | Comment |
---|
guid | int(10) | vorzeichenlos | PRI | NO | 0 | | Global Unique Identifier | quest | int(10) | vorzeichenlos | PRI | nein | 0 | | Quest Identifier | status | tinyint(3) | vorzeichenlos | | nein | 0 | | | explored | tinyint(3) | vorzeichenlos | | nein | 0 | | | timer | int(10) | vorzeichenlos | | nein | 0 | | | mobcount1 | smallint(5) | vorzeichenlos | | nein | 0 | | | mobcount2 | smallint(5) | vorzeichenlos | | nein | 0 | | | mobcount3 | smallint(5) | vorzeichenlos | | nein | 0 | | | mobcount4 | smallint(5) | vorzeichenlos | | nein | 0 | | | itemcount1 | smallint(5) | vorzeichenlos | | nein | 0 | | | itemcount2 | smallint(5) | vorzeichenlos | | nein | 0 | | | itemcount3 | smallint(5) | vorzeichenlos | | nein | 0 | | | itemcount4 | smallint(5) | vorzeichenlos | | nein | 0 | | | playercount | smallint(5) | vorzeichenlos | | nein | 0 | | |
Description of the fieldsguidThe GUID of the character. See characters/guid questThe quest ID. See quest_template.entry statusThe 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 |
exploredBoolean 1 or 0 representing if the character has explored what was needed to explore for the quest. timerfield-no-description|5
mobcountCurrent count of the number of kills or casts on the first creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount itemcountCurrent item count for the first item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount playercountCurrent player slay count. Required in quest_template.PlayersSlain
|