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 MaNGOSTwo
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
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 accountSign in
Already have an account? Sign in here.
Sign In Now