Pet aura
Материал из YTDB DataBase
Neggod (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Back to the characters database list of tables. <big>'''The `pet_aura` table'''</big> Contains aura informat…») |
NeatElves (Обсуждение | вклад) |
||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| - | + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | |
| - | <big>''' | + | <big>'''Таблица `pet_aura`'''</big> |
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. | 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. | ||
| - | <big>''' | + | <big>'''Структура'''</big> |
{| border="1" | {| border="1" | ||
|'''Field''' | |'''Field''' | ||
|'''Type''' | |'''Type''' | ||
| + | |'''Attributes''' | ||
|'''Null''' | |'''Null''' | ||
|'''Key''' | |'''Key''' | ||
|'''Default''' | |'''Default''' | ||
| - | |''' | + | |'''Comments''' |
|- | |- | ||
|[[#guid|guid]] | |[[#guid|guid]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 27: | Строка 29: | ||
|- | |- | ||
|[[#caster_guid|caster_guid]] | |[[#caster_guid|caster_guid]] | ||
| - | |bigint(20) unsigned | + | |bigint(20) |
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 34: | Строка 37: | ||
|- | |- | ||
|[[#spell|spell]] | |[[#spell|spell]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 41: | Строка 45: | ||
|- | |- | ||
|[[#effect_index|effect_index]] | |[[#effect_index|effect_index]] | ||
| - | |int(11) unsigned | + | |int(11) |
| + | |unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
| Строка 49: | Строка 54: | ||
|[[#amount|amount]] | |[[#amount|amount]] | ||
|int(11) | |int(11) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 56: | Строка 62: | ||
|[[#maxduration|maxduration]] | |[[#maxduration|maxduration]] | ||
|int(11) | |int(11) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 63: | Строка 70: | ||
|[[#remaintime|remaintime]] | |[[#remaintime|remaintime]] | ||
|int(11) | |int(11) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 70: | Строка 78: | ||
|[[#remaincharges|remaincharges]] | |[[#remaincharges|remaincharges]] | ||
|int(11) | |int(11) | ||
| + | | | ||
|NO | |NO | ||
| | | | ||
| Строка 77: | Строка 86: | ||
| - | <big>''' | + | <big>'''Описание полей'''</big> |
====guid==== | ====guid==== | ||
The GUID of the target affected by the aura. See [[character#guid|character.guid]] | The GUID of the target affected by the aura. See [[character#guid|character.guid]] | ||
Версия 10:39, 31 августа 2010
|
К описанию таблиц базы данных characters.
Таблица `pet_aura`
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.
Структура
| Field | Type | Attributes | Null | Key | Default | Comments |
| guid | int(11) | unsigned | NO | PRI | 0 | |
| caster_guid | bigint(20) | unsigned | NO | 0 | ||
| spell | int(11) | unsigned | NO | PRI | 0 | |
| effect_index | int(11) | unsigned | NO | PRI | 0 | |
| amount | int(11) | NO | 0 | |||
| maxduration | int(11) | NO | 0 | |||
| remaintime | int(11) | NO | 0 | |||
| remaincharges | int(11) | NO | 0 |
Описание полей
guid
The GUID of the target affected by the aura. See character.guid
caster_guid
The GUID of the player or creature who casted the aura. See character.guid
spell
The spell from which the aura was applied. See Spell.dbc column 1
effect_index
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.
amount
The modifier value associated with the aura.
maxduration
The maximum duration of the aura.
remaintime
The time remaining in seconds on the aura. -1 means that the aura is indefinite.
remaincharges
The number of charges remaining on the aura.
(c)udbwiki
