NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'character_queststatus' table for MaNGOSZero
Holds information on the quest status of each character.
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
---|---|---|---|---|---|---|
guid | int(11) unsigned | NO | PRI | '0' | The GUID of the character. [See character.guid]. | |
quest | int(11) unsigned | NO | PRI | '0' | The quest ID. [See quest_template.entry]. | |
status | int(11) unsigned | NO | '0' | The current quest status. | ||
rewarded | tinyint(1) unsigned | NO | '0' | Boolean 1 or 0 representing whether the quest has been rewarded or not. | ||
explored | tinyint(1) unsigned | NO | '0' | Boolean 1 or 0 representing if the character has explored what was needed. | ||
timer | bigint(20) unsigned | NO | '0' | Remaining time left on the quest if the quest has a timer [See quest_template]. | ||
mobcount1 | int(11) unsigned | NO | '0' | Current count of the first number of kills or casts. | ||
mobcount2 | int(11) unsigned | NO | '0' | Current count of the second number of kills or casts. | ||
mobcount3 | int(11) unsigned | NO | '0' | Current count of the third number of kills or casts. | ||
mobcount4 | int(11) unsigned | NO | '0' | Current count of the forth number of kills or casts. | ||
itemcount1 | int(11) unsigned | NO | '0' | Current item count for the first item in a delivery quest, if any. | ||
itemcount2 | int(11) unsigned | NO | '0' | Current item count for the second item in a delivery quest, if any. | ||
itemcount3 | int(11) unsigned | NO | '0' | Current item count for the third item in a delivery quest, if any. | ||
itemcount4 | int(11) unsigned | NO | '0' | Current item count for the forth item in a delivery quest, if any. |
Description of the fields
guid int(11) unsigned
The GUID of the character. [See character.guid].
quest int(11) unsigned
The quest ID. [See quest_template.entry].
status int(11) unsigned
The current quest status.
Value | Status Flag | Notes |
---|---|---|
0 | QUEST_STATUS_NONE | Quest isn't shown in quest list - default value |
1 | QUEST_STATUS_COMPLETE | Quest has been completed. |
2 | QUEST_STATUS_UNAVAILABLE | Quest is unavailable to the character. |
3 | QUEST_STATUS_INCOMPLETE | Quest is active in quest log but incomplete |
4 | QUEST_STATUS_AVAILABLE | Quest is available to be taken by character |
5 | QUEST_STATUS_FAILED | Quest requires not achieved. (i.e. Woo Ping must survive) |
6 | QUEST_STATUS_FORCE_COMPLETE | This quest was force completed by GM command |
rewarded tinyint(1) unsigned
Boolean 1 or 0 representing whether the quest has been rewarded or not.
explored tinyint(1) unsigned
Boolean 1 or 0 representing if the character has explored what was needed to explore for the quest.
timer bigint(20) unsigned
Remaining time left on the quest if the quest has a timer. [See quest_template.LimitTime].
mobcount1 int(11) unsigned
Current count of the number of kills or casts on the second creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount1
mobcount2 int(11) unsigned
Current count of the number of kills or casts on the second creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount2
mobcount3 int(11) unsigned
Current count of the number of kills or casts on the third creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount3
mobcount4 int(11) unsigned
Current count of the number of kills or casts on the forth creature or gameobject, if any. Corresponds with quest_template.ReqCreatureOrGOCount4
itemcount1 int(11) unsigned
Current item count for the first item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount1
itemcount2 int(11) unsigned
Current item count for the second item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount2
itemcount3 int(11) unsigned
Current item count for the third item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount3
itemcount4 int(11) unsigned
Current item count for the forth item in a delivery quest, if any. Corresponds with quest_template.ReqItemCount4
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now