Character spell cooldown
Материал из YTDB DataBase
(Различия между версиями)
Neggod (Обсуждение | вклад) (Новая страница: «{| align="right" | __TOC__ |} Back to the characters database list of tables. <big>'''The `character_spell_cooldown` table'''</big> Holds …») |
NeatElves (Обсуждение | вклад) |
||
| (7 промежуточных версий не показаны.) | |||
| Строка 2: | Строка 2: | ||
| __TOC__ | | __TOC__ | ||
|} | |} | ||
| - | + | [[Category: Mangos characters database tables]] | |
| + | К описанию таблиц [[Charactersdb_struct|базы данных characters]]. | ||
| Строка 24: | Строка 25: | ||
|PRI | |PRI | ||
|0 | |0 | ||
| - | | | + | |Global Unique Identifier, Low part |
|- | |- | ||
| - | |[[# | + | |[[#SpellId|SpellId]] |
|int(11) unsigned | |int(11) unsigned | ||
|NO | |NO | ||
|PRI | |PRI | ||
|0 | |0 | ||
| + | |Spell Identifier | ||
| + | |- | ||
| + | |[[#SpellExpireTime|SpellExpireTime]] | ||
| + | |bigint(20) unsigned | ||
| + | |NO | ||
| | | | ||
| + | |0 | ||
| + | |Spell cooldown expire time | ||
|- | |- | ||
| - | |[[# | + | |[[#Category|Category]] |
|int(11) unsigned | |int(11) unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| - | | | + | |Spell category |
|- | |- | ||
| - | |[[# | + | |[[#CategoryExpireTime|CategoryExpireTime]] |
|bigint(20) unsigned | |bigint(20) unsigned | ||
|NO | |NO | ||
| | | | ||
|0 | |0 | ||
| + | |Spell category cooldown expire time | ||
| + | |- | ||
| + | |[[#ItemId|ItemId]] | ||
| + | |int(11) unsigned | ||
| + | |NO | ||
| | | | ||
| + | |0 | ||
| + | |Item Identifier | ||
|} | |} | ||
| Строка 51: | Строка 66: | ||
<big>'''Description of the fields'''</big> | <big>'''Description of the fields'''</big> | ||
====guid==== | ====guid==== | ||
| - | The GUID of the character. See [[ | + | The GUID of the character. See [[Characters#guid|Characters.guid]] |
| - | ==== | + | |
| + | ====SpellId==== | ||
The spell ID. See Spell.dbc column 1 | The spell ID. See Spell.dbc column 1 | ||
| - | + | ||
| - | + | ====SpellExpireTime==== | |
| - | ==== | + | |
The time when the spell cooldown will finish, measured in [http://en.wikipedia.org/wiki/Unix_time Unix time] | The time when the spell cooldown will finish, measured in [http://en.wikipedia.org/wiki/Unix_time Unix time] | ||
| - | + | ====Category==== | |
| + | Category. | ||
| + | |||
| + | ====CategoryExpireTime==== | ||
| + | The time when the category cooldown will finish, measured in [http://en.wikipedia.org/wiki/Unix_time Unix time] | ||
| + | |||
| + | ====ItemId==== | ||
| + | If the spell was casted from an item, the item ID. See [[item_template#entry|item_template.entry]] | ||
Текущая версия на 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
