diff options
| -rw-r--r-- | INSTALL.linux (renamed from INSTALL) | 0 | ||||
| -rw-r--r-- | sql/create_mysql.sql | 10 | ||||
| -rw-r--r-- | sql/drop_mysql.sql | 18 | ||||
| -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.sql | 4483 | ||||
| -rw-r--r-- | sql/world.sql | 2 | ||||
| -rw-r--r-- | src/game/ObjectMgr.cpp | 2 | ||||
| -rw-r--r-- | src/trinityrealm/AuthSocket.cpp | 7 |
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) |