aboutsummaryrefslogtreecommitdiff
path: root/sql/base/world_database.sql
diff options
context:
space:
mode:
authorMachiavelli <none@none>2010-12-04 18:29:14 +0100
committerMachiavelli <none@none>2010-12-04 18:29:14 +0100
commitb9fb7554c5eb88aa982011eeddea331c69efc0a3 (patch)
treef33aeb09b8a8285fd9b5260aeaf194cdb1a61422 /sql/base/world_database.sql
parent3240a4ec33f9a0df47b374b055d54e00f0de6a68 (diff)
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
Diffstat (limited to 'sql/base/world_database.sql')
-rw-r--r--sql/base/world_database.sql2
1 files changed, 2 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;