diff options
| author | runningnak3d <none@none> | 2008-10-14 12:30:35 -0500 |
|---|---|---|
| committer | runningnak3d <none@none> | 2008-10-14 12:30:35 -0500 |
| commit | fbdc2505d0d5c10fbdae4aca893a4c226d4a1e17 (patch) | |
| tree | da0918210459a621ec85f8fe945361a52e54ae9a /sql/updates | |
| parent | 2265aef916e3b2d63d87faa68a2b51e7d747c54c (diff) | |
[svn] * SQL cleanup
* Removed unneeded revision SQL, since everyone will be starting off at a single revision.
* Left the characters SQL in case someone needs to convert a MaNGOS characters DB
* Final dumps of realmd / world / and characters DB schemas
--HG--
branch : trunk
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/10_world.sql | 39 | ||||
| -rw-r--r-- | sql/updates/34_world.sql | 4483 | ||||
| -rw-r--r-- | sql/updates/40_world.sql | 77 | ||||
| -rw-r--r-- | sql/updates/45_world.sql | 68 | ||||
| -rw-r--r-- | sql/updates/mangos_string_to_trinity_string.sql | 1 |
5 files changed, 0 insertions, 4668 deletions
diff --git a/sql/updates/10_world.sql b/sql/updates/10_world.sql deleted file mode 100644 index 9f3f79ebfa9..00000000000 --- a/sql/updates/10_world.sql +++ /dev/null @@ -1,39 +0,0 @@ -DELETE FROM `instance_template` WHERE `map` IN ('489', '30', '529', '566', '559', '562', '572'); -INSERT INTO `instance_template` (`map`, `parent`, `levelMin`, `levelMax`, `maxPlayers`, `reset_delay`) VALUES -('489', '0', '10', '0', '50', '0'), -('30', '0', '10', '0', '50', '0'), -('529', '0', '10', '0', '50', '0'), -('566', '0', '10', '0', '50', '0'), -('559', '0', '10', '0', '50', '0'), -('562', '0', '10', '0', '50', '0'), -('572', '0', '10', '0', '50', '0'); - -DELETE FROM `command` WHERE `name` = "flusharenapoints"; -DELETE FROM `command` WHERE `name` = "debug arena"; -INSERT INTO `command` (`name`, `security`, `help`) VALUES -('flusharenapoints',3,'Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'), -('debug arena',3,'Syntax: .debug arena\r\n\r\n Toggles arena 1v1 or normal mode.'); - - -DELETE FROM trinity_string WHERE entry IN (711,712); -DELETE FROM trinity_string WHERE entry BETWEEN 730 AND 745; -INSERT INTO trinity_string (entry, content_default) VALUES - (711,'Your group is too large for this battleground. Please regroup to join.'), - (712,'Your group is too large for this arena. Please regroup to join.'), - (730,'Your group has members not in your arena team. Please regroup to join.'), - (731,'Your group does not have enough players to join this match.'), - (732,'The Gold Team wins!'), - (733,'The Green Team wins!'), - (734, 'There aren\'t enough players in this battleground. It will end soon unless some more players join to balance the fight.'), - (735, 'Your group has an offline member. Please remove him before joining.'), - (736, 'Your group has players from the opposing faction. You can\'t join the battleground as a group.'), - (737, 'Your group has players from different battleground brakets. You can\'t join as group.'), - (738, 'Someone in your party is already in this battleground queue. (S)he must leave it before joining as group.'), - (739, 'Someone in your party is Deserter. You can\'t join as group.'), - (740, 'Someone in your party is already in three battleground queues. You cannot join as group.'), - (741, 'You cannot teleport to a battleground or arena map.'), - (742, 'You cannot summon players to a battleground or arena map.'), - (743, 'You must be in GM mode to teleport to a player in a battleground.'), - (744, 'You cannot teleport to a battleground from another battleground. Please leave the current battleground first.'), - (745, 'Arena testing turned %s'); - diff --git a/sql/updates/34_world.sql b/sql/updates/34_world.sql deleted file mode 100644 index 28a38b57fdc..00000000000 --- a/sql/updates/34_world.sql +++ /dev/null @@ -1,4483 +0,0 @@ --- 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/updates/40_world.sql b/sql/updates/40_world.sql deleted file mode 100644 index 123a8cbce2e..00000000000 --- a/sql/updates/40_world.sql +++ /dev/null @@ -1,77 +0,0 @@ -SET FOREIGN_KEY_CHECKS=0; --- ---------------------------- --- Table structure for IRC_Commands --- ---------------------------- -DROP TABLE IF EXISTS `IRC_Commands`; -CREATE TABLE `IRC_Commands` ( - `Command` varchar(10) NOT NULL default '', - `Description` varchar(150) NOT NULL default '', - `gmlevel` tinyint(3) unsigned NOT NULL default '0', - PRIMARY KEY (`Command`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='IRC Module System'; - --- ---------------------------- --- Records --- ---------------------------- -INSERT INTO `IRC_Commands` VALUES ('acct', '[acct <Player> <(un)lock/mail/pass/rename>] : Perform Action To <Player> Account.', '3'); -INSERT INTO `IRC_Commands` VALUES ('ban', '[ban <Player/IP> <ip/acct/unban/reason>] : Ban/Unban <Player>', '3'); -INSERT INTO `IRC_Commands` VALUES ('chan', '[chan <op/deop/voice/devoice> <*IRC Nick*>] : Set Mode On Yourself, If <IRC Nick> Is Specified Then Set mode On Nick.', '3'); -INSERT INTO `IRC_Commands` VALUES ('char', '[char <Player> <mailcheat/taxicheat/maxskill/setskill>] : Perform Action To Character.', '3'); -INSERT INTO `IRC_Commands` VALUES ('fun', '[fun <Player> <Sound/Say>] : Do Selected Fun Action To <Player>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('help', '[help Command] : Use No Paramaters For List Of Available Commands.', '0'); -INSERT INTO `IRC_Commands` VALUES ('inchan', '[inchan <Channel>] : Display Users In Selected In Game <Channel>', '0'); -INSERT INTO `IRC_Commands` VALUES ('info', '[info] : Display Server Info. (Number Of Players Online/Max Since Last Restart/Uptime)', '0'); -INSERT INTO `IRC_Commands` VALUES ('item', '[item <Player> <add> <ItemID/[ItemName]> <Amount>] : Additem To <Player>, Use <ItemID> Or <[Exact Item Name]>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('jail', '[jail <Player> <release/Reason>] : Jail Selected <Player> For <Reason>. Using release As <Reason> Releases Player.', '3'); -INSERT INTO `IRC_Commands` VALUES ('kick', '[kick <Player> <Reason>] : Kick <Player> For <Reason>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('kill', '[kill <Player> <Reason>] : Kill <Player> For <Reason>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('level', '[level <Player> <NewLevel>] : Level <Player> To <NewLevel>. *Can Be Done Offline*', '3'); -INSERT INTO `IRC_Commands` VALUES ('lookup', '[lookup <acct/char/creature/faction/go/item/quest/skill/spell/tele> <ID/Name>] : ', '3'); -INSERT INTO `IRC_Commands` VALUES ('login', '[login <UserName> <Password>] : Login To MangChat Admin Mode. (Must Be Done In A PM)', '0'); -INSERT INTO `IRC_Commands` VALUES ('logout', '[logout] : Logout Of MangChat Admin Mode.', '0'); -INSERT INTO `IRC_Commands` VALUES ('money', '[money <Player> <(-)Money>] : Give Money To <Player>, Use - To Take Money. *Can Be Done Offline*', '3'); -INSERT INTO `IRC_Commands` VALUES ('mute', '[mute <Player> <release/TimeInMins> <Reason>] : Mute Player For Reason, For <TimeInMins>. Using release As Time Releases Player. *Can Be Done Offline*', '3'); -INSERT INTO `IRC_Commands` VALUES ('online', '[online] : Display All Users Logged In Game.', '0'); -INSERT INTO `IRC_Commands` VALUES ('pm', '[pm <Player> <Message>] : Whisper <Player> In WoW <Message>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('reload', '[reload] : Reload MangChat Config Options And Security Level From DataBase.', '3'); -INSERT INTO `IRC_Commands` VALUES ('restart', '[restart] : Restart MangChat, NOT MaNGOS World Server Itself. Forces Reconnection To IRC Server.', '3'); -INSERT INTO `IRC_Commands` VALUES ('revive', '[revive <Player>] : Revive <Player>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('saveall', '[saveall] : Forces MaNGOS To Save All Players.', '3'); -INSERT INTO `IRC_Commands` VALUES ('shutdown', '[shutdown <TimeInSeconds>] : Shuts The Server Down In <TimeInSeconds>, Use 0 For Immediate Shut Down', '3'); -INSERT INTO `IRC_Commands` VALUES ('spell', '[spell <Player> <Cast/Learn/UnLearn> <SpellID>] : Make <Player> <Learn> Or <UnLearn> A Spell, Or <Cast> A Spell On A <Player>.', '3'); -INSERT INTO `IRC_Commands` VALUES ('sysmsg', '[sysmsg <a/n/e/add/del/list> <Message>] : Broadcasts A System Message. (a-Broadcast System Message)(n-Broadcast Notify Message)(e-Event Message)', '3'); -INSERT INTO `IRC_Commands` VALUES ('tele', '[tele <Player> <l/c/r/to> <Loc.Name/MAPID X Y Z/Recall/Player>] : Teleport Player To Location, Coords, Or Another Player. (l-Location)(c-Coords)', '3'); -INSERT INTO `IRC_Commands` VALUES ('top', '[top <accttime/chartime/money> <limit>] : Display top stats for given option. Only GM Higher Than Config Option Can Use Limit.', '3'); -INSERT INTO `IRC_Commands` VALUES ('who', '[who] : Displays Users Currently Logged In To MangChat.', '1'); - -SET FOREIGN_KEY_CHECKS=0; --- ---------------------------- --- Table structure for IRC_Inchan --- ---------------------------- -DROP TABLE IF EXISTS `IRC_Inchan`; -CREATE TABLE `IRC_Inchan` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `name` varchar(12) NOT NULL default '', - `channel` varchar(15) NOT NULL default '', - PRIMARY KEY (`guid`,`channel`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='IRC Module System'; - -SET FOREIGN_KEY_CHECKS=0; --- ---------------------------- --- Table structure for IRC_AutoAnnounce --- ---------------------------- -DROP TABLE IF EXISTS `IRC_AutoAnnounce`; -CREATE TABLE `IRC_AutoAnnounce` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `message` longtext NOT NULL, - `addedby` varchar(12) NOT NULL default '', - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='IRC Module System'; - --- Add ircpm command. -delete from `command` WHERE `name`='ircpm'; -insert into `command` (`name`, `security`, `help`) values ('ircpm', 0, 'Syntax: .ircpm <user> <text>\n\nSends a PM with <text> to <user> on IRC.'); - --- Add auto announce string. -DELETE FROM `trinity_string` WHERE `entry`=746; -insert into `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) values('746','|cffff0000[Automatic]:|r',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); diff --git a/sql/updates/45_world.sql b/sql/updates/45_world.sql deleted file mode 100644 index e5d94deecb2..00000000000 --- a/sql/updates/45_world.sql +++ /dev/null @@ -1,68 +0,0 @@ -ALTER TABLE game_event ADD COLUMN world_event tinyint(3) unsigned not null default 0 comment '0 if normal event, 1 if world event'; - -CREATE TABLE `game_event_quest_condition` ( - `quest` mediumint(8) unsigned NOT NULL default '0', - `event_id` mediumint(8) unsigned NOT NULL default '0', - `condition_id` mediumint(8) unsigned NOT NULL default '0', - `num` float default '0', - PRIMARY KEY (`quest`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_condition` ( - `event_id` mediumint(8) unsigned NOT NULL default '0', - `condition_id` mediumint(8) unsigned NOT NULL default '0', - `req_num` float default '0', - `max_world_state_field` smallint(5) unsigned NOT NULL default '0', - `done_world_state_field` smallint(5) unsigned NOT NULL default '0', - `description` varchar(25) NOT NULL default '', - PRIMARY KEY (`event_id`,`condition_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_npcflag` ( - `guid` mediumint(8) unsigned NOT NULL default '0', - `event_id` mediumint(8) unsigned NOT NULL default '0', - `npcflag` int(10) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`event_id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_prerequisite` ( - `event_id` mediumint(8) unsigned NOT NULL, - `prerequisite_event` mediumint(8) unsigned NOT NULL, - PRIMARY KEY (`event_id`,`prerequisite_event`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_npc_gossip` ( - `guid` int(10) unsigned NOT NULL, - `event_id` mediumint(8) unsigned NOT NULL default '0', - `textid` mediumint(8) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_gameobject_quest` ( - `id` mediumint(8) unsigned NOT NULL default '0', - `quest` mediumint(8) unsigned NOT NULL default '0', - `event` smallint(5) unsigned NOT NULL default '0', - PRIMARY KEY (`quest`,`event`,`id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -CREATE TABLE `game_event_npc_vendor` ( - `event` mediumint(8) unsigned NOT NULL default '0', - `guid` mediumint(8) unsigned NOT NULL default '0', - `item` mediumint(8) unsigned NOT NULL default '0', - `maxcount` mediumint(8) unsigned NOT NULL default '0', - `incrtime` mediumint(8) unsigned NOT NULL default '0', - `ExtendedCost` mediumint(8) unsigned NOT NULL default '0', - PRIMARY KEY (`guid`,`item`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -ALTER TABLE game_event_creature_quest DROP PRIMARY KEY, ADD PRIMARY KEY (quest, event, id); - -ALTER TABLE game_event_creature DROP PRIMARY KEY, ADD PRIMARY KEY (guid, event); - -ALTER TABLE game_event_gameobject DROP PRIMARY KEY, ADD PRIMARY KEY (guid, event); - -DELETE FROM `command` WHERE `name` LIKE 'debug threatlist'; -DELETE FROM `command` WHERE `name` LIKE 'debug hostilrefs'; -INSERT INTO `command` VALUES -('debug threatlist', 3, 'Syntax: .debug threatlist\n\n Prints out the current threatlist of the targetted creature.'), -('debug hostilrefs', 3, 'Syntax: .debug hostilrefs\n\n Prints out the hostil refs of the targetted unit.'); diff --git a/sql/updates/mangos_string_to_trinity_string.sql b/sql/updates/mangos_string_to_trinity_string.sql deleted file mode 100644 index 0f5dc999628..00000000000 --- a/sql/updates/mangos_string_to_trinity_string.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE `mangos_string` RENAME TO `trinity_string`; |
