Character spell cooldown
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| Строка 20: | Строка 20: | ||
|'''Extra''' | |'''Extra''' | ||
|- | |- | ||
| - | |[[# | + | |[[#guid|guid]] |
|int(11) unsigned | |int(11) unsigned | ||
|NO | |NO | ||
| Строка 65: | Строка 65: | ||
<big>'''Description of the fields'''</big> | <big>'''Description of the fields'''</big> | ||
| - | ==== | + | ====guid==== |
The GUID of the character. See [[Characters#guid|Characters.guid]] | The GUID of the character. See [[Characters#guid|Characters.guid]] | ||
Текущая версия на 05:56, 29 января 2019
|
К описанию таблиц базы данных 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 |
| guid | 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 Characters.guid
SpellId
The spell ID. See Spell.dbc column 1
SpellExpireTime
The time when the spell cooldown will finish, measured in Unix time
Category
Category.
CategoryExpireTime
The time when the category cooldown will finish, measured in Unix time
ItemId
If the spell was casted from an item, the item ID. See item_template.entry
