*added code for loading Spelldifficulty.dbc + Custom Spelldifficulty from Database

*added spell searcher based on creature's map difficulty, usage is optional and only for scipts for now
*added new table spelldifficulty_dbc

--HG--
branch : trunk

1 files changed, 9 insertions, 0 deletions

diff --git a/sql/updates/7815_world_spelldifficulty_dbc.sql b/sql/updates/7815_world_spelldifficulty_dbc.sql
new file mode 100644
index 00000000000..2c91beaefbb
--- /dev/null
+++ b/sql/updates/7815_world_spelldifficulty_dbc.sql
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS `spelldifficulty_dbc`;
+CREATE TABLE `spelldifficulty_dbc` (
+  `id` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid0` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid1` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid2` int(11) unsigned NOT NULL DEFAULT '0',
+  `spellid3` int(11) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;