From 78e92e9023eff0bffb1bdb1a4f110ba9fcb3c5a8 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Mon, 12 Jan 2009 21:58:01 -0600
Subject: *Update to Mangos 7076.

--HG--
branch : trunk
---
 sql/mangos.sql | 414 +++++++++++++++++++++++++++++++++++++++------------------
 1 file changed, 284 insertions(+), 130 deletions(-)

(limited to 'sql/mangos.sql')

diff --git a/sql/mangos.sql b/sql/mangos.sql
index e9154169eb6..1854d14927c 100644
--- a/sql/mangos.sql
+++ b/sql/mangos.sql
@@ -22,7 +22,7 @@
 DROP TABLE IF EXISTS `db_version`;
 CREATE TABLE `db_version` (
   `version` varchar(120) default NULL,
-  `required_7067_02_mangos_spell_learn_spell` bit(1) default NULL
+  `required_7075_02_mangos_spell_learn_spell` bit(1) default NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
 
 --
@@ -9808,14 +9808,15 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,1,201,'One-Handed Swords'),
 (1,1,203,'Unarmed'),
 (1,1,204,'Defense'),
-(1,1,522,'SPELLDEFENSE(DND)'),
+(1,1,522,'SPELLDEFENSE (DND)'),
 (1,1,668,'Language Common'),
+(1,1,1843,'Disarm'),
 (1,1,2382,'Generic'),
 (1,1,2457,'Battle Stance'),
 (1,1,2479,'Honorless Target'),
 (1,1,3050,'Detect'),
 (1,1,3365,'Opening'),
-(1,1,5301,'Defensive State(DND)'),
+(1,1,5301,'Defensive State (DND)'),
 (1,1,6233,'Closing'),
 (1,1,6246,'Closing'),
 (1,1,6247,'Opening'),
@@ -9834,22 +9835,26 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,1,20597,'Sword Specialization'),
 (1,1,20598,'The Human Spirit'),
 (1,1,20599,'Diplomacy'),
-(1,1,20600,'Perception'),
 (1,1,20864,'Mace Specialization'),
 (1,1,21651,'Opening'),
 (1,1,21652,'Closing'),
 (1,1,22027,'Remove Insignia'),
 (1,1,22810,'Opening - No Text'),
 (1,1,32215,'Victorious State'),
+(1,1,45927,'Summon Friend'),
+(1,1,58985,'Perception'),
+(1,1,59752,'Every Man for Himself'),
+(1,1,61437,'Opening'),
 (1,2,81,'Dodge'),
 (1,2,107,'Block'),
 (1,2,198,'One-Handed Maces'),
 (1,2,199,'Two-Handed Maces'),
 (1,2,203,'Unarmed'),
 (1,2,204,'Defense'),
-(1,2,522,'SPELLDEFENSE(DND)'),
+(1,2,522,'SPELLDEFENSE (DND)'),
 (1,2,635,'Holy Light'),
 (1,2,668,'Language Common'),
+(1,2,1843,'Disarm'),
 (1,2,2382,'Generic'),
 (1,2,2479,'Honorless Target'),
 (1,2,3050,'Detect'),
@@ -9869,24 +9874,28 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,2,9078,'Cloth'),
 (1,2,9116,'Shield'),
 (1,2,9125,'Generic'),
-(1,2,21084,'Seal of Righteousness'),
+(1,2,20154,'Seal of Righteousness'),
 (1,2,20597,'Sword Specialization'),
 (1,2,20598,'The Human Spirit'),
 (1,2,20599,'Diplomacy'),
-(1,2,20600,'Perception'),
 (1,2,20864,'Mace Specialization'),
 (1,2,21651,'Opening'),
 (1,2,21652,'Closing'),
 (1,2,22027,'Remove Insignia'),
 (1,2,22810,'Opening - No Text'),
 (1,2,27762,'Libram'),
+(1,2,45927,'Summon Friend'),
+(1,2,58985,'Perception'),
+(1,2,59752,'Every Man for Himself'),
+(1,2,61437,'Opening'),
 (1,4,81,'Dodge'),
 (1,4,203,'Unarmed'),
 (1,4,204,'Defense'),
-(1,4,522,'SPELLDEFENSE(DND)'),
+(1,4,522,'SPELLDEFENSE (DND)'),
 (1,4,668,'Language Common'),
 (1,4,1180,'Daggers'),
 (1,4,1752,'Sinister Strike'),
+(1,4,1843,'Disarm'),
 (1,4,2098,'Eviscerate'),
 (1,4,2382,'Generic'),
 (1,4,2479,'Honorless Target'),
@@ -9907,24 +9916,28 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,4,9077,'Leather'),
 (1,4,9078,'Cloth'),
 (1,4,9125,'Generic'),
-(1,4,16092,'Defensive State(DND)'),
+(1,4,16092,'Defensive State (DND)'),
 (1,4,20597,'Sword Specialization'),
 (1,4,20598,'The Human Spirit'),
 (1,4,20599,'Diplomacy'),
-(1,4,20600,'Perception'),
 (1,4,20864,'Mace Specialization'),
-(1,4,21184,'Rogue Passive(DND)'),
+(1,4,21184,'Rogue Passive (DND)'),
 (1,4,21651,'Opening'),
 (1,4,21652,'Closing'),
 (1,4,22027,'Remove Insignia'),
 (1,4,22810,'Opening - No Text'),
+(1,4,45927,'Summon Friend'),
+(1,4,58985,'Perception'),
+(1,4,59752,'Every Man for Himself'),
+(1,4,61437,'Opening'),
 (1,5,81,'Dodge'),
 (1,5,198,'One-Handed Maces'),
 (1,5,203,'Unarmed'),
 (1,5,204,'Defense'),
-(1,5,522,'SPELLDEFENSE(DND)'),
+(1,5,522,'SPELLDEFENSE (DND)'),
 (1,5,585,'Smite'),
 (1,5,668,'Language Common'),
+(1,5,1843,'Disarm'),
 (1,5,2050,'Lesser Heal'),
 (1,5,2382,'Generic'),
 (1,5,2479,'Honorless Target'),
@@ -9947,12 +9960,15 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,5,20597,'Sword Specialization'),
 (1,5,20598,'The Human Spirit'),
 (1,5,20599,'Diplomacy'),
-(1,5,20600,'Perception'),
 (1,5,20864,'Mace Specialization'),
 (1,5,21651,'Opening'),
 (1,5,21652,'Closing'),
 (1,5,22027,'Remove Insignia'),
 (1,5,22810,'Opening - No Text'),
+(1,5,45927,'Summon Friend'),
+(1,5,58985,'Perception'),
+(1,5,59752,'Every Man for Himself'),
+(1,5,61437,'Opening'),
 (1,6,81,'Dodge'),
 (1,6,196,'One-Handed Axes'),
 (1,6,197,'Two-Handed Axes'),
@@ -10028,8 +10044,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,8,203,'Unarmed'),
 (1,8,204,'Defense'),
 (1,8,227,'Staves'),
-(1,8,522,'SPELLDEFENSE(DND)'),
+(1,8,522,'SPELLDEFENSE (DND)'),
 (1,8,668,'Language Common'),
+(1,8,1843,'Disarm'),
 (1,8,2382,'Generic'),
 (1,8,2479,'Honorless Target'),
 (1,8,3050,'Detect'),
@@ -10051,20 +10068,24 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,8,20597,'Sword Specialization'),
 (1,8,20598,'The Human Spirit'),
 (1,8,20599,'Diplomacy'),
-(1,8,20600,'Perception'),
 (1,8,20864,'Mace Specialization'),
 (1,8,21651,'Opening'),
 (1,8,21652,'Closing'),
 (1,8,22027,'Remove Insignia'),
 (1,8,22810,'Opening - No Text'),
+(1,8,45927,'Summon Friend'),
+(1,8,58985,'Perception'),
+(1,8,59752,'Every Man for Himself'),
+(1,8,61437,'Opening'),
 (1,9,81,'Dodge'),
 (1,9,203,'Unarmed'),
 (1,9,204,'Defense'),
-(1,9,522,'SPELLDEFENSE(DND)'),
+(1,9,522,'SPELLDEFENSE (DND)'),
 (1,9,668,'Language Common'),
 (1,9,686,'Shadow Bolt'),
 (1,9,687,'Demon Skin'),
 (1,9,1180,'Daggers'),
+(1,9,1843,'Disarm'),
 (1,9,2382,'Generic'),
 (1,9,2479,'Honorless Target'),
 (1,9,3050,'Detect'),
@@ -10086,12 +10107,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (1,9,20597,'Sword Specialization'),
 (1,9,20598,'The Human Spirit'),
 (1,9,20599,'Diplomacy'),
-(1,9,20600,'Perception'),
 (1,9,20864,'Mace Specialization'),
 (1,9,21651,'Opening'),
 (1,9,21652,'Closing'),
 (1,9,22027,'Remove Insignia'),
 (1,9,22810,'Opening - No Text'),
+(1,9,45927,'Summon Friend'),
+(1,9,58284,'Chaos Bolt Passive'),
+(1,9,58985,'Perception'),
+(1,9,59752,'Every Man for Himself'),
+(1,9,61437,'Opening'),
 (2,1,78,'Heroic Strike'),
 (2,1,81,'Dodge'),
 (2,1,107,'Block'),
@@ -10100,14 +10125,15 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,1,201,'One-Handed Swords'),
 (2,1,203,'Unarmed'),
 (2,1,204,'Defense'),
-(2,1,522,'SPELLDEFENSE(DND)'),
+(2,1,522,'SPELLDEFENSE (DND)'),
 (2,1,669,'Language Orcish'),
+(2,1,1843,'Disarm'),
 (2,1,2382,'Generic'),
 (2,1,2457,'Battle Stance'),
 (2,1,2479,'Honorless Target'),
 (2,1,3050,'Detect'),
 (2,1,3365,'Opening'),
-(2,1,5301,'Defensive State(DND)'),
+(2,1,5301,'Defensive State (DND)'),
 (2,1,6233,'Closing'),
 (2,1,6246,'Closing'),
 (2,1,6247,'Opening'),
@@ -10132,14 +10158,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,1,22027,'Remove Insignia'),
 (2,1,22810,'Opening - No Text'),
 (2,1,32215,'Victorious State'),
+(2,1,45927,'Summon Friend'),
+(2,1,61437,'Opening'),
 (2,3,75,'Auto Shot'),
 (2,3,81,'Dodge'),
 (2,3,196,'One-Handed Axes'),
 (2,3,203,'Unarmed'),
 (2,3,204,'Defense'),
 (2,3,264,'Bows'),
-(2,3,522,'SPELLDEFENSE(DND)'),
+(2,3,522,'SPELLDEFENSE (DND)'),
 (2,3,669,'Language Orcish'),
+(2,3,1843,'Disarm'),
 (2,3,2382,'Generic'),
 (2,3,2479,'Honorless Target'),
 (2,3,2973,'Raptor Strike'),
@@ -10158,7 +10187,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,3,9077,'Leather'),
 (2,3,9078,'Cloth'),
 (2,3,9125,'Generic'),
-(2,3,13358,'Defensive State(DND)'),
+(2,3,13358,'Defensive State (DND)'),
 (2,3,20572,'Blood Fury'),
 (2,3,20573,'Hardiness'),
 (2,3,20574,'Axe Specialization'),
@@ -10167,15 +10196,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,3,21652,'Closing'),
 (2,3,22027,'Remove Insignia'),
 (2,3,22810,'Opening - No Text'),
-(2,3,24949,'Defensive State 2(DND)'),
-(2,3,34082,'Advantaged State(DND)'),
+(2,3,24949,'Defensive State 2 (DND)'),
+(2,3,34082,'Advantaged State (DND)'),
+(2,3,45927,'Summon Friend'),
+(2,3,61437,'Opening'),
 (2,4,81,'Dodge'),
 (2,4,203,'Unarmed'),
 (2,4,204,'Defense'),
-(2,4,522,'SPELLDEFENSE(DND)'),
+(2,4,522,'SPELLDEFENSE (DND)'),
 (2,4,669,'Language Orcish'),
 (2,4,1180,'Daggers'),
 (2,4,1752,'Sinister Strike'),
+(2,4,1843,'Disarm'),
 (2,4,2098,'Eviscerate'),
 (2,4,2382,'Generic'),
 (2,4,2479,'Honorless Target'),
@@ -10196,16 +10228,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,4,9077,'Leather'),
 (2,4,9078,'Cloth'),
 (2,4,9125,'Generic'),
-(2,4,16092,'Defensive State(DND)'),
+(2,4,16092,'Defensive State (DND)'),
 (2,4,20572,'Blood Fury'),
 (2,4,20573,'Hardiness'),
 (2,4,20574,'Axe Specialization'),
-(2,4,21184,'Rogue Passive(DND)'),
+(2,4,21184,'Rogue Passive (DND)'),
 (2,4,21563,'Command'),
 (2,4,21651,'Opening'),
 (2,4,21652,'Closing'),
 (2,4,22027,'Remove Insignia'),
 (2,4,22810,'Opening - No Text'),
+(2,4,45927,'Summon Friend'),
+(2,4,61437,'Opening'),
 (2,6,81,'Dodge'),
 (2,6,196,'One-Handed Axes'),
 (2,6,197,'Two-Handed Axes'),
@@ -10281,8 +10315,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,7,227,'Staves'),
 (2,7,331,'Healing Wave'),
 (2,7,403,'Lightning Bolt'),
-(2,7,522,'SPELLDEFENSE(DND)'),
+(2,7,522,'SPELLDEFENSE (DND)'),
 (2,7,669,'Language Orcish'),
+(2,7,1843,'Disarm'),
 (2,7,2382,'Generic'),
 (2,7,2479,'Honorless Target'),
 (2,7,3050,'Detect'),
@@ -10310,14 +10345,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,7,22810,'Opening - No Text'),
 (2,7,27763,'Totem'),
 (2,7,33697,'Blood Fury'),
+(2,7,45927,'Summon Friend'),
+(2,7,61437,'Opening'),
 (2,9,81,'Dodge'),
 (2,9,203,'Unarmed'),
 (2,9,204,'Defense'),
-(2,9,522,'SPELLDEFENSE(DND)'),
+(2,9,522,'SPELLDEFENSE (DND)'),
 (2,9,669,'Language Orcish'),
 (2,9,686,'Shadow Bolt'),
 (2,9,687,'Demon Skin'),
 (2,9,1180,'Daggers'),
+(2,9,1843,'Disarm'),
 (2,9,2382,'Generic'),
 (2,9,2479,'Honorless Target'),
 (2,9,3050,'Detect'),
@@ -10344,6 +10382,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (2,9,22027,'Remove Insignia'),
 (2,9,22810,'Opening - No Text'),
 (2,9,33702,'Blood Fury'),
+(2,9,45927,'Summon Friend'),
+(2,9,58284,'Chaos Bolt Passive'),
+(2,9,61437,'Opening'),
 (3,1,78,'Heroic Strike'),
 (3,1,81,'Dodge'),
 (3,1,107,'Block'),
@@ -10352,16 +10393,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,1,198,'One-Handed Maces'),
 (3,1,203,'Unarmed'),
 (3,1,204,'Defense'),
-(3,1,522,'SPELLDEFENSE(DND)'),
+(3,1,522,'SPELLDEFENSE (DND)'),
 (3,1,668,'Language Common'),
 (3,1,672,'Language Dwarven'),
+(3,1,1843,'Disarm'),
 (3,1,2382,'Generic'),
 (3,1,2457,'Battle Stance'),
 (3,1,2479,'Honorless Target'),
 (3,1,2481,'Find Treasure'),
 (3,1,3050,'Detect'),
 (3,1,3365,'Opening'),
-(3,1,5301,'Defensive State(DND)'),
+(3,1,5301,'Defensive State (DND)'),
 (3,1,6233,'Closing'),
 (3,1,6246,'Closing'),
 (3,1,6247,'Opening'),
@@ -10385,16 +10427,20 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,1,22027,'Remove Insignia'),
 (3,1,22810,'Opening - No Text'),
 (3,1,32215,'Victorious State'),
+(3,1,45927,'Summon Friend'),
+(3,1,59224,'Mace Specialization'),
+(3,1,61437,'Opening'),
 (3,2,81,'Dodge'),
 (3,2,107,'Block'),
 (3,2,198,'One-Handed Maces'),
 (3,2,199,'Two-Handed Maces'),
 (3,2,203,'Unarmed'),
 (3,2,204,'Defense'),
-(3,2,522,'SPELLDEFENSE(DND)'),
+(3,2,522,'SPELLDEFENSE (DND)'),
 (3,2,635,'Holy Light'),
 (3,2,668,'Language Common'),
 (3,2,672,'Language Dwarven'),
+(3,2,1843,'Disarm'),
 (3,2,2382,'Generic'),
 (3,2,2479,'Honorless Target'),
 (3,2,2481,'Find Treasure'),
@@ -10415,7 +10461,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,2,9078,'Cloth'),
 (3,2,9116,'Shield'),
 (3,2,9125,'Generic'),
-(3,2,21084,'Seal of Righteousness'),
+(3,2,20154,'Seal of Righteousness'),
 (3,2,20594,'Stoneform'),
 (3,2,20595,'Gun Specialization'),
 (3,2,20596,'Frost Resistance'),
@@ -10424,15 +10470,19 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,2,22027,'Remove Insignia'),
 (3,2,22810,'Opening - No Text'),
 (3,2,27762,'Libram'),
+(3,2,45927,'Summon Friend'),
+(3,2,59224,'Mace Specialization'),
+(3,2,61437,'Opening'),
 (3,3,75,'Auto Shot'),
 (3,3,81,'Dodge'),
 (3,3,196,'One-Handed Axes'),
 (3,3,203,'Unarmed'),
 (3,3,204,'Defense'),
 (3,3,266,'Guns'),
-(3,3,522,'SPELLDEFENSE(DND)'),
+(3,3,522,'SPELLDEFENSE (DND)'),
 (3,3,668,'Language Common'),
 (3,3,672,'Language Dwarven'),
+(3,3,1843,'Disarm'),
 (3,3,2382,'Generic'),
 (3,3,2479,'Honorless Target'),
 (3,3,2481,'Find Treasure'),
@@ -10452,7 +10502,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,3,9077,'Leather'),
 (3,3,9078,'Cloth'),
 (3,3,9125,'Generic'),
-(3,3,13358,'Defensive State(DND)'),
+(3,3,13358,'Defensive State (DND)'),
 (3,3,20594,'Stoneform'),
 (3,3,20595,'Gun Specialization'),
 (3,3,20596,'Frost Resistance'),
@@ -10460,16 +10510,20 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,3,21652,'Closing'),
 (3,3,22027,'Remove Insignia'),
 (3,3,22810,'Opening - No Text'),
-(3,3,24949,'Defensive State 2(DND)'),
-(3,3,34082,'Advantaged State(DND)'),
+(3,3,24949,'Defensive State 2 (DND)'),
+(3,3,34082,'Advantaged State (DND)'),
+(3,3,45927,'Summon Friend'),
+(3,3,59224,'Mace Specialization'),
+(3,3,61437,'Opening'),
 (3,4,81,'Dodge'),
 (3,4,203,'Unarmed'),
 (3,4,204,'Defense'),
-(3,4,522,'SPELLDEFENSE(DND)'),
+(3,4,522,'SPELLDEFENSE (DND)'),
 (3,4,668,'Language Common'),
 (3,4,672,'Language Dwarven'),
 (3,4,1180,'Daggers'),
 (3,4,1752,'Sinister Strike'),
+(3,4,1843,'Disarm'),
 (3,4,2098,'Eviscerate'),
 (3,4,2382,'Generic'),
 (3,4,2479,'Honorless Target'),
@@ -10491,23 +10545,27 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,4,9077,'Leather'),
 (3,4,9078,'Cloth'),
 (3,4,9125,'Generic'),
-(3,4,16092,'Defensive State(DND)'),
+(3,4,16092,'Defensive State (DND)'),
 (3,4,20594,'Stoneform'),
 (3,4,20595,'Gun Specialization'),
 (3,4,20596,'Frost Resistance'),
-(3,4,21184,'Rogue Passive(DND)'),
+(3,4,21184,'Rogue Passive (DND)'),
 (3,4,21651,'Opening'),
 (3,4,21652,'Closing'),
 (3,4,22027,'Remove Insignia'),
 (3,4,22810,'Opening - No Text'),
+(3,4,45927,'Summon Friend'),
+(3,4,59224,'Mace Specialization'),
+(3,4,61437,'Opening'),
 (3,5,81,'Dodge'),
 (3,5,198,'One-Handed Maces'),
 (3,5,203,'Unarmed'),
 (3,5,204,'Defense'),
-(3,5,522,'SPELLDEFENSE(DND)'),
+(3,5,522,'SPELLDEFENSE (DND)'),
 (3,5,585,'Smite'),
 (3,5,668,'Language Common'),
 (3,5,672,'Language Dwarven'),
+(3,5,1843,'Disarm'),
 (3,5,2050,'Lesser Heal'),
 (3,5,2382,'Generic'),
 (3,5,2479,'Honorless Target'),
@@ -10535,6 +10593,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (3,5,21652,'Closing'),
 (3,5,22027,'Remove Insignia'),
 (3,5,22810,'Opening - No Text'),
+(3,5,45927,'Summon Friend'),
+(3,5,59224,'Mace Specialization'),
+(3,5,61437,'Opening'),
 (3,6,81,'Dodge'),
 (3,6,196,'One-Handed Axes'),
 (3,6,197,'Two-Handed Axes'),
@@ -10611,16 +10672,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,1,201,'One-Handed Swords'),
 (4,1,203,'Unarmed'),
 (4,1,204,'Defense'),
-(4,1,522,'SPELLDEFENSE(DND)'),
+(4,1,522,'SPELLDEFENSE (DND)'),
 (4,1,668,'Language Common'),
 (4,1,671,'Language Darnassian'),
 (4,1,1180,'Daggers'),
+(4,1,1843,'Disarm'),
 (4,1,2382,'Generic'),
 (4,1,2457,'Battle Stance'),
 (4,1,2479,'Honorless Target'),
 (4,1,3050,'Detect'),
 (4,1,3365,'Opening'),
-(4,1,5301,'Defensive State(DND)'),
+(4,1,5301,'Defensive State (DND)'),
 (4,1,6233,'Closing'),
 (4,1,6246,'Closing'),
 (4,1,6247,'Opening'),
@@ -10636,25 +10698,27 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,1,9078,'Cloth'),
 (4,1,9116,'Shield'),
 (4,1,9125,'Generic'),
-(4,1,20580,'Shadowmeld'),
 (4,1,20582,'Quickness'),
 (4,1,20583,'Nature Resistance'),
 (4,1,20585,'Wisp Spirit'),
-(4,1,21009,'Shadowmeld Passive'),
 (4,1,21651,'Opening'),
 (4,1,21652,'Closing'),
 (4,1,22027,'Remove Insignia'),
 (4,1,22810,'Opening - No Text'),
 (4,1,32215,'Victorious State'),
+(4,1,45927,'Summon Friend'),
+(4,1,58984,'Shadowmelt'),
+(4,1,61437,'Opening'),
 (4,3,75,'Auto Shot'),
 (4,3,81,'Dodge'),
 (4,3,203,'Unarmed'),
 (4,3,204,'Defense'),
 (4,3,264,'Bows'),
-(4,3,522,'SPELLDEFENSE(DND)'),
+(4,3,522,'SPELLDEFENSE (DND)'),
 (4,3,668,'Language Common'),
 (4,3,671,'Language Darnassian'),
 (4,3,1180,'Daggers'),
+(4,3,1843,'Disarm'),
 (4,3,2382,'Generic'),
 (4,3,2479,'Honorless Target'),
 (4,3,2973,'Raptor Strike'),
@@ -10673,26 +10737,28 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,3,9077,'Leather'),
 (4,3,9078,'Cloth'),
 (4,3,9125,'Generic'),
-(4,3,13358,'Defensive State(DND)'),
-(4,3,20580,'Shadowmeld'),
+(4,3,13358,'Defensive State (DND)'),
 (4,3,20582,'Quickness'),
 (4,3,20583,'Nature Resistance'),
 (4,3,20585,'Wisp Spirit'),
-(4,3,21009,'Shadowmeld Passive'),
 (4,3,21651,'Opening'),
 (4,3,21652,'Closing'),
 (4,3,22027,'Remove Insignia'),
 (4,3,22810,'Opening - No Text'),
-(4,3,24949,'Defensive State 2(DND)'),
-(4,3,34082,'Advantaged State(DND)'),
+(4,3,24949,'Defensive State 2 (DND)'),
+(4,3,34082,'Advantaged State (DND)'),
+(4,3,45927,'Summon Friend'),
+(4,3,58984,'Shadowmelt'),
+(4,3,61437,'Opening'),
 (4,4,81,'Dodge'),
 (4,4,203,'Unarmed'),
 (4,4,204,'Defense'),
-(4,4,522,'SPELLDEFENSE(DND)'),
+(4,4,522,'SPELLDEFENSE (DND)'),
 (4,4,668,'Language Common'),
 (4,4,671,'Language Darnassian'),
 (4,4,1180,'Daggers'),
 (4,4,1752,'Sinister Strike'),
+(4,4,1843,'Disarm'),
 (4,4,2098,'Eviscerate'),
 (4,4,2382,'Generic'),
 (4,4,2479,'Honorless Target'),
@@ -10713,25 +10779,27 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,4,9077,'Leather'),
 (4,4,9078,'Cloth'),
 (4,4,9125,'Generic'),
-(4,4,16092,'Defensive State(DND)'),
-(4,4,20580,'Shadowmeld'),
+(4,4,16092,'Defensive State (DND)'),
 (4,4,20582,'Quickness'),
 (4,4,20583,'Nature Resistance'),
 (4,4,20585,'Wisp Spirit'),
-(4,4,21009,'Shadowmeld Passive'),
-(4,4,21184,'Rogue Passive(DND)'),
+(4,4,21184,'Rogue Passive (DND)'),
 (4,4,21651,'Opening'),
 (4,4,21652,'Closing'),
 (4,4,22027,'Remove Insignia'),
 (4,4,22810,'Opening - No Text'),
+(4,4,45927,'Summon Friend'),
+(4,4,58984,'Shadowmelt'),
+(4,4,61437,'Opening'),
 (4,5,81,'Dodge'),
 (4,5,198,'One-Handed Maces'),
 (4,5,203,'Unarmed'),
 (4,5,204,'Defense'),
-(4,5,522,'SPELLDEFENSE(DND)'),
+(4,5,522,'SPELLDEFENSE (DND)'),
 (4,5,585,'Smite'),
 (4,5,668,'Language Common'),
 (4,5,671,'Language Darnassian'),
+(4,5,1843,'Disarm'),
 (4,5,2050,'Lesser Heal'),
 (4,5,2382,'Generic'),
 (4,5,2479,'Honorless Target'),
@@ -10751,15 +10819,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,5,8386,'Attacking'),
 (4,5,9078,'Cloth'),
 (4,5,9125,'Generic'),
-(4,5,20580,'Shadowmeld'),
 (4,5,20582,'Quickness'),
 (4,5,20583,'Nature Resistance'),
 (4,5,20585,'Wisp Spirit'),
-(4,5,21009,'Shadowmeld Passive'),
 (4,5,21651,'Opening'),
 (4,5,21652,'Closing'),
 (4,5,22027,'Remove Insignia'),
 (4,5,22810,'Opening - No Text'),
+(4,5,45927,'Summon Friend'),
+(4,5,58984,'Shadowmelt'),
+(4,5,61437,'Opening'),
 (4,6,81,'Dodge'),
 (4,6,196,'One-Handed Axes'),
 (4,6,197,'Two-Handed Axes'),
@@ -10832,10 +10901,11 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,11,203,'Unarmed'),
 (4,11,204,'Defense'),
 (4,11,227,'Staves'),
-(4,11,522,'SPELLDEFENSE(DND)'),
+(4,11,522,'SPELLDEFENSE (DND)'),
 (4,11,668,'Language Common'),
 (4,11,671,'Language Darnassian'),
 (4,11,1180,'Daggers'),
+(4,11,1843,'Disarm'),
 (4,11,2382,'Generic'),
 (4,11,2479,'Honorless Target'),
 (4,11,3050,'Detect'),
@@ -10855,16 +10925,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (4,11,9077,'Leather'),
 (4,11,9078,'Cloth'),
 (4,11,9125,'Generic'),
-(4,11,20580,'Shadowmeld'),
 (4,11,20582,'Quickness'),
 (4,11,20583,'Nature Resistance'),
 (4,11,20585,'Wisp Spirit'),
-(4,11,21009,'Shadowmeld Passive'),
 (4,11,21651,'Opening'),
 (4,11,21652,'Closing'),
 (4,11,22027,'Remove Insignia'),
 (4,11,22810,'Opening - No Text'),
 (4,11,27764,'Fetish'),
+(4,11,45927,'Summon Friend'),
+(4,11,58984,'Shadowmelt'),
+(4,11,61437,'Opening'),
 (5,1,78,'Heroic Strike'),
 (5,1,81,'Dodge'),
 (5,1,107,'Block'),
@@ -10872,16 +10943,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,1,202,'Two-Handed Swords'),
 (5,1,203,'Unarmed'),
 (5,1,204,'Defense'),
-(5,1,522,'SPELLDEFENSE(DND)'),
+(5,1,522,'SPELLDEFENSE (DND)'),
 (5,1,669,'Language Orcish'),
 (5,1,1180,'Daggers'),
+(5,1,1843,'Disarm'),
 (5,1,2382,'Generic'),
 (5,1,2457,'Battle Stance'),
 (5,1,2479,'Honorless Target'),
 (5,1,3050,'Detect'),
 (5,1,3365,'Opening'),
 (5,1,5227,'Underwater Breathing'),
-(5,1,5301,'Defensive State(DND)'),
+(5,1,5301,'Defensive State (DND)'),
 (5,1,6233,'Closing'),
 (5,1,6246,'Closing'),
 (5,1,6247,'Opening'),
@@ -10906,13 +10978,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,1,22027,'Remove Insignia'),
 (5,1,22810,'Opening - No Text'),
 (5,1,32215,'Victorious State'),
+(5,1,45927,'Summon Friend'),
+(5,1,61437,'Opening'),
 (5,4,81,'Dodge'),
 (5,4,203,'Unarmed'),
 (5,4,204,'Defense'),
-(5,4,522,'SPELLDEFENSE(DND)'),
+(5,4,522,'SPELLDEFENSE (DND)'),
 (5,4,669,'Language Orcish'),
 (5,4,1180,'Daggers'),
 (5,4,1752,'Sinister Strike'),
+(5,4,1843,'Disarm'),
 (5,4,2098,'Eviscerate'),
 (5,4,2382,'Generic'),
 (5,4,2479,'Honorless Target'),
@@ -10935,22 +11010,25 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,4,9077,'Leather'),
 (5,4,9078,'Cloth'),
 (5,4,9125,'Generic'),
-(5,4,16092,'Defensive State(DND)'),
+(5,4,16092,'Defensive State (DND)'),
 (5,4,17737,'Language Gutterspeak'),
 (5,4,20577,'Cannibalize'),
 (5,4,20579,'Shadow Resistance'),
-(5,4,21184,'Rogue Passive(DND)'),
+(5,4,21184,'Rogue Passive (DND)'),
 (5,4,21651,'Opening'),
 (5,4,21652,'Closing'),
 (5,4,22027,'Remove Insignia'),
 (5,4,22810,'Opening - No Text'),
+(5,4,45927,'Summon Friend'),
+(5,4,61437,'Opening'),
 (5,5,81,'Dodge'),
 (5,5,198,'One-Handed Maces'),
 (5,5,203,'Unarmed'),
 (5,5,204,'Defense'),
-(5,5,522,'SPELLDEFENSE(DND)'),
+(5,5,522,'SPELLDEFENSE (DND)'),
 (5,5,585,'Smite'),
 (5,5,669,'Language Orcish'),
+(5,5,1843,'Disarm'),
 (5,5,2050,'Lesser Heal'),
 (5,5,2382,'Generic'),
 (5,5,2479,'Honorless Target'),
@@ -10979,6 +11057,8 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,5,21652,'Closing'),
 (5,5,22027,'Remove Insignia'),
 (5,5,22810,'Opening - No Text'),
+(5,5,45927,'Summon Friend'),
+(5,5,61437,'Opening'),
 (5,6,81,'Dodge'),
 (5,6,196,'One-Handed Axes'),
 (5,6,197,'Two-Handed Axes'),
@@ -11053,8 +11133,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,8,203,'Unarmed'),
 (5,8,204,'Defense'),
 (5,8,227,'Staves'),
-(5,8,522,'SPELLDEFENSE(DND)'),
+(5,8,522,'SPELLDEFENSE (DND)'),
 (5,8,669,'Language Orcish'),
+(5,8,1843,'Disarm'),
 (5,8,2382,'Generic'),
 (5,8,2479,'Honorless Target'),
 (5,8,3050,'Detect'),
@@ -11082,14 +11163,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,8,21652,'Closing'),
 (5,8,22027,'Remove Insignia'),
 (5,8,22810,'Opening - No Text'),
+(5,8,45927,'Summon Friend'),
+(5,8,61437,'Opening'),
 (5,9,81,'Dodge'),
 (5,9,203,'Unarmed'),
 (5,9,204,'Defense'),
-(5,9,522,'SPELLDEFENSE(DND)'),
+(5,9,522,'SPELLDEFENSE (DND)'),
 (5,9,669,'Language Orcish'),
 (5,9,686,'Shadow Bolt'),
 (5,9,687,'Demon Skin'),
 (5,9,1180,'Daggers'),
+(5,9,1843,'Disarm'),
 (5,9,2382,'Generic'),
 (5,9,2479,'Honorless Target'),
 (5,9,3050,'Detect'),
@@ -11117,6 +11201,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (5,9,21652,'Closing'),
 (5,9,22027,'Remove Insignia'),
 (5,9,22810,'Opening - No Text'),
+(5,9,45927,'Summon Friend'),
+(5,9,58284,'Chaos Bolt Passive'),
+(5,9,61437,'Opening'),
 (6,1,78,'Heroic Strike'),
 (6,1,81,'Dodge'),
 (6,1,107,'Block'),
@@ -11125,15 +11212,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,1,199,'Two-Handed Maces'),
 (6,1,203,'Unarmed'),
 (6,1,204,'Defense'),
-(6,1,522,'SPELLDEFENSE(DND)'),
+(6,1,522,'SPELLDEFENSE (DND)'),
 (6,1,669,'Language Orcish'),
 (6,1,670,'Language Taurahe'),
+(6,1,1843,'Disarm'),
 (6,1,2382,'Generic'),
 (6,1,2457,'Battle Stance'),
 (6,1,2479,'Honorless Target'),
 (6,1,3050,'Detect'),
 (6,1,3365,'Opening'),
-(6,1,5301,'Defensive State(DND)'),
+(6,1,5301,'Defensive State (DND)'),
 (6,1,6233,'Closing'),
 (6,1,6246,'Closing'),
 (6,1,6247,'Opening'),
@@ -11158,15 +11246,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,1,22027,'Remove Insignia'),
 (6,1,22810,'Opening - No Text'),
 (6,1,32215,'Victorious State'),
+(6,1,45927,'Summon Friend'),
+(6,1,61437,'Opening'),
 (6,3,75,'Auto Shot'),
 (6,3,81,'Dodge'),
 (6,3,196,'One-Handed Axes'),
 (6,3,203,'Unarmed'),
 (6,3,204,'Defense'),
 (6,3,266,'Guns'),
-(6,3,522,'SPELLDEFENSE(DND)'),
+(6,3,522,'SPELLDEFENSE (DND)'),
 (6,3,669,'Language Orcish'),
 (6,3,670,'Language Taurahe'),
+(6,3,1843,'Disarm'),
 (6,3,2382,'Generic'),
 (6,3,2479,'Honorless Target'),
 (6,3,2973,'Raptor Strike'),
@@ -11185,7 +11276,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,3,9077,'Leather'),
 (6,3,9078,'Cloth'),
 (6,3,9125,'Generic'),
-(6,3,13358,'Defensive State(DND)'),
+(6,3,13358,'Defensive State (DND)'),
 (6,3,20549,'War Stomp'),
 (6,3,20550,'Endurance'),
 (6,3,20551,'Nature Resistance'),
@@ -11194,8 +11285,10 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,3,21652,'Closing'),
 (6,3,22027,'Remove Insignia'),
 (6,3,22810,'Opening - No Text'),
-(6,3,24949,'Defensive State 2(DND)'),
-(6,3,34082,'Advantaged State(DND)'),
+(6,3,24949,'Defensive State 2 (DND)'),
+(6,3,34082,'Advantaged State (DND)'),
+(6,3,45927,'Summon Friend'),
+(6,3,61437,'Opening'),
 (6,6,81,'Dodge'),
 (6,6,196,'One-Handed Axes'),
 (6,6,197,'Two-Handed Axes'),
@@ -11272,9 +11365,10 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,7,227,'Staves'),
 (6,7,331,'Healing Wave'),
 (6,7,403,'Lightning Bolt'),
-(6,7,522,'SPELLDEFENSE(DND)'),
+(6,7,522,'SPELLDEFENSE (DND)'),
 (6,7,669,'Language Orcish'),
 (6,7,670,'Language Taurahe'),
+(6,7,1843,'Disarm'),
 (6,7,2382,'Generic'),
 (6,7,2479,'Honorless Target'),
 (6,7,3050,'Detect'),
@@ -11302,14 +11396,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,7,22027,'Remove Insignia'),
 (6,7,22810,'Opening - No Text'),
 (6,7,27763,'Totem'),
+(6,7,45927,'Summon Friend'),
+(6,7,61437,'Opening'),
 (6,11,81,'Dodge'),
 (6,11,198,'One-Handed Maces'),
 (6,11,203,'Unarmed'),
 (6,11,204,'Defense'),
 (6,11,227,'Staves'),
-(6,11,522,'SPELLDEFENSE(DND)'),
+(6,11,522,'SPELLDEFENSE (DND)'),
 (6,11,669,'Language Orcish'),
 (6,11,670,'Language Taurahe'),
+(6,11,1843,'Disarm'),
 (6,11,2382,'Generic'),
 (6,11,2479,'Honorless Target'),
 (6,11,3050,'Detect'),
@@ -11338,6 +11435,8 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (6,11,22027,'Remove Insignia'),
 (6,11,22810,'Opening - No Text'),
 (6,11,27764,'Fetish'),
+(6,11,45927,'Summon Friend'),
+(6,11,61437,'Opening'),
 (7,1,78,'Heroic Strike'),
 (7,1,81,'Dodge'),
 (7,1,107,'Block'),
@@ -11345,15 +11444,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (7,1,201,'One-Handed Swords'),
 (7,1,203,'Unarmed'),
 (7,1,204,'Defense'),
-(7,1,522,'SPELLDEFENSE(DND)'),
+(7,1,522,'SPELLDEFENSE (DND)'),
 (7,1,668,'Language Common'),
 (7,1,1180,'Daggers'),
+(7,1,1843,'Disarm'),
 (7,1,2382,'Generic'),
 (7,1,2457,'Battle Stance'),
 (7,1,2479,'Honorless Target'),
 (7,1,3050,'Detect'),
 (7,1,3365,'Opening'),
-(7,1,5301,'Defensive State(DND)'),
+(7,1,5301,'Defensive State (DND)'),
 (7,1,6233,'Closing'),
 (7,1,6246,'Closing'),
 (7,1,6247,'Opening'),
@@ -11379,13 +11479,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (7,1,22027,'Remove Insignia'),
 (7,1,22810,'Opening - No Text'),
 (7,1,32215,'Victorious State'),
+(7,1,45927,'Summon Friend'),
+(7,1,61437,'Opening'),
 (7,4,81,'Dodge'),
 (7,4,203,'Unarmed'),
 (7,4,204,'Defense'),
-(7,4,522,'SPELLDEFENSE(DND)'),
+(7,4,522,'SPELLDEFENSE (DND)'),
 (7,4,668,'Language Common'),
 (7,4,1180,'Daggers'),
 (7,4,1752,'Sinister Strike'),
+(7,4,1843,'Disarm'),
 (7,4,2098,'Eviscerate'),
 (7,4,2382,'Generic'),
 (7,4,2479,'Honorless Target'),
@@ -11407,16 +11510,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (7,4,9077,'Leather'),
 (7,4,9078,'Cloth'),
 (7,4,9125,'Generic'),
-(7,4,16092,'Defensive State(DND)'),
+(7,4,16092,'Defensive State (DND)'),
 (7,4,20589,'Escape Artist'),
 (7,4,20591,'Expansive Mind'),
 (7,4,20592,'Arcane Resistance'),
 (7,4,20593,'Engineering Specialization'),
-(7,4,21184,'Rogue Passive(DND)'),
+(7,4,21184,'Rogue Passive (DND)'),
 (7,4,21651,'Opening'),
 (7,4,21652,'Closing'),
 (7,4,22027,'Remove Insignia'),
 (7,4,22810,'Opening - No Text'),
+(7,4,45927,'Summon Friend'),
+(7,4,61437,'Opening'),
 (7,6,81,'Dodge'),
 (7,6,196,'One-Handed Axes'),
 (7,6,197,'Two-Handed Axes'),
@@ -11491,8 +11596,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (7,8,203,'Unarmed'),
 (7,8,204,'Defense'),
 (7,8,227,'Staves'),
-(7,8,522,'SPELLDEFENSE(DND)'),
+(7,8,522,'SPELLDEFENSE (DND)'),
 (7,8,668,'Language Common'),
+(7,8,1843,'Disarm'),
 (7,8,2382,'Generic'),
 (7,8,2479,'Honorless Target'),
 (7,8,3050,'Detect'),
@@ -11520,14 +11626,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (7,8,21652,'Closing'),
 (7,8,22027,'Remove Insignia'),
 (7,8,22810,'Opening - No Text'),
+(7,8,45927,'Summon Friend'),
+(7,8,61437,'Opening'),
 (7,9,81,'Dodge'),
 (7,9,203,'Unarmed'),
 (7,9,204,'Defense'),
-(7,9,522,'SPELLDEFENSE(DND)'),
+(7,9,522,'SPELLDEFENSE (DND)'),
 (7,9,668,'Language Common'),
 (7,9,686,'Shadow Bolt'),
 (7,9,687,'Demon Skin'),
 (7,9,1180,'Daggers'),
+(7,9,1843,'Disarm'),
 (7,9,2382,'Generic'),
 (7,9,2479,'Honorless Target'),
 (7,9,3050,'Detect'),
@@ -11555,15 +11664,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (7,9,21652,'Closing'),
 (7,9,22027,'Remove Insignia'),
 (7,9,22810,'Opening - No Text'),
+(7,9,45927,'Summon Friend'),
+(7,9,61437,'Opening'),
 (8,1,78,'Heroic Strike'),
 (8,1,81,'Dodge'),
 (8,1,107,'Block'),
 (8,1,196,'One-Handed Axes'),
 (8,1,203,'Unarmed'),
 (8,1,204,'Defense'),
-(8,1,522,'SPELLDEFENSE(DND)'),
+(8,1,522,'SPELLDEFENSE (DND)'),
 (8,1,669,'Language Orcish'),
 (8,1,1180,'Daggers'),
+(8,1,1843,'Disarm'),
 (8,1,2382,'Generic'),
 (8,1,2457,'Battle Stance'),
 (8,1,2479,'Honorless Target'),
@@ -11571,7 +11683,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,1,2764,'Throw'),
 (8,1,3050,'Detect'),
 (8,1,3365,'Opening'),
-(8,1,5301,'Defensive State(DND)'),
+(8,1,5301,'Defensive State (DND)'),
 (8,1,6233,'Closing'),
 (8,1,6246,'Closing'),
 (8,1,6247,'Opening'),
@@ -11598,14 +11710,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,1,26290,'Bow Specialization'),
 (8,1,26296,'Berserking'),
 (8,1,32215,'Victorious State'),
+(8,1,45927,'Summon Friend'),
+(8,1,58943,'Da Voodoo Shuffle'),
+(8,1,61437,'Opening'),
 (8,3,75,'Auto Shot'),
 (8,3,81,'Dodge'),
 (8,3,196,'One-Handed Axes'),
 (8,3,203,'Unarmed'),
 (8,3,204,'Defense'),
 (8,3,264,'Bows'),
-(8,3,522,'SPELLDEFENSE(DND)'),
+(8,3,522,'SPELLDEFENSE (DND)'),
 (8,3,669,'Language Orcish'),
+(8,3,1843,'Disarm'),
 (8,3,2382,'Generic'),
 (8,3,2479,'Honorless Target'),
 (8,3,2973,'Raptor Strike'),
@@ -11625,7 +11741,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,3,9077,'Leather'),
 (8,3,9078,'Cloth'),
 (8,3,9125,'Generic'),
-(8,3,13358,'Defensive State(DND)'),
+(8,3,13358,'Defensive State (DND)'),
 (8,3,20554,'Berserking'),
 (8,3,20555,'Regeneration'),
 (8,3,20557,'Beast Slaying'),
@@ -11634,16 +11750,20 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,3,21652,'Closing'),
 (8,3,22027,'Remove Insignia'),
 (8,3,22810,'Opening - No Text'),
-(8,3,24949,'Defensive State 2(DND)'),
+(8,3,24949,'Defensive State 2 (DND)'),
 (8,3,26290,'Bow Specialization'),
-(8,3,34082,'Advantaged State(DND)'),
+(8,3,34082,'Advantaged State (DND)'),
+(8,3,45927,'Summon Friend'),
+(8,3,58943,'Da Voodoo Shuffle'),
+(8,3,61437,'Opening'),
 (8,4,81,'Dodge'),
 (8,4,203,'Unarmed'),
 (8,4,204,'Defense'),
-(8,4,522,'SPELLDEFENSE(DND)'),
+(8,4,522,'SPELLDEFENSE (DND)'),
 (8,4,669,'Language Orcish'),
 (8,4,1180,'Daggers'),
 (8,4,1752,'Sinister Strike'),
+(8,4,1843,'Disarm'),
 (8,4,2098,'Eviscerate'),
 (8,4,2382,'Generic'),
 (8,4,2479,'Honorless Target'),
@@ -11665,24 +11785,28 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,4,9077,'Leather'),
 (8,4,9078,'Cloth'),
 (8,4,9125,'Generic'),
-(8,4,16092,'Defensive State(DND)'),
+(8,4,16092,'Defensive State (DND)'),
 (8,4,20555,'Regeneration'),
 (8,4,20557,'Beast Slaying'),
 (8,4,20558,'Throwing Specialization'),
-(8,4,21184,'Rogue Passive(DND)'),
+(8,4,21184,'Rogue Passive (DND)'),
 (8,4,21651,'Opening'),
 (8,4,21652,'Closing'),
 (8,4,22027,'Remove Insignia'),
 (8,4,22810,'Opening - No Text'),
 (8,4,26290,'Bow Specialization'),
 (8,4,26297,'Berserking'),
+(8,4,45927,'Summon Friend'),
+(8,4,58943,'Da Voodoo Shuffle'),
+(8,4,61437,'Opening'),
 (8,5,81,'Dodge'),
 (8,5,198,'One-Handed Maces'),
 (8,5,203,'Unarmed'),
 (8,5,204,'Defense'),
-(8,5,522,'SPELLDEFENSE(DND)'),
+(8,5,522,'SPELLDEFENSE (DND)'),
 (8,5,585,'Smite'),
 (8,5,669,'Language Orcish'),
+(8,5,1843,'Disarm'),
 (8,5,2050,'Lesser Heal'),
 (8,5,2382,'Generic'),
 (8,5,2479,'Honorless Target'),
@@ -11712,6 +11836,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,5,22027,'Remove Insignia'),
 (8,5,22810,'Opening - No Text'),
 (8,5,26290,'Bow Specialization'),
+(8,5,45927,'Summon Friend'),
+(8,5,58943,'Da Voodoo Shuffle'),
+(8,5,61437,'Opening'),
 (8,6,81,'Dodge'),
 (8,6,196,'One-Handed Axes'),
 (8,6,197,'Two-Handed Axes'),
@@ -11790,8 +11917,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,7,227,'Staves'),
 (8,7,331,'Healing Wave'),
 (8,7,403,'Lightning Bolt'),
-(8,7,522,'SPELLDEFENSE(DND)'),
+(8,7,522,'SPELLDEFENSE (DND)'),
 (8,7,669,'Language Orcish'),
+(8,7,1843,'Disarm'),
 (8,7,2382,'Generic'),
 (8,7,2479,'Honorless Target'),
 (8,7,3050,'Detect'),
@@ -11821,14 +11949,18 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,7,22810,'Opening - No Text'),
 (8,7,26290,'Bow Specialization'),
 (8,7,27763,'Totem'),
+(8,7,45927,'Summon Friend'),
+(8,7,58943,'Da Voodoo Shuffle'),
+(8,7,61437,'Opening'),
 (8,8,81,'Dodge'),
 (8,8,133,'Fireball'),
 (8,8,168,'Frost Armor'),
 (8,8,203,'Unarmed'),
 (8,8,204,'Defense'),
 (8,8,227,'Staves'),
-(8,8,522,'SPELLDEFENSE(DND)'),
+(8,8,522,'SPELLDEFENSE (DND)'),
 (8,8,669,'Language Orcish'),
+(8,8,1843,'Disarm'),
 (8,8,2382,'Generic'),
 (8,8,2479,'Honorless Target'),
 (8,8,3050,'Detect'),
@@ -11857,13 +11989,16 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (8,8,22027,'Remove Insignia'),
 (8,8,22810,'Opening - No Text'),
 (8,8,26290,'Bow Specialization'),
+(8,8,45927,'Summon Friend'),
+(8,8,58943,'Da Voodoo Shuffle'),
+(8,8,61437,'Opening'),
 (10,2,81,'Dodge'),
 (10,2,107,'Block'),
 (10,2,201,'One-Handed Swords'),
 (10,2,202,'Two-Handed Swords'),
 (10,2,203,'Unarmed'),
 (10,2,204,'Defense'),
-(10,2,522,'SPELLDEFENSE(DND)'),
+(10,2,522,'SPELLDEFENSE (DND)'),
 (10,2,635,'Holy Light'),
 (10,2,669,'Language Orcish'),
 (10,2,813,'Language Thalassian'),
@@ -11901,7 +12036,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (10,3,203,'Unarmed'),
 (10,3,204,'Defense'),
 (10,3,264,'Bows'),
-(10,3,522,'SPELLDEFENSE(DND)'),
+(10,3,522,'SPELLDEFENSE (DND)'),
 (10,3,669,'Language Orcish'),
 (10,3,813,'Language Thalassian'),
 (10,3,822,'Magic Resistance'),
@@ -11924,20 +12059,20 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (10,3,9077,'Leather'),
 (10,3,9078,'Cloth'),
 (10,3,9125,'Generic'),
-(10,3,13358,'Defensive State(DND)'),
+(10,3,13358,'Defensive State (DND)'),
 (10,3,21651,'Opening'),
 (10,3,21652,'Closing'),
 (10,3,22027,'Remove Insignia'),
 (10,3,22810,'Opening - No Text'),
-(10,3,24949,'Defensive State 2(DND)'),
+(10,3,24949,'Defensive State 2 (DND)'),
 (10,3,28730,'Arcane Torrent'),
 (10,3,28734,'Mana Tap'),
 (10,3,28877,'Arcane Affinity'),
-(10,3,34082,'Advantaged State(DND)'),
+(10,3,34082,'Advantaged State (DND)'),
 (10,4,81,'Dodge'),
 (10,4,203,'Unarmed'),
 (10,4,204,'Defense'),
-(10,4,522,'SPELLDEFENSE(DND)'),
+(10,4,522,'SPELLDEFENSE (DND)'),
 (10,4,669,'Language Orcish'),
 (10,4,813,'Language Thalassian'),
 (10,4,822,'Magic Resistance'),
@@ -11963,8 +12098,8 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (10,4,9077,'Leather'),
 (10,4,9078,'Cloth'),
 (10,4,9125,'Generic'),
-(10,4,16092,'Defensive State(DND)'),
-(10,4,21184,'Rogue Passive(DND)'),
+(10,4,16092,'Defensive State (DND)'),
+(10,4,21184,'Rogue Passive (DND)'),
 (10,4,21651,'Opening'),
 (10,4,21652,'Closing'),
 (10,4,22027,'Remove Insignia'),
@@ -11976,7 +12111,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (10,5,198,'One-Handed Maces'),
 (10,5,203,'Unarmed'),
 (10,5,204,'Defense'),
-(10,5,522,'SPELLDEFENSE(DND)'),
+(10,5,522,'SPELLDEFENSE (DND)'),
 (10,5,585,'Smite'),
 (10,5,669,'Language Orcish'),
 (10,5,813,'Language Thalassian'),
@@ -12080,7 +12215,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (10,8,203,'Unarmed'),
 (10,8,204,'Defense'),
 (10,8,227,'Staves'),
-(10,8,522,'SPELLDEFENSE(DND)'),
+(10,8,522,'SPELLDEFENSE (DND)'),
 (10,8,669,'Language Orcish'),
 (10,8,813,'Language Thalassian'),
 (10,8,822,'Magic Resistance'),
@@ -12112,7 +12247,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (10,9,81,'Dodge'),
 (10,9,203,'Unarmed'),
 (10,9,204,'Defense'),
-(10,9,522,'SPELLDEFENSE(DND)'),
+(10,9,522,'SPELLDEFENSE (DND)'),
 (10,9,669,'Language Orcish'),
 (10,9,686,'Shadow Bolt'),
 (10,9,687,'Demon Skin'),
@@ -12152,14 +12287,15 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,1,202,'Two-Handed Swords'),
 (11,1,203,'Unarmed'),
 (11,1,204,'Defense'),
-(11,1,522,'SPELLDEFENSE(DND)'),
+(11,1,522,'SPELLDEFENSE (DND)'),
 (11,1,668,'Language Common'),
+(11,1,1843,'Disarm'),
 (11,1,2382,'Generic'),
 (11,1,2457,'Battle Stance'),
 (11,1,2479,'Honorless Target'),
 (11,1,3050,'Detect'),
 (11,1,3365,'Opening'),
-(11,1,5301,'Defensive State(DND)'),
+(11,1,5301,'Defensive State (DND)'),
 (11,1,6233,'Closing'),
 (11,1,6246,'Closing'),
 (11,1,6247,'Opening'),
@@ -12176,7 +12312,6 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,1,9078,'Cloth'),
 (11,1,9116,'Shield'),
 (11,1,9125,'Generic'),
-(11,1,20579,'Shadow Resistance'),
 (11,1,21651,'Opening'),
 (11,1,21652,'Closing'),
 (11,1,22027,'Remove Insignia'),
@@ -12185,15 +12320,19 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,1,28880,'Gift of the Naaru'),
 (11,1,29932,'Language Draenei'),
 (11,1,32215,'Victorious State'),
+(11,1,45927,'Summon Friend'),
+(11,1,59221,'Shadow Resistance'),
+(11,1,61437,'Opening'),
 (11,2,81,'Dodge'),
 (11,2,107,'Block'),
 (11,2,198,'One-Handed Maces'),
 (11,2,199,'Two-Handed Maces'),
 (11,2,203,'Unarmed'),
 (11,2,204,'Defense'),
-(11,2,522,'SPELLDEFENSE(DND)'),
+(11,2,522,'SPELLDEFENSE (DND)'),
 (11,2,635,'Holy Light'),
 (11,2,668,'Language Common'),
+(11,2,1843,'Disarm'),
 (11,2,2382,'Generic'),
 (11,2,2479,'Honorless Target'),
 (11,2,3050,'Detect'),
@@ -12215,22 +12354,25 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,2,9116,'Shield'),
 (11,2,9125,'Generic'),
 (11,2,21084,'Seal of Righteousness'),
-(11,2,20579,'Shadow Resistance'),
 (11,2,21651,'Opening'),
 (11,2,21652,'Closing'),
 (11,2,22027,'Remove Insignia'),
 (11,2,22810,'Opening - No Text'),
 (11,2,27762,'Libram'),
 (11,2,28875,'Gemcutting'),
-(11,2,59542,'Gift of the Naaru'),
 (11,2,29932,'Language Draenei'),
+(11,2,45927,'Summon Friend'),
+(11,2,59221,'Shadow Resistance'),
+(11,2,59542,'Gift of the Naaru'),
+(11,2,61437,'Opening'),
 (11,3,75,'Auto Shot'),
 (11,3,81,'Dodge'),
 (11,3,201,'One-Handed Swords'),
 (11,3,203,'Unarmed'),
 (11,3,204,'Defense'),
-(11,3,522,'SPELLDEFENSE(DND)'),
+(11,3,522,'SPELLDEFENSE (DND)'),
 (11,3,668,'Language Common'),
+(11,3,1843,'Disarm'),
 (11,3,2382,'Generic'),
 (11,3,2479,'Honorless Target'),
 (11,3,2973,'Raptor Strike'),
@@ -12251,24 +12393,27 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,3,9077,'Leather'),
 (11,3,9078,'Cloth'),
 (11,3,9125,'Generic'),
-(11,3,13358,'Defensive State(DND)'),
-(11,3,20579,'Shadow Resistance'),
+(11,3,13358,'Defensive State (DND)'),
 (11,3,21651,'Opening'),
 (11,3,21652,'Closing'),
 (11,3,22027,'Remove Insignia'),
 (11,3,22810,'Opening - No Text'),
-(11,3,24949,'Defensive State 2(DND)'),
+(11,3,24949,'Defensive State 2 (DND)'),
 (11,3,28875,'Gemcutting'),
-(11,3,59543,'Gift of the Naaru'),
 (11,3,29932,'Language Draenei'),
-(11,3,34082,'Advantaged State(DND)'),
+(11,3,34082,'Advantaged State (DND)'),
+(11,3,45927,'Summon Friend'),
+(11,3,59221,'Shadow Resistance'),
+(11,3,59543,'Gift of the Naaru'),
+(11,3,61437,'Opening'),
 (11,5,81,'Dodge'),
 (11,5,198,'One-Handed Maces'),
 (11,5,203,'Unarmed'),
 (11,5,204,'Defense'),
-(11,5,522,'SPELLDEFENSE(DND)'),
+(11,5,522,'SPELLDEFENSE (DND)'),
 (11,5,585,'Smite'),
 (11,5,668,'Language Common'),
+(11,5,1843,'Disarm'),
 (11,5,2050,'Lesser Heal'),
 (11,5,2382,'Generic'),
 (11,5,2479,'Honorless Target'),
@@ -12288,15 +12433,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,5,8386,'Attacking'),
 (11,5,9078,'Cloth'),
 (11,5,9125,'Generic'),
-(11,5,20579,'Shadow Resistance'),
 (11,5,21651,'Opening'),
 (11,5,21652,'Closing'),
 (11,5,22027,'Remove Insignia'),
 (11,5,22810,'Opening - No Text'),
 (11,5,28875,'Gemcutting'),
 (11,5,28878,'Inspiring Presence'),
-(11,5,59544,'Gift of the Naaru'),
 (11,5,29932,'Language Draenei'),
+(11,5,45927,'Summon Friend'),
+(11,5,59221,'Shadow Resistance'),
+(11,5,59544,'Gift of the Naaru'),
+(11,5,61437,'Opening'),
 (11,6,81,'Dodge'),
 (11,6,196,'One-Handed Axes'),
 (11,6,197,'Two-Handed Axes'),
@@ -12359,6 +12506,7 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,6,49410,'Forceful Deflection'),
 (11,6,49576,'Death Grip'),
 (11,6,52665,'Sigil'),
+(11,6,59221,'Shadow Resistance'),
 (11,6,59539,'Shadow Resistance'),
 (11,6,59545,'Gift of the Naaru'),
 (11,6,59879,'Blood Plague'),
@@ -12373,8 +12521,9 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,7,227,'Staves'),
 (11,7,331,'Healing Wave'),
 (11,7,403,'Lightning Bolt'),
-(11,7,522,'SPELLDEFENSE(DND)'),
+(11,7,522,'SPELLDEFENSE (DND)'),
 (11,7,668,'Language Common'),
+(11,7,1843,'Disarm'),
 (11,7,2382,'Generic'),
 (11,7,2479,'Honorless Target'),
 (11,7,3050,'Detect'),
@@ -12393,7 +12542,6 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,7,9078,'Cloth'),
 (11,7,9116,'Shield'),
 (11,7,9125,'Generic'),
-(11,7,20579,'Shadow Resistance'),
 (11,7,21651,'Opening'),
 (11,7,21652,'Closing'),
 (11,7,22027,'Remove Insignia'),
@@ -12401,16 +12549,20 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,7,27763,'Totem'),
 (11,7,28875,'Gemcutting'),
 (11,7,28878,'Inspiring Presence'),
-(11,7,59547,'Gift of the Naaru'),
 (11,7,29932,'Language Draenei'),
+(11,7,45927,'Summon Friend'),
+(11,7,59221,'Shadow Resistance'),
+(11,7,59547,'Gift of the Naaru'),
+(11,7,61437,'Opening'),
 (11,8,81,'Dodge'),
 (11,8,133,'Fireball'),
 (11,8,168,'Frost Armor'),
 (11,8,203,'Unarmed'),
 (11,8,204,'Defense'),
 (11,8,227,'Staves'),
-(11,8,522,'SPELLDEFENSE(DND)'),
+(11,8,522,'SPELLDEFENSE (DND)'),
 (11,8,668,'Language Common'),
+(11,8,1843,'Disarm'),
 (11,8,2382,'Generic'),
 (11,8,2479,'Honorless Target'),
 (11,8,3050,'Detect'),
@@ -12429,15 +12581,17 @@ INSERT INTO `playercreateinfo_spell` VALUES
 (11,8,8386,'Attacking'),
 (11,8,9078,'Cloth'),
 (11,8,9125,'Generic'),
-(11,8,20579,'Shadow Resistance'),
 (11,8,21651,'Opening'),
 (11,8,21652,'Closing'),
 (11,8,22027,'Remove Insignia'),
 (11,8,22810,'Opening - No Text'),
 (11,8,28875,'Gemcutting'),
 (11,8,28878,'Inspiring Presence'),
+(11,8,29932,'Language Draenei'),
+(11,8,45927,'Summon Friend'),
+(11,8,59221,'Shadow Resistance'),
 (11,8,59548,'Gift of the Naaru'),
-(11,8,29932,'Language Draenei');
+(11,8,61437,'Opening');
 /*!40000 ALTER TABLE `playercreateinfo_spell` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -15963,8 +16117,8 @@ INSERT INTO `spell_learn_spell` VALUES
 (40123,40121,0),
 (40123,40122,0),
 (53428,53341,1),
-(53428,53343,1);
-
+(53428,53343,1),
+(58984,21009,1);
 
 
 /*!40000 ALTER TABLE `spell_learn_spell` ENABLE KEYS */;
-- 
cgit v1.2.3

