[8169] Implement new optional table `spell_check` and console command .debug spellcheck Author: VladimirMangos

    * Table expected to be store data mirror same data in code:
      - explicit spell ids with related expected spell properties like effects, spell family or auras
      - implicit requirements for select some spell sets like spell family masks, icons or visual values
    * For check can be used .debug spellcheck _console_ only command.
    * Main purpose table and related command check code parts for outdated data at client switch.
      It also can be used for check data in patch writing time to be sure code correctness.

--HG--
branch : trunk

1 files changed, 48 insertions, 0 deletions

diff --git a/sql/mangos_spell_check.sql b/sql/mangos_spell_check.sql
new file mode 100644
index 00000000000..5f34ffdc64e
--- /dev/null
+++ b/sql/mangos_spell_check.sql
@@ -0,0 +1,48 @@
+/* This file contain expected by code spell properties from simple existance to spell family mask and icons. */
+
+/* This data let easy detect spell properties change at client version       */
+/* support switch and update or drop problematic code associated with checked*/
+/* spell data.                                                               */
+
+/* sql file not required for server work but expected to be applied to       */
+/* MaNGOS DB if you plan use .debug spellcheck command in console.           */
+
+/* To code commiters:                                                        */
+/*                                                                           */
+/* If you commit code that include explicit used spell id or checks base at  */
+/* spell family mask (and etc) please include same data in this table always.*/
+/* At least for parts already added in table.                                */
+/* File not required sql updates way to support, and always expected full    */
+/* re-adding before command use. So need just adding new line to file.       */
+
+/* Current table fill progress state:                                        */
+/* SpellEffect.cpp from start until end of Spell::EffectInstaKill            */
+
+DROP TABLE IF EXISTS spell_check;
+CREATE TABLE `spell_check` (
+  spellid           mediumint(7) unsigned NOT NULL default '0',
+  SpellFamilyName   smallint(5) NOT NULL default '-1',
+  SpellFamilyMaskA  bigint(30)  NOT NULL default '-1', /* 0xFFFFFFFFFFFFFFFF */
+  SpellFamilyMaskB  int(10)     NOT NULL default '-1', /* 0xFFFFFFFF         */
+  SpellIcon         int(10)     NOT NULL default '-1',
+  SpellVisual       int(10)     NOT NULL default '-1',
+  SpellCategory     int(10)     NOT NULL default '-1',
+  EffectType        int(10)     NOT NULL default '-1',
+  EffectAura        int(10)     NOT NULL default '-1',
+  EffectIdx         tinyint(3)  NOT NULL default '-1',
+  Name              varchar(40) NOT NULL default '',
+  Code              varchar(40) NOT NULL default '',
+  PRIMARY KEY (spellid,SpellFamilyName,SpellFamilyMaskA,SpellFamilyMaskB,SpellIcon,SpellVisual,SpellCategory,Code)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+INSERT INTO spell_check (spellid,SpellFamilyName,SpellFamilyMaskA,SpellFamilyMaskB,SpellIcon,SpellVisual,SpellCategory,EffectType,EffectAura,EffectIdx,Name,Code) VALUES
+/* sorted by spell ids */
+/*id   fm familyMaskA        fmMaskB    icon vis  cat  eff aur ef name                                  code                   */
+(18788,-1,                -1,        -1,  -1,  -1,  -1,  1, -1,-1,'Demonic Sacrifice',                  'Spell::EffectInstaKill'),
+(18789,-1,                -1,        -1,  -1,  -1,  -1, -1, -1,-1,'',                                   'Spell::EffectInstaKill'),
+(18790,-1,                -1,        -1,  -1,  -1,  -1, -1, -1,-1,'',                                   'Spell::EffectInstaKill'),
+(18791,-1,                -1,        -1,  -1,  -1,  -1, -1, -1,-1,'',                                   'Spell::EffectInstaKill'),
+(18792,-1,                -1,        -1,  -1,  -1,  -1, -1, -1,-1,'',                                   'Spell::EffectInstaKill');
+/* sorted by spell names */
+/*id   fm familyMaskA        fmMaskB    icon vis  cat  eff aur ef name                                  code                   */
+/* no at this moment                                                                                                           */