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

  • character_stats


    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 'character_stats' table for MaNGOSOne

    This table holds information on all the stats regarding the character.

    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 character. [See character.guid].
    maxhealth int(10) unsigned NO '0'   Maximum amount of health that the character has.
    maxpower1 int(10) unsigned NO '0'   Max Mana
    maxpower2 int(10) unsigned NO '0'   Max Rage
    maxpower3 int(10) unsigned NO '0'   Max Focus
    maxpower4 int(10) unsigned NO '0'   Max Energy
    maxpower5 int(10) unsigned NO '0'   Max Happiness
    maxpower6 int(10) unsigned NO '0'   Max Rune
    maxpower7 int(10) unsigned NO '0'   Max Runic Power
    strength int(10) unsigned NO '0'   Character's current strength value.
    agility int(10) unsigned NO '0'   Character's current agility value
    stamina int(10) unsigned NO '0'   Character's current stamina value.
    intellect int(10) unsigned NO '0'   Character's current intellect value.
    spirit int(10) unsigned NO '0'   Character's current spirit value.
    armor int(10) unsigned NO '0'   Character's current armor value.
    resHoly int(10) unsigned NO '0'   Character's current holy resistance value.
    resFire int(10) unsigned NO '0'   Character's current fire resistance value.
    resNature int(10) unsigned NO '0'   Character's current nature resistance value.
    resFrost int(10) unsigned NO '0'   Character's current frost resistance value.
    resShadow int(10) unsigned NO '0'   Character's current shadow resistance value.
    resArcane int(10) unsigned NO '0'   Character's current arcane resistance value.
    blockPct float unsigned NO '0'   Character's current block chance
    dodgePct float unsigned NO '0'   Character's current dodge chance.
    parryPct float unsigned NO '0'   Character's current parry chance.
    critPct float unsigned NO '0'   Character's current crit chance.
    rangedCritPct float unsigned NO '0'   Character's current ranged crit chance.
    spellCritPct float unsigned NO '0'    
    attackPower int(10) unsigned NO '0'   Character's current attackpower.
    rangedAttackPower int(10) unsigned NO '0'   Character's current ranged attackpower.
    spellPower int(10) unsigned NO '0'    

    Description of the fields

    guid int(11) unsigned

    The guid of the character. [See character.guid].

    maxhealth int(10) unsigned

    Maximum amount of health that the character has.

    maxpower1 int(10) unsigned

    Max Mana

    maxpower2 int(10) unsigned

    Max Rage

    maxpower3 int(10) unsigned

    Max Focus

    maxpower4 int(10) unsigned

    Max Energy

    maxpower5 int(10) unsigned

    Max Happiness

    maxpower6 int(10) unsigned

    Max Rune

    maxpower7 int(10) unsigned

    Max Runic Power

    strength int(10) unsigned

    Character's current strength value.

    agility int(10) unsigned

    Character's current agility value

    stamina int(10) unsigned

    Character's current stamina value.

    intellect int(10) unsigned

    Character's current intellect value.

    spirit int(10) unsigned

    Character's current spirit value.

    armor int(10) unsigned

    Character's current armor value.

    resHoly int(10) unsigned

    Character's current holy resistance value.

    resFire int(10) unsigned

    Character's current fire resistance value.

    resNature int(10) unsigned

    Character's current nature resistance value.

    resFrost int(10) unsigned

    Character's current frost resistance value.

    resShadow int(10) unsigned

    Character's current shadow resistance value.

    resArcane int(10) unsigned

    Character's current arcane resistance value.

    blockPct float unsigned

    Character's current block chance

    dodgePct float unsigned

    Character's current dodge chance.

    parryPct float unsigned

    Character's current parry chance.

    critPct float unsigned

    Character's current crit chance.

    rangedCritPct float unsigned

    Character's current ranged crit chance.

    spellCritPct float unsigned

    attackPower int(10) unsigned

    Character's current attackpower.

    rangedAttackPower int(10) unsigned

    Character's current ranged attackpower.

    spellPower int(10) unsigned


    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