From b9fb7554c5eb88aa982011eeddea331c69efc0a3 Mon Sep 17 00:00:00 2001
From: Machiavelli <none@none>
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

