[7349] Implement spell cast depenences from area/quest.aura state store in new table `spell_area`. Author: VladimirMangos

    * It allow store requirenments: area, active or rewarded quest (until possible another quest not rewarded),
      aura present at character, character race/gender.
    * Listed spell can marked as auto-casted when fit requirents. In this case spell requirements checked at
      zone/subzone update (and then resurraction also), quest start/reward, dummy aura apply.
    * Old hardcoded lines for similar check removed from sources and required DB support for work now.

--HG--
branch : trunk

1 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/7349_01_mangos_spell_area.sql b/sql/updates/7349_01_mangos_spell_area.sql
new file mode 100644
index 00000000000..969fff950ae
--- /dev/null
+++ b/sql/updates/7349_01_mangos_spell_area.sql
@@ -0,0 +1,15 @@
+ALTER TABLE db_version CHANGE COLUMN required_7332_01_mangos_command required_7349_01_mangos_spell_area bit;
+
+DROP TABLE IF EXISTS `spell_area`;
+CREATE TABLE `spell_area` (
+  `spell`              mediumint(8) unsigned NOT NULL default '0',
+  `area`               mediumint(8) unsigned NOT NULL default '0',
+  `quest_start`        mediumint(8) unsigned NOT NULL default '0',
+  `quest_start_active` tinyint(1) unsigned NOT NULL default '0',
+  `quest_end`          mediumint(8) unsigned NOT NULL default '0',
+  `aura_spell`         mediumint(8) unsigned NOT NULL default '0',
+  `racemask`           mediumint(8) unsigned NOT NULL default '0',
+  `gender`             tinyint(1) unsigned NOT NULL default '2',
+  `autocast`           tinyint(1) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`spell`,`area`,`quest_start`,`quest_start_active`,`aura_spell`,`racemask`,`gender`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;