From 1efb3f08e278530f59d681f676b031a7fc6db3ac Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 10 Sep 2015 19:39:30 +0200 Subject: Core/Spells: Improved spell category cooldown handling * Category cooldown is stored with the spell that started the cooldown (and only resetting cooldown on that spell will clear cooldowns on entire category - this fully mirrors client behavior) * This significantly reduces the amount of data saved to database for cooldowns * Spell casts from items that have a different category specified than on spell will now check for cooldown during the cast Closes #15349 --- sql/updates/characters/2015_09_10_00_characters.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/characters/2015_09_10_00_characters.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2015_09_10_00_characters.sql b/sql/updates/characters/2015_09_10_00_characters.sql new file mode 100644 index 00000000000..94c9066c6ae --- /dev/null +++ b/sql/updates/characters/2015_09_10_00_characters.sql @@ -0,0 +1,7 @@ +ALTER TABLE `character_spell_cooldown` + ADD `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id' AFTER `time`, + ADD `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0' AFTER `categoryId`; + +ALTER TABLE `pet_spell_cooldown` + ADD `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id' AFTER `time`, + ADD `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0' AFTER `categoryId`; -- cgit v1.2.3