From b9fb7554c5eb88aa982011eeddea331c69efc0a3 Mon Sep 17 00:00:00 2001 From: Machiavelli Date: Sat, 4 Dec 2010 18:29:14 +0100 Subject: 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 --- sql/base/world_database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'sql/base/world_database.sql') 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; -- cgit v1.2.3