|
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 'pet_aura' table for MaNGOSZero
This table contains aura information that is loaded when a pet is loaded, so the auras that were on the pet when the owner character logged out are still kept when they log 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 of the target affected by the aura. [See character.guid] | |
| caster_guid | bigint(20) unsigned | NO | PRI | '0' | The GUID of the player or creature who casted the aura. [See character.guid] | |
| item_guid | int(11) unsigned | NO | PRI | '0' | Guid of the item that is casting the aura on the pet. | |
| spell | int(11) unsigned | NO | PRI | '0' | The spell from which the aura was applied. [See Spell.dbc column 1] | |
| stackcount | int(11) unsigned | NO | '1' | This is the total number of times the aura can be stacked on the pet. | ||
| 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 (appears to be only healing related) | ||
| basepoints2 | int(11) | NO | '0' | Secondary effect (appears to be only damage related) | ||
| periodictime0 | int(11) unsigned | NO | '0' | Primary effect over time. | ||
| periodictime1 | int(11) unsigned | NO | '0' | Secondary effect (healing) over time | ||
| periodictime2 | int(11) unsigned | NO | '0' | Secondary effect (damage) over time. | ||
| 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 of the target affected by the aura. [See character.guid]
caster_guid bigint(20) unsigned
The GUID of the player or creature who casted the aura. [See character.guid]
item_guid int(11) unsigned
Guid of the item that is casting the aura on the pet.
spell int(11) unsigned
The spell from which the aura was applied. [See Spell.dbc column 1]
stackcount int(11) unsigned
This is the total number of times the aura can be stacked on the pet.
remaincharges int(11) unsigned
The number of charges remaining on the aura.
basepoints0 int(11)
Primary effect, such as healing.
basepoints1 int(11)
Secondary effect (appears to be only healing related)
basepoints2 int(11)
Secondary effect (appears to be only damage related)
periodictime0 int(11) unsigned
Primary effect over time.
periodictime1 int(11) unsigned
Secondary effect (healing) over time
periodictime2 int(11) unsigned
Secondary effect (damage) over time.
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