Pet aura
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| (4 промежуточные версии не показаны) | |||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| + | [[Category: Mangos characters database tables]] | ||
К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | ||
| Строка 26: | Строка 27: | ||
|PRI | |PRI | ||
|0 | |0 | ||
| - | | | + | |Global Unique Identifier |
|- | |- | ||
|[[#caster_guid|caster_guid]] | |[[#caster_guid|caster_guid]] | ||
| Строка 32: | Строка 33: | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
| - | | | + | |PRI |
|0 | |0 | ||
| - | | | + | |Full Global Unique Identifier |
|- | |- | ||
|[[#item_guid|item_guid]] | |[[#item_guid|item_guid]] | ||
| Строка 54: | Строка 55: | ||
|[[#stackcount|stackcount]] | |[[#stackcount|stackcount]] | ||
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
| Строка 62: | Строка 63: | ||
|[[#remaincharges|remaincharges]] | |[[#remaincharges|remaincharges]] | ||
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
| Строка 92: | Строка 93: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#periodictime|periodictime0]] |
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
| Строка 100: | Строка 101: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#periodictime|periodictime1]] |
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
| Строка 108: | Строка 109: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#periodictime|periodictime2]] |
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
| Строка 116: | Строка 117: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#maxduration|maxduration]] |
|int(11) | |int(11) | ||
| | | | ||
| Строка 124: | Строка 125: | ||
| | | | ||
|- | |- | ||
| - | |[[#remaintime| | + | |[[#remaintime|remaintime]] |
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
| - | + | ||
|int(11) | |int(11) | ||
| | | | ||
| Строка 142: | Строка 135: | ||
|[[#effIndexMask|effIndexMask]] | |[[#effIndexMask|effIndexMask]] | ||
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
| Строка 153: | Строка 146: | ||
<big>'''Описание полей'''</big> | <big>'''Описание полей'''</big> | ||
====guid==== | ====guid==== | ||
| - | The GUID of the target affected by the aura. See [[characters#guid|characters.guid]] | + | The GUID of the target affected by the aura. See [[characters#guid|characters.guid]]. |
====caster_guid==== | ====caster_guid==== | ||
| - | The GUID of the player or creature who casted the aura. See [[characters#guid|characters.guid]] | + | The GUID of the player or creature who casted the aura. See [[characters#guid|characters.guid]]. |
| + | ====item_guid==== | ||
====spell==== | ====spell==== | ||
| - | The spell from which the aura was applied. See [[Spell.dbc]] column 1 | + | The spell from which the aura was applied. See [[Spell.dbc]] column 1. |
| - | ==== | + | ====stackcount==== |
| - | + | ====remaincharges==== | |
| - | ==== | + | ====basepoints==== |
| - | + | ====periodictime==== | |
====maxduration==== | ====maxduration==== | ||
| - | |||
====remaintime==== | ====remaintime==== | ||
| - | + | ====effIndexMask==== | |
| - | ==== | + | |
| - | + | ||
| - | + | ||
| - | + | ||
Текущая версия на 11:36, 1 апреля 2011
|
К описанию таблиц базы данных 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 | Global Unique Identifier |
| caster_guid | bigint(20) | unsigned | NO | PRI | 0 | Full Global Unique Identifier |
| item_guid | int(11) | unsigned | NO | PRI | 0 | |
| spell | int(11) | unsigned | NO | PRI | 0 | |
| stackcount | int(11) | unsigned | NO | 1 | ||
| remaincharges | int(11) | unsigned | NO | 0 | ||
| basepoints0 | int(11) | NO | 0 | |||
| basepoints1 | int(11) | NO | 0 | |||
| basepoints2 | int(11) | NO | 0 | |||
| periodictime0 | int(11) | unsigned | NO | 0 | ||
| periodictime1 | int(11) | unsigned | NO | 0 | ||
| periodictime2 | int(11) | unsigned | NO | 0 | ||
| maxduration | int(11) | NO | 0 | |||
| remaintime | int(11) | NO | 0 | |||
| effIndexMask | int(11) | unsigned | NO | 0 |
Описание полей
guid
The GUID of the target affected by the aura. See characters.guid.
caster_guid
The GUID of the player or creature who casted the aura. See characters.guid.
item_guid
spell
The spell from which the aura was applied. See Spell.dbc column 1.
