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

  • item_instance


    antz
     Share

     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 'item_instance' table for MaNGOSThree

    This table holds individual item instance information for all items currently equipped or in some kind of character bag or bank.

    Table Notes

    This table uses the 'InnoDB' 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 item. This number is unique for each item instance.
    owner_guid int(11) unsigned NO MUL '0'   The GUID of the character who has ownership of this item. [See character.guid]
    data longtext YES NULL   Much like the playerbytes fields in the characters table.
    text longtext YES NULL    

    Description of the fields

    guid int(11) unsigned

    The GUID of the item. This number is unique for each item instance.

    owner_guid int(11) unsigned

    The GUID of the character who has ownership of this item. [See character.guid]

    data longtext

    Much like the playerbytes fields in the characters table, this field has many number fields all separated by a space which contain specific individual item information like any enchantments applied to the item, etc.

    Index Flag Name Meaning
    0 OBJECT_FIELD_GUID Item GUID
    2 OBJECT_FIELD_TYPE Should be 3 (TYPE_OBJECT + TYPE_ITEM)
    3 OBJECT_FIELD_ENTRY Entry
    4 OBJECT_FIELD_SCALE_X 1.0
    5 OBJECT_FIELD_PADDING Some padding, need more info here.
    6 ITEM_FIELD_OWNER owner_guid
    8 ITEM_FIELD_CONTAINED If the item is in a bag, the GUID of the bag item; otherwise owner GUID.
    10 ITEM_FIELD_CREATOR GUID of character who created the item.
    12 ITEM_FIELD_GIFTCREATOR GUID of character who created the "item". [See character_gifts.item_guid].
    14 ITEM_FIELD_STACK_COUNT Current number of item copies in the stack.
    15 ITEM_FIELD_DURATION Current duration (in milliseconds)
    16 ITEM_FIELD_SPELL_CHARGES Current Number of charges left in the item
    21 ITEM_FIELD_FLAGS Flags from "item_template" (See Item_template.flags).
    22 ITEM_FIELD_ENCHANTMENT Unknown
    55 ITEM_FIELD_PROPERTY_SEED Also called ITEM_FIELD_SUFFIX_FACTOR
    56 ITEM_FIELD_RANDOM_PROPERTIES_ID Unknown
    57 ITEM_FIELD_ITEM_TEXT_ID Text id used and shown by the item.
    58 ITEM_FIELD_DURABILITY Current item durability.
    59 ITEM_FIELD_MAXDURABILITY Maximum item durability.

    text longtext


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

     Share


    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