Character spell cooldown
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
Строка 25: | Строка 25: | ||
|PRI | |PRI | ||
|0 | |0 | ||
- | | | + | |Global Unique Identifier, Low part |
|- | |- | ||
|[[#SpellId|SpellId]] | |[[#SpellId|SpellId]] | ||
Строка 32: | Строка 32: | ||
|PRI | |PRI | ||
|0 | |0 | ||
- | | | + | |Spell Identifier |
|- | |- | ||
|[[#SpellExpireTime|SpellExpireTime]] | |[[#SpellExpireTime|SpellExpireTime]] | ||
Строка 39: | Строка 39: | ||
| | | | ||
|0 | |0 | ||
- | | | + | |Spell cooldown expire time |
|- | |- | ||
|[[#Category|Category]] | |[[#Category|Category]] | ||
|int(11) unsigned | |int(11) unsigned | ||
|NO | |NO | ||
- | | | + | | |
|0 | |0 | ||
- | | | + | |Spell category |
|- | |- | ||
|[[#CategoryExpireTime|CategoryExpireTime]] | |[[#CategoryExpireTime|CategoryExpireTime]] | ||
Строка 53: | Строка 53: | ||
| | | | ||
|0 | |0 | ||
- | | | + | |Spell category cooldown expire time |
|- | |- | ||
|[[#ItemId|ItemId]] | |[[#ItemId|ItemId]] | ||
Строка 60: | Строка 60: | ||
| | | | ||
|0 | |0 | ||
- | | | + | |Item Identifier |
|} | |} | ||
Версия 08:26, 5 сентября 2017
|
К описанию таблиц базы данных characters.
The `character_spell_cooldown` table
Holds the remaining cooldowns from either character spells or item spells for each character.
Structure
Field | Type | Null | Key | Default | Extra |
LowGuid | int(11) unsigned | NO | PRI | 0 | Global Unique Identifier, Low part |
SpellId | int(11) unsigned | NO | PRI | 0 | Spell Identifier |
SpellExpireTime | bigint(20) unsigned | NO | 0 | Spell cooldown expire time | |
Category | int(11) unsigned | NO | 0 | Spell category | |
CategoryExpireTime | bigint(20) unsigned | NO | 0 | Spell category cooldown expire time | |
ItemId | int(11) unsigned | NO | 0 | Item Identifier |
Description of the fields
guid
The GUID of the character. See character.guid
spell
The spell ID. See Spell.dbc column 1
item
If the spell was casted from an item, the item ID. See item_template.entry
time
The time when the spell cooldown will finish, measured in Unix time