root/trunk/sql/updates/90_world.sql @ 85

Revision 85, 361 bytes (checked in by yumileroy, 17 years ago)

[svn] Implement a new table (spell_disabled) to allow disabling some spells for players and / or creatures. To disable a spell for a players and pets, set 20 in the disable_mask, to disable for creatures, set 21. The comment field is optional. Original patch provided by Craker.

Original author: w12x
Date: 2008-10-21 03:58:38-05:00
Line 
1DROP TABLE IF EXISTS `spell_disabled`;
2CREATE TABLE `spell_disabled` (
3  `entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry',
4  `disable_mask` int(8) unsigned NOT NULL default '0',
5  `comment` varchar(64) NOT NULL default '',
6  PRIMARY KEY  (`entry`)
7) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System';
Note: See TracBrowser for help on using the browser.