diff options
20 files changed, 2647 insertions, 135 deletions
diff --git a/doc/TextTables.txt b/doc/TextTables.txt deleted file mode 100644 index fa8aebdb5d3..00000000000 --- a/doc/TextTables.txt +++ /dev/null @@ -1,92 +0,0 @@ -========================================= -Texts Documentation -========================================= - -========================================================= -WARNING: THIS DOCUMENTATION IS NOT ALWAYS UP TO DATE. -FOR MORE UP-TO-DATE INFORMATION, CHECK THE TRINITY WIKI. -========================================================= - -Scriptdev2 Revision 695 introduces a new format for using texts in EventAI and SD2 Scripts. -This information relates to the *_texts tables located in the ScriptDev Database. - -Any script can at any time access and use text from any of the three text tables, as long as the entry does in fact exist. -Custom scripters are adviced to store their text data in custom_texts. - -The different tables has ranges of entries allowed for that table. -Reserved EventAI in Mangos entry -1 -> -999999 -script_texts: entry -1000000 -> -1999999 -custom_texts: entry -2000000 -> -2999999 -Any entry out of range for that table will display a startup error. - - -========================================= -Basic Structure of script_texts and custom_texts -========================================= -Below is a the list of current fields within the texts tables. - -Field_Name Description ------------------------------------------------------------ -entry This value is mearly an NEGATIVE identifier of the current text number. Required for sql queries. -content_default This is the actual text presented in the default language (English). - -content_loc1 This is the actual text presented in the Localization #1 Clients (Korean) -content_loc2 This is the actual text presented in the Localization #2 Clients (French) -content_loc3 This is the actual text presented in the Localization #3 Clients (German) -content_loc4 This is the actual text presented in the Localization #4 Clients (Chinese) -content_loc5 This is the actual text presented in the Localization #5 Clients (Taiwanese) -content_loc6 This is the actual text presented in the Localization #6 Clients (Spanish) -content_loc7 This is the actual text presented in the Localization #7 Clients (Spanish Mexico) -content_loc8 This is the actual text presented in the Localization #8 Clients (Russian) - -sound This value is the Sound ID that corresponds to the actual text used (Defined in SoundEntries.dbc). -type Variables used to define type of text (Say/Yell/Textemote/Whisper). -language This value is the Language that the text is native in (Defined in Languages.dbc). -emote Value from enum Emote (defined in Emotes.dbc). Only source of text will play this emote (not target, if target are defined in DoScriptText) -comment This is a comment regarding the text entry (For ACID, accepted format is to use Creature ID of NPC using it). - -Note: Fields `content_loc1` to `content_loc8` are NULL values by default and are handled by seperate localization projects. - - -========================================= -Text Types (type) -========================================= -Below is the list of current Text types that texts tables can handle. These were previously seperate Actions in ACID. - -# Internal Name Description ------------------------------------------------------------ -0 CHAT_TYPE_SAY This type sets the text to be displayed as a Say (Speech Bubble). -1 CHAT_TYPE_YELL This type sets the text to be displayed as a Yell (Red Speech Bubble) and usually has a matching Sound ID. -2 CHAT_TYPE_TEXT_EMOTE This type sets the text to be displayed as a text emote in orange in the chat log. -3 CHAT_TYPE_BOSS_EMOTE This type sets the text to be displayed as a text emote in orange in the chat log (Used only for specific Bosses). -4 CHAT_TYPE_WHISPER This type sets the text to be displayed as a whisper to the player in the chat log. -5 CHAT_TYPE_BOSS_WHISPER This type sets the text to be displayed as a whisper to the player in the chat log (Used only for specific Bosses). -6 CHAT_TYPE_ZONE_YELL Same as CHAT_TYPE_YELL but will display to all players in current zone. - - -========================================= -Language Types (language) -========================================= -Below is the list of current Language types that are allowed. -This is the Race Language that the text is native to (So it will display properly) - -# Internal Name Description ------------------------------------------------------------ -0 UNIVERSAL Text in this language is understood by ALL Races. -1 ORCISH Text in this language is understood ONLY by Horde Races. -2 DARNASSIAN Text in this language is understood ONLY by the Night Elf Race. -3 TAURAHE Text in this language is understood ONLY by the Tauren Race. -6 DWARVISH Text in this language is understood ONLY by the Dwarf Race. -7 COMMON Text in this language is understood ONLY by Alliance Races. -8 DEMONIC Text in this language is understood ONLY by the Demon Race (Not Implimented). -9 TITAN This language was used by Sargeras to speak with other Titians (Not Implemented). -10 THALASSIAN Text in this language is understood ONLY by the Blood Elf Race. -11 DRACONIC Text in this language is understood ONLY by the Dragon Race. -12 KALIMAG Text will display as Kalimag (not readable by players, language of all elementals) -13 GNOMISH Text in this language is understood ONLY by the Gnome Race. -14 TROLL Text in this language is understood ONLY by the Troll Race. -33 GUTTERSPEAK Text in this language is understood ONLY by the Undead Race. -35 DRAENEI Text in this language is understood ONLY by the Draenai Race. -36 ZOMBIE (not currently used?) -37 GNOMISH BINARY Binary language used by Alliance when drinking Binary Brew -38 GOBLIN BINARY Binary language used by Horce when drinking Binary Brew
\ No newline at end of file diff --git a/sql/updates/world/2013_03_10_world_misc.sql b/sql/updates/world/2013_03_10_00_world_misc.sql index cd8b7215e39..cd8b7215e39 100644 --- a/sql/updates/world/2013_03_10_world_misc.sql +++ b/sql/updates/world/2013_03_10_00_world_misc.sql diff --git a/sql/updates/world/2013_03_11_01_world_playercreateinfo_spell.sql b/sql/updates/world/2013_03_11_01_world_playercreateinfo_spell.sql new file mode 100644 index 00000000000..3a8f0501916 --- /dev/null +++ b/sql/updates/world/2013_03_11_01_world_playercreateinfo_spell.sql @@ -0,0 +1,558 @@ +-- playercreateinfo_spell +TRUNCATE TABLE `playercreateinfo_spell`; + +ALTER TABLE `playercreateinfo_spell` + CHANGE `race` `racemask` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `class` `classmask` INT(10) UNSIGNED DEFAULT 0 NOT NULL; + +ALTER TABLE `playercreateinfo_spell_custom` + CHANGE `race` `racemask` INT(10) UNSIGNED DEFAULT 0 NOT NULL, + CHANGE `class` `classmask` INT(10) UNSIGNED DEFAULT 0 NOT NULL; + +INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 78, "Heroic Strike"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 81, "Dodge"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Shaman +(0x6FF, 0x43, 107, "Block"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Hunter, Death Knight +(0x6FF, 0x25, 196, "One-Handed Axes"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Priest, Shaman, Druid +(0x6FF, 0x453, 198, "One-Handed Maces"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Death Knight +(0x6FF, 0x27, 201, "One-Handed Swords"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 203, "Unarmed"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 204, "Defense"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 522, "SPELLDEFENSE (DND)"), +-- Races: Human, Dwarf, Night elf, Gnome, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x44D, 0x5FF, 668, "Language Common"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 1843, "Disarm"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 2382, "Generic"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 2457, "Battle Stance"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 2479, "Honorless Target"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 3050, "Detect"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 3365, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 5301, "Defensive State (DND)"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 6233, "Closing"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 6246, "Closing"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 6247, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 6477, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 6478, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 6603, "Attack"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 7266, "Duel"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 7267, "Grovel"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 7355, "Stuck"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 8386, "Attacking"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Death Knight +(0x6FF, 0x23, 8737, "Mail"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Death Knight, Shaman, Druid +(0x6FF, 0x46F, 9077, "Leather"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 9078, "Cloth"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Shaman +(0x6FF, 0x43, 9116, "Shield"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 9125, "Generic"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Mage, Warlock +(0x1, 0x1BB, 20597, "Sword Specialization"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Mage, Warlock +(0x1, 0x1BB, 20598, "The Human Spirit"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Mage, Warlock +(0x1, 0x1BB, 20599, "Diplomacy"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Mage, Warlock +(0x1, 0x1BB, 20864, "Mace Specialization"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 21651, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 21652, "Closing"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 22027, "Remove Insignia"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 22810, "Opening - No Text"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 32215, "Victorious State"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 45927, "Summon Friend"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Mage, Warlock +(0x1, 0x1BB, 58985, "Perception"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Death Knight, Mage, Warlock +(0x1, 0x1BB, 59752, "Every Man for Himself"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5FF, 61437, "Opening"), +-- Races: Human, Dwarf, Tauren, Dranei +-- Classes: Warrior, Paladin +(0x425, 0x3, 199, "Two-Handed Maces"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 635, "Holy Light"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 21084, "Seal of Righteousness"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27762, "Libram"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Warrior, Hunter, Rogue, Warlock, Druid +(0x2DF, 0x50D, 1180, "Daggers"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1752, "Sinister Strike"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 2098, "Eviscerate"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Warrior, Rogue +(0x2DF, 0x9, 2567, "Thrown"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Warrior, Rogue +(0x2DF, 0x9, 2764, "Throw"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 16092, "Defensive State (DND)"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 21184, "Rogue Passive (DND)"), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 585, "Smite"), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 2050, "Lesser Heal"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Priest, Mage, Warlock +(0x6DF, 0x190, 5009, "Wands"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Priest, Mage, Warlock +(0x6DF, 0x190, 5019, "Shoot"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Hunter, Death Knight +(0x6FF, 0x25, 197, "Two-Handed Axes"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 200, "Polearms"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Death Knight +(0x6FF, 0x23, 202, "Two-Handed Swords"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Rogue, Death Knight +(0x6FF, 0x28, 674, "Dual Wield"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 750, "Plate Mail"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 3127, "Parry"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 3275, "Linen Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 3276, "Heavy Linen Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 3277, "Wool Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 3278, "Heavy Wool Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 7928, "Silk Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 7929, "Heavy Silk Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 7934, "Anti-Venom"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 10840, "Mageweave Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 10841, "Heavy Mageweave Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 10846, "First Aid"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 18629, "Runecloth Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 18630, "Heavy Runecloth Bandage"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 33391, "Journeyman Riding"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 45462, "Plague Strike"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 45477, "Icy Touch"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 45902, "Blood Strike"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 45903, "Offensive State (DND)"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 47541, "Death Coil"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 48266, "Blood Presence"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 49410, "Forceful Deflection"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 49576, "Death Grip"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 52665, "Sigil"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 59879, "Blood Plague"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 59921, "Frost Fever"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Death Knight +(0x6FF, 0x20, 61455, "Runic Focus"), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 133, "Fireball"), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 168, "Frost Armor"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5D0, 227, "Staves"), +-- Races: Human, Orc, Undead, Gnome, Blood elf +-- Classes: Warlock +(0x253, 0x100, 686, "Shadow Bolt"), +-- Races: Human, Orc, Undead, Gnome, Blood elf +-- Classes: Warlock +(0x253, 0x100, 687, "Demon Skin"), +-- Races: Human, Orc, Undead, Gnome, Blood elf +-- Classes: Warlock +(0x253, 0x100, 58284, "Chaos Bolt Passive"), +-- Races: Orc, Undead, Tauren, Troll, Blood elf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid +(0x2B2, 0x5FF, 669, "Language Orcish"), +-- Races: Orc +-- Classes: Warrior, Hunter, Rogue, Death Knight +(0x2, 0x2D, 20572, "Blood Fury"), +-- Races: Orc +-- Classes: Warrior, Hunter, Rogue, Death Knight, Shaman, Warlock +(0x2, 0x16D, 20573, "Hardiness"), +-- Races: Orc +-- Classes: Warrior, Hunter, Rogue, Death Knight, Shaman, Warlock +(0x2, 0x16D, 20574, "Axe Specialization"), +-- Races: Orc +-- Classes: Warrior, Rogue, Shaman +(0x2, 0x49, 21563, "Command"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 75, "Auto Shot"), +-- Races: Orc, Night elf, Troll, Blood elf +-- Classes: Hunter +(0x28A, 0x4, 264, "Bows"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 2973, "Raptor Strike"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 13358, "Defensive State (DND)"), +-- Races: Orc +-- Classes: Hunter +(0x2, 0x4, 20576, "Command"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 24949, "Defensive State 2 (DND)"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34082, "Advantaged State (DND)"), +-- Races: Orc +-- Classes: Death Knight +(0x2, 0x20, 54562, "Command"), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 331, "Healing Wave"), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 403, "Lightning Bolt"), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 27763, "Totem"), +-- Races: Orc +-- Classes: Shaman +(0x2, 0x40, 33697, "Blood Fury"), +-- Races: Orc +-- Classes: Warlock +(0x2, 0x100, 20575, "Command"), +-- Races: Orc +-- Classes: Warlock +(0x2, 0x100, 33702, "Blood Fury"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight +(0x4, 0x3F, 672, "Language Dwarven"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight +(0x4, 0x3F, 2481, "Find Treasure"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight +(0x4, 0x3F, 20594, "Stoneform"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight +(0x4, 0x3F, 20595, "Gun Specialization"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight +(0x4, 0x3F, 20596, "Frost Resistance"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight +(0x4, 0x3F, 59224, "Mace Specialization"), +-- Races: Dwarf, Tauren +-- Classes: Hunter +(0x24, 0x4, 266, "Guns"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Druid +(0x8, 0x43D, 671, "Language Darnassian"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Druid +(0x8, 0x43D, 20582, "Quickness"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Druid +(0x8, 0x43D, 20583, "Nature Resistance"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Druid +(0x8, 0x43D, 20585, "Wisp Spirit"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Druid +(0x8, 0x43D, 58984, "Shadowmelt"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5176, "Wrath"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5185, "Healing Touch"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27764, "Fetish"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock +(0x10, 0x1B9, 5227, "Underwater Breathing"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock +(0x10, 0x1B9, 7744, "Will of the Forsaken"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock +(0x10, 0x1B9, 17737, "Language Gutterspeak"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock +(0x10, 0x1B9, 20577, "Cannibalize"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Death Knight, Mage, Warlock +(0x10, 0x1B9, 20579, "Shadow Resistance"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Death Knight, Shaman, Druid +(0x20, 0x465, 670, "Language Taurahe"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Death Knight, Shaman, Druid +(0x20, 0x465, 20549, "War Stomp"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Death Knight, Shaman, Druid +(0x20, 0x465, 20550, "Endurance"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Death Knight, Shaman, Druid +(0x20, 0x465, 20551, "Nature Resistance"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Death Knight, Shaman, Druid +(0x20, 0x465, 20552, "Cultivation"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Death Knight, Mage, Warlock +(0x40, 0x1A9, 7340, "Language Gnomish"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Death Knight, Mage, Warlock +(0x40, 0x1A9, 20589, "Escape Artist"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Death Knight, Mage, Warlock +(0x40, 0x1A9, 20591, "Expansive Mind"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Death Knight, Mage, Warlock +(0x40, 0x1A9, 20592, "Arcane Resistance"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Death Knight, Mage, Warlock +(0x40, 0x1A9, 20593, "Engineering Specialization"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 7341, "Language Troll"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 20555, "Regeneration"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 20557, "Beast Slaying"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 20558, "Throwing Specialization"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 26290, "Bow Specialization"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 26297, "Berserking"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Death Knight, Shaman, Mage +(0x80, 0xFD, 58943, "Da Voodoo Shuffle"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock +(0x200, 0x1BE, 813, "Language Thalassian"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock +(0x200, 0x1BE, 822, "Magic Resistance"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Priest, Mage, Warlock +(0x200, 0x196, 28730, "Arcane Torrent"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Rogue, Priest, Death Knight, Mage, Warlock +(0x200, 0x1BE, 28877, "Arcane Affinity"), +-- Races: Blood elf +-- Classes: Rogue +(0x200, 0x8, 25046, "Arcane Torrent"), +-- Races: Blood elf +-- Classes: Death Knight +(0x200, 0x20, 50613, "Arcane Torrent"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter, Death Knight +(0x400, 0x27, 6562, "Heroic Presence"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Shaman, Mage +(0x400, 0xF7, 28875, "Gemcutting"), +-- Races: Dranei +-- Classes: Warrior +(0x400, 0x1, 28880, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter, Priest, Death Knight, Shaman, Mage +(0x400, 0xF7, 29932, "Language Draenei"), +-- Races: Dranei +-- Classes: Mage +(0x400, 0x80, 59541, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Paladin +(0x400, 0x2, 59542, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Hunter +(0x400, 0x4, 5011, "Crossbows"), +-- Races: Dranei +-- Classes: Shaman +(0x400, 0x40, 59540, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Hunter +(0x400, 0x4, 59543, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Priest, Shaman, Mage +(0x400, 0xD0, 28878, "Inspiring Presence"), +-- Races: Dranei +-- Classes: Death Knight +(0x400, 0x20, 59539, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Priest +(0x400, 0x10, 59544, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Priest +(0x400, 0x10, 59538, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Hunter +(0x400, 0x4, 59536, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Death Knight +(0x400, 0x20, 59545, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Paladin +(0x400, 0x2, 59535, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Shaman +(0x400, 0x40, 59547, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Warrior +(0x400, 0x1, 59221, "Shadow Resistance"), +-- Races: Dranei +-- Classes: Mage +(0x400, 0x80, 59548, "Gift of the Naaru"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 60091, "Judgement Anti-Parry/Dodge Passive"), +-- Races: All +-- Classes: Death Knight +(0x0, 0x20, 56816, "Rune Strike"), +-- Races: All +-- Classes: Shaman +(0x0, 0x40, 75461, "Flame Shock Passive"), +-- Races: All +-- Classes: Warlock +(0x0, 0x100, 75445, "Demonic Immolate"); diff --git a/sql/updates/world/2013_03_12_00_world_playercreateinfo_spell_custom.sql b/sql/updates/world/2013_03_12_00_world_playercreateinfo_spell_custom.sql new file mode 100644 index 00000000000..76f7a43eaa0 --- /dev/null +++ b/sql/updates/world/2013_03_12_00_world_playercreateinfo_spell_custom.sql @@ -0,0 +1,1632 @@ +TRUNCATE TABLE `playercreateinfo_spell_custom`; + +INSERT INTO playercreateinfo_spell_custom (racemask, classmask, Spell, Note) VALUES +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 78, "Heroic Strike"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 81, "Dodge"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Shaman +(0x6FF, 0x43, 107, "Block"), +-- Races: Human, Orc, Dwarf, Tauren, Troll +-- Classes: Warrior, Hunter +(0xA7, 0x5, 196, "One-Handed Axes"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Priest, Shaman, Druid +(0x6FF, 0x453, 198, "One-Handed Maces"), +-- Races: Human, Orc, Night elf, Undead, Gnome, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter +(0x65B, 0x7, 201, "One-Handed Swords"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 203, "Unarmed"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 204, "Defense"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 522, "SPELLDEFENSE(DND)"), +-- Races: Human, Dwarf, Night elf, Gnome, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x44D, 0x5DF, 668, "Language Common"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 2382, "Generic"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 2457, "Battle Stance"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 2479, "Honorless Target"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 3050, "Detect"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 3365, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 5301, "Defensive State(DND)"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 6233, "Closing"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 6246, "Closing"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 6247, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 6477, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 6478, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 6603, "Attack"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 7266, "Duel"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 7267, "Grovel"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 7355, "Stuck"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 7376, "Defensive Stance Passive"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 7381, "Berserker Stance Passive"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 8386, "Attacking"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Shaman +(0x6FF, 0x47, 8737, "Mail"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Shaman, Druid +(0x6FF, 0x44F, 9077, "Leather"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 9078, "Cloth"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Shaman +(0x6FF, 0x43, 9116, "Shield"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 9125, "Generic"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Mage, Warlock +(0x1, 0x19B, 20597, "Sword Specialization"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Mage, Warlock +(0x1, 0x19B, 20598, "The Human Spirit"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Mage, Warlock +(0x1, 0x19B, 20599, "Diplomacy"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Mage, Warlock +(0x1, 0x19B, 20600, "Perception"), +-- Races: Human +-- Classes: Warrior, Paladin, Rogue, Priest, Mage, Warlock +(0x1, 0x19B, 20864, "Mace Specialization"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 21156, "Battle Stance Passive"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 21651, "Opening"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 21652, "Closing"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 22027, "Remove Insignia"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x6FF, 0x5DF, 22810, "Opening - No Text"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 32215, "Victorious State"), +-- Races: Human, Dwarf, Tauren, Dranei +-- Classes: Warrior, Paladin +(0x425, 0x3, 199, "Two-Handed Maces"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 635, "Holy Light"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 21084, "Seal of Righteousness"), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27762, "Libram"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Warrior, Hunter, Rogue, Warlock, Druid +(0x2DF, 0x50D, 1180, "Daggers"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1752, "Sinister Strike"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 2098, "Eviscerate"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Warrior, Rogue +(0x2DF, 0x9, 2567, "Thrown"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Warrior, Rogue +(0x2DF, 0x9, 2764, "Throw"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 16092, "Defensive State(DND)"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 21184, "Rogue Passive(DND)"), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 585, "Smite"), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 2050, "Lesser Heal"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Priest, Mage, Warlock +(0x6DF, 0x190, 5009, "Wands"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Priest, Mage, Warlock +(0x6DF, 0x190, 5019, "Shoot"), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 133, "Fireball"), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 168, "Frost Armor"), +-- Races: Human, Orc, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Shaman, Mage, Druid +(0x6FB, 0x4C0, 227, "Staves"), +-- Races: Human, Orc, Undead, Gnome, Blood elf +-- Classes: Warlock +(0x253, 0x100, 686, "Shadow Bolt"), +-- Races: Human, Orc, Undead, Gnome, Blood elf +-- Classes: Warlock +(0x253, 0x100, 687, "Demon Skin"), +-- Races: Orc, Dwarf +-- Classes: Warrior +(0x6, 0x1, 197, "Two-Handed Axes"), +-- Races: Orc, Undead, Tauren, Troll, Blood elf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock, Druid +(0x2B2, 0x5DF, 669, "Language Orcish"), +-- Races: Orc +-- Classes: Warrior, Hunter, Rogue +(0x2, 0xD, 20572, "Blood Fury"), +-- Races: Orc +-- Classes: Warrior, Hunter, Rogue, Shaman, Warlock +(0x2, 0x14D, 20573, "Hardiness"), +-- Races: Orc +-- Classes: Warrior, Hunter, Rogue, Shaman, Warlock +(0x2, 0x14D, 20574, "Axe Specialization"), +-- Races: Orc +-- Classes: Warrior, Rogue, Shaman +(0x2, 0x49, 21563, "Command"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 75, "Auto Shot"), +-- Races: Orc, Night elf, Troll, Blood elf +-- Classes: Hunter +(0x28A, 0x4, 264, "Bows"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 2973, "Raptor Strike"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 13358, "Defensive State(DND)"), +-- Races: Orc +-- Classes: Hunter +(0x2, 0x4, 20576, "Command"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 24949, "Defensive State 2(DND)"), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34082, "Advantaged State(DND)"), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 331, "Healing Wave"), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 403, "Lightning Bolt"), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 27763, "Totem"), +-- Races: Orc +-- Classes: Shaman +(0x2, 0x40, 33697, "Blood Fury"), +-- Races: Orc +-- Classes: Warlock +(0x2, 0x100, 20575, "Command"), +-- Races: Orc +-- Classes: Warlock +(0x2, 0x100, 33702, "Blood Fury"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest +(0x4, 0x1F, 672, "Language Dwarven"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest +(0x4, 0x1F, 2481, "Find Treasure"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest +(0x4, 0x1F, 20594, "Stoneform"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest +(0x4, 0x1F, 20595, "Gun Specialization"), +-- Races: Dwarf +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest +(0x4, 0x1F, 20596, "Frost Resistance"), +-- Races: Dwarf, Tauren +-- Classes: Hunter +(0x24, 0x4, 266, "Guns"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Druid +(0x8, 0x41D, 671, "Language Darnassian"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Druid +(0x8, 0x41D, 20580, "Shadowmeld"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Druid +(0x8, 0x41D, 20582, "Quickness"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Druid +(0x8, 0x41D, 20583, "Nature Resistance"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Druid +(0x8, 0x41D, 20585, "Wisp Spirit"), +-- Races: Night elf +-- Classes: Warrior, Hunter, Rogue, Priest, Druid +(0x8, 0x41D, 21009, "Shadowmeld Passive"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 1178, "Bear Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 3025, "Cat Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5176, "Wrath"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5185, "Healing Touch"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5419, "Travel Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5420, "Tree of Life"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5421, "Aquatic Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 9635, "Dire Bear Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 21178, "Bear Form(Passive2)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 24905, "Moonkin Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27764, "Fetish"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 33948, "Flight Form(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 34123, "Tree of Life(Passive)"), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 40121, "Swift Flight Form(Passive)"), +-- Races: Undead, Blood elf, Dranei +-- Classes: Warrior, Paladin +(0x610, 0x3, 202, "Two-Handed Swords"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Mage, Warlock +(0x10, 0x199, 5227, "Underwater Breathing"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Mage, Warlock +(0x10, 0x199, 7744, "Will of the Forsaken"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Mage, Warlock +(0x10, 0x199, 17737, "Language Gutterspeak"), +-- Races: Undead +-- Classes: Warrior, Rogue, Priest, Mage, Warlock +(0x10, 0x199, 20577, "Cannibalize"), +-- Races: Undead, Dranei +-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Shaman, Mage, Warlock +(0x410, 0x1DF, 20579, "Shadow Resistance"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Shaman, Druid +(0x20, 0x445, 670, "Language Taurahe"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Shaman, Druid +(0x20, 0x445, 20549, "War Stomp"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Shaman, Druid +(0x20, 0x445, 20550, "Endurance"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Shaman, Druid +(0x20, 0x445, 20551, "Nature Resistance"), +-- Races: Tauren +-- Classes: Warrior, Hunter, Shaman, Druid +(0x20, 0x445, 20552, "Cultivation"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Mage, Warlock +(0x40, 0x189, 7340, "Language Gnomish"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Mage, Warlock +(0x40, 0x189, 20589, "Escape Artist"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Mage, Warlock +(0x40, 0x189, 20591, "Expansive Mind"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Mage, Warlock +(0x40, 0x189, 20592, "Arcane Resistance"), +-- Races: Gnome +-- Classes: Warrior, Rogue, Mage, Warlock +(0x40, 0x189, 20593, "Engineering Specialization"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Shaman, Mage +(0x80, 0xDD, 7341, "Language Troll"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Shaman, Mage +(0x80, 0xDD, 20555, "Regeneration"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Shaman, Mage +(0x80, 0xDD, 20557, "Beast Slaying"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Shaman, Mage +(0x80, 0xDD, 20558, "Throwing Specialization"), +-- Races: Troll +-- Classes: Warrior, Hunter, Rogue, Priest, Shaman, Mage +(0x80, 0xDD, 26290, "Bow Specialization"), +-- Races: Troll +-- Classes: Warrior +(0x80, 0x1, 26296, "Berserking"), +-- Races: Troll +-- Classes: Hunter, Priest, Shaman, Mage +(0x80, 0xD4, 20554, "Berserking"), +-- Races: Troll +-- Classes: Rogue +(0x80, 0x8, 26297, "Berserking"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Rogue, Priest, Mage, Warlock +(0x200, 0x19E, 813, "Language Thalassian"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Rogue, Priest, Mage, Warlock +(0x200, 0x19E, 822, "Magic Resistance"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Priest, Mage, Warlock +(0x200, 0x196, 28730, "Arcane Torrent"), +-- Races: Blood elf +-- Classes: Paladin, Hunter, Rogue, Priest, Mage, Warlock +(0x200, 0x19E, 28877, "Arcane Affinity"), +-- Races: Blood elf +-- Classes: Rogue +(0x200, 0x8, 25046, "Arcane Torrent"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter +(0x400, 0x7, 6562, "Heroic Presence"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter, Priest, Shaman, Mage +(0x400, 0xD7, 28875, "Gemcutting"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter, Priest, Shaman, Mage +(0x400, 0xD7, 28880, "Gift of the Naaru"), +-- Races: Dranei +-- Classes: Warrior, Paladin, Hunter, Priest, Shaman, Mage +(0x400, 0xD7, 29932, "Language Draenei"), +-- Races: Dranei +-- Classes: Hunter +(0x400, 0x4, 5011, "Crossbows"), +-- Races: Dranei +-- Classes: Priest, Shaman, Mage +(0x400, 0xD0, 28878, "Inspiring Presence"), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 2048, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 30324, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 11578, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25208, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25264, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 2687, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 71, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25225, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 355, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 11585, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 29704, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25203, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 30357, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25266, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 2565, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 676, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25231, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 20230, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 5246, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25236, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 1161, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 871, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 2458, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25275, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25242, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 18499, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 1680, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 6554, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 1719, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 34428, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 23920, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 469, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 3411, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27014, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 1494, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 13163, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27016, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27019, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 14325, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 5116, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27044, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 883, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 2641, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 6991, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 982, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 1515, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19883, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27020, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27046, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 14268, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 6197, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 1002, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 14327, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27023, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 36916, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27021, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19884, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 5118, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27015, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 14311, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 3043, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 1462, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19885, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 3045, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19880, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 13809, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 13161, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 5384, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 1543, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19878, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27025, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27018, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 13159, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19882, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27022, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 27045, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19879, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 19801, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34120, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34074, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34026, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34600, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 34477, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27149, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27136, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27155, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27140, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 20271, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27158, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 10308, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 10278, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27154, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 20773, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27142, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 31789, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27150, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 25780, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 1044, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 33776, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27173, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27138, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27137, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 5502, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 19746, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 31895, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 5627, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 1038, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27151, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 19752, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27160, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27152, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 1020, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27153, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27166, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27144, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 4987, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27180, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27148, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27139, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27141, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 10326, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27143, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 25898, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27145, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 25895, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 32223, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 27169, ""), +-- Races: Human, Dwarf, Blood elf, Dranei +-- Classes: Paladin +(0x605, 0x2, 31884, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26865, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26862, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1787, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26863, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 921, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 38764, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26669, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 11297, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 6774, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 11305, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 38768, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26866, ""), +-- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2D7, 0x8, 26884, ""), +-- Races: Human, Orc, Dwarf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2D7, 0x8, 27448, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1804, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 27441, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 2842, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1725, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26867, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26889, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1833, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1842, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 408, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 2094, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 32684, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 26679, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 31224, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 5938, ""), +-- Races: Night elf +-- Classes: Rogue +(0x8, 0x8, 426884, ""), +-- Races: Night elf +-- Classes: Rogue +(0x8, 0x8, 427448, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27215, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27209, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27216, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 30909, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27222, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27218, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 6215, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27230, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27217, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27259, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27226, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27220, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 5697, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27238, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 30459, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27260, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27212, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 698, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 5500, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 30908, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 11719, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 132, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 18647, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27213, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 11726, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27228, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 28610, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 28172, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27250, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 17928, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27223, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27229, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 30545, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 30910, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 18540, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 28189, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 32231, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 29858, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 29893, ""), +-- Races: Human, Orc, Undead, Gnome, Dranei +-- Classes: Warlock +(0x453, 0x100, 27243, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26979, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26990, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26985, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26988, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26982, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26992, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26989, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26998, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 6795, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26996, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 18960, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 9634, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 768, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 783, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 1066, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 40120, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5229, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26980, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 8983, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 8946, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26997, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26993, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 18658, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27000, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 9913, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26994, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27008, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26986, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27002, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26995, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27003, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 2782, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 9846, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 2893, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 33357, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5209, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27004, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26983, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 24248, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27005, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 5225, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26999, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27012, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 27006, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 29166, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 22812, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 26991, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 22570, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 33763, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 33745, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 33786, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27126, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27070, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 22018, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27072, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 22019, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27079, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 38704, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 28272, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 28271, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 12826, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27088, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 33944, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 130, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27082, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27086, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 33946, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 475, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 1953, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27085, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 12051, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27128, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27131, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 32796, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27074, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 2139, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27101, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27124, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 45438, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27125, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27127, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 30482, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 30451, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 30455, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 66, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 43987, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 30449, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25389, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25364, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25368, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25218, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25429, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25222, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25375, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25435, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25431, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 528, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 10890, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 988, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 6346, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25235, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25384, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25596, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 10955, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 10909, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25380, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 10912, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25308, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25433, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 552, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 1706, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25213, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25392, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 39374, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 32999, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 32996, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 32546, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 34433, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 33076, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 32375, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25396, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25449, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25485, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25454, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25509, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 2484, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25472, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25525, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25457, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25489, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25533, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25528, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 20777, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25547, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 8012, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 526, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 8143, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25464, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25500, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 2645, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25567, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25420, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 2870, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 8166, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 131, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25560, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 6196, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25552, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25570, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25563, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25557, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 546, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 556, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 8177, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25574, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 36936, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25505, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 421, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25587, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 6495, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25577, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 8170, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25423, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25359, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25908, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 33736, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 3738, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 2062, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 2894, ""), +-- Races: Orc, Tauren, Troll +-- Classes: Shaman +(0xA2, 0x40, 2825, ""), +-- Races: Dranei +-- Classes: Shaman +(0x400, 0x40, 32182, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Hunter, Rogue +(0x6FF, 0xD, 674, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Warrior, Paladin +(0x6FF, 0x3, 750, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei +-- Classes: Paladin, Hunter, Rogue +(0x6FF, 0xE, 3127, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 25442, ""), +-- Races: Orc, Tauren, Troll, Dranei +-- Classes: Shaman +(0x4A2, 0x40, 20608, ""), +-- Races: Human, Undead, Gnome, Troll, Blood elf, Dranei +-- Classes: Mage +(0x6D1, 0x80, 27087, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 8643, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 25212, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei +-- Classes: Warrior +(0x4FF, 0x1, 12678, ""), +-- Races: Orc, Dwarf, Night elf, Tauren, Troll, Blood elf, Dranei +-- Classes: Hunter +(0x6AE, 0x4, 5149, ""), +-- Races: Human, Dwarf, Dranei +-- Classes: Paladin +(0x405, 0x2, 23214, ""), +-- Races: Blood elf +-- Classes: Paladin +(0x200, 0x2, 34767, ""), +-- Races: Human, Orc, Undead, Gnome, Blood elf, Dranei +-- Classes: Warlock +(0x653, 0x100, 23161, ""), +-- Races: Human, Orc, Undead, Gnome, Blood elf, Dranei +-- Classes: Warlock +(0x653, 0x100, 688, ""), +-- Races: Human, Orc, Undead, Gnome, Blood elf, Dranei +-- Classes: Warlock +(0x653, 0x100, 697, ""), +-- Races: Human, Orc, Undead, Gnome, Blood elf, Dranei +-- Classes: Warlock +(0x653, 0x100, 712, ""), +-- Races: Human, Orc, Undead, Gnome, Blood elf, Dranei +-- Classes: Warlock +(0x653, 0x100, 691, ""), +-- Races: Night elf, Tauren +-- Classes: Druid +(0x28, 0x400, 20719, ""), +-- Races: Human, Orc, Undead, Gnome, Blood elf +-- Classes: Warlock +(0x253, 0x100, 126, ""), +-- Races: Human, Dwarf, Dranei +-- Classes: Paladin +(0x405, 0x2, 31801, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 3776, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 9186, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 21927, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 22054, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 22055, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 2836, ""), +-- Races: Human, Orc, Dwarf, Night elf, Undead, Gnome, Troll, Blood elf +-- Classes: Rogue +(0x2DF, 0x8, 1860, ""), +-- Races: Human +-- Classes: Priest +(0x1, 0x10, 25441, ""), +-- Races: Human, Dwarf, Night elf, Undead, Troll, Blood elf, Dranei +-- Classes: Priest +(0x69D, 0x10, 25312, ""), +-- Races: Human, Dwarf +-- Classes: Priest +(0x5, 0x10, 25437, ""); diff --git a/sql/updates/world/2013_03_13_00_world_misc.sql b/sql/updates/world/2013_03_13_00_world_misc.sql new file mode 100644 index 00000000000..f579a82f5d5 --- /dev/null +++ b/sql/updates/world/2013_03_13_00_world_misc.sql @@ -0,0 +1,78 @@ +SET @CGUID := 49815; +SET @OGUID := 14972; +SET @SERINAR := 26593; +SET @NECROLYTE := 27356; +SET @BUNNY := 27369; +SET @RUNE := 188695; + +UPDATE `creature` SET `MovementType`=0, `spawndist`=0, `unit_flags`=33024 WHERE `guid`=116960; +DELETE FROM `creature` WHERE `guid` IN (117061,117371,117372,117421,117422,117423,117633,117634,117646,117648,117649); +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(117061, @BUNNY, 571, 1, 1, 13069, 4495.499, 1747.361, 175.1579, 0.6806784, 300, 0, 0), +(117371, @BUNNY, 571, 1, 1, 13069, 4544.45, 1739.195, 167.6779, 0.9075712, 300, 0, 0), +(117372, @BUNNY, 571, 1, 1, 13069, 4573.836, 1708.501, 171.742, 1.466077, 300, 0, 0), +(117421, @BUNNY, 571, 1, 1, 13069, 4604.599, 1727.422, 170.6874, 4.921828, 300, 0, 0), +(117422, @BUNNY, 571, 1, 1, 13069, 4601.996, 1700.385, 171.9938, 1.37881, 300, 0, 0), +(117423, @BUNNY, 571, 1, 1, 13069, 4576.454, 1755.058, 167.8554, 2.164208, 300, 0, 0), +(117633, @BUNNY, 571, 1, 1, 13069, 4625.904, 1754.476, 182.3284, 6.038839, 300, 0, 0), +(117634, @BUNNY, 571, 1, 1, 13069, 4561.219, 1731.186, 166.7194, 3.926991, 300, 0, 0), +(117646, @BUNNY, 571, 1, 1, 13069, 4497.56, 1880.672, 164.3632, 5.61996, 300, 0, 0), +(117648, 27362, 571, 1, 1, 0, 4567.375, 1724.495, 168.1724, 0.6806784, 300, 5, 1), +(117649, 27362, 571, 1, 1, 0, 4608.474, 1721.618, 170.9504, 3.124139, 300, 5, 1), +(@CGUID+0, 27358, 571, 1, 1, 0, 4576.38, 1711.559, 171.3237, 4.018391, 300, 5, 1), +(@CGUID+1, 27358, 571, 1, 1, 0, 4574.408, 1751.613, 167.8838, 1.03504, 300, 5, 1), +(@CGUID+2, 27363, 571, 1, 1, 0, 4570.443, 1678.617, 170.5762, 0.002298846, 300, 5, 1); + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+8; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`, `orientation`, `rotation0`, `rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) VALUES +(@OGUID+0,@RUNE,571,1,1,4495.527,1747.337,175.0751,0.7330382,0,0,0.3583679,0.9335805,300,100,1), +(@OGUID+1,@RUNE,571,1,1,4544.453,1739.186,167.594,-1.151916,0,0,-0.5446386,0.8386708,300,100,1), +(@OGUID+2,@RUNE,571,1,1,4573.879,1708.473,171.6586,-2.268925,0,0,-0.9063072,0.4226195,300,100,1), +(@OGUID+3,@RUNE,571,1,1,4604.577,1727.41,170.6038,-0.1919852,0,0,-0.09584522,0.9953963,300,100,1), +(@OGUID+4,@RUNE,571,1,1,4601.975,1700.365,171.9105,-0.4014249,0,0,-0.1993675,0.9799248,300,100,1), +(@OGUID+5,@RUNE,571,1,1,4576.479,1755.036,167.7747,-0.2792516,0,0,-0.1391726,0.9902682,300,100,1), +(@OGUID+6,@RUNE,571,1,1,4625.864,1754.506,182.2451,-0.7330382,0,0,-0.3583679,0.9335805,300,100,1), +(@OGUID+7,@RUNE,571,1,1,4561.233,1731.201,166.6359,-0.6108635,0,0,-0.300705,0.9537172,300,100,1), +(@OGUID+8,@RUNE,571,1,1,4497.559,1880.615,164.2788,0.8377574,0,0,0.4067364,0.9135455,300,100,1); + +DELETE FROM `creature_addon` WHERE `guid`=116960; +INSERT INTO `creature_addon` (`guid`,`auras`) VALUES +(116960,'29266'); + +DELETE FROM `creature_text` WHERE `entry`=@SERINAR; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES +(@SERINAR,0,0, 'Perfect. As long as you don''t go hacking and slashing your way through, they''ll never know the difference.',12,0,100,0,0,0, 'Serinar'); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=48750; +INSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES +(48750,48770,2,'Serinar''s Vision is applied while aura Burning Depths Necrolyte Image is active'); + +UPDATE `quest_template` SET `PrevQuestId`=12447 WHERE `Id` IN (12261,12262); +UPDATE `quest_template` SET `PrevQuestId`=12263 WHERE `Id` IN (12264,12265); + +UPDATE `gameobject_template` SET `flags`=4 WHERE `entry`=188695; +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@SERINAR; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@SERINAR AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@SERINAR*100 AND `source_type`=9; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@SERINAR, 0, 0, 1, 19, 0, 100, 0, 12263, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, @NECROLYTE, 20, 0, 0, 0, 0, 0, 'Serinar - On quest accept - Turn to'), +(@SERINAR, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 11, 48748, 0, 0, 0, 0, 0, 19, @NECROLYTE, 20, 0, 0, 0, 0, 0, 'Serinar - On quest accept - Spellcast Absorb Image'), +(@SERINAR, 0, 2, 0, 61, 0, 100, 0, 0, 0, 0, 0, 80, @SERINAR*100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Serinar - On quest accept - Run script'), +(@SERINAR, 0, 3, 4, 62, 0, 100, 0, 9537, 0, 0, 0, 11, 48750, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Serinar - On gossip select - Spellcast Burning Depths Necrolyte Image'), +(@SERINAR, 0, 4, 5, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Serinar - On gossip select - Say line'), +(@SERINAR, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Serinar - On gossip select - Close gossip'), + +(@SERINAR*100, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Serinar script - Turn to'), +(@SERINAR*100, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 11, 48750, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Serinar script - Spellcast Burning Depths Necrolyte Image'), +(@SERINAR*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Serinar script - Say line'), +(@SERINAR*100, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Serinar script - Turn to'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (48738,48748); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9537 AND `SourceEntry`=0; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 48738, 0, 0, 31, 0, 4, 0, 0, 0, 0, '', 'Spell Stamp Out Necromantic Rune effect0 targets player'), +(13, 2, 48738, 0, 0, 31, 0, 3, @BUNNY, 0, 0, 0, '', 'Spell Stamp Out Necromantic Rune effect1 targets Necromantic Rune Bunny'), +(13, 1, 48748, 0, 0, 31, 0, 3, @NECROLYTE, 0, 0, 0, '', 'Spell Absorb Image targets Burning Depths Necrolyte'), +(15, 9537, 0, 0, 0, 9, 0, 12263, 0, 0, 0, 0, '', 'Show gossip option only if player has taken quest The Best of Intentions'), +(15, 9537, 0, 0, 0, 1, 0, 48750, 0, 0, 1, 0, '', 'Show gossip option only if player doesn''t have aura Burning Depths Necrolyte Image'); diff --git a/sql/updates/world/2013_03_13_01_world_creature_loot_template.sql b/sql/updates/world/2013_03_13_01_world_creature_loot_template.sql new file mode 100644 index 00000000000..ce1fbd0cec4 --- /dev/null +++ b/sql/updates/world/2013_03_13_01_world_creature_loot_template.sql @@ -0,0 +1,2 @@ +-- wrong lootmode +UPDATE `creature_loot_template` SET `lootmode`=1 WHERE `item` IN(46367,46381,46380); diff --git a/sql/updates/world/2013_03_13_02_sai.sql b/sql/updates/world/2013_03_13_02_sai.sql new file mode 100644 index 00000000000..b3712d52197 --- /dev/null +++ b/sql/updates/world/2013_03_13_02_sai.sql @@ -0,0 +1,49 @@ +-- Darkwraith +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=15657 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Plaguehound +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=8598 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Amani Berserker +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=15643 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Enraged Wraith +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=17086 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Anok'suten +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=16357 AND `source_type`=0 AND `id`=3 AND `link`=0; +-- Bloodscalp Warrior +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=587 AND `source_type`=0 AND `id`=2 AND `link`=3; +-- Bloodscalp Berserker +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=597 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Commander Aggro'gosh +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=2464 AND `source_type`=0 AND `id`=3 AND `link`=4; +-- Vilebranch Berserker +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=2643 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Hungering Wraith +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=1802 AND `source_type`=0 AND `id`=1 AND `link`=2; +-- Dark Strand Enforcer +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=3727 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Scarlet Myrmidon +UPDATE `smart_scripts` SET `event_flags`=1 WHERE `entryorguid`=4295 AND `source_type`=0 AND `id`=0 AND `link`=1; +-- Ymirjar Flesh Hunter +UPDATE `smart_scripts` SET `event_flags`=7 WHERE `entryorguid`=26670 AND `source_type`=0 AND `id`=27 AND `link`=28; +-- Startup Errors +UPDATE `smart_scripts` SET `event_flags`=0 WHERE `entryorguid`=22895 AND `source_type`=0 AND `id`=0 AND `link`=0; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=1487 AND `source_type`=0 AND `id`=8 AND `link`=9; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=2245 AND `source_type`=0 AND `id`=14 AND `link`=15; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=2375 AND `source_type`=0 AND `id`=8 AND `link`=9; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=16344 AND `source_type`=0 AND `id`=8 AND `link`=9; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=29174 AND `source_type`=0 AND `id`=2 AND `link`=3; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=29174 AND `source_type`=0 AND `id`=3 AND `link`=4; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=29174 AND `source_type`=0 AND `id`=4 AND `link`=5; +-- Timed action scripts aren't supposed to have links set on them +UPDATE `smart_scripts` SET `link`=0, `event_type`=0 WHERE `entryorguid`=83600 AND `source_type`=9 AND `id`=1 AND `link`=2; +UPDATE `smart_scripts` SET `link`=0, `event_type`=0 WHERE `entryorguid`=83600 AND `source_type`=9 AND `id`=2 AND `link`=3; +UPDATE `smart_scripts` SET `event_type`=0 WHERE `entryorguid`=83600 AND `source_type`=9 AND `id`=3 AND `link`=0; +-- Aforementioned issue about links on timed scripts +UPDATE `smart_scripts` SET `event_type`=0 WHERE `entryorguid`=83600 AND `source_type`=9 AND `id`=3 AND `link`=0; +UPDATE `smart_scripts` SET `link`=0, `event_type`=0 WHERE `entryorguid`=305400 AND `source_type`=9 AND `id`=1 AND `link`=2; +UPDATE `smart_scripts` SET `link`=0 WHERE `entryorguid`=15938 AND `source_type`=0 AND `id`=7 AND `link`=8; +-- This one had messed up ID's too +UPDATE `smart_scripts` SET `id`=5, `link`=6 WHERE `entryorguid`=19456 AND `source_type`=0 AND `id`=6 AND `link`=7; +UPDATE `smart_scripts` SET `id`=6 WHERE `entryorguid`=19456 AND `source_type`=0 AND `id`=7 AND `link`=0; +UPDATE `smart_scripts` SET `id`=7 WHERE `entryorguid`=19456 AND `source_type`=0 AND `id`=8 AND `link`=0; +UPDATE `smart_scripts` SET `id`=8 WHERE `entryorguid`=19456 AND `source_type`=0 AND `id`=9 AND `link`=0; +UPDATE `smart_scripts` SET `id`=9 WHERE `entryorguid`=19456 AND `source_type`=0 AND `id`=10 AND `link`=0; diff --git a/sql/updates/world/2013_03_13_03_world_playercreateinfo_spell.sql b/sql/updates/world/2013_03_13_03_world_playercreateinfo_spell.sql new file mode 100644 index 00000000000..0212fef5cd1 --- /dev/null +++ b/sql/updates/world/2013_03_13_03_world_playercreateinfo_spell.sql @@ -0,0 +1,49 @@ +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=0 WHERE `Spell`=56816; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=0 WHERE `Spell`=75461; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=0 WHERE `Spell`=75445; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=669; +UPDATE `playercreateinfo_spell` SET `racemask`=223, `classmask`=8 WHERE `Spell`=2567; +UPDATE `playercreateinfo_spell` SET `racemask`=223, `classmask`=8 WHERE `Spell`=2764; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=8 WHERE `Spell`=1180; +UPDATE `playercreateinfo_spell` SET `racemask`=1029, `classmask`=1 WHERE `Spell`=199; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=33 WHERE `Spell`=668; +UPDATE `playercreateinfo_spell` SET `racemask`=529, `classmask`=0 WHERE `Spell`=5009; +UPDATE `playercreateinfo_spell` SET `racemask`=529, `classmask`=0 WHERE `Spell`=5019; +UPDATE `playercreateinfo_spell` SET `racemask`=1029, `classmask`=32 WHERE `Spell`=202; +UPDATE `playercreateinfo_spell` SET `racemask`=1029, `classmask`=32 WHERE `Spell`=8737; +UPDATE `playercreateinfo_spell` SET `racemask`=1198, `classmask`=32 WHERE `Spell`=196; +UPDATE `playercreateinfo_spell` SET `racemask`=1198, `classmask`=32 WHERE `Spell`=197; +UPDATE `playercreateinfo_spell` SET `racemask`=1028, `classmask`=32 WHERE `Spell`=201; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=32 WHERE `Spell`=674; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=0 WHERE `Spell`=107; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=0 WHERE `Spell`=9116; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=0 WHERE `Spell`=198; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=9077; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=0 WHERE `Spell`=227; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=81; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=203; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=204; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=522; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=1843; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=2382; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=2479; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=3050; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=3365; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=6233; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=6246; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=6247; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=6477; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=6478; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=6603; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=7266; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=7267; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=7355; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=8386; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=9078; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=9125; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=21651; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=21652; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=22027; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=22810; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=45927; +UPDATE `playercreateinfo_spell` SET `racemask`=0, `classmask`=32 WHERE `Spell`=61437; diff --git a/sql/updates/world/2013_03_15_00_world_playercreateinfo_spell.sql b/sql/updates/world/2013_03_15_00_world_playercreateinfo_spell.sql new file mode 100644 index 00000000000..b8d9b13bc52 --- /dev/null +++ b/sql/updates/world/2013_03_15_00_world_playercreateinfo_spell.sql @@ -0,0 +1,184 @@ +UPDATE `playercreateinfo_spell` SET `racemask`=1710, `classmask`=4 WHERE `Spell`=75; +UPDATE `playercreateinfo_spell` SET `racemask`=1279, `classmask`=1 WHERE `Spell`=78; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=81; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=67 WHERE `Spell`=107; +UPDATE `playercreateinfo_spell` SET `racemask`=1745, `classmask`=128 WHERE `Spell`=133; +UPDATE `playercreateinfo_spell` SET `racemask`=1745, `classmask`=128 WHERE `Spell`=168; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=37 WHERE `Spell`=196; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=37 WHERE `Spell`=197; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1107 WHERE `Spell`=198; +UPDATE `playercreateinfo_spell` SET `racemask`=1061, `classmask`=3 WHERE `Spell`=199; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=200; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=39 WHERE `Spell`=201; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=35 WHERE `Spell`=202; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=203; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=204; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1488 WHERE `Spell`=227; +UPDATE `playercreateinfo_spell` SET `racemask`=650, `classmask`=4 WHERE `Spell`=264; +UPDATE `playercreateinfo_spell` SET `racemask`=36, `classmask`=4 WHERE `Spell`=266; +UPDATE `playercreateinfo_spell` SET `racemask`=1186, `classmask`=64 WHERE `Spell`=331; +UPDATE `playercreateinfo_spell` SET `racemask`=1186, `classmask`=64 WHERE `Spell`=403; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=522; +UPDATE `playercreateinfo_spell` SET `racemask`=1693, `classmask`=16 WHERE `Spell`=585; +UPDATE `playercreateinfo_spell` SET `racemask`=1541, `classmask`=2 WHERE `Spell`=635; +UPDATE `playercreateinfo_spell` SET `racemask`=1101, `classmask`=1535 WHERE `Spell`=668; +UPDATE `playercreateinfo_spell` SET `racemask`=690, `classmask`=1535 WHERE `Spell`=669; +UPDATE `playercreateinfo_spell` SET `racemask`=32, `classmask`=1125 WHERE `Spell`=670; +UPDATE `playercreateinfo_spell` SET `racemask`=8, `classmask`=1085 WHERE `Spell`=671; +UPDATE `playercreateinfo_spell` SET `racemask`=4, `classmask`=63 WHERE `Spell`=672; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=40 WHERE `Spell`=674; +UPDATE `playercreateinfo_spell` SET `racemask`=595, `classmask`=256 WHERE `Spell`=686; +UPDATE `playercreateinfo_spell` SET `racemask`=595, `classmask`=256 WHERE `Spell`=687; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=750; +UPDATE `playercreateinfo_spell` SET `racemask`=512, `classmask`=446 WHERE `Spell`=813; +UPDATE `playercreateinfo_spell` SET `racemask`=512, `classmask`=446 WHERE `Spell`=822; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=1293 WHERE `Spell`=1180; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=8 WHERE `Spell`=1752; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=1843; +UPDATE `playercreateinfo_spell` SET `racemask`=1693, `classmask`=16 WHERE `Spell`=2050; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=8 WHERE `Spell`=2098; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=2382; +UPDATE `playercreateinfo_spell` SET `racemask`=1279, `classmask`=1 WHERE `Spell`=2457; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=2479; +UPDATE `playercreateinfo_spell` SET `racemask`=4, `classmask`=63 WHERE `Spell`=2481; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=9 WHERE `Spell`=2567; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=9 WHERE `Spell`=2764; +UPDATE `playercreateinfo_spell` SET `racemask`=1710, `classmask`=4 WHERE `Spell`=2973; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=3050; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=3127; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=3275; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=3276; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=3277; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=3278; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=3365; +UPDATE `playercreateinfo_spell` SET `racemask`=1759, `classmask`=400 WHERE `Spell`=5009; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=4 WHERE `Spell`=5011; +UPDATE `playercreateinfo_spell` SET `racemask`=1759, `classmask`=400 WHERE `Spell`=5019; +UPDATE `playercreateinfo_spell` SET `racemask`=40, `classmask`=1024 WHERE `Spell`=5176; +UPDATE `playercreateinfo_spell` SET `racemask`=40, `classmask`=1024 WHERE `Spell`=5185; +UPDATE `playercreateinfo_spell` SET `racemask`=16, `classmask`=441 WHERE `Spell`=5227; +UPDATE `playercreateinfo_spell` SET `racemask`=1279, `classmask`=1 WHERE `Spell`=5301; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=6233; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=6246; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=6247; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=6477; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=6478; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=39 WHERE `Spell`=6562; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=6603; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=7266; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=7267; +UPDATE `playercreateinfo_spell` SET `racemask`=64, `classmask`=425 WHERE `Spell`=7340; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=7341; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=7355; +UPDATE `playercreateinfo_spell` SET `racemask`=16, `classmask`=441 WHERE `Spell`=7744; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=7928; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=7929; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=7934; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=8386; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=35 WHERE `Spell`=8737; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1135 WHERE `Spell`=9077; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=9078; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=67 WHERE `Spell`=9116; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=9125; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=10840; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=10841; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=10846; +UPDATE `playercreateinfo_spell` SET `racemask`=1710, `classmask`=4 WHERE `Spell`=13358; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=8 WHERE `Spell`=16092; +UPDATE `playercreateinfo_spell` SET `racemask`=16, `classmask`=441 WHERE `Spell`=17737; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=18629; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=18630; +UPDATE `playercreateinfo_spell` SET `racemask`=32, `classmask`=1125 WHERE `Spell`=20549; +UPDATE `playercreateinfo_spell` SET `racemask`=32, `classmask`=1125 WHERE `Spell`=20550; +UPDATE `playercreateinfo_spell` SET `racemask`=32, `classmask`=1125 WHERE `Spell`=20551; +UPDATE `playercreateinfo_spell` SET `racemask`=32, `classmask`=1125 WHERE `Spell`=20552; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=20555; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=20557; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=20558; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=45 WHERE `Spell`=20572; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=365 WHERE `Spell`=20573; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=365 WHERE `Spell`=20574; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=256 WHERE `Spell`=20575; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=4 WHERE `Spell`=20576; +UPDATE `playercreateinfo_spell` SET `racemask`=16, `classmask`=441 WHERE `Spell`=20577; +UPDATE `playercreateinfo_spell` SET `racemask`=16, `classmask`=441 WHERE `Spell`=20579; +UPDATE `playercreateinfo_spell` SET `racemask`=8, `classmask`=1085 WHERE `Spell`=20582; +UPDATE `playercreateinfo_spell` SET `racemask`=8, `classmask`=1085 WHERE `Spell`=20583; +UPDATE `playercreateinfo_spell` SET `racemask`=8, `classmask`=1085 WHERE `Spell`=20585; +UPDATE `playercreateinfo_spell` SET `racemask`=64, `classmask`=425 WHERE `Spell`=20589; +UPDATE `playercreateinfo_spell` SET `racemask`=64, `classmask`=425 WHERE `Spell`=20591; +UPDATE `playercreateinfo_spell` SET `racemask`=64, `classmask`=425 WHERE `Spell`=20592; +UPDATE `playercreateinfo_spell` SET `racemask`=64, `classmask`=425 WHERE `Spell`=20593; +UPDATE `playercreateinfo_spell` SET `racemask`=4, `classmask`=63 WHERE `Spell`=20594; +UPDATE `playercreateinfo_spell` SET `racemask`=4, `classmask`=63 WHERE `Spell`=20595; +UPDATE `playercreateinfo_spell` SET `racemask`=4, `classmask`=63 WHERE `Spell`=20596; +UPDATE `playercreateinfo_spell` SET `racemask`=1, `classmask`=443 WHERE `Spell`=20597; +UPDATE `playercreateinfo_spell` SET `racemask`=1, `classmask`=443 WHERE `Spell`=20598; +UPDATE `playercreateinfo_spell` SET `racemask`=1, `classmask`=443 WHERE `Spell`=20599; +UPDATE `playercreateinfo_spell` SET `racemask`=1, `classmask`=443 WHERE `Spell`=20864; +UPDATE `playercreateinfo_spell` SET `racemask`=1541, `classmask`=2 WHERE `Spell`=21084; +UPDATE `playercreateinfo_spell` SET `racemask`=735, `classmask`=8 WHERE `Spell`=21184; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=73 WHERE `Spell`=21563; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=21651; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=21652; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=22027; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=22810; +UPDATE `playercreateinfo_spell` SET `racemask`=1710, `classmask`=4 WHERE `Spell`=24949; +UPDATE `playercreateinfo_spell` SET `racemask`=512, `classmask`=8 WHERE `Spell`=25046; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=26290; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=26297; +UPDATE `playercreateinfo_spell` SET `racemask`=1541, `classmask`=2 WHERE `Spell`=27762; +UPDATE `playercreateinfo_spell` SET `racemask`=1186, `classmask`=64 WHERE `Spell`=27763; +UPDATE `playercreateinfo_spell` SET `racemask`=40, `classmask`=1024 WHERE `Spell`=27764; +UPDATE `playercreateinfo_spell` SET `racemask`=512, `classmask`=406 WHERE `Spell`=28730; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=247 WHERE `Spell`=28875; +UPDATE `playercreateinfo_spell` SET `racemask`=512, `classmask`=446 WHERE `Spell`=28877; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=208 WHERE `Spell`=28878; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=1 WHERE `Spell`=28880; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=247 WHERE `Spell`=29932; +UPDATE `playercreateinfo_spell` SET `racemask`=1279, `classmask`=1 WHERE `Spell`=32215; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=33391; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=64 WHERE `Spell`=33697; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=256 WHERE `Spell`=33702; +UPDATE `playercreateinfo_spell` SET `racemask`=1710, `classmask`=4 WHERE `Spell`=34082; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=45462; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=45477; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=45902; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=45903; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=45927; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=47541; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=48266; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=49410; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=49576; +UPDATE `playercreateinfo_spell` SET `racemask`=512, `classmask`=32 WHERE `Spell`=50613; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=52665; +UPDATE `playercreateinfo_spell` SET `racemask`=2, `classmask`=32 WHERE `Spell`=54562; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=56816; +UPDATE `playercreateinfo_spell` SET `racemask`=595, `classmask`=256 WHERE `Spell`=58284; +UPDATE `playercreateinfo_spell` SET `racemask`=128, `classmask`=253 WHERE `Spell`=58943; +UPDATE `playercreateinfo_spell` SET `racemask`=8, `classmask`=1085 WHERE `Spell`=58984; +UPDATE `playercreateinfo_spell` SET `racemask`=1, `classmask`=443 WHERE `Spell`=58985; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=1 WHERE `Spell`=59221; +UPDATE `playercreateinfo_spell` SET `racemask`=4, `classmask`=63 WHERE `Spell`=59224; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=2 WHERE `Spell`=59535; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=4 WHERE `Spell`=59536; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=16 WHERE `Spell`=59538; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=32 WHERE `Spell`=59539; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=64 WHERE `Spell`=59540; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=128 WHERE `Spell`=59541; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=2 WHERE `Spell`=59542; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=4 WHERE `Spell`=59543; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=16 WHERE `Spell`=59544; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=32 WHERE `Spell`=59545; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=64 WHERE `Spell`=59547; +UPDATE `playercreateinfo_spell` SET `racemask`=1024, `classmask`=128 WHERE `Spell`=59548; +UPDATE `playercreateinfo_spell` SET `racemask`=1, `classmask`=443 WHERE `Spell`=59752; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=59879; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=59921; +UPDATE `playercreateinfo_spell` SET `racemask`=1541, `classmask`=2 WHERE `Spell`=60091; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=1535 WHERE `Spell`=61437; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=32 WHERE `Spell`=61455; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=256 WHERE `Spell`=75445; +UPDATE `playercreateinfo_spell` SET `racemask`=1791, `classmask`=64 WHERE `Spell`=75461; +UPDATE `playercreateinfo_spell` SET `racemask`=0 WHERE `racemask`=1791; -- All races +UPDATE `playercreateinfo_spell` SET `classmask`=0 WHERE `classmask`=1535; -- All classes diff --git a/sql/updates/world/2013_03_15_01_world_smart_scripts.sql b/sql/updates/world/2013_03_15_01_world_smart_scripts.sql new file mode 100644 index 00000000000..63561342f3c --- /dev/null +++ b/sql/updates/world/2013_03_15_01_world_smart_scripts.sql @@ -0,0 +1,12 @@ +DELETE FROM `smart_scripts` WHERE `entryorguid`=30407 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`id`,`link`,`event_type`,`event_flags`,`event_phase_mask`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`target_type`,`comment`) VALUES +(30407,0,1,11,0,0,0,0,0,0,11,56726,0,1,'Captured Crusader - On Respawn - Apply Nerubian Webs (56726)'), +(30407,1,0,61,0,0,0,0,0,0,22,1,0,1,'Captured Crusader - Linked to id 0 - Set event phase to 1'), +(30407,2,0, 1,0,1,4000,4000,4000,4000,10,70,22,1,'Captured Crusader - Out of combat - Random emote'), +(30407,3,4, 8,0,1,56683,0,0,0,11,56687,0,7,'Captured Crusader - Spell hit of Grab Captured Crusader (56683) - Cast Ride Vehicle (56687)'), +(30407,4,5,61,0,1,0,0,0,0,1,0,0,1,'Captured Crusader - Linked to id 3 - Talk'), +(30407,5,0,61,0,1,0,0,0,0,22,2,0,1,'Captured Crusader - Linked to id 3 - Set event phase to 2'), +(30407,6,0, 1,0,2,8000,8000,8000,8000,1,1,0,1,'Captured Crusader - Out of combat - Talk'), +(30407,7,8,23,1,2,56687,0,0,0,1,2,0,1,'Captured Crusader - Aura Ride Vehicle (56687) removed - Talk'), +(30407,8,9,61,0,2,0,0,0,0,41,5000,0,1,'Captured Crusader - Linked to id 7 - Despawn'), +(30407,9,0,61,0,2,0,0,0,0,22,0,0,1,'Captured Crusader - Linked to id 7 - Set event phase to 0'); diff --git a/src/server/game/AI/SmartScripts/SmartScriptMgr.h b/src/server/game/AI/SmartScripts/SmartScriptMgr.h index 2ff5ce27aa0..3b9109a8f38 100644 --- a/src/server/game/AI/SmartScripts/SmartScriptMgr.h +++ b/src/server/game/AI/SmartScripts/SmartScriptMgr.h @@ -104,8 +104,8 @@ enum SMART_EVENT SMART_EVENT_REWARD_QUEST = 20, // QuestID(0any) SMART_EVENT_REACHED_HOME = 21, // NONE SMART_EVENT_RECEIVE_EMOTE = 22, // EmoteId, CooldownMin, CooldownMax, condition, val1, val2, val3 - SMART_EVENT_HAS_AURA = 23, // Param1 = SpellID, Param2 = Number of Time STacked, Param3/4 RepeatMin, RepeatMax - SMART_EVENT_TARGET_BUFFED = 24, // Param1 = SpellID, Param2 = Number of Time STacked, Param3/4 RepeatMin, RepeatMax + SMART_EVENT_HAS_AURA = 23, // Param1 = SpellID, Param2 = Stack amount, Param3/4 RepeatMin, RepeatMax + SMART_EVENT_TARGET_BUFFED = 24, // Param1 = SpellID, Param2 = Stack amount, Param3/4 RepeatMin, RepeatMax SMART_EVENT_RESET = 25, // Called after combat, when the creature respawn and spawn. SMART_EVENT_IC_LOS = 26, // NoHostile, MaxRnage, CooldownMin, CooldownMax SMART_EVENT_PASSENGER_BOARDED = 27, // CooldownMin, CooldownMax diff --git a/src/server/game/Entities/Creature/Creature.cpp b/src/server/game/Entities/Creature/Creature.cpp index 6f88222bbbc..83cdb52776c 100644 --- a/src/server/game/Entities/Creature/Creature.cpp +++ b/src/server/game/Entities/Creature/Creature.cpp @@ -1294,8 +1294,8 @@ bool Creature::CreateFromProto(uint32 guidlow, uint32 Entry, uint32 vehId, uint3 if (!UpdateEntry(Entry, team, data)) return false; - if (vehId && !CreateVehicleKit(vehId, Entry)) - vehId = 0; + if (vehId) + CreateVehicleKit(vehId, Entry); return true; } diff --git a/src/server/game/Entities/Player/Player.cpp b/src/server/game/Entities/Player/Player.cpp index 195a9118929..6d83ea60dba 100644 --- a/src/server/game/Entities/Player/Player.cpp +++ b/src/server/game/Entities/Player/Player.cpp @@ -25689,6 +25689,7 @@ void Player::ActivateSpec(uint8 spec) ClearComboPointHolders(); ClearAllReactives(); UnsummonAllTotems(); + ExitVehicle(); RemoveAllControlled(); /*RemoveAllAurasOnDeath(); if (GetPet()) diff --git a/src/server/game/Entities/Unit/Unit.cpp b/src/server/game/Entities/Unit/Unit.cpp index 9d581fcdce9..d76885591a5 100644 --- a/src/server/game/Entities/Unit/Unit.cpp +++ b/src/server/game/Entities/Unit/Unit.cpp @@ -12419,6 +12419,9 @@ void Unit::setDeathState(DeathState s) if (IsNonMeleeSpellCasted(false)) InterruptNonMeleeSpells(false); + ExitVehicle(); // Exit vehicle before calling RemoveAllControlled + // vehicles use special type of charm that is not removed by the next function + // triggering an assert UnsummonAllTotems(); RemoveAllControlled(); RemoveAllAurasOnDeath(); @@ -16842,7 +16845,10 @@ void Unit::_EnterVehicle(Vehicle* vehicle, int8 seatId, AuraApplication const* a if (Player* player = ToPlayer()) { if (vehicle->GetBase()->GetTypeId() == TYPEID_PLAYER && player->isInCombat()) + { + vehicle->GetBase()->RemoveAura(const_cast<AuraApplication*>(aurApp)); return; + } } ASSERT(!m_vehicle); @@ -16906,7 +16912,7 @@ void Unit::_ExitVehicle(Position const* exitPosition) Player* player = ToPlayer(); - // If player is on mouted duel and exits the mount should immediatly lose the duel + // If the player is on mounted duel and exits the mount, he should immediatly lose the duel if (player && player->duel && player->duel->isMounted) player->DuelComplete(DUEL_FLED); @@ -16934,14 +16940,19 @@ void Unit::_ExitVehicle(Position const* exitPosition) SendMessageToSet(&data, false); } + float height = pos.GetPositionZ(); + Movement::MoveSplineInit init(this); - init.MoveTo(pos.GetPositionX(), pos.GetPositionY(), pos.GetPositionZ(), false); + + // Creatures without inhabit type air should begin falling after exiting the vehicle + if (GetTypeId() == TYPEID_UNIT && !CanFly() && height > GetMap()->GetWaterOrGroundLevel(pos.GetPositionX(), pos.GetPositionY(), pos.GetPositionZ(), &height) + 0.1f) + init.SetFall(); + + init.MoveTo(pos.GetPositionX(), pos.GetPositionY(), height, false); init.SetFacing(GetOrientation()); init.SetTransportExit(); init.Launch(); - //GetMotionMaster()->MoveFall(); // Enable this once passenger positions are calculater properly (see above) - if (player) player->ResummonPetTemporaryUnSummonedIfAny(); diff --git a/src/server/game/Entities/Vehicle/Vehicle.cpp b/src/server/game/Entities/Vehicle/Vehicle.cpp index 85215c5302b..fad9115ee3d 100755 --- a/src/server/game/Entities/Vehicle/Vehicle.cpp +++ b/src/server/game/Entities/Vehicle/Vehicle.cpp @@ -744,6 +744,31 @@ void Vehicle::RemovePendingEventsForSeat(int8 seatId) } } +/** + * @fn void Vehicle::RemovePendingEventsForSeat(uint8 seatId) + * + * @brief Removes any pending events for given passenger. Executed when vehicle control aura is removed while adding passenger is in progress + * + * @author Shauren + * @date 13-2-2013 + * + * @param passenger Unit that is supposed to enter the vehicle. + */ + +void Vehicle::RemovePendingEventsForPassenger(Unit* passenger) +{ + for (PendingJoinEventContainer::iterator itr = _pendingJoinEvents.begin(); itr != _pendingJoinEvents.end();) + { + if ((*itr)->Passenger == passenger) + { + (*itr)->to_Abort = true; + _pendingJoinEvents.erase(itr++); + } + else + ++itr; + } +} + VehicleJoinEvent::~VehicleJoinEvent() { if (Target) @@ -769,6 +794,7 @@ bool VehicleJoinEvent::Execute(uint64, uint32) { ASSERT(Passenger->IsInWorld()); ASSERT(Target && Target->GetBase()->IsInWorld()); + ASSERT(Target->GetBase()->HasAuraTypeWithCaster(SPELL_AURA_CONTROL_VEHICLE, Passenger->GetGUID())); Target->RemovePendingEventsForSeat(Seat->first); diff --git a/src/server/game/Entities/Vehicle/Vehicle.h b/src/server/game/Entities/Vehicle/Vehicle.h index 70b821de912..67975490ecc 100644 --- a/src/server/game/Entities/Vehicle/Vehicle.h +++ b/src/server/game/Entities/Vehicle/Vehicle.h @@ -71,6 +71,8 @@ class Vehicle : public TransportBase VehicleSeatEntry const* GetSeatForPassenger(Unit const* passenger) const; + void RemovePendingEventsForPassenger(Unit* passenger); + protected: friend class VehicleJoinEvent; uint32 UsableSeatNum; ///< Number of seats that match VehicleSeatEntry::UsableByPlayer, used for proper display flags diff --git a/src/server/game/Globals/ObjectMgr.cpp b/src/server/game/Globals/ObjectMgr.cpp index 08b05b1a7e3..effd2057c68 100644 --- a/src/server/game/Globals/ObjectMgr.cpp +++ b/src/server/game/Globals/ObjectMgr.cpp @@ -3241,7 +3241,7 @@ void ObjectMgr::LoadPlayerInfo() uint32 oldMSTime = getMSTime(); std::string tableName = sWorld->getBoolConfig(CONFIG_START_ALL_SPELLS) ? "playercreateinfo_spell_custom" : "playercreateinfo_spell"; - QueryResult result = WorldDatabase.PQuery("SELECT race, class, Spell FROM %s", tableName.c_str()); + QueryResult result = WorldDatabase.PQuery("SELECT racemask, classmask, Spell FROM %s", tableName.c_str()); if (!result) { @@ -3254,41 +3254,43 @@ void ObjectMgr::LoadPlayerInfo() do { Field* fields = result->Fetch(); + uint32 raceMask = fields[0].GetUInt32(); + uint32 classMask = fields[1].GetUInt32(); + uint32 spellId = fields[2].GetUInt32(); - uint32 current_race = fields[0].GetUInt8(); - if (current_race >= MAX_RACES) + if (raceMask != 0 && !(raceMask & RACEMASK_ALL_PLAYABLE)) { - sLog->outError(LOG_FILTER_SQL, "Wrong race %u in `playercreateinfo_spell` table, ignoring.", current_race); + sLog->outError(LOG_FILTER_SQL, "Wrong race mask %u in `playercreateinfo_spell` table, ignoring.", raceMask); continue; } - uint32 current_class = fields[1].GetUInt8(); - if (current_class >= MAX_CLASSES) + if (classMask != 0 && !(classMask & CLASSMASK_ALL_PLAYABLE)) { - sLog->outError(LOG_FILTER_SQL, "Wrong class %u in `playercreateinfo_spell` table, ignoring.", current_class); + sLog->outError(LOG_FILTER_SQL, "Wrong class mask %u in `playercreateinfo_spell` table, ignoring.", classMask); continue; } - if (!current_race || !current_class) + for (uint32 raceIndex = RACE_HUMAN; raceIndex < MAX_RACES; ++raceIndex) { - uint32 min_race = current_race ? current_race : 1; - uint32 max_race = current_race ? current_race + 1 : MAX_RACES; - uint32 min_class = current_class ? current_class : 1; - uint32 max_class = current_class ? current_class + 1 : MAX_CLASSES; - for (uint32 r = min_race; r < max_race; ++r) - for (uint32 c = min_class; c < max_class; ++c) - if (PlayerInfo* info = _playerInfo[r][c]) - info->spell.push_back(fields[2].GetUInt32()); - } - else if (PlayerInfo* info = _playerInfo[current_race][current_class]) - info->spell.push_back(fields[2].GetUInt32()); - else - { - sLog->outError(LOG_FILTER_SQL, "Wrong race: %u, class: %u combination in `playercreateinfo_spell` table, ignoring.", current_race, current_class); - continue; + if (raceMask == 0 || ((1 << (raceIndex - 1)) & raceMask)) + { + for (uint32 classIndex = CLASS_WARRIOR; classIndex < MAX_CLASSES; ++classIndex) + { + if (classMask == 0 || ((1 << (classIndex - 1)) & classMask)) + { + if (PlayerInfo* info = _playerInfo[raceIndex][classIndex]) + { + info->spell.push_back(spellId); + ++count; + } + // We need something better here, the check is not accounting for spells used by multiple races/classes but not all of them. + // Either split the masks per class, or per race, which kind of kills the point yet. + // else if (raceMask != 0 && classMask != 0) + // sLog->outError(LOG_FILTER_SQL, "Racemask/classmask (%u/%u) combination was found containing an invalid race/class combination (%u/%u) in `playercreateinfo_spell` (Spell %u), ignoring.", raceMask, classMask, raceIndex, classIndex, spellId); + } + } + } } - - ++count; } while (result->NextRow()); diff --git a/src/server/game/Spells/Auras/SpellAuraEffects.cpp b/src/server/game/Spells/Auras/SpellAuraEffects.cpp index e3d266eaaa5..24c58a666d1 100644 --- a/src/server/game/Spells/Auras/SpellAuraEffects.cpp +++ b/src/server/game/Spells/Auras/SpellAuraEffects.cpp @@ -2323,7 +2323,7 @@ void AuraEffect::HandleAuraModPacifyAndSilence(AuraApplication const* aurApp, ui Unit* target = aurApp->GetTarget(); // Vengeance of the Blue Flight (@todo REMOVE THIS!) - /// @workaround + /// @workaround if (m_spellInfo->Id == 45839) { if (apply) @@ -2926,6 +2926,9 @@ void AuraEffect::HandleAuraControlVehicle(AuraApplication const* aurApp, uint8 m } else { + // Remove pending passengers before exiting vehicle - might cause an Uninstall + target->GetVehicleKit()->RemovePendingEventsForPassenger(caster); + if (GetId() == 53111) // Devour Humanoid { target->Kill(caster); diff --git a/src/server/scripts/Northrend/FrozenHalls/PitOfSaron/boss_scourgelord_tyrannus.cpp b/src/server/scripts/Northrend/FrozenHalls/PitOfSaron/boss_scourgelord_tyrannus.cpp index 8b771f507c2..3d22bac4376 100644 --- a/src/server/scripts/Northrend/FrozenHalls/PitOfSaron/boss_scourgelord_tyrannus.cpp +++ b/src/server/scripts/Northrend/FrozenHalls/PitOfSaron/boss_scourgelord_tyrannus.cpp @@ -54,7 +54,7 @@ enum Yells SAY_SYLVANAS_OUTRO_4 = 4 }; -enum Spelsl +enum Spells { SPELL_OVERLORD_BRAND = 69172, SPELL_OVERLORD_BRAND_HEAL = 69190, diff --git a/src/server/scripts/Outland/zone_shadowmoon_valley.cpp b/src/server/scripts/Outland/zone_shadowmoon_valley.cpp index 5a9fcba8fd4..b8f96e373f3 100644 --- a/src/server/scripts/Outland/zone_shadowmoon_valley.cpp +++ b/src/server/scripts/Outland/zone_shadowmoon_valley.cpp @@ -1891,16 +1891,11 @@ class spell_unlocking_zuluheds_chains : public SpellScriptLoader { PrepareSpellScript(spell_unlocking_zuluheds_chains_SpellScript); - bool Load() - { - return GetCaster()->GetTypeId() == TYPEID_PLAYER; - } - void HandleAfterHit() { - Player* caster = GetCaster()->ToPlayer(); - if (caster->GetQuestStatus(QUEST_ZULUHED) == QUEST_STATUS_INCOMPLETE) - caster->KilledMonsterCredit(NPC_KARYNAKU, 0); + if (GetCaster()->GetTypeId() == TYPEID_PLAYER) + if (Creature* karynaku = GetCaster()->FindNearestCreature(NPC_KARYNAKU, 15.0f)) + GetCaster()->ToPlayer()->CastedCreatureOrGO(NPC_KARYNAKU, karynaku->GetGUID(), GetSpellInfo()->Id); } void Register() |