Back to 'character_spell' Return to characters Go to 'character_stats'
Holds the remaining cooldowns from either character spells or item spells for each character.
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | int | unsigned | PRI | NO | 0 | Global Unique Identifier, Low part | |
| spell | mediumint | unsigned | PRI | NO | 0 | Spell Identifier | |
| item | int | unsigned | NO | 0 | Item Identifier | ||
| time | int | unsigned | NO | 0 | |||
| categoryId | int | unsigned | NO | 0 | Spell category Id | ||
| categoryEnd | int | unsigned | NO | 0 |
The GUID of the character
The Spell ID taken from first column in spell.dbc
If the spell was casted from an item, the item ID. See item_template.entry
The time when the spell cooldown will finish, measured in Unix time
The Spells category ID (if any) taken from spell.dbc column 2. Used for category cooldown handling.
The time when the category cooldown will finish, measured in Unix time
Back to 'character_spell' Return to characters Go to 'character_stats'