Playercooldowns

From ArcEmu-Wiki
Jump to: navigation, search

Contents

player_guid

The Guid of the player.

cooldown_type

The type of cooldown.
0 is spell
1 is item
2 is category

cooldown_misc

The spellid/itemid or category

cooldown_expire_time

Time until the cooldown expires.
It's in unix format.

cooldown_spellid

Spellid that casts it.

cooldown_itemid

Itemid that casts it

SQL Structure

CREATE TABLE `playercooldowns` (
  `player_guid` int(30) NOT NULL,
  `cooldown_type` int(30) NOT NULL COMMENT '0 is spell, 1 is item, 2 is spell category',
  `cooldown_misc` int(30) NOT NULL COMMENT 'spellid/itemid/category',
  `cooldown_expire_time` int(30) NOT NULL COMMENT 'expiring time in unix epoch format',
  `cooldown_spellid` int(30) NOT NULL COMMENT 'spell that cast it',
  `cooldown_itemid` int(30) NOT NULL COMMENT 'item that cast it'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Personal tools