Pet aura
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| (5 промежуточных версий не показаны.) | |||
| Строка 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 | ||
| + | |Full Global Unique Identifier | ||
| + | |- | ||
| + | |[[#item_guid|item_guid]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | |PRI | ||
|0 | |0 | ||
| | | | ||
| Строка 44: | Строка 53: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#stackcount|stackcount]] |
|int(11) | |int(11) | ||
|unsigned | |unsigned | ||
|NO | |NO | ||
| - | | | + | | |
| + | |1 | ||
| + | | | ||
| + | |- | ||
| + | |[[#remaincharges|remaincharges]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
|0 | |0 | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#basepoints|basepoints0]] |
|int(11) | |int(11) | ||
| | | | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#basepoints|basepoints1]] | ||
| + | |int(11) | ||
| + | | | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#basepoints|basepoints2]] | ||
| + | |int(11) | ||
| + | | | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#periodictime|periodictime0]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#periodictime|periodictime1]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#periodictime|periodictime2]] | ||
| + | |int(11) | ||
| + | |unsigned | ||
|NO | |NO | ||
| | | | ||
| Строка 76: | Строка 133: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#effIndexMask|effIndexMask]] |
|int(11) | |int(11) | ||
| - | | | + | |unsigned |
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| | | | ||
| + | |- | ||
|} | |} | ||
| Строка 88: | Строка 146: | ||
<big>'''Описание полей'''</big> | <big>'''Описание полей'''</big> | ||
====guid==== | ====guid==== | ||
| - | The GUID of the target affected by the aura. See [[ | + | 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 [[ | + | 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.
