Character queststatus tc2

Back to characters database list of tables.

The `character_queststatus` table

Holds information on the quest status of each character.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned	PRI	NO	0		Global Unique Identifier
quest	int(10)	unsigned	PRI	NO	0		Quest Identifier
status	tinyint(3)	unsigned		NO	0
explored	tinyint(3)	unsigned		NO	0
timer	int(10)	unsigned		NO	0
mobcount1	smallint(5)	unsigned		NO	0
mobcount2	smallint(5)	unsigned		NO	0
mobcount3	smallint(5)	unsigned		NO	0
mobcount4	smallint(5)	unsigned		NO	0
itemcount1	smallint(5)	unsigned		NO	0
itemcount2	smallint(5)	unsigned		NO	0
itemcount3	smallint(5)	unsigned		NO	0
itemcount4	smallint(5)	unsigned		NO	0
playercount	smallint(5)	unsigned		NO	0

Description of the fields

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

This field has no description. You can help wiki by clicking here to describe this field, if you have permissions.

mobcount

Current count of the number of kills or casts on the first creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount

itemcount

Current item count for the first item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount

playercount

Current player slay count. Required in quest_template.PlayersSlain