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/updates/10570_world_disables.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 sql/updates/10570_world_disables.sql (limited to 'sql/updates') 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; -- cgit v1.2.3