Original Here: [SQL] Glyph vendors - #5 by hoppus
Tested with 3.3.5a
SET @Deathknight := 90500 ;
SET @Druid := @Deathknight+1 ;
SET @Hunter := @Deathknight+2 ;
SET @Mage := @Deathknight+3 ;
SET @Paladin := @Deathknight+4 ;
SET @Priest := @Deathknight+5 ;
SET @Rogue := @Deathknight+6 ;
SET @Shaman := @Deathknight+7 ;
SET @Warlock := @Deathknight+8 ;
SET @Warrior := @Deathknight+9 ;
DELETE FROM `creature_template` WHERE `entry` BETWEEN @Deathknight AND @Deathknight+9;
DELETE FROM `npc_vendor` WHERE `entry` BETWEEN @Deathknight AND @Deathknight+9;
DELETE FROM `creature` WHERE `guid` BETWEEN @guid AND @guid+9;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `spell_school_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
(@Deathknight,0,0,0,0,0,26000,0,0,0,'Deathknight','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Druid,0,0,0,0,0,29996,0,0,0,'Druid','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Hunter,0,0,0,0,0,28185,0,0,0,'Hunter','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Mage,0,0,0,0,0,22957,0,0,0,'Mage','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Paladin,0,0,0,0,0,29480,0,0,0,'Paladin','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Priest,0,0,0,0,0,31117,0,0,0,'Priest','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Rogue,0,0,0,0,0,27942,0,0,0,'Rogue','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Shaman,0,0,0,0,0,31194,0,0,0,'Shaman','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Warlock,0,0,0,0,0,30008,0,0,0,'Warlock','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0),
(@Warrior,0,0,0,0,0,22929,0,0,0,'Warrior','Glyph','',0,80,80,0,35,4224,1,1,1,0,0,1500,0,0,0,2,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,1,1,1,0,0,0,0,1,0,0,2,'',0);
INSERT INTO npc_vendor (entry, slot, item, maxcount, incrtime, ExtendedCost, VerifiedBuild) VALUES
(@Deathknight,0,43533,0,0,0,0),
(@Deathknight,0,43826,0,0,0,0),
(@Deathknight,0,43535,0,0,0,0),
(@Deathknight,0,43536,0,0,0,0),
(@Deathknight,0,43537,0,0,0,0),
(@Deathknight,0,43671,0,0,0,0),
(@Deathknight,0,45799,0,0,0,0),
(@Deathknight,0,43538,0,0,0,0),
(@Deathknight,0,45804,0,0,0,0),
(@Deathknight,0,43542,0,0,0,0),
(@Deathknight,0,43541,0,0,0,0),
(@Deathknight,0,43827,0,0,0,0),
(@Deathknight,0,43539,0,0,0,0),
(@Deathknight,0,45805,0,0,0,0),
(@Deathknight,0,43543,0,0,0,0),
(@Deathknight,0,43534,0,0,0,0),
(@Deathknight,0,43544,0,0,0,0),
(@Deathknight,0,45806,0,0,0,0),
(@Deathknight,0,45800,0,0,0,0),
(@Deathknight,0,43545,0,0,0,0),
(@Deathknight,0,43546,0,0,0,0),
(@Deathknight,0,43547,0,0,0,0),
(@Deathknight,0,43672,0,0,0,0),
(@Deathknight,0,43548,0,0,0,0),
(@Deathknight,0,43673,0,0,0,0),
(@Deathknight,0,43550,0,0,0,0),
(@Deathknight,0,43825,0,0,0,0),
(@Deathknight,0,43551,0,0,0,0),
(@Deathknight,0,43552,0,0,0,0),
(@Deathknight,0,43549,0,0,0,0),
(@Deathknight,0,43553,0,0,0,0),
(@Deathknight,0,45803,0,0,0,0),
(@Deathknight,0,43554,0,0,0,0),
(@Druid,0,43316,0,0,0,0),
(@Druid,0,45623,0,0,0,0),
(@Druid,0,45601,0,0,0,0),
(@Druid,0,43334,0,0,0,0),
(@Druid,0,48720,0,0,0,0),
(@Druid,0,43674,0,0,0,0),
(@Druid,0,44928,0,0,0,0),
(@Druid,0,40896,0,0,0,0),
(@Druid,0,40899,0,0,0,0),
(@Druid,0,40914,0,0,0,0),
(@Druid,0,40920,0,0,0,0),
(@Druid,0,40915,0,0,0,0),
(@Druid,0,40900,0,0,0,0),
(@Druid,0,40897,0,0,0,0),
(@Druid,0,45622,0,0,0,0),
(@Druid,0,40923,0,0,0,0),
(@Druid,0,45603,0,0,0,0),
(@Druid,0,40903,0,0,0,0),
(@Druid,0,50125,0,0,0,0),
(@Druid,0,40909,0,0,0,0),
(@Druid,0,40912,0,0,0,0),
(@Druid,0,40913,0,0,0,0),
(@Druid,0,40902,0,0,0,0),
(@Druid,0,45604,0,0,0,0),
(@Druid,0,40901,0,0,0,0),
(@Druid,0,40921,0,0,0,0),
(@Druid,0,40916,0,0,0,0),
(@Druid,0,46372,0,0,0,0),
(@Druid,0,40906,0,0,0,0),
(@Druid,0,43335,0,0,0,0),
(@Druid,0,43332,0,0,0,0),
(@Druid,0,44922,0,0,0,0),
(@Druid,0,43331,0,0,0,0),
(@Druid,0,45602,0,0,0,0),
(@Druid,0,40922,0,0,0,0),
(@Hunter,0,42897,0,0,0,0),
(@Hunter,0,42898,0,0,0,0),
(@Hunter,0,42901,0,0,0,0),
(@Hunter,0,42902,0,0,0,0),
(@Hunter,0,45625,0,0,0,0),
(@Hunter,0,42903,0,0,0,0),
(@Hunter,0,42904,0,0,0,0),
(@Hunter,0,45731,0,0,0,0),
(@Hunter,0,45733,0,0,0,0),
(@Hunter,0,43351,0,0,0,0),
(@Hunter,0,42905,0,0,0,0),
(@Hunter,0,42906,0,0,0,0),
(@Hunter,0,42907,0,0,0,0),
(@Hunter,0,42908,0,0,0,0),
(@Hunter,0,45732,0,0,0,0),
(@Hunter,0,43350,0,0,0,0),
(@Hunter,0,42900,0,0,0,0),
(@Hunter,0,42910,0,0,0,0),
(@Hunter,0,43354,0,0,0,0),
(@Hunter,0,42911,0,0,0,0),
(@Hunter,0,45735,0,0,0,0),
(@Hunter,0,43338,0,0,0,0),
(@Hunter,0,43356,0,0,0,0),
(@Hunter,0,45734,0,0,0,0),
(@Hunter,0,42912,0,0,0,0),
(@Hunter,0,42913,0,0,0,0),
(@Hunter,0,42914,0,0,0,0),
(@Hunter,0,42899,0,0,0,0),
(@Hunter,0,42909,0,0,0,0),
(@Hunter,0,43355,0,0,0,0),
(@Hunter,0,42915,0,0,0,0),
(@Hunter,0,42916,0,0,0,0),
(@Hunter,0,42917,0,0,0,0),
(@Mage,0,45738,0,0,0,0),
(@Mage,0,44955,0,0,0,0),
(@Mage,0,42734,0,0,0,0),
(@Mage,0,43339,0,0,0,0),
(@Mage,0,42735,0,0,0,0),
(@Mage,0,42736,0,0,0,0),
(@Mage,0,44920,0,0,0,0),
(@Mage,0,42737,0,0,0,0),
(@Mage,0,45736,0,0,0,0),
(@Mage,0,50045,0,0,0,0),
(@Mage,0,42738,0,0,0,0),
(@Mage,0,42740,0,0,0,0),
(@Mage,0,43357,0,0,0,0),
(@Mage,0,42739,0,0,0,0),
(@Mage,0,43359,0,0,0,0),
(@Mage,0,42741,0,0,0,0),
(@Mage,0,43360,0,0,0,0),
(@Mage,0,42742,0,0,0,0),
(@Mage,0,44684,0,0,0,0),
(@Mage,0,42743,0,0,0,0),
(@Mage,0,45740,0,0,0,0),
(@Mage,0,42744,0,0,0,0),
(@Mage,0,42745,0,0,0,0),
(@Mage,0,42746,0,0,0,0),
(@Mage,0,42748,0,0,0,0),
(@Mage,0,45737,0,0,0,0),
(@Mage,0,42749,0,0,0,0),
(@Mage,0,42750,0,0,0,0),
(@Mage,0,45739,0,0,0,0),
(@Mage,0,42751,0,0,0,0),
(@Mage,0,42752,0,0,0,0),
(@Mage,0,42753,0,0,0,0),
(@Mage,0,42747,0,0,0,0),
(@Mage,0,43364,0,0,0,0),
(@Mage,0,43361,0,0,0,0),
(@Mage,0,42754,0,0,0,0),
(@Paladin,0,41101,0,0,0,0),
(@Paladin,0,41107,0,0,0,0),
(@Paladin,0,45741,0,0,0,0),
(@Paladin,0,43365,0,0,0,0),
(@Paladin,0,43340,0,0,0,0),
(@Paladin,0,43366,0,0,0,0),
(@Paladin,0,41104,0,0,0,0),
(@Paladin,0,41099,0,0,0,0),
(@Paladin,0,41098,0,0,0,0),
(@Paladin,0,45745,0,0,0,0),
(@Paladin,0,45743,0,0,0,0),
(@Paladin,0,41108,0,0,0,0),
(@Paladin,0,41103,0,0,0,0),
(@Paladin,0,41105,0,0,0,0),
(@Paladin,0,41095,0,0,0,0),
(@Paladin,0,45742,0,0,0,0),
(@Paladin,0,41097,0,0,0,0),
(@Paladin,0,41106,0,0,0,0),
(@Paladin,0,45746,0,0,0,0),
(@Paladin,0,43867,0,0,0,0),
(@Paladin,0,41092,0,0,0,0),
(@Paladin,0,43367,0,0,0,0),
(@Paladin,0,41100,0,0,0,0),
(@Paladin,0,45747,0,0,0,0),
(@Paladin,0,41094,0,0,0,0),
(@Paladin,0,41110,0,0,0,0),
(@Paladin,0,43868,0,0,0,0),
(@Paladin,0,43869,0,0,0,0),
(@Paladin,0,41109,0,0,0,0),
(@Paladin,0,43368,0,0,0,0),
(@Paladin,0,45744,0,0,0,0),
(@Paladin,0,41096,0,0,0,0),
(@Paladin,0,43369,0,0,0,0),
(@Paladin,0,41102,0,0,0,0),
(@Priest,0,42396,0,0,0,0),
(@Priest,0,42397,0,0,0,0),
(@Priest,0,45753,0,0,0,0),
(@Priest,0,42398,0,0,0,0),
(@Priest,0,43342,0,0,0,0),
(@Priest,0,42399,0,0,0,0),
(@Priest,0,42400,0,0,0,0),
(@Priest,0,43371,0,0,0,0),
(@Priest,0,45755,0,0,0,0),
(@Priest,0,42401,0,0,0,0),
(@Priest,0,45758,0,0,0,0),
(@Priest,0,42402,0,0,0,0),
(@Priest,0,43370,0,0,0,0),
(@Priest,0,42403,0,0,0,0),
(@Priest,0,42404,0,0,0,0),
(@Priest,0,42405,0,0,0,0),
(@Priest,0,42415,0,0,0,0),
(@Priest,0,45757,0,0,0,0),
(@Priest,0,45760,0,0,0,0),
(@Priest,0,45756,0,0,0,0),
(@Priest,0,42408,0,0,0,0),
(@Priest,0,42409,0,0,0,0),
(@Priest,0,42410,0,0,0,0),
(@Priest,0,42411,0,0,0,0),
(@Priest,0,42412,0,0,0,0),
(@Priest,0,43373,0,0,0,0),
(@Priest,0,42407,0,0,0,0),
(@Priest,0,43372,0,0,0,0),
(@Priest,0,42414,0,0,0,0),
(@Priest,0,42406,0,0,0,0),
(@Priest,0,43374,0,0,0,0),
(@Priest,0,42416,0,0,0,0),
(@Priest,0,42417,0,0,0,0),
(@Rogue,0,42954,0,0,0,0),
(@Rogue,0,42955,0,0,0,0),
(@Rogue,0,42956,0,0,0,0),
(@Rogue,0,42957,0,0,0,0),
(@Rogue,0,43379,0,0,0,0),
(@Rogue,0,45769,0,0,0,0),
(@Rogue,0,42958,0,0,0,0),
(@Rogue,0,42959,0,0,0,0),
(@Rogue,0,43376,0,0,0,0),
(@Rogue,0,42960,0,0,0,0),
(@Rogue,0,42961,0,0,0,0),
(@Rogue,0,42962,0,0,0,0),
(@Rogue,0,45766,0,0,0,0),
(@Rogue,0,42963,0,0,0,0),
(@Rogue,0,42964,0,0,0,0),
(@Rogue,0,42965,0,0,0,0),
(@Rogue,0,42966,0,0,0,0),
(@Rogue,0,42967,0,0,0,0),
(@Rogue,0,45761,0,0,0,0),
(@Rogue,0,45762,0,0,0,0),
(@Rogue,0,45768,0,0,0,0),
(@Rogue,0,43377,0,0,0,0),
(@Rogue,0,43343,0,0,0,0),
(@Rogue,0,42968,0,0,0,0),
(@Rogue,0,42969,0,0,0,0),
(@Rogue,0,43378,0,0,0,0),
(@Rogue,0,42970,0,0,0,0),
(@Rogue,0,45764,0,0,0,0),
(@Rogue,0,42972,0,0,0,0),
(@Rogue,0,42973,0,0,0,0),
(@Rogue,0,42974,0,0,0,0),
(@Rogue,0,45767,0,0,0,0),
(@Rogue,0,43380,0,0,0,0),
(@Rogue,0,42971,0,0,0,0),
(@Shaman,0,43381,0,0,0,0),
(@Shaman,0,41517,0,0,0,0),
(@Shaman,0,41518,0,0,0,0),
(@Shaman,0,45775,0,0,0,0),
(@Shaman,0,41527,0,0,0,0),
(@Shaman,0,41552,0,0,0,0),
(@Shaman,0,45771,0,0,0,0),
(@Shaman,0,41529,0,0,0,0),
(@Shaman,0,41530,0,0,0,0),
(@Shaman,0,41531,0,0,0,0),
(@Shaman,0,41532,0,0,0,0),
(@Shaman,0,41547,0,0,0,0),
(@Shaman,0,43725,0,0,0,0),
(@Shaman,0,41533,0,0,0,0),
(@Shaman,0,41534,0,0,0,0),
(@Shaman,0,45777,0,0,0,0),
(@Shaman,0,41524,0,0,0,0),
(@Shaman,0,41540,0,0,0,0),
(@Shaman,0,41535,0,0,0,0),
(@Shaman,0,41536,0,0,0,0),
(@Shaman,0,41537,0,0,0,0),
(@Shaman,0,41538,0,0,0,0),
(@Shaman,0,43385,0,0,0,0),
(@Shaman,0,45772,0,0,0,0),
(@Shaman,0,41526,0,0,0,0),
(@Shaman,0,45778,0,0,0,0),
(@Shaman,0,41539,0,0,0,0),
(@Shaman,0,45770,0,0,0,0),
(@Shaman,0,44923,0,0,0,0),
(@Shaman,0,45776,0,0,0,0),
(@Shaman,0,43344,0,0,0,0),
(@Shaman,0,41541,0,0,0,0),
(@Shaman,0,43386,0,0,0,0),
(@Shaman,0,43388,0,0,0,0),
(@Shaman,0,41542,0,0,0,0),
(@Warlock,0,45781,0,0,0,0),
(@Warlock,0,42454,0,0,0,0),
(@Warlock,0,42455,0,0,0,0),
(@Warlock,0,42456,0,0,0,0),
(@Warlock,0,43392,0,0,0,0),
(@Warlock,0,42457,0,0,0,0),
(@Warlock,0,45782,0,0,0,0),
(@Warlock,0,43390,0,0,0,0),
(@Warlock,0,43393,0,0,0,0),
(@Warlock,0,42458,0,0,0,0),
(@Warlock,0,42459,0,0,0,0),
(@Warlock,0,42460,0,0,0,0),
(@Warlock,0,45779,0,0,0,0),
(@Warlock,0,42461,0,0,0,0),
(@Warlock,0,42462,0,0,0,0),
(@Warlock,0,42463,0,0,0,0),
(@Warlock,0,42464,0,0,0,0),
(@Warlock,0,42465,0,0,0,0),
(@Warlock,0,42453,0,0,0,0),
(@Warlock,0,43391,0,0,0,0),
(@Warlock,0,45785,0,0,0,0),
(@Warlock,0,45780,0,0,0,0),
(@Warlock,0,50077,0,0,0,0),
(@Warlock,0,42466,0,0,0,0),
(@Warlock,0,42467,0,0,0,0),
(@Warlock,0,42468,0,0,0,0),
(@Warlock,0,45783,0,0,0,0),
(@Warlock,0,42469,0,0,0,0),
(@Warlock,0,45789,0,0,0,0),
(@Warlock,0,43394,0,0,0,0),
(@Warlock,0,42470,0,0,0,0),
(@Warlock,0,42471,0,0,0,0),
(@Warlock,0,43389,0,0,0,0),
(@Warlock,0,42472,0,0,0,0),
(@Warlock,0,42473,0,0,0,0),
(@Warrior,0,43420,0,0,0,0),
(@Warrior,0,43395,0,0,0,0),
(@Warrior,0,45790,0,0,0,0),
(@Warrior,0,43425,0,0,0,0),
(@Warrior,0,43396,0,0,0,0),
(@Warrior,0,43412,0,0,0,0),
(@Warrior,0,43397,0,0,0,0),
(@Warrior,0,43414,0,0,0,0),
(@Warrior,0,49084,0,0,0,0),
(@Warrior,0,43415,0,0,0,0),
(@Warrior,0,43400,0,0,0,0),
(@Warrior,0,45794,0,0,0,0),
(@Warrior,0,43416,0,0,0,0),
(@Warrior,0,43417,0,0,0,0),
(@Warrior,0,43418,0,0,0,0),
(@Warrior,0,43419,0,0,0,0),
(@Warrior,0,43426,0,0,0,0),
(@Warrior,0,43398,0,0,0,0),
(@Warrior,0,43421,0,0,0,0),
(@Warrior,0,43422,0,0,0,0),
(@Warrior,0,43413,0,0,0,0),
(@Warrior,0,43423,0,0,0,0),
(@Warrior,0,43430,0,0,0,0),
(@Warrior,0,43424,0,0,0,0),
(@Warrior,0,45797,0,0,0,0),
(@Warrior,0,45792,0,0,0,0),
(@Warrior,0,45795,0,0,0,0),
(@Warrior,0,43427,0,0,0,0),
(@Warrior,0,43428,0,0,0,0),
(@Warrior,0,43429,0,0,0,0),
(@Warrior,0,43399,0,0,0,0),
(@Warrior,0,43431,0,0,0,0),
(@Warrior,0,45793,0,0,0,0),
(@Warrior,0,43432,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`zoneId`,areaId,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`wander_distance`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`,`ScriptName`,`VerifiedBuild`) VALUES
(@guid,@Deathknight,571,627,504,1,1,0,0,5812.661621,422.30899,658.783203,1.551117,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+1,@Druid,571,627,504,1,1,0,0,5820.927246,423.155365,658.784851,1.877057,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+2,@Hunter,571,627,504,1,1,0,0,5828.672363,426.6763,658.783203,2.180222,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+3,@Mage,571,627,504,1,1,0,0,5834.879395,432.276611,658.783325,2.540715,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+4,@Paladin,571,627,504,1,1,0,0,5839.09082,439.533752,658.783264,2.803823,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+5,@Priest,571,627,504,1,1,0,0,5804.361816,424.023254,658.78302,1.2291,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+6,@Rogue,571,627,504,1,1,0,0,5797.117676,428.208862,658.783142,0.859963,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+7,@Shaman,571,627,504,1,1,0,0,5791.430664,434.421753,658.783386,0.589001,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+8,@Warlock,571,627,504,1,1,0,0,5787.958008,442.121826,658.783386,0.302329,100,0,0,4274,3994,0,4224,0,0,'',0),
(@guid+9,@Warrior,571,627,504,1,1,0,0,5787.085938,450.549133,658.783508,6.173172,100,0,0,4274,3994,0,4224,0,0,'',0);
Run this code in world database. Restart your server. Then spawn them in with:
Deathknight → .npc add 90500
Druid → .npc add 90501
Hunter → .npc add 90502
Mage → .npc add 90503
Paladin → .npc add 90504
Priest → .npc add 90505
Rogue → .npc add 90506
Shaman → .npc add 90507
Warlock → .npc add 90508
Warrior → .npc add 90509