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

  • character_aura


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

    Contains aura information that is loaded when a character is loaded, so the auras that were on the character when it logged out are still kept when it logs back in. A spell can have up to three auras, one in each of its effects.

    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 (Full Global Unique Identifier) of the target affected by the aura.
    caster_guid bigint(20) unsigned NO PRI '0'   The GUID (Global Unique Identifier) of the player who cast the aura.
    item_guid int(11) unsigned NO PRI '0'   The GUID (Global Unique Identifier) of the item which casted the aura.
    spell int(11) unsigned NO PRI '0'   The spell from which the aura was applied. [See Spell.dbc]
    stackcount int(11) unsigned NO '1'   Determines how many stacks of the spell the character has.
    remaincharges int(11) unsigned NO '0'   The number of charges remaining on the aura.
    basepoints0 int(11) NO '0'   Primary effect.
    basepoints1 int(11) NO '0'   Secondary effect (healing)
    basepoints2 int(11) NO '0'   Secondary effect (damage)
    periodictime0 int(11) unsigned NO '0'   Primary effect over time counter.
    periodictime1 int(11) unsigned NO '0'   Primary effect (healing) over time counter.
    periodictime2 int(11) unsigned NO '0'   Primary effect (damage) over time counter.
    maxduration int(11) NO '0'   The maximum duration of the aura.
    remaintime int(11) NO '0'   The time remaining in seconds on the aura. -1 means that the aura is indefinite.
    effIndexMask int(11) unsigned NO '0'   The effect index of the spell from which the aura came from.

    Description of the fields

    guid int(11) unsigned

    The GUID (Full Global Unique Identifier) of the target affected by the aura. [See character.id].

    caster_guid bigint(20) unsigned

    The GUID (Global Unique Identifier) of the player who cast the aura. [See character.id].

    item_guid int(11) unsigned

    The GUID (Global Unique Identifier) of the item which casted the aura. [See item_instance.guid].

    spell int(11) unsigned

    The spell from which the aura was applied. [See Spell.dbc column 1]

    stackcount int(11) unsigned

    Determines how many stacks of the spell the character has.

    remaincharges int(11) unsigned

    The number of charges remaining on the aura.

    basepoints0 int(11)

    Primary effect, such as Priest's heal, Warloack Demon skin, or Paladin's Seal of Righteousness.

    The effect can be positive or negative.

    basepoints1 int(11)

    This is a secondary effect and appears to be healing related, such as the Warlock Demon skin heal over time.

    basepoints2 int(11)

    This is a secondary effect, and appears to be damage related, such unleasing the Paladin's Seal of Righteousness.

    periodictime0 int(11) unsigned

    Primary effect over time counter, such as the Priest's heal.

    periodictime1 int(11) unsigned

    Primary effect (healing) over time counter.

    periodictime2 int(11) unsigned

    Primary effect (damage) over time counter.

    maxduration int(11)

    The maximum duration of the aura.

    remaintime int(11)

    The time remaining in seconds on the aura. -1 means that the aura is indefinite.

    effIndexMask int(11) unsigned

    The effect index of the spell from which the aura came from. A spell has up to three effects, with the index being 0, 1, or 2.


    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