Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • character_queststatus


    antz
     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


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use