aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/TBC-WLK converter/TBC-WLK_characters.sql21
-rw-r--r--sql/characters.sql2
-rw-r--r--sql/mangos.sql414
-rw-r--r--sql/updates/7074_01_mangos_playercreateinfo_spell.sql2797
-rw-r--r--sql/updates/7075_01_characters_character_spell.sql13
-rw-r--r--sql/updates/7075_02_mangos_spell_learn_spell.sql6
-rw-r--r--src/game/SharedDefines.h2
-rw-r--r--src/game/Spell.cpp2
-rw-r--r--src/game/SpellAuras.cpp4
-rw-r--r--src/game/SpellAuras.h3
-rw-r--r--src/game/SpellEffects.cpp38
-rw-r--r--src/game/SpellMgr.cpp21
-rw-r--r--src/game/Unit.cpp6
-rw-r--r--src/shared/revision_nr.h2
14 files changed, 3154 insertions, 177 deletions
diff --git a/sql/TBC-WLK converter/TBC-WLK_characters.sql b/sql/TBC-WLK converter/TBC-WLK_characters.sql
index 6a57b60cac5..1e72e2340a9 100644
--- a/sql/TBC-WLK converter/TBC-WLK_characters.sql
+++ b/sql/TBC-WLK converter/TBC-WLK_characters.sql
@@ -1,15 +1,16 @@
-DELETE FROM `character_spell` WHERE `spell` IN ('28880', 59542, 59543, 59544, 59545, 59547, 59548);
-DELETE FROM `character_spell` WHERE `spell` IN (7376,3025,5419,5421,21156,7381,1178,21178,9635,21178,24905,5420,34123,33948,34090,34764,40121,40122);
-INSERT INTO character_spell SELECT characters.guid as guid, 28880, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 1;
-INSERT INTO character_spell SELECT characters.guid as guid, 59542, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 2;
-INSERT INTO character_spell SELECT characters.guid as guid, 59543, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 3;
-INSERT INTO character_spell SELECT characters.guid as guid, 59544, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 5;
-INSERT INTO character_spell SELECT characters.guid as guid, 59545, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 6;
-INSERT INTO character_spell SELECT characters.guid as guid, 59547, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 7;
-INSERT INTO character_spell SELECT characters.guid as guid, 59548, -1, 1, 0 FROM `characters` WHERE characters.race=11 AND characters.class = 8;
-
ALTER TABLE character_spell
DROP slot;
+DELETE FROM `character_spell` WHERE `spell` IN (28880, 59542, 59543, 59544, 59545, 59547, 59548);
+DELETE FROM `character_spell` WHERE `spell` IN (7376,3025,5419,5421,21156,7381,1178,21178,9635,21178,24905,5420,34123,33948,34090,34764,40121,40122);
+DELETE FROM character_spell WHERE `spell` IN (
+ 20580, /*old Shadowmeld*/
+ 20600, /*Perception*/
+ 21009, /*old Shadowmeld Passive and new Elusiveness (learned as racial passive)*/
+ 21184 /*old Seal of Righteousness*/
+);
+/*old Shadow Resistance, leaned as racial passive of race 5 */
+DELETE FROM character_spell USING character_spell INNER JOIN characters ON character_spell.guid = characters.guid
+WHERE character_spell.spell = 20579 AND characters.race <> 5;
alter table `character_pet`
drop column `trainpoint`,
diff --git a/sql/characters.sql b/sql/characters.sql
index c18c86759f0..b0ed36d0a7c 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -21,7 +21,7 @@
DROP TABLE IF EXISTS `character_db_version`;
CREATE TABLE `character_db_version` (
- `required_7067_03_characters_character_spell` bit(1) default NULL
+ `required_7075_01_characters_character_spell` bit(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
--
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 */;
diff --git a/sql/updates/7074_01_mangos_playercreateinfo_spell.sql b/sql/updates/7074_01_mangos_playercreateinfo_spell.sql
new file mode 100644
index 00000000000..7bf0b677557
--- /dev/null
+++ b/sql/updates/7074_01_mangos_playercreateinfo_spell.sql
@@ -0,0 +1,2797 @@
+ALTER TABLE db_version CHANGE COLUMN required_7067_02_mangos_spell_learn_spell required_7074_01_mangos_playercreateinfo_spell bit;
+
+DELETE FROM `playercreateinfo_spell`;
+
+INSERT INTO `playercreateinfo_spell` VALUES
+(1,1,78,'Heroic Strike'),
+(1,1,81,'Dodge'),
+(1,1,107,'Block'),
+(1,1,196,'One-Handed Axes'),
+(1,1,198,'One-Handed Maces'),
+(1,1,201,'One-Handed Swords'),
+(1,1,203,'Unarmed'),
+(1,1,204,'Defense'),
+(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,6233,'Closing'),
+(1,1,6246,'Closing'),
+(1,1,6247,'Opening'),
+(1,1,6477,'Opening'),
+(1,1,6478,'Opening'),
+(1,1,6603,'Attack'),
+(1,1,7266,'Duel'),
+(1,1,7267,'Grovel'),
+(1,1,7355,'Stuck'),
+(1,1,8386,'Attacking'),
+(1,1,8737,'Mail'),
+(1,1,9077,'Leather'),
+(1,1,9078,'Cloth'),
+(1,1,9116,'Shield'),
+(1,1,9125,'Generic'),
+(1,1,20597,'Sword Specialization'),
+(1,1,20598,'The Human Spirit'),
+(1,1,20599,'Diplomacy'),
+(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,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'),
+(1,2,3365,'Opening'),
+(1,2,6233,'Closing'),
+(1,2,6246,'Closing'),
+(1,2,6247,'Opening'),
+(1,2,6477,'Opening'),
+(1,2,6478,'Opening'),
+(1,2,6603,'Attack'),
+(1,2,7266,'Duel'),
+(1,2,7267,'Grovel'),
+(1,2,7355,'Stuck'),
+(1,2,8386,'Attacking'),
+(1,2,8737,'Mail'),
+(1,2,9077,'Leather'),
+(1,2,9078,'Cloth'),
+(1,2,9116,'Shield'),
+(1,2,9125,'Generic'),
+(1,2,20154,'Seal of Righteousness'),
+(1,2,20597,'Sword Specialization'),
+(1,2,20598,'The Human Spirit'),
+(1,2,20599,'Diplomacy'),
+(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,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'),
+(1,4,2567,'Thrown'),
+(1,4,2764,'Throw'),
+(1,4,3050,'Detect'),
+(1,4,3365,'Opening'),
+(1,4,6233,'Closing'),
+(1,4,6246,'Closing'),
+(1,4,6247,'Opening'),
+(1,4,6477,'Opening'),
+(1,4,6478,'Opening'),
+(1,4,6603,'Attack'),
+(1,4,7266,'Duel'),
+(1,4,7267,'Grovel'),
+(1,4,7355,'Stuck'),
+(1,4,8386,'Attacking'),
+(1,4,9077,'Leather'),
+(1,4,9078,'Cloth'),
+(1,4,9125,'Generic'),
+(1,4,16092,'Defensive State (DND)'),
+(1,4,20597,'Sword Specialization'),
+(1,4,20598,'The Human Spirit'),
+(1,4,20599,'Diplomacy'),
+(1,4,20864,'Mace Specialization'),
+(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,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'),
+(1,5,3050,'Detect'),
+(1,5,3365,'Opening'),
+(1,5,5009,'Wands'),
+(1,5,5019,'Shoot'),
+(1,5,6233,'Closing'),
+(1,5,6246,'Closing'),
+(1,5,6247,'Opening'),
+(1,5,6477,'Opening'),
+(1,5,6478,'Opening'),
+(1,5,6603,'Attack'),
+(1,5,7266,'Duel'),
+(1,5,7267,'Grovel'),
+(1,5,7355,'Stuck'),
+(1,5,8386,'Attacking'),
+(1,5,9078,'Cloth'),
+(1,5,9125,'Generic'),
+(1,5,20597,'Sword Specialization'),
+(1,5,20598,'The Human Spirit'),
+(1,5,20599,'Diplomacy'),
+(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'),
+(1,6,200,'Polearms'),
+(1,6,201,'One-Handed Swords'),
+(1,6,202,'Two-Handed Swords'),
+(1,6,203,'Unarmed'),
+(1,6,204,'Defense'),
+(1,6,522,'SPELLDEFENSE (DND)'),
+(1,6,668,'Language Common'),
+(1,6,674,'Dual Wield'),
+(1,6,750,'Plate Mail'),
+(1,6,1843,'Disarm'),
+(1,6,2382,'Generic'),
+(1,6,2479,'Honorless Target'),
+(1,6,3050,'Detect'),
+(1,6,3127,'Parry'),
+(1,6,3275,'Linen Bandage'),
+(1,6,3276,'Heavy Linen Bandage'),
+(1,6,3277,'Wool Bandage'),
+(1,6,3278,'Heavy Wool Bandage'),
+(1,6,3365,'Opening'),
+(1,6,6233,'Closing'),
+(1,6,6246,'Closing'),
+(1,6,6247,'Opening'),
+(1,6,6477,'Opening'),
+(1,6,6478,'Opening'),
+(1,6,6603,'Attack'),
+(1,6,7266,'Duel'),
+(1,6,7267,'Grovel'),
+(1,6,7355,'Stuck'),
+(1,6,7928,'Silk Bandage'),
+(1,6,7929,'Heavy Silk Bandage'),
+(1,6,7934,'Anti-Venom'),
+(1,6,8386,'Attacking'),
+(1,6,8737,'Mail'),
+(1,6,9077,'Leather'),
+(1,6,9078,'Cloth'),
+(1,6,9125,'Generic'),
+(1,6,10840,'Mageweave Bandage'),
+(1,6,10841,'Heavy Mageweave Bandage'),
+(1,6,10846,'First Aid'),
+(1,6,18629,'Runecloth Bandage'),
+(1,6,18630,'Heavy Runecloth Bandage'),
+(1,6,20597,'Sword Specialization'),
+(1,6,20598,'The Human Spirit'),
+(1,6,20599,'Diplomacy'),
+(1,6,20864,'Mace Specialization'),
+(1,6,21651,'Opening'),
+(1,6,21652,'Closing'),
+(1,6,22027,'Remove Insignia'),
+(1,6,22810,'Opening - No Text'),
+(1,6,33391,'Journeyman Riding'),
+(1,6,45462,'Plague Strike'),
+(1,6,45477,'Icy Touch'),
+(1,6,45902,'Blood Strike'),
+(1,6,45903,'Offensive State (DND)'),
+(1,6,45927,'Summon Friend'),
+(1,6,47541,'Death Coil'),
+(1,6,48266,'Blood Presence'),
+(1,6,49410,'Forceful Deflection'),
+(1,6,49576,'Death Grip'),
+(1,6,52665,'Sigil'),
+(1,6,58985,'Perception'),
+(1,6,59752,'Every Man for Himself'),
+(1,6,59879,'Blood Plague'),
+(1,6,59921,'Frost Fever'),
+(1,6,61437,'Opening'),
+(1,6,61455,'Runic Focus'),
+(1,8,81,'Dodge'),
+(1,8,133,'Fireball'),
+(1,8,168,'Frost Armor'),
+(1,8,203,'Unarmed'),
+(1,8,204,'Defense'),
+(1,8,227,'Staves'),
+(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'),
+(1,8,3365,'Opening'),
+(1,8,5009,'Wands'),
+(1,8,5019,'Shoot'),
+(1,8,6233,'Closing'),
+(1,8,6246,'Closing'),
+(1,8,6247,'Opening'),
+(1,8,6477,'Opening'),
+(1,8,6478,'Opening'),
+(1,8,6603,'Attack'),
+(1,8,7266,'Duel'),
+(1,8,7267,'Grovel'),
+(1,8,7355,'Stuck'),
+(1,8,8386,'Attacking'),
+(1,8,9078,'Cloth'),
+(1,8,9125,'Generic'),
+(1,8,20597,'Sword Specialization'),
+(1,8,20598,'The Human Spirit'),
+(1,8,20599,'Diplomacy'),
+(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,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'),
+(1,9,3365,'Opening'),
+(1,9,5009,'Wands'),
+(1,9,5019,'Shoot'),
+(1,9,6233,'Closing'),
+(1,9,6246,'Closing'),
+(1,9,6247,'Opening'),
+(1,9,6477,'Opening'),
+(1,9,6478,'Opening'),
+(1,9,6603,'Attack'),
+(1,9,7266,'Duel'),
+(1,9,7267,'Grovel'),
+(1,9,7355,'Stuck'),
+(1,9,8386,'Attacking'),
+(1,9,9078,'Cloth'),
+(1,9,9125,'Generic'),
+(1,9,20597,'Sword Specialization'),
+(1,9,20598,'The Human Spirit'),
+(1,9,20599,'Diplomacy'),
+(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'),
+(2,1,196,'One-Handed Axes'),
+(2,1,197,'Two-Handed Axes'),
+(2,1,201,'One-Handed Swords'),
+(2,1,203,'Unarmed'),
+(2,1,204,'Defense'),
+(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,6233,'Closing'),
+(2,1,6246,'Closing'),
+(2,1,6247,'Opening'),
+(2,1,6477,'Opening'),
+(2,1,6478,'Opening'),
+(2,1,6603,'Attack'),
+(2,1,7266,'Duel'),
+(2,1,7267,'Grovel'),
+(2,1,7355,'Stuck'),
+(2,1,8386,'Attacking'),
+(2,1,8737,'Mail'),
+(2,1,9077,'Leather'),
+(2,1,9078,'Cloth'),
+(2,1,9116,'Shield'),
+(2,1,9125,'Generic'),
+(2,1,20572,'Blood Fury'),
+(2,1,20573,'Hardiness'),
+(2,1,20574,'Axe Specialization'),
+(2,1,21563,'Command'),
+(2,1,21651,'Opening'),
+(2,1,21652,'Closing'),
+(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,669,'Language Orcish'),
+(2,3,1843,'Disarm'),
+(2,3,2382,'Generic'),
+(2,3,2479,'Honorless Target'),
+(2,3,2973,'Raptor Strike'),
+(2,3,3050,'Detect'),
+(2,3,3365,'Opening'),
+(2,3,6233,'Closing'),
+(2,3,6246,'Closing'),
+(2,3,6247,'Opening'),
+(2,3,6477,'Opening'),
+(2,3,6478,'Opening'),
+(2,3,6603,'Attack'),
+(2,3,7266,'Duel'),
+(2,3,7267,'Grovel'),
+(2,3,7355,'Stuck'),
+(2,3,8386,'Attacking'),
+(2,3,9077,'Leather'),
+(2,3,9078,'Cloth'),
+(2,3,9125,'Generic'),
+(2,3,13358,'Defensive State (DND)'),
+(2,3,20572,'Blood Fury'),
+(2,3,20573,'Hardiness'),
+(2,3,20574,'Axe Specialization'),
+(2,3,20576,'Command'),
+(2,3,21651,'Opening'),
+(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,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,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'),
+(2,4,2567,'Thrown'),
+(2,4,2764,'Throw'),
+(2,4,3050,'Detect'),
+(2,4,3365,'Opening'),
+(2,4,6233,'Closing'),
+(2,4,6246,'Closing'),
+(2,4,6247,'Opening'),
+(2,4,6477,'Opening'),
+(2,4,6478,'Opening'),
+(2,4,6603,'Attack'),
+(2,4,7266,'Duel'),
+(2,4,7267,'Grovel'),
+(2,4,7355,'Stuck'),
+(2,4,8386,'Attacking'),
+(2,4,9077,'Leather'),
+(2,4,9078,'Cloth'),
+(2,4,9125,'Generic'),
+(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,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'),
+(2,6,200,'Polearms'),
+(2,6,201,'One-Handed Swords'),
+(2,6,202,'Two-Handed Swords'),
+(2,6,203,'Unarmed'),
+(2,6,204,'Defense'),
+(2,6,522,'SPELLDEFENSE (DND)'),
+(2,6,669,'Language Orcish'),
+(2,6,674,'Dual Wield'),
+(2,6,750,'Plate Mail'),
+(2,6,1843,'Disarm'),
+(2,6,2382,'Generic'),
+(2,6,2479,'Honorless Target'),
+(2,6,3050,'Detect'),
+(2,6,3127,'Parry'),
+(2,6,3275,'Linen Bandage'),
+(2,6,3276,'Heavy Linen Bandage'),
+(2,6,3277,'Wool Bandage'),
+(2,6,3278,'Heavy Wool Bandage'),
+(2,6,3365,'Opening'),
+(2,6,6233,'Closing'),
+(2,6,6246,'Closing'),
+(2,6,6247,'Opening'),
+(2,6,6477,'Opening'),
+(2,6,6478,'Opening'),
+(2,6,6603,'Attack'),
+(2,6,7266,'Duel'),
+(2,6,7267,'Grovel'),
+(2,6,7355,'Stuck'),
+(2,6,7928,'Silk Bandage'),
+(2,6,7929,'Heavy Silk Bandage'),
+(2,6,7934,'Anti-Venom'),
+(2,6,8386,'Attacking'),
+(2,6,8737,'Mail'),
+(2,6,9077,'Leather'),
+(2,6,9078,'Cloth'),
+(2,6,9125,'Generic'),
+(2,6,10840,'Mageweave Bandage'),
+(2,6,10841,'Heavy Mageweave Bandage'),
+(2,6,10846,'First Aid'),
+(2,6,18629,'Runecloth Bandage'),
+(2,6,18630,'Heavy Runecloth Bandage'),
+(2,6,20572,'Blood Fury'),
+(2,6,20573,'Hardiness'),
+(2,6,20574,'Axe Specialization'),
+(2,6,21651,'Opening'),
+(2,6,21652,'Closing'),
+(2,6,22027,'Remove Insignia'),
+(2,6,22810,'Opening - No Text'),
+(2,6,33391,'Journeyman Riding'),
+(2,6,45462,'Plague Strike'),
+(2,6,45477,'Icy Touch'),
+(2,6,45902,'Blood Strike'),
+(2,6,45903,'Offensive State (DND)'),
+(2,6,45927,'Summon Friend'),
+(2,6,47541,'Death Coil'),
+(2,6,48266,'Blood Presence'),
+(2,6,49410,'Forceful Deflection'),
+(2,6,49576,'Death Grip'),
+(2,6,52665,'Sigil'),
+(2,6,54562,'Command'),
+(2,6,59879,'Blood Plague'),
+(2,6,59921,'Frost Fever'),
+(2,6,61437,'Opening'),
+(2,6,61455,'Runic Focus'),
+(2,7,81,'Dodge'),
+(2,7,107,'Block'),
+(2,7,198,'One-Handed Maces'),
+(2,7,203,'Unarmed'),
+(2,7,204,'Defense'),
+(2,7,227,'Staves'),
+(2,7,331,'Healing Wave'),
+(2,7,403,'Lightning Bolt'),
+(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'),
+(2,7,3365,'Opening'),
+(2,7,6233,'Closing'),
+(2,7,6246,'Closing'),
+(2,7,6247,'Opening'),
+(2,7,6477,'Opening'),
+(2,7,6478,'Opening'),
+(2,7,6603,'Attack'),
+(2,7,7266,'Duel'),
+(2,7,7267,'Grovel'),
+(2,7,7355,'Stuck'),
+(2,7,8386,'Attacking'),
+(2,7,9077,'Leather'),
+(2,7,9078,'Cloth'),
+(2,7,9116,'Shield'),
+(2,7,9125,'Generic'),
+(2,7,20573,'Hardiness'),
+(2,7,20574,'Axe Specialization'),
+(2,7,21563,'Command'),
+(2,7,21651,'Opening'),
+(2,7,21652,'Closing'),
+(2,7,22027,'Remove Insignia'),
+(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,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'),
+(2,9,3365,'Opening'),
+(2,9,5009,'Wands'),
+(2,9,5019,'Shoot'),
+(2,9,6233,'Closing'),
+(2,9,6246,'Closing'),
+(2,9,6247,'Opening'),
+(2,9,6477,'Opening'),
+(2,9,6478,'Opening'),
+(2,9,6603,'Attack'),
+(2,9,7266,'Duel'),
+(2,9,7267,'Grovel'),
+(2,9,7355,'Stuck'),
+(2,9,8386,'Attacking'),
+(2,9,9078,'Cloth'),
+(2,9,9125,'Generic'),
+(2,9,20573,'Hardiness'),
+(2,9,20574,'Axe Specialization'),
+(2,9,20575,'Command'),
+(2,9,21651,'Opening'),
+(2,9,21652,'Closing'),
+(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'),
+(3,1,196,'One-Handed Axes'),
+(3,1,197,'Two-Handed Axes'),
+(3,1,198,'One-Handed Maces'),
+(3,1,203,'Unarmed'),
+(3,1,204,'Defense'),
+(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,6233,'Closing'),
+(3,1,6246,'Closing'),
+(3,1,6247,'Opening'),
+(3,1,6477,'Opening'),
+(3,1,6478,'Opening'),
+(3,1,6603,'Attack'),
+(3,1,7266,'Duel'),
+(3,1,7267,'Grovel'),
+(3,1,7355,'Stuck'),
+(3,1,8386,'Attacking'),
+(3,1,8737,'Mail'),
+(3,1,9077,'Leather'),
+(3,1,9078,'Cloth'),
+(3,1,9116,'Shield'),
+(3,1,9125,'Generic'),
+(3,1,20594,'Stoneform'),
+(3,1,20595,'Gun Specialization'),
+(3,1,20596,'Frost Resistance'),
+(3,1,21651,'Opening'),
+(3,1,21652,'Closing'),
+(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,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'),
+(3,2,3050,'Detect'),
+(3,2,3365,'Opening'),
+(3,2,6233,'Closing'),
+(3,2,6246,'Closing'),
+(3,2,6247,'Opening'),
+(3,2,6477,'Opening'),
+(3,2,6478,'Opening'),
+(3,2,6603,'Attack'),
+(3,2,7266,'Duel'),
+(3,2,7267,'Grovel'),
+(3,2,7355,'Stuck'),
+(3,2,8386,'Attacking'),
+(3,2,8737,'Mail'),
+(3,2,9077,'Leather'),
+(3,2,9078,'Cloth'),
+(3,2,9116,'Shield'),
+(3,2,9125,'Generic'),
+(3,2,20154,'Seal of Righteousness'),
+(3,2,20594,'Stoneform'),
+(3,2,20595,'Gun Specialization'),
+(3,2,20596,'Frost Resistance'),
+(3,2,21651,'Opening'),
+(3,2,21652,'Closing'),
+(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,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'),
+(3,3,2973,'Raptor Strike'),
+(3,3,3050,'Detect'),
+(3,3,3365,'Opening'),
+(3,3,6233,'Closing'),
+(3,3,6246,'Closing'),
+(3,3,6247,'Opening'),
+(3,3,6477,'Opening'),
+(3,3,6478,'Opening'),
+(3,3,6603,'Attack'),
+(3,3,7266,'Duel'),
+(3,3,7267,'Grovel'),
+(3,3,7355,'Stuck'),
+(3,3,8386,'Attacking'),
+(3,3,9077,'Leather'),
+(3,3,9078,'Cloth'),
+(3,3,9125,'Generic'),
+(3,3,13358,'Defensive State (DND)'),
+(3,3,20594,'Stoneform'),
+(3,3,20595,'Gun Specialization'),
+(3,3,20596,'Frost Resistance'),
+(3,3,21651,'Opening'),
+(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,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,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'),
+(3,4,2481,'Find Treasure'),
+(3,4,2567,'Thrown'),
+(3,4,2764,'Throw'),
+(3,4,3050,'Detect'),
+(3,4,3365,'Opening'),
+(3,4,6233,'Closing'),
+(3,4,6246,'Closing'),
+(3,4,6247,'Opening'),
+(3,4,6477,'Opening'),
+(3,4,6478,'Opening'),
+(3,4,6603,'Attack'),
+(3,4,7266,'Duel'),
+(3,4,7267,'Grovel'),
+(3,4,7355,'Stuck'),
+(3,4,8386,'Attacking'),
+(3,4,9077,'Leather'),
+(3,4,9078,'Cloth'),
+(3,4,9125,'Generic'),
+(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,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,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'),
+(3,5,2481,'Find Treasure'),
+(3,5,3050,'Detect'),
+(3,5,3365,'Opening'),
+(3,5,5009,'Wands'),
+(3,5,5019,'Shoot'),
+(3,5,6233,'Closing'),
+(3,5,6246,'Closing'),
+(3,5,6247,'Opening'),
+(3,5,6477,'Opening'),
+(3,5,6478,'Opening'),
+(3,5,6603,'Attack'),
+(3,5,7266,'Duel'),
+(3,5,7267,'Grovel'),
+(3,5,7355,'Stuck'),
+(3,5,8386,'Attacking'),
+(3,5,9078,'Cloth'),
+(3,5,9125,'Generic'),
+(3,5,20594,'Stoneform'),
+(3,5,20595,'Gun Specialization'),
+(3,5,20596,'Frost Resistance'),
+(3,5,21651,'Opening'),
+(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'),
+(3,6,200,'Polearms'),
+(3,6,201,'One-Handed Swords'),
+(3,6,202,'Two-Handed Swords'),
+(3,6,203,'Unarmed'),
+(3,6,204,'Defense'),
+(3,6,522,'SPELLDEFENSE (DND)'),
+(3,6,668,'Language Common'),
+(3,6,672,'Language Dwarven'),
+(3,6,674,'Dual Wield'),
+(3,6,750,'Plate Mail'),
+(3,6,1843,'Disarm'),
+(3,6,2382,'Generic'),
+(3,6,2479,'Honorless Target'),
+(3,6,2481,'Find Treasure'),
+(3,6,3050,'Detect'),
+(3,6,3127,'Parry'),
+(3,6,3275,'Linen Bandage'),
+(3,6,3276,'Heavy Linen Bandage'),
+(3,6,3277,'Wool Bandage'),
+(3,6,3278,'Heavy Wool Bandage'),
+(3,6,3365,'Opening'),
+(3,6,6233,'Closing'),
+(3,6,6246,'Closing'),
+(3,6,6247,'Opening'),
+(3,6,6477,'Opening'),
+(3,6,6478,'Opening'),
+(3,6,6603,'Attack'),
+(3,6,7266,'Duel'),
+(3,6,7267,'Grovel'),
+(3,6,7355,'Stuck'),
+(3,6,7928,'Silk Bandage'),
+(3,6,7929,'Heavy Silk Bandage'),
+(3,6,7934,'Anti-Venom'),
+(3,6,8386,'Attacking'),
+(3,6,8737,'Mail'),
+(3,6,9077,'Leather'),
+(3,6,9078,'Cloth'),
+(3,6,9125,'Generic'),
+(3,6,10840,'Mageweave Bandage'),
+(3,6,10841,'Heavy Mageweave Bandage'),
+(3,6,10846,'First Aid'),
+(3,6,18629,'Runecloth Bandage'),
+(3,6,18630,'Heavy Runecloth Bandage'),
+(3,6,20594,'Stoneform'),
+(3,6,20595,'Gun Specialization'),
+(3,6,20596,'Frost Resistance'),
+(3,6,21651,'Opening'),
+(3,6,21652,'Closing'),
+(3,6,22027,'Remove Insignia'),
+(3,6,22810,'Opening - No Text'),
+(3,6,33391,'Journeyman Riding'),
+(3,6,45462,'Plague Strike'),
+(3,6,45477,'Icy Touch'),
+(3,6,45902,'Blood Strike'),
+(3,6,45903,'Offensive State (DND)'),
+(3,6,45927,'Summon Friend'),
+(3,6,47541,'Death Coil'),
+(3,6,48266,'Blood Presence'),
+(3,6,49410,'Forceful Deflection'),
+(3,6,49576,'Death Grip'),
+(3,6,52665,'Sigil'),
+(3,6,59224,'Mace Specialization'),
+(3,6,59879,'Blood Plague'),
+(3,6,59921,'Frost Fever'),
+(3,6,61437,'Opening'),
+(3,6,61455,'Runic Focus'),
+(4,1,78,'Heroic Strike'),
+(4,1,81,'Dodge'),
+(4,1,107,'Block'),
+(4,1,198,'One-Handed Maces'),
+(4,1,201,'One-Handed Swords'),
+(4,1,203,'Unarmed'),
+(4,1,204,'Defense'),
+(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,6233,'Closing'),
+(4,1,6246,'Closing'),
+(4,1,6247,'Opening'),
+(4,1,6477,'Opening'),
+(4,1,6478,'Opening'),
+(4,1,6603,'Attack'),
+(4,1,7266,'Duel'),
+(4,1,7267,'Grovel'),
+(4,1,7355,'Stuck'),
+(4,1,8386,'Attacking'),
+(4,1,8737,'Mail'),
+(4,1,9077,'Leather'),
+(4,1,9078,'Cloth'),
+(4,1,9116,'Shield'),
+(4,1,9125,'Generic'),
+(4,1,20582,'Quickness'),
+(4,1,20583,'Nature Resistance'),
+(4,1,20585,'Wisp Spirit'),
+(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,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'),
+(4,3,3050,'Detect'),
+(4,3,3365,'Opening'),
+(4,3,6233,'Closing'),
+(4,3,6246,'Closing'),
+(4,3,6247,'Opening'),
+(4,3,6477,'Opening'),
+(4,3,6478,'Opening'),
+(4,3,6603,'Attack'),
+(4,3,7266,'Duel'),
+(4,3,7267,'Grovel'),
+(4,3,7355,'Stuck'),
+(4,3,8386,'Attacking'),
+(4,3,9077,'Leather'),
+(4,3,9078,'Cloth'),
+(4,3,9125,'Generic'),
+(4,3,13358,'Defensive State (DND)'),
+(4,3,20582,'Quickness'),
+(4,3,20583,'Nature Resistance'),
+(4,3,20585,'Wisp Spirit'),
+(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,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,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'),
+(4,4,2567,'Thrown'),
+(4,4,2764,'Throw'),
+(4,4,3050,'Detect'),
+(4,4,3365,'Opening'),
+(4,4,6233,'Closing'),
+(4,4,6246,'Closing'),
+(4,4,6247,'Opening'),
+(4,4,6477,'Opening'),
+(4,4,6478,'Opening'),
+(4,4,6603,'Attack'),
+(4,4,7266,'Duel'),
+(4,4,7267,'Grovel'),
+(4,4,7355,'Stuck'),
+(4,4,8386,'Attacking'),
+(4,4,9077,'Leather'),
+(4,4,9078,'Cloth'),
+(4,4,9125,'Generic'),
+(4,4,16092,'Defensive State (DND)'),
+(4,4,20582,'Quickness'),
+(4,4,20583,'Nature Resistance'),
+(4,4,20585,'Wisp Spirit'),
+(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,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'),
+(4,5,3050,'Detect'),
+(4,5,3365,'Opening'),
+(4,5,5009,'Wands'),
+(4,5,5019,'Shoot'),
+(4,5,6233,'Closing'),
+(4,5,6246,'Closing'),
+(4,5,6247,'Opening'),
+(4,5,6477,'Opening'),
+(4,5,6478,'Opening'),
+(4,5,6603,'Attack'),
+(4,5,7266,'Duel'),
+(4,5,7267,'Grovel'),
+(4,5,7355,'Stuck'),
+(4,5,8386,'Attacking'),
+(4,5,9078,'Cloth'),
+(4,5,9125,'Generic'),
+(4,5,20582,'Quickness'),
+(4,5,20583,'Nature Resistance'),
+(4,5,20585,'Wisp Spirit'),
+(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'),
+(4,6,200,'Polearms'),
+(4,6,201,'One-Handed Swords'),
+(4,6,202,'Two-Handed Swords'),
+(4,6,203,'Unarmed'),
+(4,6,204,'Defense'),
+(4,6,522,'SPELLDEFENSE (DND)'),
+(4,6,668,'Language Common'),
+(4,6,671,'Language Darnassian'),
+(4,6,674,'Dual Wield'),
+(4,6,750,'Plate Mail'),
+(4,6,1843,'Disarm'),
+(4,6,2382,'Generic'),
+(4,6,2479,'Honorless Target'),
+(4,6,3050,'Detect'),
+(4,6,3127,'Parry'),
+(4,6,3275,'Linen Bandage'),
+(4,6,3276,'Heavy Linen Bandage'),
+(4,6,3277,'Wool Bandage'),
+(4,6,3278,'Heavy Wool Bandage'),
+(4,6,3365,'Opening'),
+(4,6,6233,'Closing'),
+(4,6,6246,'Closing'),
+(4,6,6247,'Opening'),
+(4,6,6477,'Opening'),
+(4,6,6478,'Opening'),
+(4,6,6603,'Attack'),
+(4,6,7266,'Duel'),
+(4,6,7267,'Grovel'),
+(4,6,7355,'Stuck'),
+(4,6,7928,'Silk Bandage'),
+(4,6,7929,'Heavy Silk Bandage'),
+(4,6,7934,'Anti-Venom'),
+(4,6,8386,'Attacking'),
+(4,6,8737,'Mail'),
+(4,6,9077,'Leather'),
+(4,6,9078,'Cloth'),
+(4,6,9125,'Generic'),
+(4,6,10840,'Mageweave Bandage'),
+(4,6,10841,'Heavy Mageweave Bandage'),
+(4,6,10846,'First Aid'),
+(4,6,18629,'Runecloth Bandage'),
+(4,6,18630,'Heavy Runecloth Bandage'),
+(4,6,20582,'Quickness'),
+(4,6,20583,'Nature Resistance'),
+(4,6,20585,'Wisp Spirit'),
+(4,6,21651,'Opening'),
+(4,6,21652,'Closing'),
+(4,6,22027,'Remove Insignia'),
+(4,6,22810,'Opening - No Text'),
+(4,6,33391,'Journeyman Riding'),
+(4,6,45462,'Plague Strike'),
+(4,6,45477,'Icy Touch'),
+(4,6,45902,'Blood Strike'),
+(4,6,45903,'Offensive State (DND)'),
+(4,6,45927,'Summon Friend'),
+(4,6,47541,'Death Coil'),
+(4,6,48266,'Blood Presence'),
+(4,6,49410,'Forceful Deflection'),
+(4,6,49576,'Death Grip'),
+(4,6,52665,'Sigil'),
+(4,6,58984,'Shadowmeld'),
+(4,6,59879,'Blood Plague'),
+(4,6,59921,'Frost Fever'),
+(4,6,61437,'Opening'),
+(4,6,61455,'Runic Focus'),
+(4,11,81,'Dodge'),
+(4,11,203,'Unarmed'),
+(4,11,204,'Defense'),
+(4,11,227,'Staves'),
+(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'),
+(4,11,3365,'Opening'),
+(4,11,5176,'Wrath'),
+(4,11,5185,'Healing Touch'),
+(4,11,6233,'Closing'),
+(4,11,6246,'Closing'),
+(4,11,6247,'Opening'),
+(4,11,6477,'Opening'),
+(4,11,6478,'Opening'),
+(4,11,6603,'Attack'),
+(4,11,7266,'Duel'),
+(4,11,7267,'Grovel'),
+(4,11,7355,'Stuck'),
+(4,11,8386,'Attacking'),
+(4,11,9077,'Leather'),
+(4,11,9078,'Cloth'),
+(4,11,9125,'Generic'),
+(4,11,20582,'Quickness'),
+(4,11,20583,'Nature Resistance'),
+(4,11,20585,'Wisp Spirit'),
+(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'),
+(5,1,201,'One-Handed Swords'),
+(5,1,202,'Two-Handed Swords'),
+(5,1,203,'Unarmed'),
+(5,1,204,'Defense'),
+(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,6233,'Closing'),
+(5,1,6246,'Closing'),
+(5,1,6247,'Opening'),
+(5,1,6477,'Opening'),
+(5,1,6478,'Opening'),
+(5,1,6603,'Attack'),
+(5,1,7266,'Duel'),
+(5,1,7267,'Grovel'),
+(5,1,7355,'Stuck'),
+(5,1,7744,'Will of the Forsaken'),
+(5,1,8386,'Attacking'),
+(5,1,8737,'Mail'),
+(5,1,9077,'Leather'),
+(5,1,9078,'Cloth'),
+(5,1,9116,'Shield'),
+(5,1,9125,'Generic'),
+(5,1,17737,'Language Gutterspeak'),
+(5,1,20577,'Cannibalize'),
+(5,1,20579,'Shadow Resistance'),
+(5,1,21651,'Opening'),
+(5,1,21652,'Closing'),
+(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,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'),
+(5,4,2567,'Thrown'),
+(5,4,2764,'Throw'),
+(5,4,3050,'Detect'),
+(5,4,3365,'Opening'),
+(5,4,5227,'Underwater Breathing'),
+(5,4,6233,'Closing'),
+(5,4,6246,'Closing'),
+(5,4,6247,'Opening'),
+(5,4,6477,'Opening'),
+(5,4,6478,'Opening'),
+(5,4,6603,'Attack'),
+(5,4,7266,'Duel'),
+(5,4,7267,'Grovel'),
+(5,4,7355,'Stuck'),
+(5,4,7744,'Will of the Forsaken'),
+(5,4,8386,'Attacking'),
+(5,4,9077,'Leather'),
+(5,4,9078,'Cloth'),
+(5,4,9125,'Generic'),
+(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,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,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'),
+(5,5,3050,'Detect'),
+(5,5,3365,'Opening'),
+(5,5,5009,'Wands'),
+(5,5,5019,'Shoot'),
+(5,5,5227,'Underwater Breathing'),
+(5,5,6233,'Closing'),
+(5,5,6246,'Closing'),
+(5,5,6247,'Opening'),
+(5,5,6477,'Opening'),
+(5,5,6478,'Opening'),
+(5,5,6603,'Attack'),
+(5,5,7266,'Duel'),
+(5,5,7267,'Grovel'),
+(5,5,7355,'Stuck'),
+(5,5,7744,'Will of the Forsaken'),
+(5,5,8386,'Attacking'),
+(5,5,9078,'Cloth'),
+(5,5,9125,'Generic'),
+(5,5,17737,'Language Gutterspeak'),
+(5,5,20577,'Cannibalize'),
+(5,5,20579,'Shadow Resistance'),
+(5,5,21651,'Opening'),
+(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'),
+(5,6,200,'Polearms'),
+(5,6,201,'One-Handed Swords'),
+(5,6,202,'Two-Handed Swords'),
+(5,6,203,'Unarmed'),
+(5,6,204,'Defense'),
+(5,6,522,'SPELLDEFENSE (DND)'),
+(5,6,669,'Language Orcish'),
+(5,6,674,'Dual Wield'),
+(5,6,750,'Plate Mail'),
+(5,6,1843,'Disarm'),
+(5,6,2382,'Generic'),
+(5,6,2479,'Honorless Target'),
+(5,6,3050,'Detect'),
+(5,6,3127,'Parry'),
+(5,6,3275,'Linen Bandage'),
+(5,6,3276,'Heavy Linen Bandage'),
+(5,6,3277,'Wool Bandage'),
+(5,6,3278,'Heavy Wool Bandage'),
+(5,6,3365,'Opening'),
+(5,6,5227,'Underwater Breathing'),
+(5,6,6233,'Closing'),
+(5,6,6246,'Closing'),
+(5,6,6247,'Opening'),
+(5,6,6477,'Opening'),
+(5,6,6478,'Opening'),
+(5,6,6603,'Attack'),
+(5,6,7266,'Duel'),
+(5,6,7267,'Grovel'),
+(5,6,7355,'Stuck'),
+(5,6,7744,'Will of the Forsaken'),
+(5,6,7928,'Silk Bandage'),
+(5,6,7929,'Heavy Silk Bandage'),
+(5,6,7934,'Anti-Venom'),
+(5,6,8386,'Attacking'),
+(5,6,8737,'Mail'),
+(5,6,9077,'Leather'),
+(5,6,9078,'Cloth'),
+(5,6,9125,'Generic'),
+(5,6,10840,'Mageweave Bandage'),
+(5,6,10841,'Heavy Mageweave Bandage'),
+(5,6,10846,'First Aid'),
+(5,6,17737,'Language Gutterspeak'),
+(5,6,18629,'Runecloth Bandage'),
+(5,6,18630,'Heavy Runecloth Bandage'),
+(5,6,20577,'Cannibalize'),
+(5,6,20579,'Shadow Resistance'),
+(5,6,21651,'Opening'),
+(5,6,21652,'Closing'),
+(5,6,22027,'Remove Insignia'),
+(5,6,22810,'Opening - No Text'),
+(5,6,33391,'Journeyman Riding'),
+(5,6,45462,'Plague Strike'),
+(5,6,45477,'Icy Touch'),
+(5,6,45902,'Blood Strike'),
+(5,6,45903,'Offensive State (DND)'),
+(5,6,45927,'Summon Friend'),
+(5,6,47541,'Death Coil'),
+(5,6,48266,'Blood Presence'),
+(5,6,49410,'Forceful Deflection'),
+(5,6,49576,'Death Grip'),
+(5,6,52665,'Sigil'),
+(5,6,59879,'Blood Plague'),
+(5,6,59921,'Frost Fever'),
+(5,6,61437,'Opening'),
+(5,6,61455,'Runic Focus'),
+(5,8,81,'Dodge'),
+(5,8,133,'Fireball'),
+(5,8,168,'Frost Armor'),
+(5,8,203,'Unarmed'),
+(5,8,204,'Defense'),
+(5,8,227,'Staves'),
+(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'),
+(5,8,3365,'Opening'),
+(5,8,5009,'Wands'),
+(5,8,5019,'Shoot'),
+(5,8,5227,'Underwater Breathing'),
+(5,8,6233,'Closing'),
+(5,8,6246,'Closing'),
+(5,8,6247,'Opening'),
+(5,8,6477,'Opening'),
+(5,8,6478,'Opening'),
+(5,8,6603,'Attack'),
+(5,8,7266,'Duel'),
+(5,8,7267,'Grovel'),
+(5,8,7355,'Stuck'),
+(5,8,7744,'Will of the Forsaken'),
+(5,8,8386,'Attacking'),
+(5,8,9078,'Cloth'),
+(5,8,9125,'Generic'),
+(5,8,17737,'Language Gutterspeak'),
+(5,8,20577,'Cannibalize'),
+(5,8,20579,'Shadow Resistance'),
+(5,8,21651,'Opening'),
+(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,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'),
+(5,9,3365,'Opening'),
+(5,9,5009,'Wands'),
+(5,9,5019,'Shoot'),
+(5,9,5227,'Underwater Breathing'),
+(5,9,6233,'Closing'),
+(5,9,6246,'Closing'),
+(5,9,6247,'Opening'),
+(5,9,6477,'Opening'),
+(5,9,6478,'Opening'),
+(5,9,6603,'Attack'),
+(5,9,7266,'Duel'),
+(5,9,7267,'Grovel'),
+(5,9,7355,'Stuck'),
+(5,9,7744,'Will of the Forsaken'),
+(5,9,8386,'Attacking'),
+(5,9,9078,'Cloth'),
+(5,9,9125,'Generic'),
+(5,9,17737,'Language Gutterspeak'),
+(5,9,20577,'Cannibalize'),
+(5,9,20579,'Shadow Resistance'),
+(5,9,21651,'Opening'),
+(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'),
+(6,1,196,'One-Handed Axes'),
+(6,1,198,'One-Handed Maces'),
+(6,1,199,'Two-Handed Maces'),
+(6,1,203,'Unarmed'),
+(6,1,204,'Defense'),
+(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,6233,'Closing'),
+(6,1,6246,'Closing'),
+(6,1,6247,'Opening'),
+(6,1,6477,'Opening'),
+(6,1,6478,'Opening'),
+(6,1,6603,'Attack'),
+(6,1,7266,'Duel'),
+(6,1,7267,'Grovel'),
+(6,1,7355,'Stuck'),
+(6,1,8386,'Attacking'),
+(6,1,8737,'Mail'),
+(6,1,9077,'Leather'),
+(6,1,9078,'Cloth'),
+(6,1,9116,'Shield'),
+(6,1,9125,'Generic'),
+(6,1,20549,'War Stomp'),
+(6,1,20550,'Endurance'),
+(6,1,20551,'Nature Resistance'),
+(6,1,20552,'Cultivation'),
+(6,1,21651,'Opening'),
+(6,1,21652,'Closing'),
+(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,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'),
+(6,3,3050,'Detect'),
+(6,3,3365,'Opening'),
+(6,3,6233,'Closing'),
+(6,3,6246,'Closing'),
+(6,3,6247,'Opening'),
+(6,3,6477,'Opening'),
+(6,3,6478,'Opening'),
+(6,3,6603,'Attack'),
+(6,3,7266,'Duel'),
+(6,3,7267,'Grovel'),
+(6,3,7355,'Stuck'),
+(6,3,8386,'Attacking'),
+(6,3,9077,'Leather'),
+(6,3,9078,'Cloth'),
+(6,3,9125,'Generic'),
+(6,3,13358,'Defensive State (DND)'),
+(6,3,20549,'War Stomp'),
+(6,3,20550,'Endurance'),
+(6,3,20551,'Nature Resistance'),
+(6,3,20552,'Cultivation'),
+(6,3,21651,'Opening'),
+(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,45927,'Summon Friend'),
+(6,3,61437,'Opening'),
+(6,6,81,'Dodge'),
+(6,6,196,'One-Handed Axes'),
+(6,6,197,'Two-Handed Axes'),
+(6,6,200,'Polearms'),
+(6,6,201,'One-Handed Swords'),
+(6,6,202,'Two-Handed Swords'),
+(6,6,203,'Unarmed'),
+(6,6,204,'Defense'),
+(6,6,522,'SPELLDEFENSE (DND)'),
+(6,6,669,'Language Orcish'),
+(6,6,670,'Language Taurahe'),
+(6,6,674,'Dual Wield'),
+(6,6,750,'Plate Mail'),
+(6,6,1843,'Disarm'),
+(6,6,2382,'Generic'),
+(6,6,2479,'Honorless Target'),
+(6,6,3050,'Detect'),
+(6,6,3127,'Parry'),
+(6,6,3275,'Linen Bandage'),
+(6,6,3276,'Heavy Linen Bandage'),
+(6,6,3277,'Wool Bandage'),
+(6,6,3278,'Heavy Wool Bandage'),
+(6,6,3365,'Opening'),
+(6,6,6233,'Closing'),
+(6,6,6246,'Closing'),
+(6,6,6247,'Opening'),
+(6,6,6477,'Opening'),
+(6,6,6478,'Opening'),
+(6,6,6603,'Attack'),
+(6,6,7266,'Duel'),
+(6,6,7267,'Grovel'),
+(6,6,7355,'Stuck'),
+(6,6,7928,'Silk Bandage'),
+(6,6,7929,'Heavy Silk Bandage'),
+(6,6,7934,'Anti-Venom'),
+(6,6,8386,'Attacking'),
+(6,6,8737,'Mail'),
+(6,6,9077,'Leather'),
+(6,6,9078,'Cloth'),
+(6,6,9125,'Generic'),
+(6,6,10840,'Mageweave Bandage'),
+(6,6,10841,'Heavy Mageweave Bandage'),
+(6,6,10846,'First Aid'),
+(6,6,18629,'Runecloth Bandage'),
+(6,6,18630,'Heavy Runecloth Bandage'),
+(6,6,20549,'War Stomp'),
+(6,6,20550,'Endurance'),
+(6,6,20551,'Nature Resistance'),
+(6,6,20552,'Cultivation'),
+(6,6,21651,'Opening'),
+(6,6,21652,'Closing'),
+(6,6,22027,'Remove Insignia'),
+(6,6,22810,'Opening - No Text'),
+(6,6,33391,'Journeyman Riding'),
+(6,6,45462,'Plague Strike'),
+(6,6,45477,'Icy Touch'),
+(6,6,45902,'Blood Strike'),
+(6,6,45903,'Offensive State (DND)'),
+(6,6,45927,'Summon Friend'),
+(6,6,47541,'Death Coil'),
+(6,6,48266,'Blood Presence'),
+(6,6,49410,'Forceful Deflection'),
+(6,6,49576,'Death Grip'),
+(6,6,52665,'Sigil'),
+(6,6,59879,'Blood Plague'),
+(6,6,59921,'Frost Fever'),
+(6,6,61437,'Opening'),
+(6,6,61455,'Runic Focus'),
+(6,7,81,'Dodge'),
+(6,7,107,'Block'),
+(6,7,198,'One-Handed Maces'),
+(6,7,203,'Unarmed'),
+(6,7,204,'Defense'),
+(6,7,227,'Staves'),
+(6,7,331,'Healing Wave'),
+(6,7,403,'Lightning Bolt'),
+(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'),
+(6,7,3365,'Opening'),
+(6,7,6233,'Closing'),
+(6,7,6246,'Closing'),
+(6,7,6247,'Opening'),
+(6,7,6477,'Opening'),
+(6,7,6478,'Opening'),
+(6,7,6603,'Attack'),
+(6,7,7266,'Duel'),
+(6,7,7267,'Grovel'),
+(6,7,7355,'Stuck'),
+(6,7,8386,'Attacking'),
+(6,7,9077,'Leather'),
+(6,7,9078,'Cloth'),
+(6,7,9116,'Shield'),
+(6,7,9125,'Generic'),
+(6,7,20549,'War Stomp'),
+(6,7,20550,'Endurance'),
+(6,7,20551,'Nature Resistance'),
+(6,7,20552,'Cultivation'),
+(6,7,21651,'Opening'),
+(6,7,21652,'Closing'),
+(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,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'),
+(6,11,3365,'Opening'),
+(6,11,5176,'Wrath'),
+(6,11,5185,'Healing Touch'),
+(6,11,6233,'Closing'),
+(6,11,6246,'Closing'),
+(6,11,6247,'Opening'),
+(6,11,6477,'Opening'),
+(6,11,6478,'Opening'),
+(6,11,6603,'Attack'),
+(6,11,7266,'Duel'),
+(6,11,7267,'Grovel'),
+(6,11,7355,'Stuck'),
+(6,11,8386,'Attacking'),
+(6,11,9077,'Leather'),
+(6,11,9078,'Cloth'),
+(6,11,9125,'Generic'),
+(6,11,20549,'War Stomp'),
+(6,11,20550,'Endurance'),
+(6,11,20551,'Nature Resistance'),
+(6,11,20552,'Cultivation'),
+(6,11,21651,'Opening'),
+(6,11,21652,'Closing'),
+(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'),
+(7,1,198,'One-Handed Maces'),
+(7,1,201,'One-Handed Swords'),
+(7,1,203,'Unarmed'),
+(7,1,204,'Defense'),
+(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,6233,'Closing'),
+(7,1,6246,'Closing'),
+(7,1,6247,'Opening'),
+(7,1,6477,'Opening'),
+(7,1,6478,'Opening'),
+(7,1,6603,'Attack'),
+(7,1,7266,'Duel'),
+(7,1,7267,'Grovel'),
+(7,1,7340,'Language Gnomish'),
+(7,1,7355,'Stuck'),
+(7,1,8386,'Attacking'),
+(7,1,8737,'Mail'),
+(7,1,9077,'Leather'),
+(7,1,9078,'Cloth'),
+(7,1,9116,'Shield'),
+(7,1,9125,'Generic'),
+(7,1,20589,'Escape Artist'),
+(7,1,20591,'Expansive Mind'),
+(7,1,20592,'Arcane Resistance'),
+(7,1,20593,'Engineering Specialization'),
+(7,1,21651,'Opening'),
+(7,1,21652,'Closing'),
+(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,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'),
+(7,4,2567,'Thrown'),
+(7,4,2764,'Throw'),
+(7,4,3050,'Detect'),
+(7,4,3365,'Opening'),
+(7,4,6233,'Closing'),
+(7,4,6246,'Closing'),
+(7,4,6247,'Opening'),
+(7,4,6477,'Opening'),
+(7,4,6478,'Opening'),
+(7,4,6603,'Attack'),
+(7,4,7266,'Duel'),
+(7,4,7267,'Grovel'),
+(7,4,7340,'Language Gnomish'),
+(7,4,7355,'Stuck'),
+(7,4,8386,'Attacking'),
+(7,4,9077,'Leather'),
+(7,4,9078,'Cloth'),
+(7,4,9125,'Generic'),
+(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,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'),
+(7,6,200,'Polearms'),
+(7,6,201,'One-Handed Swords'),
+(7,6,202,'Two-Handed Swords'),
+(7,6,203,'Unarmed'),
+(7,6,204,'Defense'),
+(7,6,522,'SPELLDEFENSE (DND)'),
+(7,6,668,'Language Common'),
+(7,6,674,'Dual Wield'),
+(7,6,750,'Plate Mail'),
+(7,6,1843,'Disarm'),
+(7,6,2382,'Generic'),
+(7,6,2479,'Honorless Target'),
+(7,6,3050,'Detect'),
+(7,6,3127,'Parry'),
+(7,6,3275,'Linen Bandage'),
+(7,6,3276,'Heavy Linen Bandage'),
+(7,6,3277,'Wool Bandage'),
+(7,6,3278,'Heavy Wool Bandage'),
+(7,6,3365,'Opening'),
+(7,6,6233,'Closing'),
+(7,6,6246,'Closing'),
+(7,6,6247,'Opening'),
+(7,6,6477,'Opening'),
+(7,6,6478,'Opening'),
+(7,6,6603,'Attack'),
+(7,6,7266,'Duel'),
+(7,6,7267,'Grovel'),
+(7,6,7340,'Language Gnomish'),
+(7,6,7355,'Stuck'),
+(7,6,7928,'Silk Bandage'),
+(7,6,7929,'Heavy Silk Bandage'),
+(7,6,7934,'Anti-Venom'),
+(7,6,8386,'Attacking'),
+(7,6,8737,'Mail'),
+(7,6,9077,'Leather'),
+(7,6,9078,'Cloth'),
+(7,6,9125,'Generic'),
+(7,6,10840,'Mageweave Bandage'),
+(7,6,10841,'Heavy Mageweave Bandage'),
+(7,6,10846,'First Aid'),
+(7,6,18629,'Runecloth Bandage'),
+(7,6,18630,'Heavy Runecloth Bandage'),
+(7,6,20589,'Escape Artist'),
+(7,6,20591,'Expansive Mind'),
+(7,6,20592,'Arcane Resistance'),
+(7,6,20593,'Engineering Specialization'),
+(7,6,21651,'Opening'),
+(7,6,21652,'Closing'),
+(7,6,22027,'Remove Insignia'),
+(7,6,22810,'Opening - No Text'),
+(7,6,33391,'Journeyman Riding'),
+(7,6,45462,'Plague Strike'),
+(7,6,45477,'Icy Touch'),
+(7,6,45902,'Blood Strike'),
+(7,6,45903,'Offensive State (DND)'),
+(7,6,45927,'Summon Friend'),
+(7,6,47541,'Death Coil'),
+(7,6,48266,'Blood Presence'),
+(7,6,49410,'Forceful Deflection'),
+(7,6,49576,'Death Grip'),
+(7,6,52665,'Sigil'),
+(7,6,59879,'Blood Plague'),
+(7,6,59921,'Frost Fever'),
+(7,6,61437,'Opening'),
+(7,6,61455,'Runic Focus'),
+(7,8,81,'Dodge'),
+(7,8,133,'Fireball'),
+(7,8,168,'Frost Armor'),
+(7,8,203,'Unarmed'),
+(7,8,204,'Defense'),
+(7,8,227,'Staves'),
+(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'),
+(7,8,3365,'Opening'),
+(7,8,5009,'Wands'),
+(7,8,5019,'Shoot'),
+(7,8,6233,'Closing'),
+(7,8,6246,'Closing'),
+(7,8,6247,'Opening'),
+(7,8,6477,'Opening'),
+(7,8,6478,'Opening'),
+(7,8,6603,'Attack'),
+(7,8,7266,'Duel'),
+(7,8,7267,'Grovel'),
+(7,8,7340,'Language Gnomish'),
+(7,8,7355,'Stuck'),
+(7,8,8386,'Attacking'),
+(7,8,9078,'Cloth'),
+(7,8,9125,'Generic'),
+(7,8,20589,'Escape Artist'),
+(7,8,20591,'Expansive Mind'),
+(7,8,20592,'Arcane Resistance'),
+(7,8,20593,'Engineering Specialization'),
+(7,8,21651,'Opening'),
+(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,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'),
+(7,9,3365,'Opening'),
+(7,9,5009,'Wands'),
+(7,9,5019,'Shoot'),
+(7,9,6233,'Closing'),
+(7,9,6246,'Closing'),
+(7,9,6247,'Opening'),
+(7,9,6477,'Opening'),
+(7,9,6478,'Opening'),
+(7,9,6603,'Attack'),
+(7,9,7266,'Duel'),
+(7,9,7267,'Grovel'),
+(7,9,7340,'Language Gnomish'),
+(7,9,7355,'Stuck'),
+(7,9,8386,'Attacking'),
+(7,9,9078,'Cloth'),
+(7,9,9125,'Generic'),
+(7,9,20589,'Escape Artist'),
+(7,9,20591,'Expansive Mind'),
+(7,9,20592,'Arcane Resistance'),
+(7,9,20593,'Engineering Specialization'),
+(7,9,21651,'Opening'),
+(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,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'),
+(8,1,2567,'Thrown'),
+(8,1,2764,'Throw'),
+(8,1,3050,'Detect'),
+(8,1,3365,'Opening'),
+(8,1,5301,'Defensive State (DND)'),
+(8,1,6233,'Closing'),
+(8,1,6246,'Closing'),
+(8,1,6247,'Opening'),
+(8,1,6477,'Opening'),
+(8,1,6478,'Opening'),
+(8,1,6603,'Attack'),
+(8,1,7266,'Duel'),
+(8,1,7267,'Grovel'),
+(8,1,7341,'Language Troll'),
+(8,1,7355,'Stuck'),
+(8,1,8386,'Attacking'),
+(8,1,8737,'Mail'),
+(8,1,9077,'Leather'),
+(8,1,9078,'Cloth'),
+(8,1,9116,'Shield'),
+(8,1,9125,'Generic'),
+(8,1,20555,'Regeneration'),
+(8,1,20557,'Beast Slaying'),
+(8,1,20558,'Throwing Specialization'),
+(8,1,21651,'Opening'),
+(8,1,21652,'Closing'),
+(8,1,22027,'Remove Insignia'),
+(8,1,22810,'Opening - No Text'),
+(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,669,'Language Orcish'),
+(8,3,1843,'Disarm'),
+(8,3,2382,'Generic'),
+(8,3,2479,'Honorless Target'),
+(8,3,2973,'Raptor Strike'),
+(8,3,3050,'Detect'),
+(8,3,3365,'Opening'),
+(8,3,6233,'Closing'),
+(8,3,6246,'Closing'),
+(8,3,6247,'Opening'),
+(8,3,6477,'Opening'),
+(8,3,6478,'Opening'),
+(8,3,6603,'Attack'),
+(8,3,7266,'Duel'),
+(8,3,7267,'Grovel'),
+(8,3,7341,'Language Troll'),
+(8,3,7355,'Stuck'),
+(8,3,8386,'Attacking'),
+(8,3,9077,'Leather'),
+(8,3,9078,'Cloth'),
+(8,3,9125,'Generic'),
+(8,3,13358,'Defensive State (DND)'),
+(8,3,20554,'Berserking'),
+(8,3,20555,'Regeneration'),
+(8,3,20557,'Beast Slaying'),
+(8,3,20558,'Throwing Specialization'),
+(8,3,21651,'Opening'),
+(8,3,21652,'Closing'),
+(8,3,22027,'Remove Insignia'),
+(8,3,22810,'Opening - No Text'),
+(8,3,24949,'Defensive State 2 (DND)'),
+(8,3,26290,'Bow Specialization'),
+(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,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'),
+(8,4,2567,'Thrown'),
+(8,4,2764,'Throw'),
+(8,4,3050,'Detect'),
+(8,4,3365,'Opening'),
+(8,4,6233,'Closing'),
+(8,4,6246,'Closing'),
+(8,4,6247,'Opening'),
+(8,4,6477,'Opening'),
+(8,4,6478,'Opening'),
+(8,4,6603,'Attack'),
+(8,4,7266,'Duel'),
+(8,4,7267,'Grovel'),
+(8,4,7341,'Language Troll'),
+(8,4,7355,'Stuck'),
+(8,4,8386,'Attacking'),
+(8,4,9077,'Leather'),
+(8,4,9078,'Cloth'),
+(8,4,9125,'Generic'),
+(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,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,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'),
+(8,5,3050,'Detect'),
+(8,5,3365,'Opening'),
+(8,5,5009,'Wands'),
+(8,5,5019,'Shoot'),
+(8,5,6233,'Closing'),
+(8,5,6246,'Closing'),
+(8,5,6247,'Opening'),
+(8,5,6477,'Opening'),
+(8,5,6478,'Opening'),
+(8,5,6603,'Attack'),
+(8,5,7266,'Duel'),
+(8,5,7267,'Grovel'),
+(8,5,7341,'Language Troll'),
+(8,5,7355,'Stuck'),
+(8,5,8386,'Attacking'),
+(8,5,9078,'Cloth'),
+(8,5,9125,'Generic'),
+(8,5,20554,'Berserking'),
+(8,5,20555,'Regeneration'),
+(8,5,20557,'Beast Slaying'),
+(8,5,20558,'Throwing Specialization'),
+(8,5,21651,'Opening'),
+(8,5,21652,'Closing'),
+(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'),
+(8,6,200,'Polearms'),
+(8,6,201,'One-Handed Swords'),
+(8,6,202,'Two-Handed Swords'),
+(8,6,203,'Unarmed'),
+(8,6,204,'Defense'),
+(8,6,522,'SPELLDEFENSE (DND)'),
+(8,6,669,'Language Orcish'),
+(8,6,674,'Dual Wield'),
+(8,6,750,'Plate Mail'),
+(8,6,1843,'Disarm'),
+(8,6,2382,'Generic'),
+(8,6,2479,'Honorless Target'),
+(8,6,3050,'Detect'),
+(8,6,3127,'Parry'),
+(8,6,3275,'Linen Bandage'),
+(8,6,3276,'Heavy Linen Bandage'),
+(8,6,3277,'Wool Bandage'),
+(8,6,3278,'Heavy Wool Bandage'),
+(8,6,3365,'Opening'),
+(8,6,6233,'Closing'),
+(8,6,6246,'Closing'),
+(8,6,6247,'Opening'),
+(8,6,6477,'Opening'),
+(8,6,6478,'Opening'),
+(8,6,6603,'Attack'),
+(8,6,7266,'Duel'),
+(8,6,7267,'Grovel'),
+(8,6,7341,'Language Troll'),
+(8,6,7355,'Stuck'),
+(8,6,7928,'Silk Bandage'),
+(8,6,7929,'Heavy Silk Bandage'),
+(8,6,7934,'Anti-Venom'),
+(8,6,8386,'Attacking'),
+(8,6,8737,'Mail'),
+(8,6,9077,'Leather'),
+(8,6,9078,'Cloth'),
+(8,6,9125,'Generic'),
+(8,6,10840,'Mageweave Bandage'),
+(8,6,10841,'Heavy Mageweave Bandage'),
+(8,6,10846,'First Aid'),
+(8,6,18629,'Runecloth Bandage'),
+(8,6,18630,'Heavy Runecloth Bandage'),
+(8,6,20555,'Regeneration'),
+(8,6,20557,'Beast Slaying'),
+(8,6,20558,'Throwing Specialization'),
+(8,6,21651,'Opening'),
+(8,6,21652,'Closing'),
+(8,6,22027,'Remove Insignia'),
+(8,6,22810,'Opening - No Text'),
+(8,6,26290,'Bow Specialization'),
+(8,6,33391,'Journeyman Riding'),
+(8,6,45462,'Plague Strike'),
+(8,6,45477,'Icy Touch'),
+(8,6,45902,'Blood Strike'),
+(8,6,45903,'Offensive State (DND)'),
+(8,6,45927,'Summon Friend'),
+(8,6,47541,'Death Coil'),
+(8,6,48266,'Blood Presence'),
+(8,6,49410,'Forceful Deflection'),
+(8,6,49576,'Death Grip'),
+(8,6,50621,'Berserking'),
+(8,6,52665,'Sigil'),
+(8,6,58943,'Da Voodoo Shuffle'),
+(8,6,59879,'Blood Plague'),
+(8,6,59921,'Frost Fever'),
+(8,6,61437,'Opening'),
+(8,6,61455,'Runic Focus'),
+(8,7,81,'Dodge'),
+(8,7,107,'Block'),
+(8,7,198,'One-Handed Maces'),
+(8,7,203,'Unarmed'),
+(8,7,204,'Defense'),
+(8,7,227,'Staves'),
+(8,7,331,'Healing Wave'),
+(8,7,403,'Lightning Bolt'),
+(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'),
+(8,7,3365,'Opening'),
+(8,7,6233,'Closing'),
+(8,7,6246,'Closing'),
+(8,7,6247,'Opening'),
+(8,7,6477,'Opening'),
+(8,7,6478,'Opening'),
+(8,7,6603,'Attack'),
+(8,7,7266,'Duel'),
+(8,7,7267,'Grovel'),
+(8,7,7341,'Language Troll'),
+(8,7,7355,'Stuck'),
+(8,7,8386,'Attacking'),
+(8,7,9077,'Leather'),
+(8,7,9078,'Cloth'),
+(8,7,9116,'Shield'),
+(8,7,9125,'Generic'),
+(8,7,20554,'Berserking'),
+(8,7,20555,'Regeneration'),
+(8,7,20557,'Beast Slaying'),
+(8,7,20558,'Throwing Specialization'),
+(8,7,21651,'Opening'),
+(8,7,21652,'Closing'),
+(8,7,22027,'Remove Insignia'),
+(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,669,'Language Orcish'),
+(8,8,1843,'Disarm'),
+(8,8,2382,'Generic'),
+(8,8,2479,'Honorless Target'),
+(8,8,3050,'Detect'),
+(8,8,3365,'Opening'),
+(8,8,5009,'Wands'),
+(8,8,5019,'Shoot'),
+(8,8,6233,'Closing'),
+(8,8,6246,'Closing'),
+(8,8,6247,'Opening'),
+(8,8,6477,'Opening'),
+(8,8,6478,'Opening'),
+(8,8,6603,'Attack'),
+(8,8,7266,'Duel'),
+(8,8,7267,'Grovel'),
+(8,8,7341,'Language Troll'),
+(8,8,7355,'Stuck'),
+(8,8,8386,'Attacking'),
+(8,8,9078,'Cloth'),
+(8,8,9125,'Generic'),
+(8,8,20554,'Berserking'),
+(8,8,20555,'Regeneration'),
+(8,8,20557,'Beast Slaying'),
+(8,8,20558,'Throwing Specialization'),
+(8,8,21651,'Opening'),
+(8,8,21652,'Closing'),
+(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,635,'Holy Light'),
+(10,2,669,'Language Orcish'),
+(10,2,813,'Language Thalassian'),
+(10,2,822,'Magic Resistance'),
+(10,2,2382,'Generic'),
+(10,2,2479,'Honorless Target'),
+(10,2,3050,'Detect'),
+(10,2,3365,'Opening'),
+(10,2,6233,'Closing'),
+(10,2,6246,'Closing'),
+(10,2,6247,'Opening'),
+(10,2,6477,'Opening'),
+(10,2,6478,'Opening'),
+(10,2,6603,'Attack'),
+(10,2,7266,'Duel'),
+(10,2,7267,'Grovel'),
+(10,2,7355,'Stuck'),
+(10,2,8386,'Attacking'),
+(10,2,8737,'Mail'),
+(10,2,9077,'Leather'),
+(10,2,9078,'Cloth'),
+(10,2,9116,'Shield'),
+(10,2,9125,'Generic'),
+(10,2,21084,'Seal of Righteousness'),
+(10,2,21651,'Opening'),
+(10,2,21652,'Closing'),
+(10,2,22027,'Remove Insignia'),
+(10,2,22810,'Opening - No Text'),
+(10,2,27762,'Libram'),
+(10,2,28730,'Arcane Torrent'),
+(10,2,28734,'Mana Tap'),
+(10,2,28877,'Arcane Affinity'),
+(10,3,75,'Auto Shot'),
+(10,3,81,'Dodge'),
+(10,3,203,'Unarmed'),
+(10,3,204,'Defense'),
+(10,3,264,'Bows'),
+(10,3,522,'SPELLDEFENSE (DND)'),
+(10,3,669,'Language Orcish'),
+(10,3,813,'Language Thalassian'),
+(10,3,822,'Magic Resistance'),
+(10,3,1180,'Daggers'),
+(10,3,2382,'Generic'),
+(10,3,2479,'Honorless Target'),
+(10,3,2973,'Raptor Strike'),
+(10,3,3050,'Detect'),
+(10,3,3365,'Opening'),
+(10,3,6233,'Closing'),
+(10,3,6246,'Closing'),
+(10,3,6247,'Opening'),
+(10,3,6477,'Opening'),
+(10,3,6478,'Opening'),
+(10,3,6603,'Attack'),
+(10,3,7266,'Duel'),
+(10,3,7267,'Grovel'),
+(10,3,7355,'Stuck'),
+(10,3,8386,'Attacking'),
+(10,3,9077,'Leather'),
+(10,3,9078,'Cloth'),
+(10,3,9125,'Generic'),
+(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,28730,'Arcane Torrent'),
+(10,3,28734,'Mana Tap'),
+(10,3,28877,'Arcane Affinity'),
+(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,669,'Language Orcish'),
+(10,4,813,'Language Thalassian'),
+(10,4,822,'Magic Resistance'),
+(10,4,1180,'Daggers'),
+(10,4,1752,'Sinister Strike'),
+(10,4,2098,'Eviscerate'),
+(10,4,2382,'Generic'),
+(10,4,2479,'Honorless Target'),
+(10,4,2567,'Thrown'),
+(10,4,2764,'Throw'),
+(10,4,3050,'Detect'),
+(10,4,3365,'Opening'),
+(10,4,6233,'Closing'),
+(10,4,6246,'Closing'),
+(10,4,6247,'Opening'),
+(10,4,6477,'Opening'),
+(10,4,6478,'Opening'),
+(10,4,6603,'Attack'),
+(10,4,7266,'Duel'),
+(10,4,7267,'Grovel'),
+(10,4,7355,'Stuck'),
+(10,4,8386,'Attacking'),
+(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,21651,'Opening'),
+(10,4,21652,'Closing'),
+(10,4,22027,'Remove Insignia'),
+(10,4,22810,'Opening - No Text'),
+(10,4,25046,'Arcane Torrent'),
+(10,4,28734,'Mana Tap'),
+(10,4,28877,'Arcane Affinity'),
+(10,5,81,'Dodge'),
+(10,5,198,'One-Handed Maces'),
+(10,5,203,'Unarmed'),
+(10,5,204,'Defense'),
+(10,5,522,'SPELLDEFENSE (DND)'),
+(10,5,585,'Smite'),
+(10,5,669,'Language Orcish'),
+(10,5,813,'Language Thalassian'),
+(10,5,822,'Magic Resistance'),
+(10,5,2050,'Lesser Heal'),
+(10,5,2382,'Generic'),
+(10,5,2479,'Honorless Target'),
+(10,5,3050,'Detect'),
+(10,5,3365,'Opening'),
+(10,5,5009,'Wands'),
+(10,5,5019,'Shoot'),
+(10,5,6233,'Closing'),
+(10,5,6246,'Closing'),
+(10,5,6247,'Opening'),
+(10,5,6477,'Opening'),
+(10,5,6478,'Opening'),
+(10,5,6603,'Attack'),
+(10,5,7266,'Duel'),
+(10,5,7267,'Grovel'),
+(10,5,7355,'Stuck'),
+(10,5,8386,'Attacking'),
+(10,5,9078,'Cloth'),
+(10,5,9125,'Generic'),
+(10,5,21651,'Opening'),
+(10,5,21652,'Closing'),
+(10,5,22027,'Remove Insignia'),
+(10,5,22810,'Opening - No Text'),
+(10,5,28730,'Arcane Torrent'),
+(10,5,28734,'Mana Tap'),
+(10,5,28877,'Arcane Affinity'),
+(10,6,81,'Dodge'),
+(10,6,196,'One-Handed Axes'),
+(10,6,197,'Two-Handed Axes'),
+(10,6,200,'Polearms'),
+(10,6,201,'One-Handed Swords'),
+(10,6,202,'Two-Handed Swords'),
+(10,6,203,'Unarmed'),
+(10,6,204,'Defense'),
+(10,6,522,'SPELLDEFENSE (DND)'),
+(10,6,669,'Language Orcish'),
+(10,6,674,'Dual Wield'),
+(10,6,750,'Plate Mail'),
+(10,6,813,'Language Thalassian'),
+(10,6,822,'Magic Resistance'),
+(10,6,1843,'Disarm'),
+(10,6,2382,'Generic'),
+(10,6,2479,'Honorless Target'),
+(10,6,3050,'Detect'),
+(10,6,3127,'Parry'),
+(10,6,3275,'Linen Bandage'),
+(10,6,3276,'Heavy Linen Bandage'),
+(10,6,3277,'Wool Bandage'),
+(10,6,3278,'Heavy Wool Bandage'),
+(10,6,3365,'Opening'),
+(10,6,6233,'Closing'),
+(10,6,6246,'Closing'),
+(10,6,6247,'Opening'),
+(10,6,6477,'Opening'),
+(10,6,6478,'Opening'),
+(10,6,6603,'Attack'),
+(10,6,7266,'Duel'),
+(10,6,7267,'Grovel'),
+(10,6,7355,'Stuck'),
+(10,6,7928,'Silk Bandage'),
+(10,6,7929,'Heavy Silk Bandage'),
+(10,6,7934,'Anti-Venom'),
+(10,6,8386,'Attacking'),
+(10,6,8737,'Mail'),
+(10,6,9077,'Leather'),
+(10,6,9078,'Cloth'),
+(10,6,9125,'Generic'),
+(10,6,10840,'Mageweave Bandage'),
+(10,6,10841,'Heavy Mageweave Bandage'),
+(10,6,10846,'First Aid'),
+(10,6,18629,'Runecloth Bandage'),
+(10,6,18630,'Heavy Runecloth Bandage'),
+(10,6,21651,'Opening'),
+(10,6,21652,'Closing'),
+(10,6,22027,'Remove Insignia'),
+(10,6,22810,'Opening - No Text'),
+(10,6,28877,'Arcane Affinity'),
+(10,6,33391,'Journeyman Riding'),
+(10,6,45462,'Plague Strike'),
+(10,6,45477,'Icy Touch'),
+(10,6,45902,'Blood Strike'),
+(10,6,45903,'Offensive State (DND)'),
+(10,6,45927,'Summon Friend'),
+(10,6,47541,'Death Coil'),
+(10,6,48266,'Blood Presence'),
+(10,6,49410,'Forceful Deflection'),
+(10,6,49576,'Death Grip'),
+(10,6,50613,'Arcane Torrent'),
+(10,6,52665,'Sigil'),
+(10,6,59879,'Blood Plague'),
+(10,6,59921,'Frost Fever'),
+(10,6,61437,'Opening'),
+(10,6,61455,'Runic Focus'),
+(10,8,81,'Dodge'),
+(10,8,133,'Fireball'),
+(10,8,168,'Frost Armor'),
+(10,8,203,'Unarmed'),
+(10,8,204,'Defense'),
+(10,8,227,'Staves'),
+(10,8,522,'SPELLDEFENSE (DND)'),
+(10,8,669,'Language Orcish'),
+(10,8,813,'Language Thalassian'),
+(10,8,822,'Magic Resistance'),
+(10,8,2382,'Generic'),
+(10,8,2479,'Honorless Target'),
+(10,8,3050,'Detect'),
+(10,8,3365,'Opening'),
+(10,8,5009,'Wands'),
+(10,8,5019,'Shoot'),
+(10,8,6233,'Closing'),
+(10,8,6246,'Closing'),
+(10,8,6247,'Opening'),
+(10,8,6477,'Opening'),
+(10,8,6478,'Opening'),
+(10,8,6603,'Attack'),
+(10,8,7266,'Duel'),
+(10,8,7267,'Grovel'),
+(10,8,7355,'Stuck'),
+(10,8,8386,'Attacking'),
+(10,8,9078,'Cloth'),
+(10,8,9125,'Generic'),
+(10,8,21651,'Opening'),
+(10,8,21652,'Closing'),
+(10,8,22027,'Remove Insignia'),
+(10,8,22810,'Opening - No Text'),
+(10,8,28730,'Arcane Torrent'),
+(10,8,28734,'Mana Tap'),
+(10,8,28877,'Arcane Affinity'),
+(10,9,81,'Dodge'),
+(10,9,203,'Unarmed'),
+(10,9,204,'Defense'),
+(10,9,522,'SPELLDEFENSE (DND)'),
+(10,9,669,'Language Orcish'),
+(10,9,686,'Shadow Bolt'),
+(10,9,687,'Demon Skin'),
+(10,9,813,'Language Thalassian'),
+(10,9,822,'Magic Resistance'),
+(10,9,1180,'Daggers'),
+(10,9,2382,'Generic'),
+(10,9,2479,'Honorless Target'),
+(10,9,3050,'Detect'),
+(10,9,3365,'Opening'),
+(10,9,5009,'Wands'),
+(10,9,5019,'Shoot'),
+(10,9,6233,'Closing'),
+(10,9,6246,'Closing'),
+(10,9,6247,'Opening'),
+(10,9,6477,'Opening'),
+(10,9,6478,'Opening'),
+(10,9,6603,'Attack'),
+(10,9,7266,'Duel'),
+(10,9,7267,'Grovel'),
+(10,9,7355,'Stuck'),
+(10,9,8386,'Attacking'),
+(10,9,9078,'Cloth'),
+(10,9,9125,'Generic'),
+(10,9,21651,'Opening'),
+(10,9,21652,'Closing'),
+(10,9,22027,'Remove Insignia'),
+(10,9,22810,'Opening - No Text'),
+(10,9,28730,'Arcane Torrent'),
+(10,9,28734,'Mana Tap'),
+(10,9,28877,'Arcane Affinity'),
+(11,1,78,'Heroic Strike'),
+(11,1,81,'Dodge'),
+(11,1,107,'Block'),
+(11,1,198,'One-Handed Maces'),
+(11,1,201,'One-Handed Swords'),
+(11,1,202,'Two-Handed Swords'),
+(11,1,203,'Unarmed'),
+(11,1,204,'Defense'),
+(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,6233,'Closing'),
+(11,1,6246,'Closing'),
+(11,1,6247,'Opening'),
+(11,1,6477,'Opening'),
+(11,1,6478,'Opening'),
+(11,1,6562,'Heroic Presence'),
+(11,1,6603,'Attack'),
+(11,1,7266,'Duel'),
+(11,1,7267,'Grovel'),
+(11,1,7355,'Stuck'),
+(11,1,8386,'Attacking'),
+(11,1,8737,'Mail'),
+(11,1,9077,'Leather'),
+(11,1,9078,'Cloth'),
+(11,1,9116,'Shield'),
+(11,1,9125,'Generic'),
+(11,1,21651,'Opening'),
+(11,1,21652,'Closing'),
+(11,1,22027,'Remove Insignia'),
+(11,1,22810,'Opening - No Text'),
+(11,1,28875,'Gemcutting'),
+(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,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'),
+(11,2,3365,'Opening'),
+(11,2,6233,'Closing'),
+(11,2,6246,'Closing'),
+(11,2,6247,'Opening'),
+(11,2,6477,'Opening'),
+(11,2,6478,'Opening'),
+(11,2,6562,'Heroic Presence'),
+(11,2,6603,'Attack'),
+(11,2,7266,'Duel'),
+(11,2,7267,'Grovel'),
+(11,2,7355,'Stuck'),
+(11,2,8386,'Attacking'),
+(11,2,8737,'Mail'),
+(11,2,9077,'Leather'),
+(11,2,9078,'Cloth'),
+(11,2,9116,'Shield'),
+(11,2,9125,'Generic'),
+(11,2,21084,'Seal of Righteousness'),
+(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,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,668,'Language Common'),
+(11,3,1843,'Disarm'),
+(11,3,2382,'Generic'),
+(11,3,2479,'Honorless Target'),
+(11,3,2973,'Raptor Strike'),
+(11,3,3050,'Detect'),
+(11,3,3365,'Opening'),
+(11,3,5011,'Crossbows'),
+(11,3,6233,'Closing'),
+(11,3,6246,'Closing'),
+(11,3,6247,'Opening'),
+(11,3,6477,'Opening'),
+(11,3,6478,'Opening'),
+(11,3,6562,'Heroic Presence'),
+(11,3,6603,'Attack'),
+(11,3,7266,'Duel'),
+(11,3,7267,'Grovel'),
+(11,3,7355,'Stuck'),
+(11,3,8386,'Attacking'),
+(11,3,9077,'Leather'),
+(11,3,9078,'Cloth'),
+(11,3,9125,'Generic'),
+(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,28875,'Gemcutting'),
+(11,3,29932,'Language Draenei'),
+(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,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'),
+(11,5,3050,'Detect'),
+(11,5,3365,'Opening'),
+(11,5,5009,'Wands'),
+(11,5,5019,'Shoot'),
+(11,5,6233,'Closing'),
+(11,5,6246,'Closing'),
+(11,5,6247,'Opening'),
+(11,5,6477,'Opening'),
+(11,5,6478,'Opening'),
+(11,5,6603,'Attack'),
+(11,5,7266,'Duel'),
+(11,5,7267,'Grovel'),
+(11,5,7355,'Stuck'),
+(11,5,8386,'Attacking'),
+(11,5,9078,'Cloth'),
+(11,5,9125,'Generic'),
+(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,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'),
+(11,6,200,'Polearms'),
+(11,6,201,'One-Handed Swords'),
+(11,6,202,'Two-Handed Swords'),
+(11,6,203,'Unarmed'),
+(11,6,204,'Defense'),
+(11,6,522,'SPELLDEFENSE (DND)'),
+(11,6,668,'Language Common'),
+(11,6,674,'Dual Wield'),
+(11,6,750,'Plate Mail'),
+(11,6,1843,'Disarm'),
+(11,6,2382,'Generic'),
+(11,6,2479,'Honorless Target'),
+(11,6,3050,'Detect'),
+(11,6,3127,'Parry'),
+(11,6,3275,'Linen Bandage'),
+(11,6,3276,'Heavy Linen Bandage'),
+(11,6,3277,'Wool Bandage'),
+(11,6,3278,'Heavy Wool Bandage'),
+(11,6,3365,'Opening'),
+(11,6,6233,'Closing'),
+(11,6,6246,'Closing'),
+(11,6,6247,'Opening'),
+(11,6,6477,'Opening'),
+(11,6,6478,'Opening'),
+(11,6,6562,'Heroic Presence'),
+(11,6,6603,'Attack'),
+(11,6,7266,'Duel'),
+(11,6,7267,'Grovel'),
+(11,6,7355,'Stuck'),
+(11,6,7928,'Silk Bandage'),
+(11,6,7929,'Heavy Silk Bandage'),
+(11,6,7934,'Anti-Venom'),
+(11,6,8386,'Attacking'),
+(11,6,8737,'Mail'),
+(11,6,9077,'Leather'),
+(11,6,9078,'Cloth'),
+(11,6,9125,'Generic'),
+(11,6,10840,'Mageweave Bandage'),
+(11,6,10841,'Heavy Mageweave Bandage'),
+(11,6,10846,'First Aid'),
+(11,6,18629,'Runecloth Bandage'),
+(11,6,18630,'Heavy Runecloth Bandage'),
+(11,6,21651,'Opening'),
+(11,6,21652,'Closing'),
+(11,6,22027,'Remove Insignia'),
+(11,6,22810,'Opening - No Text'),
+(11,6,28875,'Gemcutting'),
+(11,6,29932,'Language Draenei'),
+(11,6,33391,'Journeyman Riding'),
+(11,6,45462,'Plague Strike'),
+(11,6,45477,'Icy Touch'),
+(11,6,45902,'Blood Strike'),
+(11,6,45903,'Offensive State (DND)'),
+(11,6,45927,'Summon Friend'),
+(11,6,47541,'Death Coil'),
+(11,6,48266,'Blood Presence'),
+(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'),
+(11,6,59921,'Frost Fever'),
+(11,6,61437,'Opening'),
+(11,6,61455,'Runic Focus'),
+(11,7,81,'Dodge'),
+(11,7,107,'Block'),
+(11,7,198,'One-Handed Maces'),
+(11,7,203,'Unarmed'),
+(11,7,204,'Defense'),
+(11,7,227,'Staves'),
+(11,7,331,'Healing Wave'),
+(11,7,403,'Lightning Bolt'),
+(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'),
+(11,7,3365,'Opening'),
+(11,7,6233,'Closing'),
+(11,7,6246,'Closing'),
+(11,7,6247,'Opening'),
+(11,7,6477,'Opening'),
+(11,7,6478,'Opening'),
+(11,7,6603,'Attack'),
+(11,7,7266,'Duel'),
+(11,7,7267,'Grovel'),
+(11,7,7355,'Stuck'),
+(11,7,8386,'Attacking'),
+(11,7,9077,'Leather'),
+(11,7,9078,'Cloth'),
+(11,7,9116,'Shield'),
+(11,7,9125,'Generic'),
+(11,7,21651,'Opening'),
+(11,7,21652,'Closing'),
+(11,7,22027,'Remove Insignia'),
+(11,7,22810,'Opening - No Text'),
+(11,7,27763,'Totem'),
+(11,7,28875,'Gemcutting'),
+(11,7,28878,'Inspiring Presence'),
+(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,668,'Language Common'),
+(11,8,1843,'Disarm'),
+(11,8,2382,'Generic'),
+(11,8,2479,'Honorless Target'),
+(11,8,3050,'Detect'),
+(11,8,3365,'Opening'),
+(11,8,5009,'Wands'),
+(11,8,5019,'Shoot'),
+(11,8,6233,'Closing'),
+(11,8,6246,'Closing'),
+(11,8,6247,'Opening'),
+(11,8,6477,'Opening'),
+(11,8,6478,'Opening'),
+(11,8,6603,'Attack'),
+(11,8,7266,'Duel'),
+(11,8,7267,'Grovel'),
+(11,8,7355,'Stuck'),
+(11,8,8386,'Attacking'),
+(11,8,9078,'Cloth'),
+(11,8,9125,'Generic'),
+(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,61437,'Opening');
diff --git a/sql/updates/7075_01_characters_character_spell.sql b/sql/updates/7075_01_characters_character_spell.sql
new file mode 100644
index 00000000000..4e6ef7ea93b
--- /dev/null
+++ b/sql/updates/7075_01_characters_character_spell.sql
@@ -0,0 +1,13 @@
+ALTER TABLE character_db_version CHANGE COLUMN required_7067_03_characters_character_spell required_7075_01_characters_character_spell bit;
+
+DELETE FROM character_spell WHERE `spell` IN (
+ 20580, /*old Shadowmeld*/
+ 20600, /*Perception*/
+ 21009, /*old Shadowmeld Passive and new Elusiveness (learned as racial passive)*/
+ 21184 /*old Seal of Righteousness*/
+);
+
+
+/*old Shadow Resistance, leaned as racial passive of race 5 */
+DELETE FROM character_spell USING character_spell INNER JOIN characters ON character_spell.guid = characters.guid
+WHERE character_spell.spell = 20579 AND characters.race <> 5;
diff --git a/sql/updates/7075_02_mangos_spell_learn_spell.sql b/sql/updates/7075_02_mangos_spell_learn_spell.sql
new file mode 100644
index 00000000000..4aec0314a27
--- /dev/null
+++ b/sql/updates/7075_02_mangos_spell_learn_spell.sql
@@ -0,0 +1,6 @@
+ALTER TABLE db_version CHANGE COLUMN required_7074_01_mangos_playercreateinfo_spell required_7075_02_mangos_spell_learn_spell bit;
+
+DELETE FROM spell_learn_spell WHERE Entry = 58984;
+
+INSERT INTO spell_learn_spell VALUES
+(58984,21009,1);
diff --git a/src/game/SharedDefines.h b/src/game/SharedDefines.h
index 0cf98fe33f9..34276c4810e 100644
--- a/src/game/SharedDefines.h
+++ b/src/game/SharedDefines.h
@@ -694,7 +694,7 @@ enum AuraState
AURA_STATE_DEFENSE = 1, // C |
AURA_STATE_HEALTHLESS_20_PERCENT = 2, // CcT |
AURA_STATE_BERSERKING = 3, // C T |
- //AURA_STATE_UNKNOWN4 = 4, // c t| some limitation to charge spells (?) and target test spells
+ AURA_STATE_FROZEN = 4, // c t| frozen target
AURA_STATE_JUDGEMENT = 5, // C |
//AURA_STATE_UNKNOWN6 = 6, // | not used
AURA_STATE_HUNTER_PARRY = 7, // C |
diff --git a/src/game/Spell.cpp b/src/game/Spell.cpp
index 1dd0c168329..af2580b5dc4 100644
--- a/src/game/Spell.cpp
+++ b/src/game/Spell.cpp
@@ -303,7 +303,7 @@ Spell::Spell( Unit* Caster, SpellEntry const *info, bool triggered, uint64 origi
break;
default:
// Wands
- if (m_spellInfo->AttributesEx3 & SPELL_ATTR_EX3_REQ_WAND)
+ if (m_spellInfo->AttributesEx2 & SPELL_ATTR_EX2_AUTOREPEAT_FLAG)
m_attackType = RANGED_ATTACK;
else
m_attackType = BASE_ATTACK;
diff --git a/src/game/SpellAuras.cpp b/src/game/SpellAuras.cpp
index 4b42c07f01c..4bce42b558f 100644
--- a/src/game/SpellAuras.cpp
+++ b/src/game/SpellAuras.cpp
@@ -3479,6 +3479,10 @@ void Aura::HandleAuraModRoot(bool apply, bool Real)
if(!Real)
return;
+ // Frost root aura -> freeze/unfreeze target
+ if (GetSpellSchoolMask(m_spellProto) & SPELL_SCHOOL_MASK_FROST)
+ m_target->ModifyAuraState(AURA_STATE_FROZEN, apply);
+
m_target->SetControlled(apply, UNIT_STAT_ROOT);
}
diff --git a/src/game/SpellAuras.h b/src/game/SpellAuras.h
index 8a8c30df04b..2c490f5ae57 100644
--- a/src/game/SpellAuras.h
+++ b/src/game/SpellAuras.h
@@ -304,8 +304,6 @@ class TRINITY_DLL_SPEC Aura
void _AddAura();
void _RemoveAura();
- void TriggerSpell();
-
bool IsUpdated() { return m_updated; }
void SetUpdated(bool val) { m_updated = val; }
void SetRemoveMode(AuraRemoveMode mode) { m_removeMode = mode; }
@@ -319,6 +317,7 @@ class TRINITY_DLL_SPEC Aura
void setDiminishGroup(DiminishingGroup group) { m_AuraDRGroup = group; }
DiminishingGroup getDiminishGroup() const { return m_AuraDRGroup; }
+ void TriggerSpell();
void PeriodicTick();
void PeriodicDummyTick();
diff --git a/src/game/SpellEffects.cpp b/src/game/SpellEffects.cpp
index 9b3b35b7e99..0a73fd43514 100644
--- a/src/game/SpellEffects.cpp
+++ b/src/game/SpellEffects.cpp
@@ -1731,6 +1731,8 @@ void Spell::EffectDummy(uint32 i)
//Shaman Rockbiter Weapon
if (m_spellInfo->SpellFamilyFlags == 0x400000)
{
+ // TODO: use expect spell for enchant (if exist talent)
+ // In 3.0.3 no mods present for rockbiter
uint32 spell_id = 0;
switch(m_spellInfo->Id)
{
@@ -1738,11 +1740,6 @@ void Spell::EffectDummy(uint32 i)
case 8018: spell_id = 36750; break; // Rank 2
case 8019: spell_id = 36755; break; // Rank 3
case 10399: spell_id = 36759; break; // Rank 4
- case 16314: spell_id = 36763; break; // Rank 5
- case 16315: spell_id = 36766; break; // Rank 6
- case 16316: spell_id = 36771; break; // Rank 7
- case 25479: spell_id = 36775; break; // Rank 8
- case 25485: spell_id = 36499; break; // Rank 9
default:
sLog.outError("Spell::EffectDummy: Spell %u not handled in RW",m_spellInfo->Id);
return;
@@ -1791,7 +1788,29 @@ void Spell::EffectDummy(uint32 i)
m_caster->CastCustomSpell(unitTarget,39609,&EffectBasePoints0,NULL,NULL,true,NULL,NULL,m_originalCasterGUID);
return;
}
-
+ // Lava Lash
+ if (m_spellInfo->SpellFamilyFlags2 & 0x00000004)
+ {
+ if (m_caster->GetTypeId()!=TYPEID_PLAYER)
+ return;
+ Item *item = ((Player*)m_caster)->GetItemByPos(INVENTORY_SLOT_BAG_0, EQUIPMENT_SLOT_OFFHAND);
+ if (item)
+ {
+ // Damage is increased if your off-hand weapon is enchanted with Flametongue.
+ Unit::AuraList const& auraDummy = m_caster->GetAurasByType(SPELL_AURA_DUMMY);
+ for(Unit::AuraList::const_iterator itr = auraDummy.begin(); itr != auraDummy.end(); ++itr)
+ {
+ if( (*itr)->GetSpellProto()->SpellFamilyName==SPELLFAMILY_SHAMAN &&
+ (*itr)->GetSpellProto()->SpellFamilyFlags & 0x0000000000200000LL &&
+ (*itr)->GetCastItemGUID() == item->GetGUID())
+ {
+ m_damage += m_damage * damage / 100;
+ return;
+ }
+ }
+ }
+ return;
+ }
break;
}
@@ -2050,12 +2069,7 @@ void Spell::EffectTriggerMissileSpell(uint32 effect_idx)
if (m_CastItem)
DEBUG_LOG("WORLD: cast Item spellId - %i", spellInfo->Id);
- Spell *spell = new Spell(m_caster, spellInfo, true, m_originalCasterGUID );
-
- SpellCastTargets targets;
- targets.setDestination(m_targets.m_destX,m_targets.m_destY,m_targets.m_destZ);
- spell->m_CastItem = m_CastItem;
- spell->prepare(&targets, NULL);
+ m_caster->CastSpell(m_targets.m_destX, m_targets.m_destY, m_targets.m_destZ, spellInfo->Id, true, m_CastItem, 0, m_originalCasterGUID);
}
void Spell::EffectTeleportUnits(uint32 i)
diff --git a/src/game/SpellMgr.cpp b/src/game/SpellMgr.cpp
index dd80acc2dc6..474bf8eae52 100644
--- a/src/game/SpellMgr.cpp
+++ b/src/game/SpellMgr.cpp
@@ -361,6 +361,13 @@ SpellSpecific GetSpellSpecific(uint32 spellId)
if (spellInfo->Dispel == DISPEL_POISON)
return SPELL_STING;
+ // only hunter aspects have this (but not all aspects in hunter family)
+ if( spellInfo->SpellFamilyFlags & 0x0044000000380000LL || spellInfo->SpellFamilyFlags2 & 0x00003010)
+ return SPELL_ASPECT;
+
+ if( spellInfo->SpellFamilyFlags2 & 0x00000002 )
+ return SPELL_TRACKER;
+
break;
}
case SPELLFAMILY_PALADIN:
@@ -405,20 +412,6 @@ SpellSpecific GetSpellSpecific(uint32 spellId)
return SPELL_WARLOCK_ARMOR;
}
- // only hunter aspects have this (but not all aspects in hunter family)
- if( spellInfo->activeIconID == 122 && (GetSpellSchoolMask(spellInfo) & SPELL_SCHOOL_MASK_NATURE) &&
- (spellInfo->Attributes & 0x50000) != 0 && (spellInfo->Attributes & 0x9000010) == 0)
- {
- return SPELL_ASPECT;
- }
-
- for(int i = 0; i < 3; i++)
- if( spellInfo->Effect[i] == SPELL_EFFECT_APPLY_AURA && (
- spellInfo->EffectApplyAuraName[i] == SPELL_AURA_TRACK_CREATURES ||
- spellInfo->EffectApplyAuraName[i] == SPELL_AURA_TRACK_RESOURCES ||
- spellInfo->EffectApplyAuraName[i] == SPELL_AURA_TRACK_STEALTHED ) )
- return SPELL_TRACKER;
-
// elixirs can have different families, but potion most ofc.
if(SpellSpecific sp = spellmgr.GetSpellElixirSpecific(spellInfo->Id))
return sp;
diff --git a/src/game/Unit.cpp b/src/game/Unit.cpp
index 66aeafcf032..165a459649a 100644
--- a/src/game/Unit.cpp
+++ b/src/game/Unit.cpp
@@ -10114,11 +10114,7 @@ void CharmInfo::SetPetNumber(uint32 petnumber, bool statwindow)
bool Unit::isFrozen() const
{
- AuraList const& mRoot = GetAurasByType(SPELL_AURA_MOD_ROOT);
- for(AuraList::const_iterator i = mRoot.begin(); i != mRoot.end(); ++i)
- if( GetSpellSchoolMask((*i)->GetSpellProto()) & SPELL_SCHOOL_MASK_FROST)
- return true;
- return false;
+ return HasAuraState(AURA_STATE_FROZEN);
}
struct ProcTriggeredData
diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h
index db52acd82a6..f8037402772 100644
--- a/src/shared/revision_nr.h
+++ b/src/shared/revision_nr.h
@@ -1,4 +1,4 @@
#ifndef __REVISION_NR_H__
#define __REVISION_NR_H__
- #define REVISION_NR "7072"
+ #define REVISION_NR "7076"
#endif // __REVISION_NR_H__