playercooldowns

This table contains the cooldowns for the characters.

Structure

Field Type Default Comment
player_guid int(30)    
cooldown_type int(30)    
cooldown_misc int(30)    
cooldown_expire_time int(30)    
cooldown_spellid int(30)    
cooldown_itemid int(30)    

player_guid

The character GUID from the characters table.

cooldown_type

The type of cooldown.

0 = Spell (single)
1 = Item
2 = Spell (category)

cooldown_misc

This field depends on the cooldown_type.

cooldown_type = 0 → Spell ID
cooldown_type = 1 → Item GUID
cooldown_type = 2 → Spell category ID

cooldown_expire_time

The time when the cooldown expires, stored in Unix epoch format.

cooldown_spellid

The spell associated with the cooldown.

cooldown_itemid

The item associated with the cooldown.