Character spell cooldown
Материал из YTDB DataBase
(Различия между версиями)
NeatElves (Обсуждение | вклад) |
NeatElves (Обсуждение | вклад) |
||
| Строка 20: | Строка 20: | ||
|'''Extra''' | |'''Extra''' | ||
|- | |- | ||
| - | |[[# | + | |[[#LowGuid|LowGuid]] |
|int(11) unsigned | |int(11) unsigned | ||
|NO | |NO | ||
| Строка 27: | Строка 27: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#SpellId|SpellId]] |
|int(11) unsigned | |int(11) unsigned | ||
|NO | |NO | ||
| Строка 34: | Строка 34: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#SpellExpireTime|SpellExpireTime]] |
| - | | | + | |bigint(20) unsigned |
|NO | |NO | ||
| | | | ||
| Строка 41: | Строка 41: | ||
| | | | ||
|- | |- | ||
| - | |[[# | + | |[[#Category|Category]] |
| + | |int(11) unsigned | ||
| + | |NO | ||
| + | |PRI | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#CategoryExpireTime|CategoryExpireTime]] | ||
|bigint(20) unsigned | |bigint(20) unsigned | ||
| + | |NO | ||
| + | | | ||
| + | |0 | ||
| + | | | ||
| + | |- | ||
| + | |[[#ItemId|ItemId]] | ||
| + | |int(11) unsigned | ||
|NO | |NO | ||
| | | | ||
Версия 08:24, 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 | |
| SpellId | int(11) unsigned | NO | PRI | 0 | |
| SpellExpireTime | bigint(20) unsigned | NO | 0 | ||
| Category | int(11) unsigned | NO | PRI | 0 | |
| CategoryExpireTime | bigint(20) unsigned | NO | 0 | ||
| ItemId | int(11) unsigned | NO | 0 |
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
