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

  • character_inventory


    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_inventory' table for MaNGOSZero

    Contains all the character inventory data, including the bank data.

    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 MUL '0'   The GUID (Global Unique Identifier) of the character. [See character.guid].
    bag int(11) unsigned NO '0'   If it isn't 0, then it is the bag's item GUID (Global Unique Identifier).
    slot tinyint(3) unsigned NO '0'   The slot is the slot in the bag where the item is.
    item int(11) unsigned NO PRI '0'   The item's GUID. [See item_instance.guid].
    item_template int(11) unsigned NO '0'   The item's template entry (Item Identifier). [See item_template.entry].

    Description of the fields

    guid int(11) unsigned

    The GUID (Global Unique Identifier) of the character. [See character.guid].

    bag int(11) unsigned

    If it isn't 0, then it is the bag's item GUID (Global Unique Identifier). [See item_instance.guid].

    slot tinyint(3) unsigned

    If the bag field is non-zero, then the slot is the slot in the bag where the item is kept. The range can differ depending on the number of slots the bag has.

    If the bag field is zero, then the slot has a range of 0 to 84 and the value stands for the following:

    Slot # Slot Name
    0 Head
    1 Neck
    2 Shoulders
    3 Body
    4 Chest
    5 Waist
    6 Legs
    7 Feet
    8 Wrists
    9 Hands
    10 Finger 1
    11 Finger 2
    12 Trinket 1
    13 Trinket 2
    14 Back
    15 Main Hand
    16 Off Hand
    17 Ranged
    18 Tabard
    19-22 Equipped Bags
    23-38 Main Backpack
    39-62 Main Bank - 24 positions
    63-68 Bank Bags - 6 positions
      later changed to
    39-67 Main Bank - 28 positions ?
    68-74 Bank Bags - 7 positions ?


    item int(11) unsigned

    The item's GUID. [See item_instance.guid].

    item_template int(11) unsigned

    The item's template entry (Item Identifier). [See item_template.entry].


    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