Core/Disables: Add flags SPELL_DISABLE_MAP and SPELL_DISABLE_AREA for sourceType DISABLE_TYPE_SPELL.

This will allow you to disable spells on certain maps/areas. Note that you must have at least flag SPELL_DISABLE_PLAYER or SPELL_DISABLE_CREATURE or SPELL_DISABLE_PET set too, as they take preference.
The parameters for mapIds and areaIds are defined in new columns params_0 and params_1 respectively, in a comma-seperated string.

Example:
INSERT INTO disables VALUES(0, 8921, (1+16+32), "571,1", "1519", "Moonfire Example");

This will disable spell moonfire for players in maps 571,1 and area 1519.

--HG--
branch : trunk

2 files changed, 5 insertions, 0 deletions

diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 72970b0d351..4265dc0434b 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -1852,6 +1852,8 @@ CREATE TABLE `disables` (
   `sourceType` int(10) unsigned NOT NULL,
   `entry` int(10) unsigned NOT NULL,
   `flags` tinyint(3) unsigned NOT NULL default '0',
+  `params_0` varchar(255) NOT NULL default '',
+  `params_1` varchar(255) NOT NULL default '',
   `comment` varchar(255) character set utf8 NOT NULL default '',
   PRIMARY KEY  (`sourceType`,`entry`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
diff --git a/sql/updates/10570_world_disables.sql b/sql/updates/10570_world_disables.sql
new file mode 100644
index 00000000000..a7e1a961d4a
--- /dev/null
+++ b/sql/updates/10570_world_disables.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `disables` 
+ADD COLUMN params_0 varchar (255) NOT NULL default '' AFTER flags,
+ADD COLUMN params_1 VARCHAR (255) NOT NULL default '' AFTER params_0;