====== character_queststatus 表 ====== ---- [[数据库:characters数据库:首页|<-返回:Characters 数据库]] Holds information on the quest status of each character. **表结构** ^Field^Type^Attributes^Key^Null^Default^extra^Comment^ |[[#guid|guid]]|INT|UNSIGNED|PRI|NO|0| |Global Unique Identifier| |[[#quest|quest]]|INT|UNSIGNED|PRI|NO|0| |Quest Identifier| |[[#status|status]]|TINYINT|UNSIGNED| |NO|0| | | |[[#explored|explored]]|TINYINT|UNSIGNED| |NO|0| | | |[[#timer|timer]]|INT|UNSIGNED| |NO|0| | | |[[#mobcount|mobcount1]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#mobcount|mobcount2]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#mobcount|mobcount3]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#mobcount|mobcount4]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#itemcount|itemcount1]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#itemcount|itemcount2]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#itemcount|itemcount3]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#itemcount|itemcount4]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#itemcount|itemcount5]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#itemcount|itemcount6]]|SMALLINT|UNSIGNED| |NO|0| | | |[[#playercount|playercount]]|SMALLINT|UNSIGNED| |NO|0| | | ===== 字段说明 ===== ---- ==== guid ==== The GUID of the character. See characters.guid. ==== quest ==== The quest ID. See quest_template.entry. ==== status ==== The current quest status. **Possible values** ^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 ==== mobcount ==== Current count of the number of kills or casts on the first creature or gameobject, if any. Corresponds with quest_template. ==== itemcount ==== Current item count for the first item in a delivery quest, if any. Corresponds with quest_template. ==== playercount ==== Current player slay count. Required in quest_template.