aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorXTZGZoReX <none@none>2008-10-10 15:20:27 -0500
committerXTZGZoReX <none@none>2008-10-10 15:20:27 -0500
commit1e1ba89c4960a76a61ceeeb90d0194b46872ec52 (patch)
treeffab7320c7a117a95e9d4a93370f9a719d90aa3f
parent479fe8b767c833ae5055af31a800738ba8e597ad (diff)
[svn] * Fixing some typos in SQL files.
* Applying proper structure to SQL updates. * Fixing ImpConfig compile problems. * Moving INSTALL to INSTALL.linux to avoid autoconf collisions. --HG-- branch : trunk rename : INSTALL => INSTALL.linux rename : sql/updates/10_instantiated_battlegrounds.sql => sql/updates/10_world.sql rename : sql/updates/11_arena_points_characters.sql => sql/updates/11_characters.sql
-rw-r--r--INSTALL.linux (renamed from INSTALL)0
-rw-r--r--sql/create_mysql.sql10
-rw-r--r--sql/drop_mysql.sql18
-rw-r--r--sql/updates/10_world.sql (renamed from sql/updates/10_instantiated_battlegrounds.sql)0
-rw-r--r--sql/updates/11_characters.sql (renamed from sql/updates/11_arena_points_characters.sql)0
-rw-r--r--sql/updates/34_world.sql4483
-rw-r--r--sql/world.sql2
-rw-r--r--src/game/ObjectMgr.cpp2
-rw-r--r--src/trinityrealm/AuthSocket.cpp7
9 files changed, 4501 insertions, 21 deletions
diff --git a/INSTALL b/INSTALL.linux
index 7a2f7e2ff66..7a2f7e2ff66 100644
--- a/INSTALL
+++ b/INSTALL.linux
diff --git a/sql/create_mysql.sql b/sql/create_mysql.sql
index 5a39665d7e7..f71ced7d07d 100644
--- a/sql/create_mysql.sql
+++ b/sql/create_mysql.sql
@@ -1,14 +1,14 @@
-GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
+GRANT USAGE ON * . * TO 'trinity'@'localhost' IDENTIFIED BY 'trinity' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 ;
-CREATE DATABASE `mangos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
+CREATE DATABASE `world` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE `realmd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
-GRANT ALL PRIVILEGES ON `mangos` . * TO 'mangos'@'localhost' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON `world` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON `characters` . * TO 'mangos'@'localhost' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON `characters` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON `realmd` . * TO 'mangos'@'localhost' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON `realmd` . * TO 'trinity'@'localhost' WITH GRANT OPTION;
diff --git a/sql/drop_mysql.sql b/sql/drop_mysql.sql
index 4ed3f55472e..1f2bf090ef8 100644
--- a/sql/drop_mysql.sql
+++ b/sql/drop_mysql.sql
@@ -1,20 +1,20 @@
-REVOKE ALL PRIVILEGES ON * . * FROM 'mangos'@'localhost';
+REVOKE ALL PRIVILEGES ON * . * FROM 'trinity'@'localhost';
-REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'mangos'@'localhost';
+REVOKE ALL PRIVILEGES ON `mangos` . * FROM 'trinity'@'localhost';
-REVOKE GRANT OPTION ON `mangos` . * FROM 'mangos'@'localhost';
+REVOKE GRANT OPTION ON `mangos` . * FROM 'trinity'@'localhost';
-REVOKE ALL PRIVILEGES ON `characters` . * FROM 'mangos'@'localhost';
+REVOKE ALL PRIVILEGES ON `characters` . * FROM 'trinity'@'localhost';
-REVOKE GRANT OPTION ON `characters` . * FROM 'mangos'@'localhost';
+REVOKE GRANT OPTION ON `characters` . * FROM 'trinity'@'localhost';
-REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'mangos'@'localhost';
+REVOKE ALL PRIVILEGES ON `realmd` . * FROM 'trinity'@'localhost';
-REVOKE GRANT OPTION ON `realmd` . * FROM 'mangos'@'localhost';
+REVOKE GRANT OPTION ON `realmd` . * FROM 'trinity'@'localhost';
-DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'mangos' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ;
+DELETE FROM `user` WHERE CONVERT( User USING utf8 ) = CONVERT( 'trinity' USING utf8 ) AND CONVERT( Host USING utf8 ) = CONVERT( 'localhost' USING utf8 ) ;
-DROP DATABASE IF EXISTS `mangos` ;
+DROP DATABASE IF EXISTS `world` ;
DROP DATABASE IF EXISTS `characters` ;
diff --git a/sql/updates/10_instantiated_battlegrounds.sql b/sql/updates/10_world.sql
index c3234c3099e..c3234c3099e 100644
--- a/sql/updates/10_instantiated_battlegrounds.sql
+++ b/sql/updates/10_world.sql
diff --git a/sql/updates/11_arena_points_characters.sql b/sql/updates/11_characters.sql
index 348eba197a5..348eba197a5 100644
--- a/sql/updates/11_arena_points_characters.sql
+++ b/sql/updates/11_characters.sql
diff --git a/sql/updates/34_world.sql b/sql/updates/34_world.sql
new file mode 100644
index 00000000000..28a38b57fdc
--- /dev/null
+++ b/sql/updates/34_world.sql
@@ -0,0 +1,4483 @@
+-- This file is only required if "PlayerStart.AllSpells" is enabled in mangosd.conf
+
+
+DROP TABLE IF EXISTS `playercreateinfo_spell_custom`;
+CREATE TABLE `playercreateinfo_spell_custom` (
+ `race` tinyint(3) unsigned NOT NULL default '0',
+ `class` tinyint(3) unsigned NOT NULL default '0',
+ `Spell` mediumint(8) unsigned NOT NULL default '0',
+ `Note` varchar(255) default NULL,
+ `Active` tinyint(3) unsigned NOT NULL default '1',
+ PRIMARY KEY (`race`,`class`,`Spell`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Dumping data for table `playercreateinfo_spell_custom`
+--
+
+LOCK TABLES `playercreateinfo_spell_custom` WRITE;
+/*!40000 ALTER TABLE `playercreateinfo_spell_custom` DISABLE KEYS */;
+INSERT INTO `playercreateinfo_spell_custom` VALUES
+(1,1,78,'Heroic Strike',1),
+(1,1,81,'Dodge',1),
+(1,1,107,'Block',1),
+(1,1,196,'One-Handed Axes',1),
+(1,1,198,'One-Handed Maces',1),
+(1,1,201,'One-Handed Swords',1),
+(1,1,203,'Unarmed',1),
+(1,1,204,'Defense',1),
+(1,1,522,'SPELLDEFENSE(DND)',1),
+(1,1,668,'Language Common',1),
+(1,1,2382,'Generic',1),
+(1,1,2457,'Battle Stance',1),
+(1,1,2479,'Honorless Target',1),
+(1,1,3050,'Detect',1),
+(1,1,3365,'Opening',1),
+(1,1,5301,'Defensive State(DND)',1),
+(1,1,6233,'Closing',1),
+(1,1,6246,'Closing',1),
+(1,1,6247,'Opening',1),
+(1,1,6477,'Opening',1),
+(1,1,6478,'Opening',1),
+(1,1,6603,'Attack',1),
+(1,1,7266,'Duel',1),
+(1,1,7267,'Grovel',1),
+(1,1,7355,'Stuck',1),
+(1,1,7376,'Defensive Stance Passive',0),
+(1,1,7381,'Berserker Stance Passive',0),
+(1,1,8386,'Attacking',1),
+(1,1,8737,'Mail',1),
+(1,1,9077,'Leather',1),
+(1,1,9078,'Cloth',1),
+(1,1,9116,'Shield',1),
+(1,1,9125,'Generic',1),
+(1,1,20597,'Sword Specialization',1),
+(1,1,20598,'The Human Spirit',1),
+(1,1,20599,'Diplomacy',1),
+(1,1,20600,'Perception',1),
+(1,1,20864,'Mace Specialization',1),
+(1,1,21156,'Battle Stance Passive',0),
+(1,1,21651,'Opening',1),
+(1,1,21652,'Closing',1),
+(1,1,22027,'Remove Insignia',1),
+(1,1,22810,'Opening - No Text',1),
+(1,1,32215,'Victorious State',1),
+(1,2,81,'Dodge',1),
+(1,2,107,'Block',1),
+(1,2,198,'One-Handed Maces',1),
+(1,2,199,'Two-Handed Maces',1),
+(1,2,203,'Unarmed',1),
+(1,2,204,'Defense',1),
+(1,2,522,'SPELLDEFENSE(DND)',1),
+(1,2,635,'Holy Light',1),
+(1,2,668,'Language Common',1),
+(1,2,2382,'Generic',1),
+(1,2,2479,'Honorless Target',1),
+(1,2,3050,'Detect',1),
+(1,2,3365,'Opening',1),
+(1,2,6233,'Closing',1),
+(1,2,6246,'Closing',1),
+(1,2,6247,'Opening',1),
+(1,2,6477,'Opening',1),
+(1,2,6478,'Opening',1),
+(1,2,6603,'Attack',1),
+(1,2,7266,'Duel',1),
+(1,2,7267,'Grovel',1),
+(1,2,7355,'Stuck',1),
+(1,2,8386,'Attacking',1),
+(1,2,8737,'Mail',1),
+(1,2,9077,'Leather',1),
+(1,2,9078,'Cloth',1),
+(1,2,9116,'Shield',1),
+(1,2,9125,'Generic',1),
+(1,2,21084,'Seal of Righteousness',1),
+(1,2,20597,'Sword Specialization',1),
+(1,2,20598,'The Human Spirit',1),
+(1,2,20599,'Diplomacy',1),
+(1,2,20600,'Perception',1),
+(1,2,20864,'Mace Specialization',1),
+(1,2,21651,'Opening',1),
+(1,2,21652,'Closing',1),
+(1,2,22027,'Remove Insignia',1),
+(1,2,22810,'Opening - No Text',1),
+(1,2,27762,'Libram',1),
+(1,4,81,'Dodge',1),
+(1,4,203,'Unarmed',1),
+(1,4,204,'Defense',1),
+(1,4,522,'SPELLDEFENSE(DND)',1),
+(1,4,668,'Language Common',1),
+(1,4,1180,'Daggers',1),
+(1,4,1752,'Sinister Strike',1),
+(1,4,2098,'Eviscerate',1),
+(1,4,2382,'Generic',1),
+(1,4,2479,'Honorless Target',1),
+(1,4,2567,'Thrown',1),
+(1,4,2764,'Throw',1),
+(1,4,3050,'Detect',1),
+(1,4,3365,'Opening',1),
+(1,4,6233,'Closing',1),
+(1,4,6246,'Closing',1),
+(1,4,6247,'Opening',1),
+(1,4,6477,'Opening',1),
+(1,4,6478,'Opening',1),
+(1,4,6603,'Attack',1),
+(1,4,7266,'Duel',1),
+(1,4,7267,'Grovel',1),
+(1,4,7355,'Stuck',1),
+(1,4,8386,'Attacking',1),
+(1,4,9077,'Leather',1),
+(1,4,9078,'Cloth',1),
+(1,4,9125,'Generic',1),
+(1,4,16092,'Defensive State(DND)',1),
+(1,4,20597,'Sword Specialization',1),
+(1,4,20598,'The Human Spirit',1),
+(1,4,20599,'Diplomacy',1),
+(1,4,20600,'Perception',1),
+(1,4,20864,'Mace Specialization',1),
+(1,4,21184,'Rogue Passive(DND)',1),
+(1,4,21651,'Opening',1),
+(1,4,21652,'Closing',1),
+(1,4,22027,'Remove Insignia',1),
+(1,4,22810,'Opening - No Text',1),
+(1,5,81,'Dodge',1),
+(1,5,198,'One-Handed Maces',1),
+(1,5,203,'Unarmed',1),
+(1,5,204,'Defense',1),
+(1,5,522,'SPELLDEFENSE(DND)',1),
+(1,5,585,'Smite',1),
+(1,5,668,'Language Common',1),
+(1,5,2050,'Lesser Heal',1),
+(1,5,2382,'Generic',1),
+(1,5,2479,'Honorless Target',1),
+(1,5,3050,'Detect',1),
+(1,5,3365,'Opening',1),
+(1,5,5009,'Wands',1),
+(1,5,5019,'Shoot',1),
+(1,5,6233,'Closing',1),
+(1,5,6246,'Closing',1),
+(1,5,6247,'Opening',1),
+(1,5,6477,'Opening',1),
+(1,5,6478,'Opening',1),
+(1,5,6603,'Attack',1),
+(1,5,7266,'Duel',1),
+(1,5,7267,'Grovel',1),
+(1,5,7355,'Stuck',1),
+(1,5,8386,'Attacking',1),
+(1,5,9078,'Cloth',1),
+(1,5,9125,'Generic',1),
+(1,5,20597,'Sword Specialization',1),
+(1,5,20598,'The Human Spirit',1),
+(1,5,20599,'Diplomacy',1),
+(1,5,20600,'Perception',1),
+(1,5,20864,'Mace Specialization',1),
+(1,5,21651,'Opening',1),
+(1,5,21652,'Closing',1),
+(1,5,22027,'Remove Insignia',1),
+(1,5,22810,'Opening - No Text',1),
+(1,8,81,'Dodge',1),
+(1,8,133,'Fireball',1),
+(1,8,168,'Frost Armor',1),
+(1,8,203,'Unarmed',1),
+(1,8,204,'Defense',1),
+(1,8,227,'Staves',1),
+(1,8,522,'SPELLDEFENSE(DND)',1),
+(1,8,668,'Language Common',1),
+(1,8,2382,'Generic',1),
+(1,8,2479,'Honorless Target',1),
+(1,8,3050,'Detect',1),
+(1,8,3365,'Opening',1),
+(1,8,5009,'Wands',1),
+(1,8,5019,'Shoot',1),
+(1,8,6233,'Closing',1),
+(1,8,6246,'Closing',1),
+(1,8,6247,'Opening',1),
+(1,8,6477,'Opening',1),
+(1,8,6478,'Opening',1),
+(1,8,6603,'Attack',1),
+(1,8,7266,'Duel',1),
+(1,8,7267,'Grovel',1),
+(1,8,7355,'Stuck',1),
+(1,8,8386,'Attacking',1),
+(1,8,9078,'Cloth',1),
+(1,8,9125,'Generic',1),
+(1,8,20597,'Sword Specialization',1),
+(1,8,20598,'The Human Spirit',1),
+(1,8,20599,'Diplomacy',1),
+(1,8,20600,'Perception',1),
+(1,8,20864,'Mace Specialization',1),
+(1,8,21651,'Opening',1),
+(1,8,21652,'Closing',1),
+(1,8,22027,'Remove Insignia',1),
+(1,8,22810,'Opening - No Text',1),
+(1,9,81,'Dodge',1),
+(1,9,203,'Unarmed',1),
+(1,9,204,'Defense',1),
+(1,9,522,'SPELLDEFENSE(DND)',1),
+(1,9,668,'Language Common',1),
+(1,9,686,'Shadow Bolt',1),
+(1,9,687,'Demon Skin',1),
+(1,9,1180,'Daggers',1),
+(1,9,2382,'Generic',1),
+(1,9,2479,'Honorless Target',1),
+(1,9,3050,'Detect',1),
+(1,9,3365,'Opening',1),
+(1,9,5009,'Wands',1),
+(1,9,5019,'Shoot',1),
+(1,9,6233,'Closing',1),
+(1,9,6246,'Closing',1),
+(1,9,6247,'Opening',1),
+(1,9,6477,'Opening',1),
+(1,9,6478,'Opening',1),
+(1,9,6603,'Attack',1),
+(1,9,7266,'Duel',1),
+(1,9,7267,'Grovel',1),
+(1,9,7355,'Stuck',1),
+(1,9,8386,'Attacking',1),
+(1,9,9078,'Cloth',1),
+(1,9,9125,'Generic',1),
+(1,9,20597,'Sword Specialization',1),
+(1,9,20598,'The Human Spirit',1),
+(1,9,20599,'Diplomacy',1),
+(1,9,20600,'Perception',1),
+(1,9,20864,'Mace Specialization',1),
+(1,9,21651,'Opening',1),
+(1,9,21652,'Closing',1),
+(1,9,22027,'Remove Insignia',1),
+(1,9,22810,'Opening - No Text',1),
+(2,1,78,'Heroic Strike',1),
+(2,1,81,'Dodge',1),
+(2,1,107,'Block',1),
+(2,1,196,'One-Handed Axes',1),
+(2,1,197,'Two-Handed Axes',1),
+(2,1,201,'One-Handed Swords',1),
+(2,1,203,'Unarmed',1),
+(2,1,204,'Defense',1),
+(2,1,522,'SPELLDEFENSE(DND)',1),
+(2,1,669,'Language Orcish',1),
+(2,1,2382,'Generic',1),
+(2,1,2457,'Battle Stance',1),
+(2,1,2479,'Honorless Target',1),
+(2,1,3050,'Detect',1),
+(2,1,3365,'Opening',1),
+(2,1,5301,'Defensive State(DND)',1),
+(2,1,6233,'Closing',1),
+(2,1,6246,'Closing',1),
+(2,1,6247,'Opening',1),
+(2,1,6477,'Opening',1),
+(2,1,6478,'Opening',1),
+(2,1,6603,'Attack',1),
+(2,1,7266,'Duel',1),
+(2,1,7267,'Grovel',1),
+(2,1,7355,'Stuck',1),
+(2,1,7376,'Defensive Stance Passive',0),
+(2,1,7381,'Berserker Stance Passive',0),
+(2,1,8386,'Attacking',1),
+(2,1,8737,'Mail',1),
+(2,1,9077,'Leather',1),
+(2,1,9078,'Cloth',1),
+(2,1,9116,'Shield',1),
+(2,1,9125,'Generic',1),
+(2,1,20572,'Blood Fury',1),
+(2,1,20573,'Hardiness',1),
+(2,1,20574,'Axe Specialization',1),
+(2,1,21156,'Battle Stance Passive',0),
+(2,1,21563,'Command',1),
+(2,1,21651,'Opening',1),
+(2,1,21652,'Closing',1),
+(2,1,22027,'Remove Insignia',1),
+(2,1,22810,'Opening - No Text',1),
+(2,1,32215,'Victorious State',1),
+(2,3,75,'Auto Shot',1),
+(2,3,81,'Dodge',1),
+(2,3,196,'One-Handed Axes',1),
+(2,3,203,'Unarmed',1),
+(2,3,204,'Defense',1),
+(2,3,264,'Bows',1),
+(2,3,522,'SPELLDEFENSE(DND)',1),
+(2,3,669,'Language Orcish',1),
+(2,3,2382,'Generic',1),
+(2,3,2479,'Honorless Target',1),
+(2,3,2973,'Raptor Strike',1),
+(2,3,3050,'Detect',1),
+(2,3,3365,'Opening',1),
+(2,3,6233,'Closing',1),
+(2,3,6246,'Closing',1),
+(2,3,6247,'Opening',1),
+(2,3,6477,'Opening',1),
+(2,3,6478,'Opening',1),
+(2,3,6603,'Attack',1),
+(2,3,7266,'Duel',1),
+(2,3,7267,'Grovel',1),
+(2,3,7355,'Stuck',1),
+(2,3,8386,'Attacking',1),
+(2,3,9077,'Leather',1),
+(2,3,9078,'Cloth',1),
+(2,3,9125,'Generic',1),
+(2,3,13358,'Defensive State(DND)',1),
+(2,3,20572,'Blood Fury',1),
+(2,3,20573,'Hardiness',1),
+(2,3,20574,'Axe Specialization',1),
+(2,3,20576,'Command',1),
+(2,3,21651,'Opening',1),
+(2,3,21652,'Closing',1),
+(2,3,22027,'Remove Insignia',1),
+(2,3,22810,'Opening - No Text',1),
+(2,3,24949,'Defensive State 2(DND)',1),
+(2,3,34082,'Advantaged State(DND)',1),
+(2,4,81,'Dodge',1),
+(2,4,203,'Unarmed',1),
+(2,4,204,'Defense',1),
+(2,4,522,'SPELLDEFENSE(DND)',1),
+(2,4,669,'Language Orcish',1),
+(2,4,1180,'Daggers',1),
+(2,4,1752,'Sinister Strike',1),
+(2,4,2098,'Eviscerate',1),
+(2,4,2382,'Generic',1),
+(2,4,2479,'Honorless Target',1),
+(2,4,2567,'Thrown',1),
+(2,4,2764,'Throw',1),
+(2,4,3050,'Detect',1),
+(2,4,3365,'Opening',1),
+(2,4,6233,'Closing',1),
+(2,4,6246,'Closing',1),
+(2,4,6247,'Opening',1),
+(2,4,6477,'Opening',1),
+(2,4,6478,'Opening',1),
+(2,4,6603,'Attack',1),
+(2,4,7266,'Duel',1),
+(2,4,7267,'Grovel',1),
+(2,4,7355,'Stuck',1),
+(2,4,8386,'Attacking',1),
+(2,4,9077,'Leather',1),
+(2,4,9078,'Cloth',1),
+(2,4,9125,'Generic',1),
+(2,4,16092,'Defensive State(DND)',1),
+(2,4,20572,'Blood Fury',1),
+(2,4,20573,'Hardiness',1),
+(2,4,20574,'Axe Specialization',1),
+(2,4,21184,'Rogue Passive(DND)',1),
+(2,4,21563,'Command',1),
+(2,4,21651,'Opening',1),
+(2,4,21652,'Closing',1),
+(2,4,22027,'Remove Insignia',1),
+(2,4,22810,'Opening - No Text',1),
+(2,7,81,'Dodge',1),
+(2,7,107,'Block',1),
+(2,7,198,'One-Handed Maces',1),
+(2,7,203,'Unarmed',1),
+(2,7,204,'Defense',1),
+(2,7,227,'Staves',1),
+(2,7,331,'Healing Wave',1),
+(2,7,403,'Lightning Bolt',1),
+(2,7,522,'SPELLDEFENSE(DND)',1),
+(2,7,669,'Language Orcish',1),
+(2,7,2382,'Generic',1),
+(2,7,2479,'Honorless Target',1),
+(2,7,3050,'Detect',1),
+(2,7,3365,'Opening',1),
+(2,7,6233,'Closing',1),
+(2,7,6246,'Closing',1),
+(2,7,6247,'Opening',1),
+(2,7,6477,'Opening',1),
+(2,7,6478,'Opening',1),
+(2,7,6603,'Attack',1),
+(2,7,7266,'Duel',1),
+(2,7,7267,'Grovel',1),
+(2,7,7355,'Stuck',1),
+(2,7,8386,'Attacking',1),
+(2,7,9077,'Leather',1),
+(2,7,9078,'Cloth',1),
+(2,7,9116,'Shield',1),
+(2,7,9125,'Generic',1),
+(2,7,20573,'Hardiness',1),
+(2,7,20574,'Axe Specialization',1),
+(2,7,21563,'Command',1),
+(2,7,21651,'Opening',1),
+(2,7,21652,'Closing',1),
+(2,7,22027,'Remove Insignia',1),
+(2,7,22810,'Opening - No Text',1),
+(2,7,27763,'Totem',1),
+(2,7,33697,'Blood Fury',1),
+(2,9,81,'Dodge',1),
+(2,9,203,'Unarmed',1),
+(2,9,204,'Defense',1),
+(2,9,522,'SPELLDEFENSE(DND)',1),
+(2,9,669,'Language Orcish',1),
+(2,9,686,'Shadow Bolt',1),
+(2,9,687,'Demon Skin',1),
+(2,9,1180,'Daggers',1),
+(2,9,2382,'Generic',1),
+(2,9,2479,'Honorless Target',1),
+(2,9,3050,'Detect',1),
+(2,9,3365,'Opening',1),
+(2,9,5009,'Wands',1),
+(2,9,5019,'Shoot',1),
+(2,9,6233,'Closing',1),
+(2,9,6246,'Closing',1),
+(2,9,6247,'Opening',1),
+(2,9,6477,'Opening',1),
+(2,9,6478,'Opening',1),
+(2,9,6603,'Attack',1),
+(2,9,7266,'Duel',1),
+(2,9,7267,'Grovel',1),
+(2,9,7355,'Stuck',1),
+(2,9,8386,'Attacking',1),
+(2,9,9078,'Cloth',1),
+(2,9,9125,'Generic',1),
+(2,9,20573,'Hardiness',1),
+(2,9,20574,'Axe Specialization',1),
+(2,9,20575,'Command',1),
+(2,9,21651,'Opening',1),
+(2,9,21652,'Closing',1),
+(2,9,22027,'Remove Insignia',1),
+(2,9,22810,'Opening - No Text',1),
+(2,9,33702,'Blood Fury',1),
+(3,1,78,'Heroic Strike',1),
+(3,1,81,'Dodge',1),
+(3,1,107,'Block',1),
+(3,1,196,'One-Handed Axes',1),
+(3,1,197,'Two-Handed Axes',1),
+(3,1,198,'One-Handed Maces',1),
+(3,1,203,'Unarmed',1),
+(3,1,204,'Defense',1),
+(3,1,522,'SPELLDEFENSE(DND)',1),
+(3,1,668,'Language Common',1),
+(3,1,672,'Language Dwarven',1),
+(3,1,2382,'Generic',1),
+(3,1,2457,'Battle Stance',1),
+(3,1,2479,'Honorless Target',1),
+(3,1,2481,'Find Treasure',1),
+(3,1,3050,'Detect',1),
+(3,1,3365,'Opening',1),
+(3,1,5301,'Defensive State(DND)',1),
+(3,1,6233,'Closing',1),
+(3,1,6246,'Closing',1),
+(3,1,6247,'Opening',1),
+(3,1,6477,'Opening',1),
+(3,1,6478,'Opening',1),
+(3,1,6603,'Attack',1),
+(3,1,7266,'Duel',1),
+(3,1,7267,'Grovel',1),
+(3,1,7355,'Stuck',1),
+(3,1,7376,'Defensive Stance Passive',0),
+(3,1,7381,'Berserker Stance Passive',0),
+(3,1,8386,'Attacking',1),
+(3,1,8737,'Mail',1),
+(3,1,9077,'Leather',1),
+(3,1,9078,'Cloth',1),
+(3,1,9116,'Shield',1),
+(3,1,9125,'Generic',1),
+(3,1,20594,'Stoneform',1),
+(3,1,20595,'Gun Specialization',1),
+(3,1,20596,'Frost Resistance',1),
+(3,1,21156,'Battle Stance Passive',0),
+(3,1,21651,'Opening',1),
+(3,1,21652,'Closing',1),
+(3,1,22027,'Remove Insignia',1),
+(3,1,22810,'Opening - No Text',1),
+(3,1,32215,'Victorious State',1),
+(3,2,81,'Dodge',1),
+(3,2,107,'Block',1),
+(3,2,198,'One-Handed Maces',1),
+(3,2,199,'Two-Handed Maces',1),
+(3,2,203,'Unarmed',1),
+(3,2,204,'Defense',1),
+(3,2,522,'SPELLDEFENSE(DND)',1),
+(3,2,635,'Holy Light',1),
+(3,2,668,'Language Common',1),
+(3,2,672,'Language Dwarven',1),
+(3,2,2382,'Generic',1),
+(3,2,2479,'Honorless Target',1),
+(3,2,2481,'Find Treasure',1),
+(3,2,3050,'Detect',1),
+(3,2,3365,'Opening',1),
+(3,2,6233,'Closing',1),
+(3,2,6246,'Closing',1),
+(3,2,6247,'Opening',1),
+(3,2,6477,'Opening',1),
+(3,2,6478,'Opening',1),
+(3,2,6603,'Attack',1),
+(3,2,7266,'Duel',1),
+(3,2,7267,'Grovel',1),
+(3,2,7355,'Stuck',1),
+(3,2,8386,'Attacking',1),
+(3,2,8737,'Mail',1),
+(3,2,9077,'Leather',1),
+(3,2,9078,'Cloth',1),
+(3,2,9116,'Shield',1),
+(3,2,9125,'Generic',1),
+(3,2,21084,'Seal of Righteousness',1),
+(3,2,20594,'Stoneform',1),
+(3,2,20595,'Gun Specialization',1),
+(3,2,20596,'Frost Resistance',1),
+(3,2,21651,'Opening',1),
+(3,2,21652,'Closing',1),
+(3,2,22027,'Remove Insignia',1),
+(3,2,22810,'Opening - No Text',1),
+(3,2,27762,'Libram',1),
+(3,3,75,'Auto Shot',1),
+(3,3,81,'Dodge',1),
+(3,3,196,'One-Handed Axes',1),
+(3,3,203,'Unarmed',1),
+(3,3,204,'Defense',1),
+(3,3,266,'Guns',1),
+(3,3,522,'SPELLDEFENSE(DND)',1),
+(3,3,668,'Language Common',1),
+(3,3,672,'Language Dwarven',1),
+(3,3,2382,'Generic',1),
+(3,3,2479,'Honorless Target',1),
+(3,3,2481,'Find Treasure',1),
+(3,3,2973,'Raptor Strike',1),
+(3,3,3050,'Detect',1),
+(3,3,3365,'Opening',1),
+(3,3,6233,'Closing',1),
+(3,3,6246,'Closing',1),
+(3,3,6247,'Opening',1),
+(3,3,6477,'Opening',1),
+(3,3,6478,'Opening',1),
+(3,3,6603,'Attack',1),
+(3,3,7266,'Duel',1),
+(3,3,7267,'Grovel',1),
+(3,3,7355,'Stuck',1),
+(3,3,8386,'Attacking',1),
+(3,3,9077,'Leather',1),
+(3,3,9078,'Cloth',1),
+(3,3,9125,'Generic',1),
+(3,3,13358,'Defensive State(DND)',1),
+(3,3,20594,'Stoneform',1),
+(3,3,20595,'Gun Specialization',1),
+(3,3,20596,'Frost Resistance',1),
+(3,3,21651,'Opening',1),
+(3,3,21652,'Closing',1),
+(3,3,22027,'Remove Insignia',1),
+(3,3,22810,'Opening - No Text',1),
+(3,3,24949,'Defensive State 2(DND)',1),
+(3,3,34082,'Advantaged State(DND)',1),
+(3,4,81,'Dodge',1),
+(3,4,203,'Unarmed',1),
+(3,4,204,'Defense',1),
+(3,4,522,'SPELLDEFENSE(DND)',1),
+(3,4,668,'Language Common',1),
+(3,4,672,'Language Dwarven',1),
+(3,4,1180,'Daggers',1),
+(3,4,1752,'Sinister Strike',1),
+(3,4,2098,'Eviscerate',1),
+(3,4,2382,'Generic',1),
+(3,4,2479,'Honorless Target',1),
+(3,4,2481,'Find Treasure',1),
+(3,4,2567,'Thrown',1),
+(3,4,2764,'Throw',1),
+(3,4,3050,'Detect',1),
+(3,4,3365,'Opening',1),
+(3,4,6233,'Closing',1),
+(3,4,6246,'Closing',1),
+(3,4,6247,'Opening',1),
+(3,4,6477,'Opening',1),
+(3,4,6478,'Opening',1),
+(3,4,6603,'Attack',1),
+(3,4,7266,'Duel',1),
+(3,4,7267,'Grovel',1),
+(3,4,7355,'Stuck',1),
+(3,4,8386,'Attacking',1),
+(3,4,9077,'Leather',1),
+(3,4,9078,'Cloth',1),
+(3,4,9125,'Generic',1),
+(3,4,16092,'Defensive State(DND)',1),
+(3,4,20594,'Stoneform',1),
+(3,4,20595,'Gun Specialization',1),
+(3,4,20596,'Frost Resistance',1),
+(3,4,21184,'Rogue Passive(DND)',1),
+(3,4,21651,'Opening',1),
+(3,4,21652,'Closing',1),
+(3,4,22027,'Remove Insignia',1),
+(3,4,22810,'Opening - No Text',1),
+(3,5,81,'Dodge',1),
+(3,5,198,'One-Handed Maces',1),
+(3,5,203,'Unarmed',1),
+(3,5,204,'Defense',1),
+(3,5,522,'SPELLDEFENSE(DND)',1),
+(3,5,585,'Smite',1),
+(3,5,668,'Language Common',1),
+(3,5,672,'Language Dwarven',1),
+(3,5,2050,'Lesser Heal',1),
+(3,5,2382,'Generic',1),
+(3,5,2479,'Honorless Target',1),
+(3,5,2481,'Find Treasure',1),
+(3,5,3050,'Detect',1),
+(3,5,3365,'Opening',1),
+(3,5,5009,'Wands',1),
+(3,5,5019,'Shoot',1),
+(3,5,6233,'Closing',1),
+(3,5,6246,'Closing',1),
+(3,5,6247,'Opening',1),
+(3,5,6477,'Opening',1),
+(3,5,6478,'Opening',1),
+(3,5,6603,'Attack',1),
+(3,5,7266,'Duel',1),
+(3,5,7267,'Grovel',1),
+(3,5,7355,'Stuck',1),
+(3,5,8386,'Attacking',1),
+(3,5,9078,'Cloth',1),
+(3,5,9125,'Generic',1),
+(3,5,20594,'Stoneform',1),
+(3,5,20595,'Gun Specialization',1),
+(3,5,20596,'Frost Resistance',1),
+(3,5,21651,'Opening',1),
+(3,5,21652,'Closing',1),
+(3,5,22027,'Remove Insignia',1),
+(3,5,22810,'Opening - No Text',1),
+(4,1,78,'Heroic Strike',1),
+(4,1,81,'Dodge',1),
+(4,1,107,'Block',1),
+(4,1,198,'One-Handed Maces',1),
+(4,1,201,'One-Handed Swords',1),
+(4,1,203,'Unarmed',1),
+(4,1,204,'Defense',1),
+(4,1,522,'SPELLDEFENSE(DND)',1),
+(4,1,668,'Language Common',1),
+(4,1,671,'Language Darnassian',1),
+(4,1,1180,'Daggers',1),
+(4,1,2382,'Generic',1),
+(4,1,2457,'Battle Stance',1),
+(4,1,2479,'Honorless Target',1),
+(4,1,3050,'Detect',1),
+(4,1,3365,'Opening',1),
+(4,1,5301,'Defensive State(DND)',1),
+(4,1,6233,'Closing',1),
+(4,1,6246,'Closing',1),
+(4,1,6247,'Opening',1),
+(4,1,6477,'Opening',1),
+(4,1,6478,'Opening',1),
+(4,1,6603,'Attack',1),
+(4,1,7266,'Duel',1),
+(4,1,7267,'Grovel',1),
+(4,1,7355,'Stuck',1),
+(4,1,7376,'Defensive Stance Passive',0),
+(4,1,7381,'Berserker Stance Passive',0),
+(4,1,8386,'Attacking',1),
+(4,1,8737,'Mail',1),
+(4,1,9077,'Leather',1),
+(4,1,9078,'Cloth',1),
+(4,1,9116,'Shield',1),
+(4,1,9125,'Generic',1),
+(4,1,20580,'Shadowmeld',1),
+(4,1,20582,'Quickness',1),
+(4,1,20583,'Nature Resistance',1),
+(4,1,20585,'Wisp Spirit',1),
+(4,1,21009,'Shadowmeld Passive',1),
+(4,1,21156,'Battle Stance Passive',0),
+(4,1,21651,'Opening',1),
+(4,1,21652,'Closing',1),
+(4,1,22027,'Remove Insignia',1),
+(4,1,22810,'Opening - No Text',1),
+(4,1,32215,'Victorious State',1),
+(4,3,75,'Auto Shot',1),
+(4,3,81,'Dodge',1),
+(4,3,203,'Unarmed',1),
+(4,3,204,'Defense',1),
+(4,3,264,'Bows',1),
+(4,3,522,'SPELLDEFENSE(DND)',1),
+(4,3,668,'Language Common',1),
+(4,3,671,'Language Darnassian',1),
+(4,3,1180,'Daggers',1),
+(4,3,2382,'Generic',1),
+(4,3,2479,'Honorless Target',1),
+(4,3,2973,'Raptor Strike',1),
+(4,3,3050,'Detect',1),
+(4,3,3365,'Opening',1),
+(4,3,6233,'Closing',1),
+(4,3,6246,'Closing',1),
+(4,3,6247,'Opening',1),
+(4,3,6477,'Opening',1),
+(4,3,6478,'Opening',1),
+(4,3,6603,'Attack',1),
+(4,3,7266,'Duel',1),
+(4,3,7267,'Grovel',1),
+(4,3,7355,'Stuck',1),
+(4,3,8386,'Attacking',1),
+(4,3,9077,'Leather',1),
+(4,3,9078,'Cloth',1),
+(4,3,9125,'Generic',1),
+(4,3,13358,'Defensive State(DND)',1),
+(4,3,20580,'Shadowmeld',1),
+(4,3,20582,'Quickness',1),
+(4,3,20583,'Nature Resistance',1),
+(4,3,20585,'Wisp Spirit',1),
+(4,3,21009,'Shadowmeld Passive',1),
+(4,3,21651,'Opening',1),
+(4,3,21652,'Closing',1),
+(4,3,22027,'Remove Insignia',1),
+(4,3,22810,'Opening - No Text',1),
+(4,3,24949,'Defensive State 2(DND)',1),
+(4,3,34082,'Advantaged State(DND)',1),
+(4,4,81,'Dodge',1),
+(4,4,203,'Unarmed',1),
+(4,4,204,'Defense',1),
+(4,4,522,'SPELLDEFENSE(DND)',1),
+(4,4,668,'Language Common',1),
+(4,4,671,'Language Darnassian',1),
+(4,4,1180,'Daggers',1),
+(4,4,1752,'Sinister Strike',1),
+(4,4,2098,'Eviscerate',1),
+(4,4,2382,'Generic',1),
+(4,4,2479,'Honorless Target',1),
+(4,4,2567,'Thrown',1),
+(4,4,2764,'Throw',1),
+(4,4,3050,'Detect',1),
+(4,4,3365,'Opening',1),
+(4,4,6233,'Closing',1),
+(4,4,6246,'Closing',1),
+(4,4,6247,'Opening',1),
+(4,4,6477,'Opening',1),
+(4,4,6478,'Opening',1),
+(4,4,6603,'Attack',1),
+(4,4,7266,'Duel',1),
+(4,4,7267,'Grovel',1),
+(4,4,7355,'Stuck',1),
+(4,4,8386,'Attacking',1),
+(4,4,9077,'Leather',1),
+(4,4,9078,'Cloth',1),
+(4,4,9125,'Generic',1),
+(4,4,16092,'Defensive State(DND)',1),
+(4,4,20580,'Shadowmeld',1),
+(4,4,20582,'Quickness',1),
+(4,4,20583,'Nature Resistance',1),
+(4,4,20585,'Wisp Spirit',1),
+(4,4,21009,'Shadowmeld Passive',1),
+(4,4,21184,'Rogue Passive(DND)',1),
+(4,4,21651,'Opening',1),
+(4,4,21652,'Closing',1),
+(4,4,22027,'Remove Insignia',1),
+(4,4,22810,'Opening - No Text',1),
+(4,5,81,'Dodge',1),
+(4,5,198,'One-Handed Maces',1),
+(4,5,203,'Unarmed',1),
+(4,5,204,'Defense',1),
+(4,5,522,'SPELLDEFENSE(DND)',1),
+(4,5,585,'Smite',1),
+(4,5,668,'Language Common',1),
+(4,5,671,'Language Darnassian',1),
+(4,5,2050,'Lesser Heal',1),
+(4,5,2382,'Generic',1),
+(4,5,2479,'Honorless Target',1),
+(4,5,3050,'Detect',1),
+(4,5,3365,'Opening',1),
+(4,5,5009,'Wands',1),
+(4,5,5019,'Shoot',1),
+(4,5,6233,'Closing',1),
+(4,5,6246,'Closing',1),
+(4,5,6247,'Opening',1),
+(4,5,6477,'Opening',1),
+(4,5,6478,'Opening',1),
+(4,5,6603,'Attack',1),
+(4,5,7266,'Duel',1),
+(4,5,7267,'Grovel',1),
+(4,5,7355,'Stuck',1),
+(4,5,8386,'Attacking',1),
+(4,5,9078,'Cloth',1),
+(4,5,9125,'Generic',1),
+(4,5,20580,'Shadowmeld',1),
+(4,5,20582,'Quickness',1),
+(4,5,20583,'Nature Resistance',1),
+(4,5,20585,'Wisp Spirit',1),
+(4,5,21009,'Shadowmeld Passive',1),
+(4,5,21651,'Opening',1),
+(4,5,21652,'Closing',1),
+(4,5,22027,'Remove Insignia',1),
+(4,5,22810,'Opening - No Text',1),
+(4,11,81,'Dodge',1),
+(4,11,203,'Unarmed',1),
+(4,11,204,'Defense',1),
+(4,11,227,'Staves',1),
+(4,11,522,'SPELLDEFENSE(DND)',1),
+(4,11,668,'Language Common',1),
+(4,11,671,'Language Darnassian',1),
+(4,11,1178,'Bear Form(Passive)',0),
+(4,11,1180,'Daggers',1),
+(4,11,2382,'Generic',1),
+(4,11,2479,'Honorless Target',1),
+(4,11,3025,'Cat Form(Passive)',0),
+(4,11,3050,'Detect',1),
+(4,11,3365,'Opening',1),
+(4,11,5176,'Wrath',1),
+(4,11,5185,'Healing Touch',1),
+(4,11,5419,'Travel Form(Passive)',0),
+(4,11,5420,'Tree of Life',0),
+(4,11,5421,'Aquatic Form(Passive)',0),
+(4,11,6233,'Closing',1),
+(4,11,6246,'Closing',1),
+(4,11,6247,'Opening',1),
+(4,11,6477,'Opening',1),
+(4,11,6478,'Opening',1),
+(4,11,6603,'Attack',1),
+(4,11,7266,'Duel',1),
+(4,11,7267,'Grovel',1),
+(4,11,7355,'Stuck',1),
+(4,11,8386,'Attacking',1),
+(4,11,9077,'Leather',1),
+(4,11,9078,'Cloth',1),
+(4,11,9125,'Generic',1),
+(4,11,9635,'Dire Bear Form(Passive)',0),
+(4,11,20580,'Shadowmeld',1),
+(4,11,20582,'Quickness',1),
+(4,11,20583,'Nature Resistance',1),
+(4,11,20585,'Wisp Spirit',1),
+(4,11,21009,'Shadowmeld Passive',1),
+(4,11,21178,'Bear Form(Passive2)',0),
+(4,11,21651,'Opening',1),
+(4,11,21652,'Closing',1),
+(4,11,22027,'Remove Insignia',1),
+(4,11,22810,'Opening - No Text',1),
+(4,11,24905,'Moonkin Form(Passive)',0),
+(4,11,27764,'Fetish',1),
+(4,11,33948,'Flight Form(Passive)',0),
+(4,11,34123,'Tree of Life(Passive)',0),
+(4,11,40121,'Swift Flight Form(Passive)',0),
+(5,1,78,'Heroic Strike',1),
+(5,1,81,'Dodge',1),
+(5,1,107,'Block',1),
+(5,1,201,'One-Handed Swords',1),
+(5,1,202,'Two-Handed Swords',1),
+(5,1,203,'Unarmed',1),
+(5,1,204,'Defense',1),
+(5,1,522,'SPELLDEFENSE(DND)',1),
+(5,1,669,'Language Orcish',1),
+(5,1,1180,'Daggers',1),
+(5,1,2382,'Generic',1),
+(5,1,2457,'Battle Stance',1),
+(5,1,2479,'Honorless Target',1),
+(5,1,3050,'Detect',1),
+(5,1,3365,'Opening',1),
+(5,1,5227,'Underwater Breathing',1),
+(5,1,5301,'Defensive State(DND)',1),
+(5,1,6233,'Closing',1),
+(5,1,6246,'Closing',1),
+(5,1,6247,'Opening',1),
+(5,1,6477,'Opening',1),
+(5,1,6478,'Opening',1),
+(5,1,6603,'Attack',1),
+(5,1,7266,'Duel',1),
+(5,1,7267,'Grovel',1),
+(5,1,7355,'Stuck',1),
+(5,1,7376,'Defensive Stance Passive',0),
+(5,1,7381,'Berserker Stance Passive',0),
+(5,1,7744,'Will of the Forsaken',1),
+(5,1,8386,'Attacking',1),
+(5,1,8737,'Mail',1),
+(5,1,9077,'Leather',1),
+(5,1,9078,'Cloth',1),
+(5,1,9116,'Shield',1),
+(5,1,9125,'Generic',1),
+(5,1,17737,'Language Gutterspeak',1),
+(5,1,20577,'Cannibalize',1),
+(5,1,20579,'Shadow Resistance',1),
+(5,1,21156,'Battle Stance Passive',0),
+(5,1,21651,'Opening',1),
+(5,1,21652,'Closing',1),
+(5,1,22027,'Remove Insignia',1),
+(5,1,22810,'Opening - No Text',1),
+(5,1,32215,'Victorious State',1),
+(5,4,81,'Dodge',1),
+(5,4,203,'Unarmed',1),
+(5,4,204,'Defense',1),
+(5,4,522,'SPELLDEFENSE(DND)',1),
+(5,4,669,'Language Orcish',1),
+(5,4,1180,'Daggers',1),
+(5,4,1752,'Sinister Strike',1),
+(5,4,2098,'Eviscerate',1),
+(5,4,2382,'Generic',1),
+(5,4,2479,'Honorless Target',1),
+(5,4,2567,'Thrown',1),
+(5,4,2764,'Throw',1),
+(5,4,3050,'Detect',1),
+(5,4,3365,'Opening',1),
+(5,4,5227,'Underwater Breathing',1),
+(5,4,6233,'Closing',1),
+(5,4,6246,'Closing',1),
+(5,4,6247,'Opening',1),
+(5,4,6477,'Opening',1),
+(5,4,6478,'Opening',1),
+(5,4,6603,'Attack',1),
+(5,4,7266,'Duel',1),
+(5,4,7267,'Grovel',1),
+(5,4,7355,'Stuck',1),
+(5,4,7744,'Will of the Forsaken',1),
+(5,4,8386,'Attacking',1),
+(5,4,9077,'Leather',1),
+(5,4,9078,'Cloth',1),
+(5,4,9125,'Generic',1),
+(5,4,16092,'Defensive State(DND)',1),
+(5,4,17737,'Language Gutterspeak',1),
+(5,4,20577,'Cannibalize',1),
+(5,4,20579,'Shadow Resistance',1),
+(5,4,21184,'Rogue Passive(DND)',1),
+(5,4,21651,'Opening',1),
+(5,4,21652,'Closing',1),
+(5,4,22027,'Remove Insignia',1),
+(5,4,22810,'Opening - No Text',1),
+(5,5,81,'Dodge',1),
+(5,5,198,'One-Handed Maces',1),
+(5,5,203,'Unarmed',1),
+(5,5,204,'Defense',1),
+(5,5,522,'SPELLDEFENSE(DND)',1),
+(5,5,585,'Smite',1),
+(5,5,669,'Language Orcish',1),
+(5,5,2050,'Lesser Heal',1),
+(5,5,2382,'Generic',1),
+(5,5,2479,'Honorless Target',1),
+(5,5,3050,'Detect',1),
+(5,5,3365,'Opening',1),
+(5,5,5009,'Wands',1),
+(5,5,5019,'Shoot',1),
+(5,5,5227,'Underwater Breathing',1),
+(5,5,6233,'Closing',1),
+(5,5,6246,'Closing',1),
+(5,5,6247,'Opening',1),
+(5,5,6477,'Opening',1),
+(5,5,6478,'Opening',1),
+(5,5,6603,'Attack',1),
+(5,5,7266,'Duel',1),
+(5,5,7267,'Grovel',1),
+(5,5,7355,'Stuck',1),
+(5,5,7744,'Will of the Forsaken',1),
+(5,5,8386,'Attacking',1),
+(5,5,9078,'Cloth',1),
+(5,5,9125,'Generic',1),
+(5,5,17737,'Language Gutterspeak',1),
+(5,5,20577,'Cannibalize',1),
+(5,5,20579,'Shadow Resistance',1),
+(5,5,21651,'Opening',1),
+(5,5,21652,'Closing',1),
+(5,5,22027,'Remove Insignia',1),
+(5,5,22810,'Opening - No Text',1),
+(5,8,81,'Dodge',1),
+(5,8,133,'Fireball',1),
+(5,8,168,'Frost Armor',1),
+(5,8,203,'Unarmed',1),
+(5,8,204,'Defense',1),
+(5,8,227,'Staves',1),
+(5,8,522,'SPELLDEFENSE(DND)',1),
+(5,8,669,'Language Orcish',1),
+(5,8,2382,'Generic',1),
+(5,8,2479,'Honorless Target',1),
+(5,8,3050,'Detect',1),
+(5,8,3365,'Opening',1),
+(5,8,5009,'Wands',1),
+(5,8,5019,'Shoot',1),
+(5,8,5227,'Underwater Breathing',1),
+(5,8,6233,'Closing',1),
+(5,8,6246,'Closing',1),
+(5,8,6247,'Opening',1),
+(5,8,6477,'Opening',1),
+(5,8,6478,'Opening',1),
+(5,8,6603,'Attack',1),
+(5,8,7266,'Duel',1),
+(5,8,7267,'Grovel',1),
+(5,8,7355,'Stuck',1),
+(5,8,7744,'Will of the Forsaken',1),
+(5,8,8386,'Attacking',1),
+(5,8,9078,'Cloth',1),
+(5,8,9125,'Generic',1),
+(5,8,17737,'Language Gutterspeak',1),
+(5,8,20577,'Cannibalize',1),
+(5,8,20579,'Shadow Resistance',1),
+(5,8,21651,'Opening',1),
+(5,8,21652,'Closing',1),
+(5,8,22027,'Remove Insignia',1),
+(5,8,22810,'Opening - No Text',1),
+(5,9,81,'Dodge',1),
+(5,9,203,'Unarmed',1),
+(5,9,204,'Defense',1),
+(5,9,522,'SPELLDEFENSE(DND)',1),
+(5,9,669,'Language Orcish',1),
+(5,9,686,'Shadow Bolt',1),
+(5,9,687,'Demon Skin',1),
+(5,9,1180,'Daggers',1),
+(5,9,2382,'Generic',1),
+(5,9,2479,'Honorless Target',1),
+(5,9,3050,'Detect',1),
+(5,9,3365,'Opening',1),
+(5,9,5009,'Wands',1),
+(5,9,5019,'Shoot',1),
+(5,9,5227,'Underwater Breathing',1),
+(5,9,6233,'Closing',1),
+(5,9,6246,'Closing',1),
+(5,9,6247,'Opening',1),
+(5,9,6477,'Opening',1),
+(5,9,6478,'Opening',1),
+(5,9,6603,'Attack',1),
+(5,9,7266,'Duel',1),
+(5,9,7267,'Grovel',1),
+(5,9,7355,'Stuck',1),
+(5,9,7744,'Will of the Forsaken',1),
+(5,9,8386,'Attacking',1),
+(5,9,9078,'Cloth',1),
+(5,9,9125,'Generic',1),
+(5,9,17737,'Language Gutterspeak',1),
+(5,9,20577,'Cannibalize',1),
+(5,9,20579,'Shadow Resistance',1),
+(5,9,21651,'Opening',1),
+(5,9,21652,'Closing',1),
+(5,9,22027,'Remove Insignia',1),
+(5,9,22810,'Opening - No Text',1),
+(6,1,78,'Heroic Strike',1),
+(6,1,81,'Dodge',1),
+(6,1,107,'Block',1),
+(6,1,196,'One-Handed Axes',1),
+(6,1,198,'One-Handed Maces',1),
+(6,1,199,'Two-Handed Maces',1),
+(6,1,203,'Unarmed',1),
+(6,1,204,'Defense',1),
+(6,1,522,'SPELLDEFENSE(DND)',1),
+(6,1,669,'Language Orcish',1),
+(6,1,670,'Language Taurahe',1),
+(6,1,2382,'Generic',1),
+(6,1,2457,'Battle Stance',1),
+(6,1,2479,'Honorless Target',1),
+(6,1,3050,'Detect',1),
+(6,1,3365,'Opening',1),
+(6,1,5301,'Defensive State(DND)',1),
+(6,1,6233,'Closing',1),
+(6,1,6246,'Closing',1),
+(6,1,6247,'Opening',1),
+(6,1,6477,'Opening',1),
+(6,1,6478,'Opening',1),
+(6,1,6603,'Attack',1),
+(6,1,7266,'Duel',1),
+(6,1,7267,'Grovel',1),
+(6,1,7355,'Stuck',1),
+(6,1,7376,'Defensive Stance Passive',0),
+(6,1,7381,'Berserker Stance Passive',0),
+(6,1,8386,'Attacking',1),
+(6,1,8737,'Mail',1),
+(6,1,9077,'Leather',1),
+(6,1,9078,'Cloth',1),
+(6,1,9116,'Shield',1),
+(6,1,9125,'Generic',1),
+(6,1,20549,'War Stomp',1),
+(6,1,20550,'Endurance',1),
+(6,1,20551,'Nature Resistance',1),
+(6,1,20552,'Cultivation',1),
+(6,1,21156,'Battle Stance Passive',0),
+(6,1,21651,'Opening',1),
+(6,1,21652,'Closing',1),
+(6,1,22027,'Remove Insignia',1),
+(6,1,22810,'Opening - No Text',1),
+(6,1,32215,'Victorious State',1),
+(6,3,75,'Auto Shot',1),
+(6,3,81,'Dodge',1),
+(6,3,196,'One-Handed Axes',1),
+(6,3,203,'Unarmed',1),
+(6,3,204,'Defense',1),
+(6,3,266,'Guns',1),
+(6,3,522,'SPELLDEFENSE(DND)',1),
+(6,3,669,'Language Orcish',1),
+(6,3,670,'Language Taurahe',1),
+(6,3,2382,'Generic',1),
+(6,3,2479,'Honorless Target',1),
+(6,3,2973,'Raptor Strike',1),
+(6,3,3050,'Detect',1),
+(6,3,3365,'Opening',1),
+(6,3,6233,'Closing',1),
+(6,3,6246,'Closing',1),
+(6,3,6247,'Opening',1),
+(6,3,6477,'Opening',1),
+(6,3,6478,'Opening',1),
+(6,3,6603,'Attack',1),
+(6,3,7266,'Duel',1),
+(6,3,7267,'Grovel',1),
+(6,3,7355,'Stuck',1),
+(6,3,8386,'Attacking',1),
+(6,3,9077,'Leather',1),
+(6,3,9078,'Cloth',1),
+(6,3,9125,'Generic',1),
+(6,3,13358,'Defensive State(DND)',1),
+(6,3,20549,'War Stomp',1),
+(6,3,20550,'Endurance',1),
+(6,3,20551,'Nature Resistance',1),
+(6,3,20552,'Cultivation',1),
+(6,3,21651,'Opening',1),
+(6,3,21652,'Closing',1),
+(6,3,22027,'Remove Insignia',1),
+(6,3,22810,'Opening - No Text',1),
+(6,3,24949,'Defensive State 2(DND)',1),
+(6,3,34082,'Advantaged State(DND)',1),
+(6,7,81,'Dodge',1),
+(6,7,107,'Block',1),
+(6,7,198,'One-Handed Maces',1),
+(6,7,203,'Unarmed',1),
+(6,7,204,'Defense',1),
+(6,7,227,'Staves',1),
+(6,7,331,'Healing Wave',1),
+(6,7,403,'Lightning Bolt',1),
+(6,7,522,'SPELLDEFENSE(DND)',1),
+(6,7,669,'Language Orcish',1),
+(6,7,670,'Language Taurahe',1),
+(6,7,2382,'Generic',1),
+(6,7,2479,'Honorless Target',1),
+(6,7,3050,'Detect',1),
+(6,7,3365,'Opening',1),
+(6,7,6233,'Closing',1),
+(6,7,6246,'Closing',1),
+(6,7,6247,'Opening',1),
+(6,7,6477,'Opening',1),
+(6,7,6478,'Opening',1),
+(6,7,6603,'Attack',1),
+(6,7,7266,'Duel',1),
+(6,7,7267,'Grovel',1),
+(6,7,7355,'Stuck',1),
+(6,7,8386,'Attacking',1),
+(6,7,9077,'Leather',1),
+(6,7,9078,'Cloth',1),
+(6,7,9116,'Shield',1),
+(6,7,9125,'Generic',1),
+(6,7,20549,'War Stomp',1),
+(6,7,20550,'Endurance',1),
+(6,7,20551,'Nature Resistance',1),
+(6,7,20552,'Cultivation',1),
+(6,7,21651,'Opening',1),
+(6,7,21652,'Closing',1),
+(6,7,22027,'Remove Insignia',1),
+(6,7,22810,'Opening - No Text',1),
+(6,7,27763,'Totem',1),
+(6,11,81,'Dodge',1),
+(6,11,198,'One-Handed Maces',1),
+(6,11,203,'Unarmed',1),
+(6,11,204,'Defense',1),
+(6,11,227,'Staves',1),
+(6,11,522,'SPELLDEFENSE(DND)',1),
+(6,11,669,'Language Orcish',1),
+(6,11,670,'Language Taurahe',1),
+(6,11,1178,'Bear Form(Passive)',0),
+(6,11,2382,'Generic',1),
+(6,11,2479,'Honorless Target',1),
+(6,11,3025,'Cat Form(Passive)',0),
+(6,11,3050,'Detect',1),
+(6,11,3365,'Opening',1),
+(6,11,5176,'Wrath',1),
+(6,11,5185,'Healing Touch',1),
+(6,11,5419,'Travel Form(Passive)',0),
+(6,11,5420,'Tree of Life',0),
+(6,11,5421,'Aquatic Form(Passive)',0),
+(6,11,6233,'Closing',1),
+(6,11,6246,'Closing',1),
+(6,11,6247,'Opening',1),
+(6,11,6477,'Opening',1),
+(6,11,6478,'Opening',1),
+(6,11,6603,'Attack',1),
+(6,11,7266,'Duel',1),
+(6,11,7267,'Grovel',1),
+(6,11,7355,'Stuck',1),
+(6,11,8386,'Attacking',1),
+(6,11,9077,'Leather',1),
+(6,11,9078,'Cloth',1),
+(6,11,9125,'Generic',1),
+(6,11,9635,'Dire Bear Form(Passive)',0),
+(6,11,20549,'War Stomp',1),
+(6,11,20550,'Endurance',1),
+(6,11,20551,'Nature Resistance',1),
+(6,11,20552,'Cultivation',1),
+(6,11,21178,'Bear Form(Passive2)',0),
+(6,11,21651,'Opening',1),
+(6,11,21652,'Closing',1),
+(6,11,22027,'Remove Insignia',1),
+(6,11,22810,'Opening - No Text',1),
+(6,11,24905,'Moonkin Form(Passive)',0),
+(6,11,27764,'Fetish',1),
+(6,11,33948,'Flight Form(Passive)',0),
+(6,11,34123,'Tree of Life(Passive)',0),
+(6,11,40121,'Swift Flight Form(Passive)',0),
+(7,1,78,'Heroic Strike',1),
+(7,1,81,'Dodge',1),
+(7,1,107,'Block',1),
+(7,1,198,'One-Handed Maces',1),
+(7,1,201,'One-Handed Swords',1),
+(7,1,203,'Unarmed',1),
+(7,1,204,'Defense',1),
+(7,1,522,'SPELLDEFENSE(DND)',1),
+(7,1,668,'Language Common',1),
+(7,1,1180,'Daggers',1),
+(7,1,2382,'Generic',1),
+(7,1,2457,'Battle Stance',1),
+(7,1,2479,'Honorless Target',1),
+(7,1,3050,'Detect',1),
+(7,1,3365,'Opening',1),
+(7,1,5301,'Defensive State(DND)',1),
+(7,1,6233,'Closing',1),
+(7,1,6246,'Closing',1),
+(7,1,6247,'Opening',1),
+(7,1,6477,'Opening',1),
+(7,1,6478,'Opening',1),
+(7,1,6603,'Attack',1),
+(7,1,7266,'Duel',1),
+(7,1,7267,'Grovel',1),
+(7,1,7340,'Language Gnomish',1),
+(7,1,7355,'Stuck',1),
+(7,1,7376,'Defensive Stance Passive',0),
+(7,1,7381,'Berserker Stance Passive',0),
+(7,1,8386,'Attacking',1),
+(7,1,8737,'Mail',1),
+(7,1,9077,'Leather',1),
+(7,1,9078,'Cloth',1),
+(7,1,9116,'Shield',1),
+(7,1,9125,'Generic',1),
+(7,1,20589,'Escape Artist',1),
+(7,1,20591,'Expansive Mind',1),
+(7,1,20592,'Arcane Resistance',1),
+(7,1,20593,'Engineering Specialization',1),
+(7,1,21156,'Battle Stance Passive',0),
+(7,1,21651,'Opening',1),
+(7,1,21652,'Closing',1),
+(7,1,22027,'Remove Insignia',1),
+(7,1,22810,'Opening - No Text',1),
+(7,1,32215,'Victorious State',1),
+(7,4,81,'Dodge',1),
+(7,4,203,'Unarmed',1),
+(7,4,204,'Defense',1),
+(7,4,522,'SPELLDEFENSE(DND)',1),
+(7,4,668,'Language Common',1),
+(7,4,1180,'Daggers',1),
+(7,4,1752,'Sinister Strike',1),
+(7,4,2098,'Eviscerate',1),
+(7,4,2382,'Generic',1),
+(7,4,2479,'Honorless Target',1),
+(7,4,2567,'Thrown',1),
+(7,4,2764,'Throw',1),
+(7,4,3050,'Detect',1),
+(7,4,3365,'Opening',1),
+(7,4,6233,'Closing',1),
+(7,4,6246,'Closing',1),
+(7,4,6247,'Opening',1),
+(7,4,6477,'Opening',1),
+(7,4,6478,'Opening',1),
+(7,4,6603,'Attack',1),
+(7,4,7266,'Duel',1),
+(7,4,7267,'Grovel',1),
+(7,4,7340,'Language Gnomish',1),
+(7,4,7355,'Stuck',1),
+(7,4,8386,'Attacking',1),
+(7,4,9077,'Leather',1),
+(7,4,9078,'Cloth',1),
+(7,4,9125,'Generic',1),
+(7,4,16092,'Defensive State(DND)',1),
+(7,4,20589,'Escape Artist',1),
+(7,4,20591,'Expansive Mind',1),
+(7,4,20592,'Arcane Resistance',1),
+(7,4,20593,'Engineering Specialization',1),
+(7,4,21184,'Rogue Passive(DND)',1),
+(7,4,21651,'Opening',1),
+(7,4,21652,'Closing',1),
+(7,4,22027,'Remove Insignia',1),
+(7,4,22810,'Opening - No Text',1),
+(7,8,81,'Dodge',1),
+(7,8,133,'Fireball',1),
+(7,8,168,'Frost Armor',1),
+(7,8,203,'Unarmed',1),
+(7,8,204,'Defense',1),
+(7,8,227,'Staves',1),
+(7,8,522,'SPELLDEFENSE(DND)',1),
+(7,8,668,'Language Common',1),
+(7,8,2382,'Generic',1),
+(7,8,2479,'Honorless Target',1),
+(7,8,3050,'Detect',1),
+(7,8,3365,'Opening',1),
+(7,8,5009,'Wands',1),
+(7,8,5019,'Shoot',1),
+(7,8,6233,'Closing',1),
+(7,8,6246,'Closing',1),
+(7,8,6247,'Opening',1),
+(7,8,6477,'Opening',1),
+(7,8,6478,'Opening',1),
+(7,8,6603,'Attack',1),
+(7,8,7266,'Duel',1),
+(7,8,7267,'Grovel',1),
+(7,8,7340,'Language Gnomish',1),
+(7,8,7355,'Stuck',1),
+(7,8,8386,'Attacking',1),
+(7,8,9078,'Cloth',1),
+(7,8,9125,'Generic',1),
+(7,8,20589,'Escape Artist',1),
+(7,8,20591,'Expansive Mind',1),
+(7,8,20592,'Arcane Resistance',1),
+(7,8,20593,'Engineering Specialization',1),
+(7,8,21651,'Opening',1),
+(7,8,21652,'Closing',1),
+(7,8,22027,'Remove Insignia',1),
+(7,8,22810,'Opening - No Text',1),
+(7,9,81,'Dodge',1),
+(7,9,203,'Unarmed',1),
+(7,9,204,'Defense',1),
+(7,9,522,'SPELLDEFENSE(DND)',1),
+(7,9,668,'Language Common',1),
+(7,9,686,'Shadow Bolt',1),
+(7,9,687,'Demon Skin',1),
+(7,9,1180,'Daggers',1),
+(7,9,2382,'Generic',1),
+(7,9,2479,'Honorless Target',1),
+(7,9,3050,'Detect',1),
+(7,9,3365,'Opening',1),
+(7,9,5009,'Wands',1),
+(7,9,5019,'Shoot',1),
+(7,9,6233,'Closing',1),
+(7,9,6246,'Closing',1),
+(7,9,6247,'Opening',1),
+(7,9,6477,'Opening',1),
+(7,9,6478,'Opening',1),
+(7,9,6603,'Attack',1),
+(7,9,7266,'Duel',1),
+(7,9,7267,'Grovel',1),
+(7,9,7340,'Language Gnomish',1),
+(7,9,7355,'Stuck',1),
+(7,9,8386,'Attacking',1),
+(7,9,9078,'Cloth',1),
+(7,9,9125,'Generic',1),
+(7,9,20589,'Escape Artist',1),
+(7,9,20591,'Expansive Mind',1),
+(7,9,20592,'Arcane Resistance',1),
+(7,9,20593,'Engineering Specialization',1),
+(7,9,21651,'Opening',1),
+(7,9,21652,'Closing',1),
+(7,9,22027,'Remove Insignia',1),
+(7,9,22810,'Opening - No Text',1),
+(8,1,78,'Heroic Strike',1),
+(8,1,81,'Dodge',1),
+(8,1,107,'Block',1),
+(8,1,196,'One-Handed Axes',1),
+(8,1,203,'Unarmed',1),
+(8,1,204,'Defense',1),
+(8,1,522,'SPELLDEFENSE(DND)',1),
+(8,1,669,'Language Orcish',1),
+(8,1,1180,'Daggers',1),
+(8,1,2382,'Generic',1),
+(8,1,2457,'Battle Stance',1),
+(8,1,2479,'Honorless Target',1),
+(8,1,2567,'Thrown',1),
+(8,1,2764,'Throw',1),
+(8,1,3050,'Detect',1),
+(8,1,3365,'Opening',1),
+(8,1,5301,'Defensive State(DND)',1),
+(8,1,6233,'Closing',1),
+(8,1,6246,'Closing',1),
+(8,1,6247,'Opening',1),
+(8,1,6477,'Opening',1),
+(8,1,6478,'Opening',1),
+(8,1,6603,'Attack',1),
+(8,1,7266,'Duel',1),
+(8,1,7267,'Grovel',1),
+(8,1,7341,'Language Troll',1),
+(8,1,7355,'Stuck',1),
+(8,1,7376,'Defensive Stance Passive',0),
+(8,1,7381,'Berserker Stance Passive',0),
+(8,1,8386,'Attacking',1),
+(8,1,8737,'Mail',1),
+(8,1,9077,'Leather',1),
+(8,1,9078,'Cloth',1),
+(8,1,9116,'Shield',1),
+(8,1,9125,'Generic',1),
+(8,1,20555,'Regeneration',1),
+(8,1,20557,'Beast Slaying',1),
+(8,1,20558,'Throwing Specialization',1),
+(8,1,21156,'Battle Stance Passive',0),
+(8,1,21651,'Opening',1),
+(8,1,21652,'Closing',1),
+(8,1,22027,'Remove Insignia',1),
+(8,1,22810,'Opening - No Text',1),
+(8,1,26290,'Bow Specialization',1),
+(8,1,26296,'Berserking',1),
+(8,1,32215,'Victorious State',1),
+(8,3,75,'Auto Shot',1),
+(8,3,81,'Dodge',1),
+(8,3,196,'One-Handed Axes',1),
+(8,3,203,'Unarmed',1),
+(8,3,204,'Defense',1),
+(8,3,264,'Bows',1),
+(8,3,522,'SPELLDEFENSE(DND)',1),
+(8,3,669,'Language Orcish',1),
+(8,3,2382,'Generic',1),
+(8,3,2479,'Honorless Target',1),
+(8,3,2973,'Raptor Strike',1),
+(8,3,3050,'Detect',1),
+(8,3,3365,'Opening',1),
+(8,3,6233,'Closing',1),
+(8,3,6246,'Closing',1),
+(8,3,6247,'Opening',1),
+(8,3,6477,'Opening',1),
+(8,3,6478,'Opening',1),
+(8,3,6603,'Attack',1),
+(8,3,7266,'Duel',1),
+(8,3,7267,'Grovel',1),
+(8,3,7341,'Language Troll',1),
+(8,3,7355,'Stuck',1),
+(8,3,8386,'Attacking',1),
+(8,3,9077,'Leather',1),
+(8,3,9078,'Cloth',1),
+(8,3,9125,'Generic',1),
+(8,3,13358,'Defensive State(DND)',1),
+(8,3,20554,'Berserking',1),
+(8,3,20555,'Regeneration',1),
+(8,3,20557,'Beast Slaying',1),
+(8,3,20558,'Throwing Specialization',1),
+(8,3,21651,'Opening',1),
+(8,3,21652,'Closing',1),
+(8,3,22027,'Remove Insignia',1),
+(8,3,22810,'Opening - No Text',1),
+(8,3,24949,'Defensive State 2(DND)',1),
+(8,3,26290,'Bow Specialization',1),
+(8,3,34082,'Advantaged State(DND)',1),
+(8,4,81,'Dodge',1),
+(8,4,203,'Unarmed',1),
+(8,4,204,'Defense',1),
+(8,4,522,'SPELLDEFENSE(DND)',1),
+(8,4,669,'Language Orcish',1),
+(8,4,1180,'Daggers',1),
+(8,4,1752,'Sinister Strike',1),
+(8,4,2098,'Eviscerate',1),
+(8,4,2382,'Generic',1),
+(8,4,2479,'Honorless Target',1),
+(8,4,2567,'Thrown',1),
+(8,4,2764,'Throw',1),
+(8,4,3050,'Detect',1),
+(8,4,3365,'Opening',1),
+(8,4,6233,'Closing',1),
+(8,4,6246,'Closing',1),
+(8,4,6247,'Opening',1),
+(8,4,6477,'Opening',1),
+(8,4,6478,'Opening',1),
+(8,4,6603,'Attack',1),
+(8,4,7266,'Duel',1),
+(8,4,7267,'Grovel',1),
+(8,4,7341,'Language Troll',1),
+(8,4,7355,'Stuck',1),
+(8,4,8386,'Attacking',1),
+(8,4,9077,'Leather',1),
+(8,4,9078,'Cloth',1),
+(8,4,9125,'Generic',1),
+(8,4,16092,'Defensive State(DND)',1),
+(8,4,20555,'Regeneration',1),
+(8,4,20557,'Beast Slaying',1),
+(8,4,20558,'Throwing Specialization',1),
+(8,4,21184,'Rogue Passive(DND)',1),
+(8,4,21651,'Opening',1),
+(8,4,21652,'Closing',1),
+(8,4,22027,'Remove Insignia',1),
+(8,4,22810,'Opening - No Text',1),
+(8,4,26290,'Bow Specialization',1),
+(8,4,26297,'Berserking',1),
+(8,5,81,'Dodge',1),
+(8,5,198,'One-Handed Maces',1),
+(8,5,203,'Unarmed',1),
+(8,5,204,'Defense',1),
+(8,5,522,'SPELLDEFENSE(DND)',1),
+(8,5,585,'Smite',1),
+(8,5,669,'Language Orcish',1),
+(8,5,2050,'Lesser Heal',1),
+(8,5,2382,'Generic',1),
+(8,5,2479,'Honorless Target',1),
+(8,5,3050,'Detect',1),
+(8,5,3365,'Opening',1),
+(8,5,5009,'Wands',1),
+(8,5,5019,'Shoot',1),
+(8,5,6233,'Closing',1),
+(8,5,6246,'Closing',1),
+(8,5,6247,'Opening',1),
+(8,5,6477,'Opening',1),
+(8,5,6478,'Opening',1),
+(8,5,6603,'Attack',1),
+(8,5,7266,'Duel',1),
+(8,5,7267,'Grovel',1),
+(8,5,7341,'Language Troll',1),
+(8,5,7355,'Stuck',1),
+(8,5,8386,'Attacking',1),
+(8,5,9078,'Cloth',1),
+(8,5,9125,'Generic',1),
+(8,5,20554,'Berserking',1),
+(8,5,20555,'Regeneration',1),
+(8,5,20557,'Beast Slaying',1),
+(8,5,20558,'Throwing Specialization',1),
+(8,5,21651,'Opening',1),
+(8,5,21652,'Closing',1),
+(8,5,22027,'Remove Insignia',1),
+(8,5,22810,'Opening - No Text',1),
+(8,5,26290,'Bow Specialization',1),
+(8,7,81,'Dodge',1),
+(8,7,107,'Block',1),
+(8,7,198,'One-Handed Maces',1),
+(8,7,203,'Unarmed',1),
+(8,7,204,'Defense',1),
+(8,7,227,'Staves',1),
+(8,7,331,'Healing Wave',1),
+(8,7,403,'Lightning Bolt',1),
+(8,7,522,'SPELLDEFENSE(DND)',1),
+(8,7,669,'Language Orcish',1),
+(8,7,2382,'Generic',1),
+(8,7,2479,'Honorless Target',1),
+(8,7,3050,'Detect',1),
+(8,7,3365,'Opening',1),
+(8,7,6233,'Closing',1),
+(8,7,6246,'Closing',1),
+(8,7,6247,'Opening',1),
+(8,7,6477,'Opening',1),
+(8,7,6478,'Opening',1),
+(8,7,6603,'Attack',1),
+(8,7,7266,'Duel',1),
+(8,7,7267,'Grovel',1),
+(8,7,7341,'Language Troll',1),
+(8,7,7355,'Stuck',1),
+(8,7,8386,'Attacking',1),
+(8,7,9077,'Leather',1),
+(8,7,9078,'Cloth',1),
+(8,7,9116,'Shield',1),
+(8,7,9125,'Generic',1),
+(8,7,20554,'Berserking',1),
+(8,7,20555,'Regeneration',1),
+(8,7,20557,'Beast Slaying',1),
+(8,7,20558,'Throwing Specialization',1),
+(8,7,21651,'Opening',1),
+(8,7,21652,'Closing',1),
+(8,7,22027,'Remove Insignia',1),
+(8,7,22810,'Opening - No Text',1),
+(8,7,26290,'Bow Specialization',1),
+(8,7,27763,'Totem',1),
+(8,8,81,'Dodge',1),
+(8,8,133,'Fireball',1),
+(8,8,168,'Frost Armor',1),
+(8,8,203,'Unarmed',1),
+(8,8,204,'Defense',1),
+(8,8,227,'Staves',1),
+(8,8,522,'SPELLDEFENSE(DND)',1),
+(8,8,669,'Language Orcish',1),
+(8,8,2382,'Generic',1),
+(8,8,2479,'Honorless Target',1),
+(8,8,3050,'Detect',1),
+(8,8,3365,'Opening',1),
+(8,8,5009,'Wands',1),
+(8,8,5019,'Shoot',1),
+(8,8,6233,'Closing',1),
+(8,8,6246,'Closing',1),
+(8,8,6247,'Opening',1),
+(8,8,6477,'Opening',1),
+(8,8,6478,'Opening',1),
+(8,8,6603,'Attack',1),
+(8,8,7266,'Duel',1),
+(8,8,7267,'Grovel',1),
+(8,8,7341,'Language Troll',1),
+(8,8,7355,'Stuck',1),
+(8,8,8386,'Attacking',1),
+(8,8,9078,'Cloth',1),
+(8,8,9125,'Generic',1),
+(8,8,20554,'Berserking',1),
+(8,8,20555,'Regeneration',1),
+(8,8,20557,'Beast Slaying',1),
+(8,8,20558,'Throwing Specialization',1),
+(8,8,21651,'Opening',1),
+(8,8,21652,'Closing',1),
+(8,8,22027,'Remove Insignia',1),
+(8,8,22810,'Opening - No Text',1),
+(8,8,26290,'Bow Specialization',1),
+(10,2,81,'Dodge',1),
+(10,2,107,'Block',1),
+(10,2,201,'One-Handed Swords',1),
+(10,2,202,'Two-Handed Swords',1),
+(10,2,203,'Unarmed',1),
+(10,2,204,'Defense',1),
+(10,2,522,'SPELLDEFENSE(DND)',1),
+(10,2,635,'Holy Light',1),
+(10,2,669,'Language Orcish',1),
+(10,2,813,'Language Thalassian',1),
+(10,2,822,'Magic Resistance',1),
+(10,2,2382,'Generic',1),
+(10,2,2479,'Honorless Target',1),
+(10,2,3050,'Detect',1),
+(10,2,3365,'Opening',1),
+(10,2,6233,'Closing',1),
+(10,2,6246,'Closing',1),
+(10,2,6247,'Opening',1),
+(10,2,6477,'Opening',1),
+(10,2,6478,'Opening',1),
+(10,2,6603,'Attack',1),
+(10,2,7266,'Duel',1),
+(10,2,7267,'Grovel',1),
+(10,2,7355,'Stuck',1),
+(10,2,8386,'Attacking',1),
+(10,2,8737,'Mail',1),
+(10,2,9077,'Leather',1),
+(10,2,9078,'Cloth',1),
+(10,2,9116,'Shield',1),
+(10,2,9125,'Generic',1),
+(10,2,21084,'Seal of Righteousness',1),
+(10,2,21651,'Opening',1),
+(10,2,21652,'Closing',1),
+(10,2,22027,'Remove Insignia',1),
+(10,2,22810,'Opening - No Text',1),
+(10,2,27762,'Libram',1),
+(10,2,28730,'Arcane Torrent',1),
+(10,2,28734,'Mana Tap',1),
+(10,2,28877,'Arcane Affinity',1),
+(10,3,75,'Auto Shot',1),
+(10,3,81,'Dodge',1),
+(10,3,203,'Unarmed',1),
+(10,3,204,'Defense',1),
+(10,3,264,'Bows',1),
+(10,3,522,'SPELLDEFENSE(DND)',1),
+(10,3,669,'Language Orcish',1),
+(10,3,813,'Language Thalassian',1),
+(10,3,822,'Magic Resistance',1),
+(10,3,1180,'Daggers',1),
+(10,3,2382,'Generic',1),
+(10,3,2479,'Honorless Target',1),
+(10,3,2973,'Raptor Strike',1),
+(10,3,3050,'Detect',1),
+(10,3,3365,'Opening',1),
+(10,3,6233,'Closing',1),
+(10,3,6246,'Closing',1),
+(10,3,6247,'Opening',1),
+(10,3,6477,'Opening',1),
+(10,3,6478,'Opening',1),
+(10,3,6603,'Attack',1),
+(10,3,7266,'Duel',1),
+(10,3,7267,'Grovel',1),
+(10,3,7355,'Stuck',1),
+(10,3,8386,'Attacking',1),
+(10,3,9077,'Leather',1),
+(10,3,9078,'Cloth',1),
+(10,3,9125,'Generic',1),
+(10,3,13358,'Defensive State(DND)',1),
+(10,3,21651,'Opening',1),
+(10,3,21652,'Closing',1),
+(10,3,22027,'Remove Insignia',1),
+(10,3,22810,'Opening - No Text',1),
+(10,3,24949,'Defensive State 2(DND)',1),
+(10,3,28730,'Arcane Torrent',1),
+(10,3,28734,'Mana Tap',1),
+(10,3,28877,'Arcane Affinity',1),
+(10,3,34082,'Advantaged State(DND)',1),
+(10,4,81,'Dodge',1),
+(10,4,203,'Unarmed',1),
+(10,4,204,'Defense',1),
+(10,4,522,'SPELLDEFENSE(DND)',1),
+(10,4,669,'Language Orcish',1),
+(10,4,813,'Language Thalassian',1),
+(10,4,822,'Magic Resistance',1),
+(10,4,1180,'Daggers',1),
+(10,4,1752,'Sinister Strike',1),
+(10,4,2098,'Eviscerate',1),
+(10,4,2382,'Generic',1),
+(10,4,2479,'Honorless Target',1),
+(10,4,2567,'Thrown',1),
+(10,4,2764,'Throw',1),
+(10,4,3050,'Detect',1),
+(10,4,3365,'Opening',1),
+(10,4,6233,'Closing',1),
+(10,4,6246,'Closing',1),
+(10,4,6247,'Opening',1),
+(10,4,6477,'Opening',1),
+(10,4,6478,'Opening',1),
+(10,4,6603,'Attack',1),
+(10,4,7266,'Duel',1),
+(10,4,7267,'Grovel',1),
+(10,4,7355,'Stuck',1),
+(10,4,8386,'Attacking',1),
+(10,4,9077,'Leather',1),
+(10,4,9078,'Cloth',1),
+(10,4,9125,'Generic',1),
+(10,4,16092,'Defensive State(DND)',1),
+(10,4,21184,'Rogue Passive(DND)',1),
+(10,4,21651,'Opening',1),
+(10,4,21652,'Closing',1),
+(10,4,22027,'Remove Insignia',1),
+(10,4,22810,'Opening - No Text',1),
+(10,4,25046,'Arcane Torrent',1),
+(10,4,28734,'Mana Tap',1),
+(10,4,28877,'Arcane Affinity',1),
+(10,5,81,'Dodge',1),
+(10,5,198,'One-Handed Maces',1),
+(10,5,203,'Unarmed',1),
+(10,5,204,'Defense',1),
+(10,5,522,'SPELLDEFENSE(DND)',1),
+(10,5,585,'Smite',1),
+(10,5,669,'Language Orcish',1),
+(10,5,813,'Language Thalassian',1),
+(10,5,822,'Magic Resistance',1),
+(10,5,2050,'Lesser Heal',1),
+(10,5,2382,'Generic',1),
+(10,5,2479,'Honorless Target',1),
+(10,5,3050,'Detect',1),
+(10,5,3365,'Opening',1),
+(10,5,5009,'Wands',1),
+(10,5,5019,'Shoot',1),
+(10,5,6233,'Closing',1),
+(10,5,6246,'Closing',1),
+(10,5,6247,'Opening',1),
+(10,5,6477,'Opening',1),
+(10,5,6478,'Opening',1),
+(10,5,6603,'Attack',1),
+(10,5,7266,'Duel',1),
+(10,5,7267,'Grovel',1),
+(10,5,7355,'Stuck',1),
+(10,5,8386,'Attacking',1),
+(10,5,9078,'Cloth',1),
+(10,5,9125,'Generic',1),
+(10,5,21651,'Opening',1),
+(10,5,21652,'Closing',1),
+(10,5,22027,'Remove Insignia',1),
+(10,5,22810,'Opening - No Text',1),
+(10,5,28730,'Arcane Torrent',1),
+(10,5,28734,'Mana Tap',1),
+(10,5,28877,'Arcane Affinity',1),
+(10,8,81,'Dodge',1),
+(10,8,133,'Fireball',1),
+(10,8,168,'Frost Armor',1),
+(10,8,203,'Unarmed',1),
+(10,8,204,'Defense',1),
+(10,8,227,'Staves',1),
+(10,8,522,'SPELLDEFENSE(DND)',1),
+(10,8,669,'Language Orcish',1),
+(10,8,813,'Language Thalassian',1),
+(10,8,822,'Magic Resistance',1),
+(10,8,2382,'Generic',1),
+(10,8,2479,'Honorless Target',1),
+(10,8,3050,'Detect',1),
+(10,8,3365,'Opening',1),
+(10,8,5009,'Wands',1),
+(10,8,5019,'Shoot',1),
+(10,8,6233,'Closing',1),
+(10,8,6246,'Closing',1),
+(10,8,6247,'Opening',1),
+(10,8,6477,'Opening',1),
+(10,8,6478,'Opening',1),
+(10,8,6603,'Attack',1),
+(10,8,7266,'Duel',1),
+(10,8,7267,'Grovel',1),
+(10,8,7355,'Stuck',1),
+(10,8,8386,'Attacking',1),
+(10,8,9078,'Cloth',1),
+(10,8,9125,'Generic',1),
+(10,8,21651,'Opening',1),
+(10,8,21652,'Closing',1),
+(10,8,22027,'Remove Insignia',1),
+(10,8,22810,'Opening - No Text',1),
+(10,8,28730,'Arcane Torrent',1),
+(10,8,28734,'Mana Tap',1),
+(10,8,28877,'Arcane Affinity',1),
+(10,9,81,'Dodge',1),
+(10,9,203,'Unarmed',1),
+(10,9,204,'Defense',1),
+(10,9,522,'SPELLDEFENSE(DND)',1),
+(10,9,669,'Language Orcish',1),
+(10,9,686,'Shadow Bolt',1),
+(10,9,687,'Demon Skin',1),
+(10,9,813,'Language Thalassian',1),
+(10,9,822,'Magic Resistance',1),
+(10,9,1180,'Daggers',1),
+(10,9,2382,'Generic',1),
+(10,9,2479,'Honorless Target',1),
+(10,9,3050,'Detect',1),
+(10,9,3365,'Opening',1),
+(10,9,5009,'Wands',1),
+(10,9,5019,'Shoot',1),
+(10,9,6233,'Closing',1),
+(10,9,6246,'Closing',1),
+(10,9,6247,'Opening',1),
+(10,9,6477,'Opening',1),
+(10,9,6478,'Opening',1),
+(10,9,6603,'Attack',1),
+(10,9,7266,'Duel',1),
+(10,9,7267,'Grovel',1),
+(10,9,7355,'Stuck',1),
+(10,9,8386,'Attacking',1),
+(10,9,9078,'Cloth',1),
+(10,9,9125,'Generic',1),
+(10,9,21651,'Opening',1),
+(10,9,21652,'Closing',1),
+(10,9,22027,'Remove Insignia',1),
+(10,9,22810,'Opening - No Text',1),
+(10,9,28730,'Arcane Torrent',1),
+(10,9,28734,'Mana Tap',1),
+(10,9,28877,'Arcane Affinity',1),
+(11,1,78,'Heroic Strike',1),
+(11,1,81,'Dodge',1),
+(11,1,107,'Block',1),
+(11,1,198,'One-Handed Maces',1),
+(11,1,201,'One-Handed Swords',1),
+(11,1,202,'Two-Handed Swords',1),
+(11,1,203,'Unarmed',1),
+(11,1,204,'Defense',1),
+(11,1,522,'SPELLDEFENSE(DND)',1),
+(11,1,668,'Language Common',1),
+(11,1,2382,'Generic',1),
+(11,1,2457,'Battle Stance',1),
+(11,1,2479,'Honorless Target',1),
+(11,1,3050,'Detect',1),
+(11,1,3365,'Opening',1),
+(11,1,5301,'Defensive State(DND)',1),
+(11,1,6233,'Closing',1),
+(11,1,6246,'Closing',1),
+(11,1,6247,'Opening',1),
+(11,1,6477,'Opening',1),
+(11,1,6478,'Opening',1),
+(11,1,6562,'Heroic Presence',1),
+(11,1,6603,'Attack',1),
+(11,1,7266,'Duel',1),
+(11,1,7267,'Grovel',1),
+(11,1,7355,'Stuck',1),
+(11,1,7376,'Defensive Stance Passive',0),
+(11,1,7381,'Berserker Stance Passive',0),
+(11,1,8386,'Attacking',1),
+(11,1,8737,'Mail',1),
+(11,1,9077,'Leather',1),
+(11,1,9078,'Cloth',1),
+(11,1,9116,'Shield',1),
+(11,1,9125,'Generic',1),
+(11,1,20579,'Shadow Resistance',1),
+(11,1,21156,'Battle Stance Passive',0),
+(11,1,21651,'Opening',1),
+(11,1,21652,'Closing',1),
+(11,1,22027,'Remove Insignia',1),
+(11,1,22810,'Opening - No Text',1),
+(11,1,28875,'Gemcutting',1),
+(11,1,28880,'Gift of the Naaru',1),
+(11,1,29932,'Language Draenei',1),
+(11,1,32215,'Victorious State',1),
+(11,2,81,'Dodge',1),
+(11,2,107,'Block',1),
+(11,2,198,'One-Handed Maces',1),
+(11,2,199,'Two-Handed Maces',1),
+(11,2,203,'Unarmed',1),
+(11,2,204,'Defense',1),
+(11,2,522,'SPELLDEFENSE(DND)',1),
+(11,2,635,'Holy Light',1),
+(11,2,668,'Language Common',1),
+(11,2,2382,'Generic',1),
+(11,2,2479,'Honorless Target',1),
+(11,2,3050,'Detect',1),
+(11,2,3365,'Opening',1),
+(11,2,6233,'Closing',1),
+(11,2,6246,'Closing',1),
+(11,2,6247,'Opening',1),
+(11,2,6477,'Opening',1),
+(11,2,6478,'Opening',1),
+(11,2,6562,'Heroic Presence',1),
+(11,2,6603,'Attack',1),
+(11,2,7266,'Duel',1),
+(11,2,7267,'Grovel',1),
+(11,2,7355,'Stuck',1),
+(11,2,8386,'Attacking',1),
+(11,2,8737,'Mail',1),
+(11,2,9077,'Leather',1),
+(11,2,9078,'Cloth',1),
+(11,2,9116,'Shield',1),
+(11,2,9125,'Generic',1),
+(11,2,21084,'Seal of Righteousness',1),
+(11,2,20579,'Shadow Resistance',1),
+(11,2,21651,'Opening',1),
+(11,2,21652,'Closing',1),
+(11,2,22027,'Remove Insignia',1),
+(11,2,22810,'Opening - No Text',1),
+(11,2,27762,'Libram',1),
+(11,2,28875,'Gemcutting',1),
+(11,2,28880,'Gift of the Naaru',1),
+(11,2,29932,'Language Draenei',1),
+(11,3,75,'Auto Shot',1),
+(11,3,81,'Dodge',1),
+(11,3,201,'One-Handed Swords',1),
+(11,3,203,'Unarmed',1),
+(11,3,204,'Defense',1),
+(11,3,522,'SPELLDEFENSE(DND)',1),
+(11,3,668,'Language Common',1),
+(11,3,2382,'Generic',1),
+(11,3,2479,'Honorless Target',1),
+(11,3,2973,'Raptor Strike',1),
+(11,3,3050,'Detect',1),
+(11,3,3365,'Opening',1),
+(11,3,5011,'Crossbows',1),
+(11,3,6233,'Closing',1),
+(11,3,6246,'Closing',1),
+(11,3,6247,'Opening',1),
+(11,3,6477,'Opening',1),
+(11,3,6478,'Opening',1),
+(11,3,6562,'Heroic Presence',1),
+(11,3,6603,'Attack',1),
+(11,3,7266,'Duel',1),
+(11,3,7267,'Grovel',1),
+(11,3,7355,'Stuck',1),
+(11,3,8386,'Attacking',1),
+(11,3,9077,'Leather',1),
+(11,3,9078,'Cloth',1),
+(11,3,9125,'Generic',1),
+(11,3,13358,'Defensive State(DND)',1),
+(11,3,20579,'Shadow Resistance',1),
+(11,3,21651,'Opening',1),
+(11,3,21652,'Closing',1),
+(11,3,22027,'Remove Insignia',1),
+(11,3,22810,'Opening - No Text',1),
+(11,3,24949,'Defensive State 2(DND)',1),
+(11,3,28875,'Gemcutting',1),
+(11,3,28880,'Gift of the Naaru',1),
+(11,3,29932,'Language Draenei',1),
+(11,3,34082,'Advantaged State(DND)',1),
+(11,5,81,'Dodge',1),
+(11,5,198,'One-Handed Maces',1),
+(11,5,203,'Unarmed',1),
+(11,5,204,'Defense',1),
+(11,5,522,'SPELLDEFENSE(DND)',1),
+(11,5,585,'Smite',1),
+(11,5,668,'Language Common',1),
+(11,5,2050,'Lesser Heal',1),
+(11,5,2382,'Generic',1),
+(11,5,2479,'Honorless Target',1),
+(11,5,3050,'Detect',1),
+(11,5,3365,'Opening',1),
+(11,5,5009,'Wands',1),
+(11,5,5019,'Shoot',1),
+(11,5,6233,'Closing',1),
+(11,5,6246,'Closing',1),
+(11,5,6247,'Opening',1),
+(11,5,6477,'Opening',1),
+(11,5,6478,'Opening',1),
+(11,5,6603,'Attack',1),
+(11,5,7266,'Duel',1),
+(11,5,7267,'Grovel',1),
+(11,5,7355,'Stuck',1),
+(11,5,8386,'Attacking',1),
+(11,5,9078,'Cloth',1),
+(11,5,9125,'Generic',1),
+(11,5,20579,'Shadow Resistance',1),
+(11,5,21651,'Opening',1),
+(11,5,21652,'Closing',1),
+(11,5,22027,'Remove Insignia',1),
+(11,5,22810,'Opening - No Text',1),
+(11,5,28875,'Gemcutting',1),
+(11,5,28878,'Inspiring Presence',1),
+(11,5,28880,'Gift of the Naaru',1),
+(11,5,29932,'Language Draenei',1),
+(11,7,81,'Dodge',1),
+(11,7,107,'Block',1),
+(11,7,198,'One-Handed Maces',1),
+(11,7,203,'Unarmed',1),
+(11,7,204,'Defense',1),
+(11,7,227,'Staves',1),
+(11,7,331,'Healing Wave',1),
+(11,7,403,'Lightning Bolt',1),
+(11,7,522,'SPELLDEFENSE(DND)',1),
+(11,7,668,'Language Common',1),
+(11,7,2382,'Generic',1),
+(11,7,2479,'Honorless Target',1),
+(11,7,3050,'Detect',1),
+(11,7,3365,'Opening',1),
+(11,7,6233,'Closing',1),
+(11,7,6246,'Closing',1),
+(11,7,6247,'Opening',1),
+(11,7,6477,'Opening',1),
+(11,7,6478,'Opening',1),
+(11,7,6603,'Attack',1),
+(11,7,7266,'Duel',1),
+(11,7,7267,'Grovel',1),
+(11,7,7355,'Stuck',1),
+(11,7,8386,'Attacking',1),
+(11,7,9077,'Leather',1),
+(11,7,9078,'Cloth',1),
+(11,7,9116,'Shield',1),
+(11,7,9125,'Generic',1),
+(11,7,20579,'Shadow Resistance',1),
+(11,7,21651,'Opening',1),
+(11,7,21652,'Closing',1),
+(11,7,22027,'Remove Insignia',1),
+(11,7,22810,'Opening - No Text',1),
+(11,7,27763,'Totem',1),
+(11,7,28875,'Gemcutting',1),
+(11,7,28878,'Inspiring Presence',1),
+(11,7,28880,'Gift of the Naaru',1),
+(11,7,29932,'Language Draenei',1),
+(11,8,81,'Dodge',1),
+(11,8,133,'Fireball',1),
+(11,8,168,'Frost Armor',1),
+(11,8,203,'Unarmed',1),
+(11,8,204,'Defense',1),
+(11,8,227,'Staves',1),
+(11,8,522,'SPELLDEFENSE(DND)',1),
+(11,8,668,'Language Common',1),
+(11,8,2382,'Generic',1),
+(11,8,2479,'Honorless Target',1),
+(11,8,3050,'Detect',1),
+(11,8,3365,'Opening',1),
+(11,8,5009,'Wands',1),
+(11,8,5019,'Shoot',1),
+(11,8,6233,'Closing',1),
+(11,8,6246,'Closing',1),
+(11,8,6247,'Opening',1),
+(11,8,6477,'Opening',1),
+(11,8,6478,'Opening',1),
+(11,8,6603,'Attack',1),
+(11,8,7266,'Duel',1),
+(11,8,7267,'Grovel',1),
+(11,8,7355,'Stuck',1),
+(11,8,8386,'Attacking',1),
+(11,8,9078,'Cloth',1),
+(11,8,9125,'Generic',1),
+(11,8,20579,'Shadow Resistance',1),
+(11,8,21651,'Opening',1),
+(11,8,21652,'Closing',1),
+(11,8,22027,'Remove Insignia',1),
+(11,8,22810,'Opening - No Text',1),
+(11,8,28875,'Gemcutting',1),
+(11,8,28878,'Inspiring Presence',1),
+(11,8,28880,'Gift of the Naaru',1),
+(11,8,29932,'Language Draenei',1);
+/*!40000 ALTER TABLE `playercreateinfo_spell_custom` ENABLE KEYS */;
+UNLOCK TABLES;
+
+-- And the class spells:
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,1,2048),
+(1,1,30324),
+(1,1,11578),
+(1,1,25208),
+(1,1,25264),
+(1,1,2687),
+(1,1,71),
+(1,1,25225),
+(1,1,355),
+(1,1,11585),
+(1,1,29704),
+(1,1,25203),
+(1,1,30357),
+(1,1,25266),
+(1,1,2565),
+(1,1,676),
+(1,1,25231),
+(1,1,20230),
+(1,1,5246),
+(1,1,25236),
+(1,1,1161),
+(1,1,871),
+(1,1,2458),
+(1,1,25275),
+(1,1,25242),
+(1,1,18499),
+(1,1,1680),
+(1,1,6554),
+(1,1,1719),
+(1,1,34428),
+(1,1,23920),
+(1,1,469),
+(1,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,1,2048),
+(2,1,30324),
+(2,1,11578),
+(2,1,25208),
+(2,1,25264),
+(2,1,2687),
+(2,1,71),
+(2,1,25225),
+(2,1,355),
+(2,1,11585),
+(2,1,29704),
+(2,1,25203),
+(2,1,30357),
+(2,1,25266),
+(2,1,2565),
+(2,1,676),
+(2,1,25231),
+(2,1,20230),
+(2,1,5246),
+(2,1,25236),
+(2,1,1161),
+(2,1,871),
+(2,1,2458),
+(2,1,25275),
+(2,1,25242),
+(2,1,18499),
+(2,1,1680),
+(2,1,6554),
+(2,1,1719),
+(2,1,34428),
+(2,1,23920),
+(2,1,469),
+(2,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,1,2048),
+(3,1,30324),
+(3,1,11578),
+(3,1,25208),
+(3,1,25264),
+(3,1,2687),
+(3,1,71),
+(3,1,25225),
+(3,1,355),
+(3,1,11585),
+(3,1,29704),
+(3,1,25203),
+(3,1,30357),
+(3,1,25266),
+(3,1,2565),
+(3,1,676),
+(3,1,25231),
+(3,1,20230),
+(3,1,5246),
+(3,1,25236),
+(3,1,1161),
+(3,1,871),
+(3,1,2458),
+(3,1,25275),
+(3,1,25242),
+(3,1,18499),
+(3,1,1680),
+(3,1,6554),
+(3,1,1719),
+(3,1,34428),
+(3,1,23920),
+(3,1,469),
+(3,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,1,2048),
+(4,1,30324),
+(4,1,11578),
+(4,1,25208),
+(4,1,25264),
+(4,1,2687),
+(4,1,71),
+(4,1,25225),
+(4,1,355),
+(4,1,11585),
+(4,1,29704),
+(4,1,25203),
+(4,1,30357),
+(4,1,25266),
+(4,1,2565),
+(4,1,676),
+(4,1,25231),
+(4,1,20230),
+(4,1,5246),
+(4,1,25236),
+(4,1,1161),
+(4,1,871),
+(4,1,2458),
+(4,1,25275),
+(4,1,25242),
+(4,1,18499),
+(4,1,1680),
+(4,1,6554),
+(4,1,1719),
+(4,1,34428),
+(4,1,23920),
+(4,1,469),
+(4,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,1,2048),
+(5,1,30324),
+(5,1,11578),
+(5,1,25208),
+(5,1,25264),
+(5,1,2687),
+(5,1,71),
+(5,1,25225),
+(5,1,355),
+(5,1,11585),
+(5,1,29704),
+(5,1,25203),
+(5,1,30357),
+(5,1,25266),
+(5,1,2565),
+(5,1,676),
+(5,1,25231),
+(5,1,20230),
+(5,1,5246),
+(5,1,25236),
+(5,1,1161),
+(5,1,871),
+(5,1,2458),
+(5,1,25275),
+(5,1,25242),
+(5,1,18499),
+(5,1,1680),
+(5,1,6554),
+(5,1,1719),
+(5,1,34428),
+(5,1,23920),
+(5,1,469),
+(5,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,1,2048),
+(6,1,30324),
+(6,1,11578),
+(6,1,25208),
+(6,1,25264),
+(6,1,2687),
+(6,1,71),
+(6,1,25225),
+(6,1,355),
+(6,1,11585),
+(6,1,29704),
+(6,1,25203),
+(6,1,30357),
+(6,1,25266),
+(6,1,2565),
+(6,1,676),
+(6,1,25231),
+(6,1,20230),
+(6,1,5246),
+(6,1,25236),
+(6,1,1161),
+(6,1,871),
+(6,1,2458),
+(6,1,25275),
+(6,1,25242),
+(6,1,18499),
+(6,1,1680),
+(6,1,6554),
+(6,1,1719),
+(6,1,34428),
+(6,1,23920),
+(6,1,469),
+(6,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,1,2048),
+(7,1,30324),
+(7,1,11578),
+(7,1,25208),
+(7,1,25264),
+(7,1,2687),
+(7,1,71),
+(7,1,25225),
+(7,1,355),
+(7,1,11585),
+(7,1,29704),
+(7,1,25203),
+(7,1,30357),
+(7,1,25266),
+(7,1,2565),
+(7,1,676),
+(7,1,25231),
+(7,1,20230),
+(7,1,5246),
+(7,1,25236),
+(7,1,1161),
+(7,1,871),
+(7,1,2458),
+(7,1,25275),
+(7,1,25242),
+(7,1,18499),
+(7,1,1680),
+(7,1,6554),
+(7,1,1719),
+(7,1,34428),
+(7,1,23920),
+(7,1,469),
+(7,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,1,2048),
+(8,1,30324),
+(8,1,11578),
+(8,1,25208),
+(8,1,25264),
+(8,1,2687),
+(8,1,71),
+(8,1,25225),
+(8,1,355),
+(8,1,11585),
+(8,1,29704),
+(8,1,25203),
+(8,1,30357),
+(8,1,25266),
+(8,1,2565),
+(8,1,676),
+(8,1,25231),
+(8,1,20230),
+(8,1,5246),
+(8,1,25236),
+(8,1,1161),
+(8,1,871),
+(8,1,2458),
+(8,1,25275),
+(8,1,25242),
+(8,1,18499),
+(8,1,1680),
+(8,1,6554),
+(8,1,1719),
+(8,1,34428),
+(8,1,23920),
+(8,1,469),
+(8,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,1,2048),
+(11,1,30324),
+(11,1,11578),
+(11,1,25208),
+(11,1,25264),
+(11,1,2687),
+(11,1,71),
+(11,1,25225),
+(11,1,355),
+(11,1,11585),
+(11,1,29704),
+(11,1,25203),
+(11,1,30357),
+(11,1,25266),
+(11,1,2565),
+(11,1,676),
+(11,1,25231),
+(11,1,20230),
+(11,1,5246),
+(11,1,25236),
+(11,1,1161),
+(11,1,871),
+(11,1,2458),
+(11,1,25275),
+(11,1,25242),
+(11,1,18499),
+(11,1,1680),
+(11,1,6554),
+(11,1,1719),
+(11,1,34428),
+(11,1,23920),
+(11,1,469),
+(11,1,3411);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,3,27014),
+(2,3,1494),
+(2,3,13163),
+(2,3,27016),
+(2,3,27019),
+(2,3,14325),
+(2,3,5116),
+(2,3,27044),
+(2,3,883),
+(2,3,2641),
+(2,3,6991),
+(2,3,982),
+(2,3,1515),
+(2,3,19883),
+(2,3,27020),
+(2,3,27046),
+(2,3,14268),
+(2,3,6197),
+(2,3,1002),
+(2,3,14327),
+(2,3,27023),
+(2,3,36916),
+(2,3,27021),
+(2,3,19884),
+(2,3,5118),
+(2,3,27015),
+(2,3,14311),
+(2,3,3043),
+(2,3,1462),
+(2,3,19885),
+(2,3,3045),
+(2,3,19880),
+(2,3,13809),
+(2,3,13161),
+(2,3,5384),
+(2,3,1543),
+(2,3,19878),
+(2,3,27025),
+(2,3,27018),
+(2,3,13159),
+(2,3,19882),
+(2,3,27022),
+(2,3,27045),
+(2,3,19879),
+(2,3,19801),
+(2,3,34120),
+(2,3,34074),
+(2,3,34026),
+(2,3,34600),
+(2,3,34477);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,3,27014),
+(3,3,1494),
+(3,3,13163),
+(3,3,27016),
+(3,3,27019),
+(3,3,14325),
+(3,3,5116),
+(3,3,27044),
+(3,3,883),
+(3,3,2641),
+(3,3,6991),
+(3,3,982),
+(3,3,1515),
+(3,3,19883),
+(3,3,27020),
+(3,3,27046),
+(3,3,14268),
+(3,3,6197),
+(3,3,1002),
+(3,3,14327),
+(3,3,27023),
+(3,3,36916),
+(3,3,27021),
+(3,3,19884),
+(3,3,5118),
+(3,3,27015),
+(3,3,14311),
+(3,3,3043),
+(3,3,1462),
+(3,3,19885),
+(3,3,3045),
+(3,3,19880),
+(3,3,13809),
+(3,3,13161),
+(3,3,5384),
+(3,3,1543),
+(3,3,19878),
+(3,3,27025),
+(3,3,27018),
+(3,3,13159),
+(3,3,19882),
+(3,3,27022),
+(3,3,27045),
+(3,3,19879),
+(3,3,19801),
+(3,3,34120),
+(3,3,34074),
+(3,3,34026),
+(3,3,34600),
+(3,3,34477);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,3,27014),
+(4,3,1494),
+(4,3,13163),
+(4,3,27016),
+(4,3,27019),
+(4,3,14325),
+(4,3,5116),
+(4,3,27044),
+(4,3,883),
+(4,3,2641),
+(4,3,6991),
+(4,3,982),
+(4,3,1515),
+(4,3,19883),
+(4,3,27020),
+(4,3,27046),
+(4,3,14268),
+(4,3,6197),
+(4,3,1002),
+(4,3,14327),
+(4,3,27023),
+(4,3,36916),
+(4,3,27021),
+(4,3,19884),
+(4,3,5118),
+(4,3,27015),
+(4,3,14311),
+(4,3,3043),
+(4,3,1462),
+(4,3,19885),
+(4,3,3045),
+(4,3,19880),
+(4,3,13809),
+(4,3,13161),
+(4,3,5384),
+(4,3,1543),
+(4,3,19878),
+(4,3,27025),
+(4,3,27018),
+(4,3,13159),
+(4,3,19882),
+(4,3,27022),
+(4,3,27045),
+(4,3,19879),
+(4,3,19801),
+(4,3,34120),
+(4,3,34074),
+(4,3,34026),
+(4,3,34600),
+(4,3,34477);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,3,27014),
+(6,3,1494),
+(6,3,13163),
+(6,3,27016),
+(6,3,27019),
+(6,3,14325),
+(6,3,5116),
+(6,3,27044),
+(6,3,883),
+(6,3,2641),
+(6,3,6991),
+(6,3,982),
+(6,3,1515),
+(6,3,19883),
+(6,3,27020),
+(6,3,27046),
+(6,3,14268),
+(6,3,6197),
+(6,3,1002),
+(6,3,14327),
+(6,3,27023),
+(6,3,36916),
+(6,3,27021),
+(6,3,19884),
+(6,3,5118),
+(6,3,27015),
+(6,3,14311),
+(6,3,3043),
+(6,3,1462),
+(6,3,19885),
+(6,3,3045),
+(6,3,19880),
+(6,3,13809),
+(6,3,13161),
+(6,3,5384),
+(6,3,1543),
+(6,3,19878),
+(6,3,27025),
+(6,3,27018),
+(6,3,13159),
+(6,3,19882),
+(6,3,27022),
+(6,3,27045),
+(6,3,19879),
+(6,3,19801),
+(6,3,34120),
+(6,3,34074),
+(6,3,34026),
+(6,3,34600),
+(6,3,34477);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,3,27014),
+(8,3,1494),
+(8,3,13163),
+(8,3,27016),
+(8,3,27019),
+(8,3,14325),
+(8,3,5116),
+(8,3,27044),
+(8,3,883),
+(8,3,2641),
+(8,3,6991),
+(8,3,982),
+(8,3,1515),
+(8,3,19883),
+(8,3,27020),
+(8,3,27046),
+(8,3,14268),
+(8,3,6197),
+(8,3,1002),
+(8,3,14327),
+(8,3,27023),
+(8,3,36916),
+(8,3,27021),
+(8,3,19884),
+(8,3,5118),
+(8,3,27015),
+(8,3,14311),
+(8,3,3043),
+(8,3,1462),
+(8,3,19885),
+(8,3,3045),
+(8,3,19880),
+(8,3,13809),
+(8,3,13161),
+(8,3,5384),
+(8,3,1543),
+(8,3,19878),
+(8,3,27025),
+(8,3,27018),
+(8,3,13159),
+(8,3,19882),
+(8,3,27022),
+(8,3,27045),
+(8,3,19879),
+(8,3,19801),
+(8,3,34120),
+(8,3,34074),
+(8,3,34026),
+(8,3,34600),
+(8,3,34477);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,3,27014),
+(10,3,1494),
+(10,3,13163),
+(10,3,27016),
+(10,3,27019),
+(10,3,14325),
+(10,3,5116),
+(10,3,27044),
+(10,3,883),
+(10,3,2641),
+(10,3,6991),
+(10,3,982),
+(10,3,1515),
+(10,3,19883),
+(10,3,27020),
+(10,3,27046),
+(10,3,14268),
+(10,3,6197),
+(10,3,1002),
+(10,3,14327),
+(10,3,27023),
+(10,3,36916),
+(10,3,27021),
+(10,3,19884),
+(10,3,5118),
+(10,3,27015),
+(10,3,14311),
+(10,3,3043),
+(10,3,1462),
+(10,3,19885),
+(10,3,3045),
+(10,3,19880),
+(10,3,13809),
+(10,3,13161),
+(10,3,5384),
+(10,3,1543),
+(10,3,19878),
+(10,3,27025),
+(10,3,27018),
+(10,3,13159),
+(10,3,19882),
+(10,3,27022),
+(10,3,27045),
+(10,3,19879),
+(10,3,19801),
+(10,3,34120),
+(10,3,34074),
+(10,3,34026),
+(10,3,34600),
+(10,3,34477);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,3,27014),
+(11,3,1494),
+(11,3,13163),
+(11,3,27016),
+(11,3,27019),
+(11,3,14325),
+(11,3,5116),
+(11,3,27044),
+(11,3,883),
+(11,3,2641),
+(11,3,6991),
+(11,3,982),
+(11,3,1515),
+(11,3,19883),
+(11,3,27020),
+(11,3,27046),
+(11,3,14268),
+(11,3,6197),
+(11,3,1002),
+(11,3,14327),
+(11,3,27023),
+(11,3,36916),
+(11,3,27021),
+(11,3,19884),
+(11,3,5118),
+(11,3,27015),
+(11,3,14311),
+(11,3,3043),
+(11,3,1462),
+(11,3,19885),
+(11,3,3045),
+(11,3,19880),
+(11,3,13809),
+(11,3,13161),
+(11,3,5384),
+(11,3,1543),
+(11,3,19878),
+(11,3,27025),
+(11,3,27018),
+(11,3,13159),
+(11,3,19882),
+(11,3,27022),
+(11,3,27045),
+(11,3,19879),
+(11,3,19801),
+(11,3,34120),
+(11,3,34074),
+(11,3,34026),
+(11,3,34600),
+(11,3,34477);
+
+
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,2,27149),
+(1,2,27136),
+(1,2,27155),
+(1,2,27140),
+(1,2,20271),
+(1,2,27158),
+(1,2,10308),
+(1,2,10278),
+(1,2,27154),
+(1,2,20773),
+(1,2,27142),
+(1,2,31789),
+(1,2,27150),
+(1,2,25780),
+(1,2,1044),
+(1,2,33776),
+(1,2,27173),
+(1,2,27138),
+(1,2,27137),
+(1,2,5502),
+(1,2,19746),
+(1,2,31895),
+(1,2,5627),
+(1,2,1038),
+(1,2,27151),
+(1,2,19752),
+(1,2,27160),
+(1,2,27152),
+(1,2,1020),
+(1,2,27153),
+(1,2,27166),
+(1,2,27144),
+(1,2,4987),
+(1,2,27180),
+(1,2,27148),
+(1,2,27139),
+(1,2,27141),
+(1,2,10326),
+(1,2,27143),
+(1,2,25898),
+(1,2,27145),
+(1,2,25895),
+(1,2,32223),
+(1,2,27169),
+(1,2,31884);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,2,27149),
+(3,2,27136),
+(3,2,27155),
+(3,2,27140),
+(3,2,20271),
+(3,2,27158),
+(3,2,10308),
+(3,2,10278),
+(3,2,27154),
+(3,2,20773),
+(3,2,27142),
+(3,2,31789),
+(3,2,27150),
+(3,2,25780),
+(3,2,1044),
+(3,2,33776),
+(3,2,27173),
+(3,2,27138),
+(3,2,27137),
+(3,2,5502),
+(3,2,19746),
+(3,2,31895),
+(3,2,5627),
+(3,2,1038),
+(3,2,27151),
+(3,2,19752),
+(3,2,27160),
+(3,2,27152),
+(3,2,1020),
+(3,2,27153),
+(3,2,27166),
+(3,2,27144),
+(3,2,4987),
+(3,2,27180),
+(3,2,27148),
+(3,2,27139),
+(3,2,27141),
+(3,2,10326),
+(3,2,27143),
+(3,2,25898),
+(3,2,27145),
+(3,2,25895),
+(3,2,32223),
+(3,2,27169),
+(3,2,31884);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,2,27149),
+(10,2,27136),
+(10,2,27155),
+(10,2,27140),
+(10,2,20271),
+(10,2,27158),
+(10,2,10308),
+(10,2,10278),
+(10,2,27154),
+(10,2,20773),
+(10,2,27142),
+(10,2,31789),
+(10,2,27150),
+(10,2,25780),
+(10,2,1044),
+(10,2,33776),
+(10,2,27173),
+(10,2,27138),
+(10,2,27137),
+(10,2,5502),
+(10,2,19746),
+(10,2,31895),
+(10,2,5627),
+(10,2,1038),
+(10,2,27151),
+(10,2,19752),
+(10,2,27160),
+(10,2,27152),
+(10,2,1020),
+(10,2,27153),
+(10,2,27166),
+(10,2,27144),
+(10,2,4987),
+(10,2,27180),
+(10,2,27148),
+(10,2,27139),
+(10,2,27141),
+(10,2,10326),
+(10,2,27143),
+(10,2,25898),
+(10,2,27145),
+(10,2,25895),
+(10,2,32223),
+(10,2,27169),
+(10,2,31884);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,2,27149),
+(11,2,27136),
+(11,2,27155),
+(11,2,27140),
+(11,2,20271),
+(11,2,27158),
+(11,2,10308),
+(11,2,10278),
+(11,2,27154),
+(11,2,20773),
+(11,2,27142),
+(11,2,31789),
+(11,2,27150),
+(11,2,25780),
+(11,2,1044),
+(11,2,33776),
+(11,2,27173),
+(11,2,27138),
+(11,2,27137),
+(11,2,5502),
+(11,2,19746),
+(11,2,31895),
+(11,2,5627),
+(11,2,1038),
+(11,2,27151),
+(11,2,19752),
+(11,2,27160),
+(11,2,27152),
+(11,2,1020),
+(11,2,27153),
+(11,2,27166),
+(11,2,27144),
+(11,2,4987),
+(11,2,27180),
+(11,2,27148),
+(11,2,27139),
+(11,2,27141),
+(11,2,10326),
+(11,2,27143),
+(11,2,25898),
+(11,2,27145),
+(11,2,25895),
+(11,2,32223),
+(11,2,27169),
+(11,2,31884);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,4,26865),
+(1,4,26862),
+(1,4,1787),
+(1,4,26863),
+(1,4,921),
+(1,4,38764),
+(1,4,26669),
+(1,4,11297),
+(1,4,6774),
+(1,4,11305),
+(1,4,38768),
+(1,4,26866),
+(1,4,26884),
+(1,4,27448),
+(1,4,1804),
+(1,4,27441),
+(1,4,2842),
+(1,4,1725),
+(1,4,26867),
+(1,4,26889),
+(1,4,1833),
+(1,4,1842),
+(1,4,408),
+(1,4,2094),
+(1,4,32684),
+(1,4,26679),
+(1,4,31224),
+(1,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,4,26865),
+(2,4,26862),
+(2,4,1787),
+(2,4,26863),
+(2,4,921),
+(2,4,38764),
+(2,4,26669),
+(2,4,11297),
+(2,4,6774),
+(2,4,11305),
+(2,4,38768),
+(2,4,26866),
+(2,4,26884),
+(2,4,27448),
+(2,4,1804),
+(2,4,27441),
+(2,4,2842),
+(2,4,1725),
+(2,4,26867),
+(2,4,26889),
+(2,4,1833),
+(2,4,1842),
+(2,4,408),
+(2,4,2094),
+(2,4,32684),
+(2,4,26679),
+(2,4,31224),
+(2,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,4,26865),
+(3,4,26862),
+(3,4,1787),
+(3,4,26863),
+(3,4,921),
+(3,4,38764),
+(3,4,26669),
+(3,4,11297),
+(3,4,6774),
+(3,4,11305),
+(3,4,38768),
+(3,4,26866),
+(3,4,26884),
+(3,4,27448),
+(3,4,1804),
+(3,4,27441),
+(3,4,2842),
+(3,4,1725),
+(3,4,26867),
+(3,4,26889),
+(3,4,1833),
+(3,4,1842),
+(3,4,408),
+(3,4,2094),
+(3,4,32684),
+(3,4,26679),
+(3,4,31224),
+(3,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,4,26865),
+(4,4,26862),
+(4,4,1787),
+(4,4,26863),
+(4,4,921),
+(4,4,38764),
+(4,4,26669),
+(4,4,11297),
+(4,4,6774),
+(4,4,11305),
+(4,4,38768),
+(4,4,26866),
+(4,4,426884),
+(4,4,427448),
+(4,4,1804),
+(4,4,27441),
+(4,4,2842),
+(4,4,1725),
+(4,4,26867),
+(4,4,26889),
+(4,4,1833),
+(4,4,1842),
+(4,4,408),
+(4,4,2094),
+(4,4,32684),
+(4,4,26679),
+(4,4,31224),
+(4,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,4,26865),
+(5,4,26862),
+(5,4,1787),
+(5,4,26863),
+(5,4,921),
+(5,4,38764),
+(5,4,26669),
+(5,4,11297),
+(5,4,6774),
+(5,4,11305),
+(5,4,38768),
+(5,4,26866),
+(5,4,26884),
+(5,4,27448),
+(5,4,1804),
+(5,4,27441),
+(5,4,2842),
+(5,4,1725),
+(5,4,26867),
+(5,4,26889),
+(5,4,1833),
+(5,4,1842),
+(5,4,408),
+(5,4,2094),
+(5,4,32684),
+(5,4,26679),
+(5,4,31224),
+(5,4,5938);
+-- This file is made by Micke223
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,4,26865),
+(7,4,26862),
+(7,4,1787),
+(7,4,26863),
+(7,4,921),
+(7,4,38764),
+(7,4,26669),
+(7,4,11297),
+(7,4,6774),
+(7,4,11305),
+(7,4,38768),
+(7,4,26866),
+(7,4,26884),
+(7,4,27448),
+(7,4,1804),
+(7,4,27441),
+(7,4,2842),
+(7,4,1725),
+(7,4,26867),
+(7,4,26889),
+(7,4,1833),
+(7,4,1842),
+(7,4,408),
+(7,4,2094),
+(7,4,32684),
+(7,4,26679),
+(7,4,31224),
+(7,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,4,26865),
+(8,4,26862),
+(8,4,1787),
+(8,4,26863),
+(8,4,921),
+(8,4,38764),
+(8,4,26669),
+(8,4,11297),
+(8,4,6774),
+(8,4,11305),
+(8,4,38768),
+(8,4,26866),
+(8,4,26884),
+(8,4,27448),
+(8,4,1804),
+(8,4,27441),
+(8,4,2842),
+(8,4,1725),
+(8,4,26867),
+(8,4,26889),
+(8,4,1833),
+(8,4,1842),
+(8,4,408),
+(8,4,2094),
+(8,4,32684),
+(8,4,26679),
+(8,4,31224),
+(8,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,4,26865),
+(10,4,26862),
+(10,4,1787),
+(10,4,26863),
+(10,4,921),
+(10,4,38764),
+(10,4,26669),
+(10,4,11297),
+(10,4,6774),
+(10,4,11305),
+(10,4,38768),
+(10,4,26866),
+(10,4,26884),
+(10,4,27448),
+(10,4,1804),
+(10,4,27441),
+(10,4,2842),
+(10,4,1725),
+(10,4,26867),
+(10,4,26889),
+(10,4,1833),
+(10,4,1842),
+(10,4,408),
+(10,4,2094),
+(10,4,32684),
+(10,4,26679),
+(10,4,31224),
+(10,4,5938);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,27215),
+(1,9,27209),
+(1,9,27216),
+(1,9,30909),
+(1,9,27222),
+(1,9,27218),
+(1,9,6215),
+(1,9,27230),
+(1,9,27217),
+(1,9,27259),
+(1,9,27226),
+(1,9,27220),
+(1,9,5697),
+(1,9,27238),
+(1,9,30459),
+(1,9,27260),
+(1,9,27212),
+(1,9,698),
+(1,9,5500),
+(1,9,30908),
+(1,9,11719),
+(1,9,132),
+(1,9,18647),
+(1,9,27213),
+(1,9,11726),
+(1,9,27228),
+(1,9,28610),
+(1,9,28172),
+(1,9,27250),
+(1,9,17928),
+(1,9,27223),
+(1,9,27229),
+(1,9,30545),
+(1,9,30910),
+(1,9,18540),
+(1,9,28189),
+(1,9,32231),
+(1,9,29858),
+(1,9,29893),
+(1,9,27243);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,9,27215),
+(2,9,27209),
+(2,9,27216),
+(2,9,30909),
+(2,9,27222),
+(2,9,27218),
+(2,9,6215),
+(2,9,27230),
+(2,9,27217),
+(2,9,27259),
+(2,9,27226),
+(2,9,27220),
+(2,9,5697),
+(2,9,27238),
+(2,9,30459),
+(2,9,27260),
+(2,9,27212),
+(2,9,698),
+(2,9,5500),
+(2,9,30908),
+(2,9,11719),
+(2,9,132),
+(2,9,18647),
+(2,9,27213),
+(2,9,11726),
+(2,9,27228),
+(2,9,28610),
+(2,9,28172),
+(2,9,27250),
+(2,9,17928),
+(2,9,27223),
+(2,9,27229),
+(2,9,30545),
+(2,9,30910),
+(2,9,18540),
+(2,9,28189),
+(2,9,32231),
+(2,9,29858),
+(2,9,29893),
+(2,9,27243);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,9,27215),
+(5,9,27209),
+(5,9,27216),
+(5,9,30909),
+(5,9,27222),
+(5,9,27218),
+(5,9,6215),
+(5,9,27230),
+(5,9,27217),
+(5,9,27259),
+(5,9,27226),
+(5,9,27220),
+(5,9,5697),
+(5,9,27238),
+(5,9,30459),
+(5,9,27260),
+(5,9,27212),
+(5,9,698),
+(5,9,5500),
+(5,9,30908),
+(5,9,11719),
+(5,9,132),
+(5,9,18647),
+(5,9,27213),
+(5,9,11726),
+(5,9,27228),
+(5,9,28610),
+(5,9,28172),
+(5,9,27250),
+(5,9,17928),
+(5,9,27223),
+(5,9,27229),
+(5,9,30545),
+(5,9,30910),
+(5,9,18540),
+(5,9,28189),
+(5,9,32231),
+(5,9,29858),
+(5,9,29893),
+(5,9,27243);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,9,27215),
+(7,9,27209),
+(7,9,27216),
+(7,9,30909),
+(7,9,27222),
+(7,9,27218),
+(7,9,6215),
+(7,9,27230),
+(7,9,27217),
+(7,9,27259),
+(7,9,27226),
+(7,9,27220),
+(7,9,5697),
+(7,9,27238),
+(7,9,30459),
+(7,9,27260),
+(7,9,27212),
+(7,9,698),
+(7,9,5500),
+(7,9,30908),
+(7,9,11719),
+(7,9,132),
+(7,9,18647),
+(7,9,27213),
+(7,9,11726),
+(7,9,27228),
+(7,9,28610),
+(7,9,28172),
+(7,9,27250),
+(7,9,17928),
+(7,9,27223),
+(7,9,27229),
+(7,9,30545),
+(7,9,30910),
+(7,9,18540),
+(7,9,28189),
+(7,9,32231),
+(7,9,29858),
+(7,9,29893),
+(7,9,27243);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,9,27215),
+(11,9,27209),
+(11,9,27216),
+(11,9,30909),
+(11,9,27222),
+(11,9,27218),
+(11,9,6215),
+(11,9,27230),
+(11,9,27217),
+(11,9,27259),
+(11,9,27226),
+(11,9,27220),
+(11,9,5697),
+(11,9,27238),
+(11,9,30459),
+(11,9,27260),
+(11,9,27212),
+(11,9,698),
+(11,9,5500),
+(11,9,30908),
+(11,9,11719),
+(11,9,132),
+(11,9,18647),
+(11,9,27213),
+(11,9,11726),
+(11,9,27228),
+(11,9,28610),
+(11,9,28172),
+(11,9,27250),
+(11,9,17928),
+(11,9,27223),
+(11,9,27229),
+(11,9,30545),
+(11,9,30910),
+(11,9,18540),
+(11,9,28189),
+(11,9,32231),
+(11,9,29858),
+(11,9,29893),
+(11,9,27243);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,11,26979),
+(4,11,26990),
+(4,11,26985),
+(4,11,26988),
+(4,11,26982),
+(4,11,26992),
+(4,11,26989),
+(4,11,26998),
+(4,11,6795),
+(4,11,26996),
+(4,11,18960),
+(4,11,9634),
+(4,11,768),
+(4,11,783),
+(4,11,1066),
+(4,11,40120),
+(4,11,5229),
+(4,11,26980),
+(4,11,8983),
+(4,11,8946),
+(4,11,26997),
+(4,11,26993),
+(4,11,18658),
+(4,11,27000),
+(4,11,9913),
+(4,11,26994),
+(4,11,27008),
+(4,11,26986),
+(4,11,27002),
+(4,11,26995),
+(4,11,27003),
+(4,11,2782),
+(4,11,9846),
+(4,11,2893),
+(4,11,33357),
+(4,11,5209),
+(4,11,27004),
+(4,11,26983),
+(4,11,24248),
+(4,11,27005),
+(4,11,5225),
+(4,11,26999),
+(4,11,27012),
+(4,11,27006),
+(4,11,29166),
+(4,11,22812),
+(4,11,26991),
+(4,11,22570),
+(4,11,33763),
+(4,11,33745),
+(4,11,33786);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,11,26979),
+(6,11,26990),
+(6,11,26985),
+(6,11,26988),
+(6,11,26982),
+(6,11,26992),
+(6,11,26989),
+(6,11,26998),
+(6,11,6795),
+(6,11,26996),
+(6,11,18960),
+(6,11,9634),
+(6,11,768),
+(6,11,783),
+(6,11,1066),
+(6,11,40120),
+(6,11,5229),
+(6,11,26980),
+(6,11,8983),
+(6,11,8946),
+(6,11,26997),
+(6,11,26993),
+(6,11,18658),
+(6,11,27000),
+(6,11,9913),
+(6,11,26994),
+(6,11,27008),
+(6,11,26986),
+(6,11,27002),
+(6,11,26995),
+(6,11,27003),
+(6,11,2782),
+(6,11,9846),
+(6,11,2893),
+(6,11,33357),
+(6,11,5209),
+(6,11,27004),
+(6,11,26983),
+(6,11,24248),
+(6,11,27005),
+(6,11,5225),
+(6,11,26999),
+(6,11,27012),
+(6,11,27006),
+(6,11,29166),
+(6,11,22812),
+(6,11,26991),
+(6,11,22570),
+(6,11,33763),
+(6,11,33745),
+(6,11,33786);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,8,27126),
+(1,8,27070),
+(1,8,22018),
+(1,8,27072),
+(1,8,22019),
+(1,8,27079),
+(1,8,38704),
+(1,8,28272),
+(1,8,28271),
+(1,8,12826),
+(1,8,27088),
+(1,8,33944),
+(1,8,130),
+(1,8,27082),
+(1,8,27086),
+(1,8,33946),
+(1,8,475),
+(1,8,1953),
+(1,8,27085),
+(1,8,12051),
+(1,8,27128),
+(1,8,27131),
+(1,8,32796),
+(1,8,27074),
+(1,8,2139),
+(1,8,27101),
+(1,8,27124),
+(1,8,45438),
+(1,8,27125),
+(1,8,27127),
+(1,8,30482),
+(1,8,30451),
+(1,8,30455),
+(1,8,66),
+(1,8,43987),
+(1,8,30449);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,8,27126),
+(5,8,27070),
+(5,8,22018),
+(5,8,27072),
+(5,8,22019),
+(5,8,27079),
+(5,8,38704),
+(5,8,28272),
+(5,8,28271),
+(5,8,12826),
+(5,8,27088),
+(5,8,33944),
+(5,8,130),
+(5,8,27082),
+(5,8,27086),
+(5,8,33946),
+(5,8,475),
+(5,8,1953),
+(5,8,27085),
+(5,8,12051),
+(5,8,27128),
+(5,8,27131),
+(5,8,32796),
+(5,8,27074),
+(5,8,2139),
+(5,8,27101),
+(5,8,27124),
+(5,8,45438),
+(5,8,27125),
+(5,8,27127),
+(5,8,30482),
+(5,8,30451),
+(5,8,30455),
+(5,8,66),
+(5,8,43987),
+(5,8,30449);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,8,27126),
+(7,8,27070),
+(7,8,22018),
+(7,8,27072),
+(7,8,22019),
+(7,8,27079),
+(7,8,38704),
+(7,8,28272),
+(7,8,28271),
+(7,8,12826),
+(7,8,27088),
+(7,8,33944),
+(7,8,130),
+(7,8,27082),
+(7,8,27086),
+(7,8,33946),
+(7,8,475),
+(7,8,1953),
+(7,8,27085),
+(7,8,12051),
+(7,8,27128),
+(7,8,27131),
+(7,8,32796),
+(7,8,27074),
+(7,8,2139),
+(7,8,27101),
+(7,8,27124),
+(7,8,45438),
+(7,8,27125),
+(7,8,27127),
+(7,8,30482),
+(7,8,30451),
+(7,8,30455),
+(7,8,66),
+(7,8,43987),
+(7,8,30449);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,8,27126),
+(8,8,27070),
+(8,8,22018),
+(8,8,27072),
+(8,8,22019),
+(8,8,27079),
+(8,8,38704),
+(8,8,28272),
+(8,8,28271),
+(8,8,12826),
+(8,8,27088),
+(8,8,33944),
+(8,8,130),
+(8,8,27082),
+(8,8,27086),
+(8,8,33946),
+(8,8,475),
+(8,8,1953),
+(8,8,27085),
+(8,8,12051),
+(8,8,27128),
+(8,8,27131),
+(8,8,32796),
+(8,8,27074),
+(8,8,2139),
+(8,8,27101),
+(8,8,27124),
+(8,8,45438),
+(8,8,27125),
+(8,8,27127),
+(8,8,30482),
+(8,8,30451),
+(8,8,30455),
+(8,8,66),
+(8,8,43987),
+(8,8,30449);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,8,27126),
+(10,8,27070),
+(10,8,22018),
+(10,8,27072),
+(10,8,22019),
+(10,8,27079),
+(10,8,38704),
+(10,8,28272),
+(10,8,28271),
+(10,8,12826),
+(10,8,27088),
+(10,8,33944),
+(10,8,130),
+(10,8,27082),
+(10,8,27086),
+(10,8,33946),
+(10,8,475),
+(10,8,1953),
+(10,8,27085),
+(10,8,12051),
+(10,8,27128),
+(10,8,27131),
+(10,8,32796),
+(10,8,27074),
+(10,8,2139),
+(10,8,27101),
+(10,8,27124),
+(10,8,45438),
+(10,8,27125),
+(10,8,27127),
+(10,8,30482),
+(10,8,30451),
+(10,8,30455),
+(10,8,66),
+(10,8,43987),
+(10,8,30449);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,8,27126),
+(11,8,27070),
+(11,8,22018),
+(11,8,27072),
+(11,8,22019),
+(11,8,27079),
+(11,8,38704),
+(11,8,28272),
+(11,8,28271),
+(11,8,12826),
+(11,8,27088),
+(11,8,33944),
+(11,8,130),
+(11,8,27082),
+(11,8,27086),
+(11,8,33946),
+(11,8,475),
+(11,8,1953),
+(11,8,27085),
+(11,8,12051),
+(11,8,27128),
+(11,8,27131),
+(11,8,32796),
+(11,8,27074),
+(11,8,2139),
+(11,8,27101),
+(11,8,27124),
+(11,8,45438),
+(11,8,27125),
+(11,8,27127),
+(11,8,30482),
+(11,8,30451),
+(11,8,30455),
+(11,8,66),
+(11,8,43987),
+(11,8,30449);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,5,25389),
+(1,5,25364),
+(1,5,25368),
+(1,5,25218),
+(1,5,25429),
+(1,5,25222),
+(1,5,25375),
+(1,5,25435),
+(1,5,25431),
+(1,5,528),
+(1,5,10890),
+(1,5,988),
+(1,5,6346),
+(1,5,25235),
+(1,5,25384),
+(1,5,25596),
+(1,5,10955),
+(1,5,10909),
+(1,5,25380),
+(1,5,10912),
+(1,5,25308),
+(1,5,25433),
+(1,5,552),
+(1,5,1706),
+(1,5,25213),
+(1,5,25392),
+(1,5,39374),
+(1,5,32999),
+(1,5,32996),
+(1,5,32546),
+(1,5,34433),
+(1,5,33076),
+(1,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,5,25389),
+(3,5,25364),
+(3,5,25368),
+(3,5,25218),
+(3,5,25429),
+(3,5,25222),
+(3,5,25375),
+(3,5,25435),
+(3,5,25431),
+(3,5,528),
+(3,5,10890),
+(3,5,988),
+(3,5,6346),
+(3,5,25235),
+(3,5,25384),
+(3,5,25596),
+(3,5,10955),
+(3,5,10909),
+(3,5,25380),
+(3,5,10912),
+(3,5,25308),
+(3,5,25433),
+(3,5,552),
+(3,5,1706),
+(3,5,25213),
+(3,5,25392),
+(3,5,39374),
+(3,5,32999),
+(3,5,32996),
+(3,5,32546),
+(3,5,34433),
+(3,5,33076),
+(3,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,5,25389),
+(4,5,25364),
+(4,5,25368),
+(4,5,25218),
+(4,5,25429),
+(4,5,25222),
+(4,5,25375),
+(4,5,25435),
+(4,5,25431),
+(4,5,528),
+(4,5,10890),
+(4,5,988),
+(4,5,6346),
+(4,5,25235),
+(4,5,25384),
+(4,5,25596),
+(4,5,10955),
+(4,5,10909),
+(4,5,25380),
+(4,5,10912),
+(4,5,25308),
+(4,5,25433),
+(4,5,552),
+(4,5,1706),
+(4,5,25213),
+(4,5,25392),
+(4,5,39374),
+(4,5,32999),
+(4,5,32996),
+(4,5,32546),
+(4,5,34433),
+(4,5,33076),
+(4,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,5,25389),
+(5,5,25364),
+(5,5,25368),
+(5,5,25218),
+(5,5,25429),
+(5,5,25222),
+(5,5,25375),
+(5,5,25435),
+(5,5,25431),
+(5,5,528),
+(5,5,10890),
+(5,5,988),
+(5,5,6346),
+(5,5,25235),
+(5,5,25384),
+(5,5,25596),
+(5,5,10955),
+(5,5,10909),
+(5,5,25380),
+(5,5,10912),
+(5,5,25308),
+(5,5,25433),
+(5,5,552),
+(5,5,1706),
+(5,5,25213),
+(5,5,25392),
+(5,5,39374),
+(5,5,32999),
+(5,5,32996),
+(5,5,32546),
+(5,5,34433),
+(5,5,33076),
+(5,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,5,25389),
+(8,5,25364),
+(8,5,25368),
+(8,5,25218),
+(8,5,25429),
+(8,5,25222),
+(8,5,25375),
+(8,5,25435),
+(8,5,25431),
+(8,5,528),
+(8,5,10890),
+(8,5,988),
+(8,5,6346),
+(8,5,25235),
+(8,5,25384),
+(8,5,25596),
+(8,5,10955),
+(8,5,10909),
+(8,5,25380),
+(8,5,10912),
+(8,5,25308),
+(8,5,25433),
+(8,5,552),
+(8,5,1706),
+(8,5,25213),
+(8,5,25392),
+(8,5,39374),
+(8,5,32999),
+(8,5,32996),
+(8,5,32546),
+(8,5,34433),
+(8,5,33076),
+(8,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,5,25389),
+(10,5,25364),
+(10,5,25368),
+(10,5,25218),
+(10,5,25429),
+(10,5,25222),
+(10,5,25375),
+(10,5,25435),
+(10,5,25431),
+(10,5,528),
+(10,5,10890),
+(10,5,988),
+(10,5,6346),
+(10,5,25235),
+(10,5,25384),
+(10,5,25596),
+(10,5,10955),
+(10,5,10909),
+(10,5,25380),
+(10,5,10912),
+(10,5,25308),
+(10,5,25433),
+(10,5,552),
+(10,5,1706),
+(10,5,25213),
+(10,5,25392),
+(10,5,39374),
+(10,5,32999),
+(10,5,32996),
+(10,5,32546),
+(10,5,34433),
+(10,5,33076),
+(10,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,5,25389),
+(11,5,25364),
+(11,5,25368),
+(11,5,25218),
+(11,5,25429),
+(11,5,25222),
+(11,5,25375),
+(11,5,25435),
+(11,5,25431),
+(11,5,528),
+(11,5,10890),
+(11,5,988),
+(11,5,6346),
+(11,5,25235),
+(11,5,25384),
+(11,5,25596),
+(11,5,10955),
+(11,5,10909),
+(11,5,25380),
+(11,5,10912),
+(11,5,25308),
+(11,5,25433),
+(11,5,552),
+(11,5,1706),
+(11,5,25213),
+(11,5,25392),
+(11,5,39374),
+(11,5,32999),
+(11,5,32996),
+(11,5,32546),
+(11,5,34433),
+(11,5,33076),
+(11,5,32375);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,7,25396),
+(2,7,25449),
+(2,7,25485),
+(2,7,25454),
+(2,7,25509),
+(2,7,2484),
+(2,7,25472),
+(2,7,25525),
+(2,7,25457),
+(2,7,25489),
+(2,7,25533),
+(2,7,25528),
+(2,7,20777),
+(2,7,25547),
+(2,7,8012),
+(2,7,526),
+(2,7,8143),
+(2,7,25464),
+(2,7,25500),
+(2,7,2645),
+(2,7,25567),
+(2,7,25420),
+(2,7,2870),
+(2,7,8166),
+(2,7,131),
+(2,7,25560),
+(2,7,6196),
+(2,7,25552),
+(2,7,25570),
+(2,7,25563),
+(2,7,25557),
+(2,7,546),
+(2,7,556),
+(2,7,8177),
+(2,7,25574),
+(2,7,36936),
+(2,7,25505),
+(2,7,421),
+(2,7,25587),
+(2,7,6495),
+(2,7,25577),
+(2,7,8170),
+(2,7,25423),
+(2,7,25359),
+(2,7,25908),
+(2,7,33736),
+(2,7,3738),
+(2,7,2062),
+(2,7,2894),
+(2,7,2825);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,7,25396),
+(6,7,25449),
+(6,7,25485),
+(6,7,25454),
+(6,7,25509),
+(6,7,2484),
+(6,7,25472),
+(6,7,25525),
+(6,7,25457),
+(6,7,25489),
+(6,7,25533),
+(6,7,25528),
+(6,7,20777),
+(6,7,25547),
+(6,7,8012),
+(6,7,526),
+(6,7,8143),
+(6,7,25464),
+(6,7,25500),
+(6,7,2645),
+(6,7,25567),
+(6,7,25420),
+(6,7,2870),
+(6,7,8166),
+(6,7,131),
+(6,7,25560),
+(6,7,6196),
+(6,7,25552),
+(6,7,25570),
+(6,7,25563),
+(6,7,25557),
+(6,7,546),
+(6,7,556),
+(6,7,8177),
+(6,7,25574),
+(6,7,36936),
+(6,7,25505),
+(6,7,421),
+(6,7,25587),
+(6,7,6495),
+(6,7,25577),
+(6,7,8170),
+(6,7,25423),
+(6,7,25359),
+(6,7,25908),
+(6,7,33736),
+(6,7,3738),
+(6,7,2062),
+(6,7,2894),
+(6,7,2825);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,7,25396),
+(8,7,25449),
+(8,7,25485),
+(8,7,25454),
+(8,7,25509),
+(8,7,2484),
+(8,7,25472),
+(8,7,25525),
+(8,7,25457),
+(8,7,25489),
+(8,7,25533),
+(8,7,25528),
+(8,7,20777),
+(8,7,25547),
+(8,7,8012),
+(8,7,526),
+(8,7,8143),
+(8,7,25464),
+(8,7,25500),
+(8,7,2645),
+(8,7,25567),
+(8,7,25420),
+(8,7,2870),
+(8,7,8166),
+(8,7,131),
+(8,7,25560),
+(8,7,6196),
+(8,7,25552),
+(8,7,25570),
+(8,7,25563),
+(8,7,25557),
+(8,7,546),
+(8,7,556),
+(8,7,8177),
+(8,7,25574),
+(8,7,36936),
+(8,7,25505),
+(8,7,421),
+(8,7,25587),
+(8,7,6495),
+(8,7,25577),
+(8,7,8170),
+(8,7,25423),
+(8,7,25359),
+(8,7,25908),
+(8,7,33736),
+(8,7,3738),
+(8,7,2062),
+(8,7,2894),
+(8,7,2825);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,7,25396),
+(11,7,25449),
+(11,7,25485),
+(11,7,25454),
+(11,7,25509),
+(11,7,2484),
+(11,7,25472),
+(11,7,25525),
+(11,7,25457),
+(11,7,25489),
+(11,7,25533),
+(11,7,25528),
+(11,7,20777),
+(11,7,25547),
+(11,7,8012),
+(11,7,526),
+(11,7,8143),
+(11,7,25464),
+(11,7,25500),
+(11,7,2645),
+(11,7,25567),
+(11,7,25420),
+(11,7,2870),
+(11,7,8166),
+(11,7,131),
+(11,7,25560),
+(11,7,6196),
+(11,7,25552),
+(11,7,25570),
+(11,7,25563),
+(11,7,25557),
+(11,7,546),
+(11,7,556),
+(11,7,8177),
+(11,7,25574),
+(11,7,36936),
+(11,7,25505),
+(11,7,421),
+(11,7,25587),
+(11,7,6495),
+(11,7,25577),
+(11,7,8170),
+(11,7,25423),
+(11,7,25359),
+(11,7,25908),
+(11,7,33736),
+(11,7,3738),
+(11,7,2062),
+(11,7,2894),
+(11,7,32182);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,3,674),
+(2,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,3,674),
+(3,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,3,674),
+(4,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,3,674),
+(6,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,3,674),
+(8,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,3,674),
+(10,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,3,674),
+(11,3,8737);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,2,750),
+(1,2,3127);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,2,750),
+(3,2,3127);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,2,750),
+(10,2,3127);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,2,750),
+(11,2,3127);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,7,25442),
+(2,7,8737),
+(2,7,20608);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,7,25442),
+(6,7,8737),
+(6,7,20608);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,7,25442),
+(8,7,8737),
+(8,7,20608);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,7,25442),
+(11,7,8737),
+(11,7,20608);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,8,27087);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,8,27087);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,8,27087);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,8,27087);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,8,27087);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,8,27087);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,4,8643),
+(1,4,3127),
+(1,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,4,8643),
+(2,4,3127),
+(2,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,4,8643),
+(3,4,3127),
+(3,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,4,8643),
+(4,4,3127),
+(4,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,4,8643),
+(5,4,3127),
+(5,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,4,8643),
+(7,4,3127),
+(7,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,4,8643),
+(8,4,3127),
+(8,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,4,8643),
+(10,4,3127),
+(10,4,674);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,1,25212),
+(1,1,674),
+(1,1,750),
+(1,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,1,25212),
+(2,1,674),
+(2,1,750),
+(2,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,1,25212),
+(3,1,674),
+(3,1,750),
+(3,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,1,25212),
+(4,1,674),
+(4,1,750),
+(4,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,1,25212),
+(5,1,674),
+(5,1,750),
+(5,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,1,25212),
+(6,1,674),
+(6,1,750),
+(6,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,1,25212),
+(7,1,674),
+(7,1,750),
+(7,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,1,25212),
+(8,1,674),
+(8,1,750),
+(8,1,12678);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(11,1,25212),
+(11,1,674),
+(11,1,750),
+(11,1,12678);
+
+-- Hunter beast training
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell,Active) VALUES
+(2,3,5149,1),
+(3,3,5149,1),
+(4,3,5149,1),
+(6,3,5149,1),
+(8,3,5149,1),
+(10,3,5149,1),
+(11,3,5149,1);
+
+-- Class mounts and warlock pets - Credits to xmaveric
+-- Paladin 60 Mount
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,2,23214),
+(3,2,23214),
+(10,2,34767),
+(11,2,23214);
+-- Warlock 60 Mount
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,23161),
+(2,9,23161),
+(5,9,23161),
+(7,9,23161),
+(10,9,23161),
+(11,9,23161);
+-- Warlock Imp
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,688),
+(2,9,688),
+(5,9,688),
+(7,9,688),
+(10,9,688),
+(11,9,688);
+-- Warlock Voidwalker
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,697),
+(2,9,697),
+(5,9,697),
+(7,9,697),
+(10,9,697),
+(11,9,697);
+-- Warlock Succubus
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,712),
+(2,9,712),
+(5,9,712),
+(7,9,712),
+(10,9,712),
+(11,9,712);
+-- Warlock Felhunter
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,691),
+(2,9,691),
+(5,9,691),
+(7,9,691),
+(10,9,691),
+(11,9,691);
+
+-- Some missing spells
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(6,11,20719),
+(4,11,20719);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,9,126),
+(2,9,126),
+(5,9,126),
+(7,9,126),
+(10,9,126);
+-- seal of vengeance (paladin spell) for human, dwarf and draenei only
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,2,31801),
+(3,2,31801),
+(11,2,31801);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,4,3776),
+(1,4,9186),
+(1,4,21927),
+(1,4,22054),
+(1,4,22055),
+(1,4,2836),
+(1,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,4,3776),
+(2,4,9186),
+(2,4,21927),
+(2,4,22054),
+(2,4,22055),
+(2,4,2836),
+(2,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(3,4,3776),
+(3,4,9186),
+(3,4,21927),
+(3,4,22054),
+(3,4,22055),
+(3,4,2836),
+(3,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(4,4,3776),
+(4,4,9186),
+(4,4,21927),
+(4,4,22054),
+(4,4,22055),
+(4,4,2836),
+(4,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(5,4,3776),
+(5,4,9186),
+(5,4,21927),
+(5,4,22054),
+(5,4,22055),
+(5,4,2836),
+(5,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(7,4,3776),
+(7,4,9186),
+(7,4,21927),
+(7,4,22054),
+(7,4,22055),
+(7,4,2836),
+(7,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(8,4,3776),
+(8,4,9186),
+(8,4,21927),
+(8,4,22054),
+(8,4,22055),
+(8,4,2836),
+(8,4,1860);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(10,4,3776),
+(10,4,9186),
+(10,4,21927),
+(10,4,22054),
+(10,4,22055),
+(10,4,2836),
+(10,4,1860);
+-- Feedback (priest) Human spell only
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,5,25441);
+
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,5,25312),
+(3,5,25312),
+(4,5,25312),
+(5,5,25312),
+(8,5,25312),
+(11,5,25312),
+(10,5,25312);
+-- Desperate Prayer (human and dwarf only)
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(1,5,25437),
+(3,5,25437);
+-- Hunter parry
+INSERT INTO playercreateinfo_spell_custom (race,class,Spell) VALUES
+(2,3,3127),
+(3,3,3127),
+(4,3,3127),
+(6,3,3127),
+(8,3,3127),
+(10,3,3127),
+(11,3,3127);
diff --git a/sql/world.sql b/sql/world.sql
index 7692f776c65..2f3c7b794bb 100644
--- a/sql/world.sql
+++ b/sql/world.sql
@@ -1,6 +1,6 @@
-- MySQL dump 10.11
--
--- Host: localhost Database: mangos
+-- Host: localhost Database: world
-- ------------------------------------------------------
-- Server version 5.0.56-nt
diff --git a/src/game/ObjectMgr.cpp b/src/game/ObjectMgr.cpp
index b6f3f44834e..b753360838e 100644
--- a/src/game/ObjectMgr.cpp
+++ b/src/game/ObjectMgr.cpp
@@ -2078,8 +2078,6 @@ void ObjectMgr::LoadPlayerInfo()
// Load playercreate spells
{
- // 0 1 2 3
- QueryResult *result = WorldDatabase.Query("SELECT race, class, Spell, Active FROM playercreateinfo_spell");
QueryResult *result = NULL;
if(sWorld.getConfig(CONFIG_START_ALL_SPELLS))
diff --git a/src/trinityrealm/AuthSocket.cpp b/src/trinityrealm/AuthSocket.cpp
index 0fd2726470d..55e65a79052 100644
--- a/src/trinityrealm/AuthSocket.cpp
+++ b/src/trinityrealm/AuthSocket.cpp
@@ -372,12 +372,11 @@ bool AuthSocket::_HandleLogonChallenge()
int MinBuild = sConfig.GetIntDefault("MinBuild", 8606);
int MaxBuild = sConfig.GetIntDefault("MaxBuild", 8606);
- if(ch->build >= MinBuild && ch->build <= MaxBuild)
+ if(ch->build >= MinBuild && ch->build <= MaxBuild) {
valid_version=true;
- break;
- }
- else
+ } else {
valid_version=false;
+ };
/// <ul><li> if this is a valid version
if(valid_version)