REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (200095, 0, 0, 0, 0, 0, 29865, 0, 29865, 0, 'Tier 9', 'Rasta-wow', '', 0, 83, 83, 0, 35, 35, 4224, 2, 2, 1, 2, 1000, 1500, 0, 1000, 1000, 1500, 1500, 2, 2, 0, 0, 0, 0, 0, 0, 1500, 1747, 1500, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 918, 0, 2, '', 12340);
DELETE FROM `npc_vendor` WHERE (`entry`=200095);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(200095, 0, 47763, 0, 0, 0),
(200095, 0, 47764, 0, 0, 0),
(200095, 0, 47765, 0, 0, 0),
(200095, 0, 47766, 0, 0, 0),
(200095, 0, 47767, 0, 0, 0),
(200095, 0, 47793, 0, 0, 0),
(200095, 0, 47794, 0, 0, 0),
(200095, 0, 47795, 0, 0, 0),
(200095, 0, 47796, 0, 0, 0),
(200095, 0, 47797, 0, 0, 0),
(200095, 0, 48057, 0, 0, 0),
(200095, 0, 48058, 0, 0, 0),
(200095, 0, 48059, 0, 0, 0),
(200095, 0, 48060, 0, 0, 0),
(200095, 0, 48061, 0, 0, 0),
(200095, 0, 48087, 0, 0, 0),
(200095, 0, 48088, 0, 0, 0),
(200095, 0, 48089, 0, 0, 0),
(200095, 0, 48090, 0, 0, 0),
(200095, 0, 48091, 0, 0, 0),
(200095, 0, 48143, 0, 0, 0),
(200095, 0, 48144, 0, 0, 0),
(200095, 0, 48145, 0, 0, 0),
(200095, 0, 48146, 0, 0, 0),
(200095, 0, 48147, 0, 0, 0),
(200095, 0, 48173, 0, 0, 0),
(200095, 0, 48174, 0, 0, 0),
(200095, 0, 48175, 0, 0, 0),
(200095, 0, 48176, 0, 0, 0),
(200095, 0, 48177, 0, 0, 0),
(200095, 0, 48198, 0, 0, 0),
(200095, 0, 48199, 0, 0, 0),
(200095, 0, 48200, 0, 0, 0),
(200095, 0, 48201, 0, 0, 0),
(200095, 0, 48202, 0, 0, 0),
(200095, 0, 48233, 0, 0, 0),
(200095, 0, 48234, 0, 0, 0),
(200095, 0, 48235, 0, 0, 0),
(200095, 0, 48236, 0, 0, 0),
(200095, 0, 48237, 0, 0, 0),
(200095, 0, 48265, 0, 0, 0),
(200095, 0, 48266, 0, 0, 0),
(200095, 0, 48267, 0, 0, 0),
(200095, 0, 48268, 0, 0, 0),
(200095, 0, 48269, 0, 0, 0),
(200095, 0, 48305, 0, 0, 0),
(200095, 0, 48306, 0, 0, 0),
(200095, 0, 48307, 0, 0, 0),
(200095, 0, 48308, 0, 0, 0),
(200095, 0, 48309, 0, 0, 0),
(200095, 0, 48326, 0, 0, 0),
(200095, 0, 48327, 0, 0, 0),
(200095, 0, 48328, 0, 0, 0),
(200095, 0, 48329, 0, 0, 0),
(200095, 0, 48330, 0, 0, 0),
(200095, 0, 48356, 0, 0, 0),
(200095, 0, 48357, 0, 0, 0),
(200095, 0, 48358, 0, 0, 0),
(200095, 0, 48359, 0, 0, 0),
(200095, 0, 48360, 0, 0, 0),
(200095, 0, 48396, 0, 0, 0),
(200095, 0, 48397, 0, 0, 0),
(200095, 0, 48398, 0, 0, 0),
(200095, 0, 48399, 0, 0, 0),
(200095, 0, 48400, 0, 0, 0),
(200095, 0, 48466, 0, 0, 0),
(200095, 0, 48467, 0, 0, 0),
(200095, 0, 48468, 0, 0, 0),
(200095, 0, 48469, 0, 0, 0),
(200095, 0, 48470, 0, 0, 0),
(200095, 0, 48491, 0, 0, 0),
(200095, 0, 48492, 0, 0, 0),
(200095, 0, 48493, 0, 0, 0),
(200095, 0, 48494, 0, 0, 0),
(200095, 0, 48495, 0, 0, 0),
(200095, 0, 48548, 0, 0, 0),
(200095, 0, 48549, 0, 0, 0),
(200095, 0, 48550, 0, 0, 0),
(200095, 0, 48551, 0, 0, 0),
(200095, 0, 48552, 0, 0, 0),
(200095, 0, 48585, 0, 0, 0),
(200095, 0, 48586, 0, 0, 0),
(200095, 0, 48587, 0, 0, 0),
(200095, 0, 48588, 0, 0, 0),
(200095, 0, 48589, 0, 0, 0),
(200095, 0, 48617, 0, 0, 0),
(200095, 0, 48618, 0, 0, 0),
(200095, 0, 48619, 0, 0, 0),
(200095, 0, 48620, 0, 0, 0),
(200095, 0, 48621, 0, 0, 0),
(200095, 0, 48647, 0, 0, 0),
(200095, 0, 48648, 0, 0, 0),
(200095, 0, 48649, 0, 0, 0),
(200095, 0, 48650, 0, 0, 0),
(200095, 0, 48651, 0, 0, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70021, 0, 0, 0, 0, 0, 29516, 0, 29516, 0, 'Alchemy, 'Rasta-wow', '', 0, 83, 83, 0, 35, 35, 81, 2, 2, 1, 2, 119, 179, 0, 45, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 95, 143, 36, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 1, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1949, 0, 2, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70021);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70021, 2275, 10, 0, 0, 5),
(70021, 2280, 500, 171, 50, 10),
(70021, 2331, 100, 171, 25, 0),
(70021, 2332, 150, 171, 40, 0),
(70021, 2334, 250, 171, 50, 0),
(70021, 2337, 1000, 171, 55, 0),
(70021, 3170, 50, 171, 15, 0),
(70021, 3171, 500, 171, 90, 0),
(70021, 3173, 1500, 171, 120, 0),
(70021, 3176, 1500, 171, 125, 0),
(70021, 3177, 2000, 171, 130, 0),
(70021, 3447, 4000, 171, 110, 0),
(70021, 3448, 5000, 171, 165, 0),
(70021, 3450, 6000, 171, 175, 0),
(70021, 3452, 5000, 171, 160, 0),
(70021, 3465, 5000, 171, 125, 20),
(70021, 7179, 450, 171, 90, 0),
(70021, 7181, 5000, 171, 155, 0),
(70021, 7836, 250, 171, 80, 0),
(70021, 7837, 1000, 171, 130, 0),
(70021, 7841, 1000, 171, 100, 0),
(70021, 7845, 3000, 171, 140, 0),
(70021, 11448, 9000, 171, 205, 0),
(70021, 11449, 6500, 171, 185, 0),
(70021, 11450, 7500, 171, 195, 0),
(70021, 11451, 8000, 171, 205, 0),
(70021, 11457, 10000, 171, 215, 0),
(70021, 11460, 5000, 171, 230, 0),
(70021, 11461, 10000, 171, 235, 0),
(70021, 11465, 12000, 171, 235, 0),
(70021, 11467, 12000, 171, 240, 0),
(70021, 11478, 14000, 171, 250, 0),
(70021, 11612, 50000, 171, 200, 35),
(70021, 12609, 8000, 171, 200, 0),
(70021, 15833, 10000, 171, 230, 0),
(70021, 17551, 15000, 171, 250, 0),
(70021, 17552, 15000, 171, 255, 0),
(70021, 17553, 15000, 171, 260, 0),
(70021, 17555, 15000, 171, 270, 0),
(70021, 17556, 20000, 171, 275, 0),
(70021, 17557, 20000, 171, 275, 0),
(70021, 17572, 20000, 171, 285, 0),
(70021, 17573, 20000, 171, 285, 0),
(70021, 22808, 10000, 171, 215, 0),
(70021, 28544, 25000, 171, 305, 0),
(70021, 28545, 25000, 171, 310, 0),
(70021, 28551, 50000, 171, 325, 0),
(70021, 28597, 100000, 171, 275, 50),
(70021, 33732, 20000, 171, 300, 0),
(70021, 33733, 25000, 171, 310, 0),
(70021, 33738, 20000, 171, 300, 0),
(70021, 33740, 20000, 171, 300, 0),
(70021, 33741, 30000, 171, 315, 0),
(70021, 38070, 20000, 171, 325, 0),
(70021, 39636, 25000, 171, 310, 0),
(70021, 39638, 30000, 171, 320, 0),
(70021, 45061, 35000, 171, 325, 0),
(70021, 53042, 1000, 171, 50, 0),
(70021, 63732, 2000, 171, 135, 0);
(70021, 51303, 350000, 171, 350, 65),
(70021, 51304, 350000, 171, 350, 65),
(70021, 53042, 1000, 171, 50, 0),
(70021, 53812, 60000, 171, 375, 0),
(70021, 53836, 150000, 171, 405, 0),
(70021, 53837, 150000, 171, 410, 0),
(70021, 53838, 40000, 171, 350, 0),
(70021, 53839, 40000, 171, 360, 0),
(70021, 53840, 120000, 171, 395, 0),
(70021, 53841, 40000, 171, 355, 0),
(70021, 53842, 40000, 171, 365, 0),
(70021, 53847, 65000, 171, 385, 0),
(70021, 53848, 60000, 171, 375, 0),
(70021, 53898, 120000, 171, 390, 0),
(70021, 53899, 60000, 171, 375, 0),
(70021, 53900, 120000, 171, 380, 0),
(70021, 53901, 180000, 171, 435, 0),
(70021, 53902, 150000, 171, 435, 0),
(70021, 53903, 180000, 171, 435, 0),
(70021, 53905, 120000, 171, 395, 0),
(70021, 54213, 150000, 171, 435, 0),
(70021, 54218, 120000, 171, 385, 0),
(70021, 57425, 150000, 171, 430, 45),
(70021, 57427, 150000, 171, 425, 45),
(70021, 58868, 150000, 171, 410, 0),
(70021, 58871, 150000, 171, 410, 0),
(70021, 60350, 150000, 171, 395, 45),
(70021, 60367, 120000, 171, 395, 0),
(70021, 60396, 200000, 171, 400, 0),
(70021, 60403, 200000, 171, 400, 0),
(70021, 60405, 200000, 171, 400, 0),
(70021, 60893, 200000, 171, 400, 0),
(70021, 62213, 120000, 171, 385, 0),
(70021, 62409, 60000, 171, 375, 0),
(70021, 66658, 150000, 171, 450, 45),
(70021, 66660, 150000, 171, 450, 45),
(70021, 66662, 150000, 171, 450, 45),
(70021, 66663, 150000, 171, 450, 45),
(70021, 66664, 150000, 171, 450, 45),
(70021, 67025, 100000, 171, 425, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70010, 0, 0, 0, 0, 0, 22209, 0, 22209, 0, 'mining', 'Rasta-wow', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 547, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70010);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70010, 2581, 10, 0, 0, 0),
(70010, 2582, 500, 186, 50, 0),
(70010, 2658, 200, 186, 75, 0),
(70010, 2659, 200, 186, 65, 0),
(70010, 3304, 50, 186, 65, 0),
(70010, 3307, 500, 186, 125, 0),
(70010, 3308, 2500, 186, 155, 0),
(70010, 3568, 5000, 186, 125, 10),
(70010, 3569, 2500, 186, 165, 0),
(70010, 10097, 5000, 186, 175, 0),
(70010, 10098, 10000, 186, 230, 0),
(70010, 10249, 50000, 186, 200, 25),
(70010, 14891, 18000, 186, 230, 0),
(70010, 16153, 20000, 186, 250, 0),
(70010, 22967, 100000, 186, 300, 60),
(70010, 29355, 100000, 186, 275, 40),
(70010, 29356, 40000, 186, 300, 0),
(70010, 29358, 40000, 186, 325, 0),
(70010, 29359, 40000, 186, 350, 0),
(70010, 29360, 40000, 186, 350, 0),
(70010, 29361, 100000, 186, 375, 0),
(70010, 29686, 100000, 186, 375, 0),
(70010, 35750, 10000, 186, 300, 0),
(70010, 35751, 10000, 186, 300, 0),
(70010, 46353, 400000, 186, 375, 70),
(70010, 49252, 100000, 186, 350, 0),
(70010, 49258, 150000, 186, 400, 0),
(70010, 50309, 350000, 186, 350, 55),
(70010, 55208, 200000, 186, 450, 0),
(70010, 55211, 200000, 186, 450, 0),
(70010, 70524, 10000, 186, 250, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70012, 0, 0, 0, 0, 0, 18637, 0, 18637, 0, 'Engineering', 'Rasta-wow', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 3245, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70012);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70012, 3922, 115, 202, 30, 0),
(70012, 3923, 130, 202, 30, 0),
(70012, 3924, 150, 202, 50, 0),
(70012, 3925, 150, 202, 50, 0),
(70012, 3926, 225, 202, 65, 0),
(70012, 3929, 250, 202, 75, 0),
(70012, 3930, 250, 202, 75, 0),
(70012, 3931, 250, 202, 75, 0),
(70012, 3932, 300, 202, 85, 0),
(70012, 3934, 400, 202, 100, 0),
(70012, 3936, 420, 202, 105, 0),
(70012, 3937, 450, 202, 105, 0),
(70012, 3938, 450, 202, 105, 0),
(70012, 3941, 500, 202, 120, 0),
(70012, 3942, 500, 202, 125, 0),
(70012, 3945, 500, 202, 125, 0),
(70012, 3946, 500, 202, 125, 0),
(70012, 3947, 300, 202, 125, 0),
(70012, 3949, 550, 202, 130, 0),
(70012, 3950, 600, 202, 140, 0),
(70012, 3953, 600, 202, 145, 0),
(70012, 3955, 750, 202, 150, 0),
(70012, 3956, 750, 202, 150, 0),
(70012, 3958, 800, 202, 160, 0),
(70012, 3961, 900, 202, 170, 0),
(70012, 3962, 1000, 202, 175, 0),
(70012, 3963, 1000, 202, 175, 0),
(70012, 3965, 1200, 202, 185, 0),
(70012, 3967, 1400, 202, 190, 0),
(70012, 3973, 300, 202, 90, 0),
(70012, 3977, 200, 202, 60, 0),
(70012, 3978, 475, 202, 110, 0),
(70012, 4039, 10, 0, 0, 5),
(70012, 4040, 500, 202, 50, 10),
(70012, 4041, 5000, 202, 125, 20),
(70012, 6458, 400, 202, 135, 0),
(70012, 7430, 150, 202, 50, 0),
(70012, 8334, 300, 202, 100, 0),
(70012, 9271, 500, 202, 150, 0),
(70012, 12584, 1000, 202, 150, 0),
(70012, 12585, 1000, 202, 175, 0),
(70012, 12586, 1000, 202, 175, 0),
(70012, 12589, 1300, 202, 195, 0),
(70012, 12590, 1000, 202, 175, 0),
(70012, 12591, 1500, 202, 200, 0),
(70012, 12594, 1600, 202, 205, 0),
(70012, 12595, 1600, 202, 205, 0),
(70012, 12596, 1700, 202, 210, 0),
(70012, 12599, 1800, 202, 215, 0),
(70012, 12603, 1800, 202, 215, 0),
(70012, 12615, 2500, 202, 225, 0),
(70012, 12618, 2200, 202, 230, 0),
(70012, 12619, 2400, 202, 235, 0),
(70012, 12621, 2800, 202, 245, 0),
(70012, 12622, 2800, 202, 245, 0),
(70012, 12657, 50000, 202, 200, 35),
(70012, 15255, 1500, 202, 200, 0),
(70012, 19567, 4000, 202, 250, 0),
(70012, 19788, 4000, 202, 250, 0),
(70012, 19790, 10000, 202, 260, 0),
(70012, 19791, 5000, 202, 260, 0),
(70012, 19792, 10000, 202, 260, 0),
(70012, 19794, 20000, 202, 270, 0),
(70012, 19795, 10000, 202, 275, 0),
(70012, 19800, 10000, 202, 285, 0),
(70012, 19825, 20000, 202, 290, 0),
(70012, 23070, 5000, 202, 250, 0),
(70012, 23071, 5000, 202, 260, 0),
(70012, 30303, 10000, 202, 300, 0),
(70012, 30304, 10000, 202, 300, 0),
(70012, 30305, 10000, 202, 300, 0),
(70012, 30306, 20000, 202, 325, 0),
(70012, 30307, 50000, 202, 340, 0),
(70012, 30308, 50000, 202, 340, 0),
(70012, 30309, 50000, 202, 340, 0),
(70012, 30310, 15000, 202, 300, 0),
(70012, 30311, 25000, 202, 325, 0),
(70012, 30312, 20000, 202, 320, 0),
(70012, 30346, 15000, 202, 310, 0),
(70012, 30351, 100000, 202, 275, 50),
(70012, 39971, 20000, 202, 335, 0),
(70012, 40274, 50000, 202, 350, 0),
(70012, 41307, 50000, 202, 375, 0),
(70012, 41311, 50000, 202, 350, 0),
(70012, 41312, 50000, 202, 350, 0),
(70012, 41314, 50000, 202, 350, 0),
(70012, 41315, 50000, 202, 350, 0),
(70012, 41316, 50000, 202, 350, 0),
(70012, 41317, 50000, 202, 350, 0),
(70012, 41318, 50000, 202, 350, 0),
(70012, 41319, 50000, 202, 350, 0),
(70012, 41320, 50000, 202, 350, 0),
(70012, 41321, 50000, 202, 350, 0),
(70012, 44155, 60000, 202, 300, 60),
(70012, 51305, 350000, 202, 350, 65),
(70012, 53281, 50000, 202, 350, 0),
(70012, 54353, 125000, 202, 400, 0),
(70012, 54736, 100000, 202, 390, 0),
(70012, 54793, 100000, 202, 380, 0),
(70012, 54998, 125000, 202, 400, 0),
(70012, 54999, 125000, 202, 400, 0),
(70012, 55002, 100000, 202, 380, 0),
(70012, 55016, 125000, 202, 405, 0),
(70012, 56349, 50000, 202, 350, 0),
(70012, 56459, 100000, 202, 375, 0),
(70012, 56460, 50000, 202, 350, 0),
(70012, 56461, 50000, 202, 375, 0),
(70012, 56462, 150000, 202, 435, 0),
(70012, 56463, 100000, 202, 375, 0),
(70012, 56464, 100000, 202, 375, 0),
(70012, 56465, 125000, 202, 420, 0),
(70012, 56466, 125000, 202, 420, 0),
(70012, 56467, 125000, 202, 420, 0),
(70012, 56468, 125000, 202, 405, 0),
(70012, 56469, 150000, 202, 425, 0),
(70012, 56470, 150000, 202, 425, 0),
(70012, 56471, 100000, 202, 390, 0),
(70012, 56472, 150000, 202, 425, 0),
(70012, 56474, 125000, 202, 410, 0),
(70012, 56475, 125000, 202, 415, 0),
(70012, 56476, 125000, 202, 410, 0),
(70012, 56477, 125000, 202, 415, 0),
(70012, 56478, 200000, 202, 430, 0),
(70012, 56479, 200000, 202, 450, 0),
(70012, 56480, 150000, 202, 440, 0),
(70012, 56481, 150000, 202, 440, 0),
(70012, 56483, 150000, 202, 440, 0),
(70012, 56484, 150000, 202, 440, 0),
(70012, 56486, 150000, 202, 440, 0),
(70012, 56487, 150000, 202, 440, 0),
(70012, 56574, 150000, 202, 440, 0),
(70012, 60874, 200000, 202, 450, 0),
(70012, 61471, 100000, 202, 390, 0),
(70012, 61481, 125000, 202, 420, 0),
(70012, 61482, 125000, 202, 420, 0),
(70012, 61483, 125000, 202, 420, 0),
(70012, 62271, 150000, 202, 440, 0),
(70012, 63750, 5000, 202, 250, 0),
(70012, 63765, 100000, 202, 380, 0),
(70012, 63770, 125000, 202, 400, 0),
(70012, 67326, 100000, 202, 410, 0),
(70012, 67839, 100000, 202, 410, 0),
(70012, 67920, 150000, 202, 435, 0),
(70012, 8895, 2200, 202, 130, 0),
(70012, 12715, 1000, 202, 205, 0),
(70012, 12716, 1500, 202, 205, 0),
(70012, 12717, 1500, 202, 205, 0),
(70012, 12718, 1500, 202, 205, 0),
(70012, 12754, 2600, 202, 235, 0),
(70012, 12755, 2400, 202, 230, 0),
(70012, 12758, 3000, 202, 245, 0),
(70012, 12760, 1500, 202, 205, 0),
(70012, 12908, 2800, 202, 240, 0),
(70012, 13240, 1500, 202, 205, 0),
(70012, 30558, 25000, 202, 325, 0),
(70012, 30560, 35000, 202, 340, 0),
(70012, 30563, 50000, 202, 350, 0),
(70012, 30565, 100000, 202, 375, 0),
(70012, 30566, 100000, 202, 375, 0),
(70012, 56514, 150000, 202, 425, 0),
(70012, 12759, 2800, 202, 240, 0),
(70012, 12895, 1500, 202, 205, 0),
(70012, 12897, 1500, 202, 210, 0),
(70012, 12899, 1500, 202, 205, 0),
(70012, 12902, 1800, 202, 210, 0),
(70012, 12903, 2000, 202, 215, 0),
(70012, 12905, 2200, 202, 225, 0),
(70012, 12906, 2400, 202, 230, 0),
(70012, 12907, 2600, 202, 235, 0),
(70012, 30568, 25000, 202, 325, 0),
(70012, 30569, 35000, 202, 340, 0),
(70012, 30570, 50000, 202, 350, 0),
(70012, 30574, 100000, 202, 375, 0),
(70012, 30575, 100000, 202, 375, 0),
(70012, 56473, 150000, 202, 425, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70023, 0, 0, 0, 0, 0, 29774, 0, 29774, 0, 'Jewelcrafting', 'Rasta-wow', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2029, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70023);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70023, 25245, 10, 0, 0, 5),
(70023, 25246, 500, 755, 50, 10),
(70023, 25278, 200, 755, 50, 0),
(70023, 25280, 200, 755, 50, 0),
(70023, 25283, 100, 755, 30, 0),
(70023, 25284, 400, 755, 60, 0),
(70023, 25287, 400, 755, 70, 0),
(70023, 25305, 1000, 755, 90, 0),
(70023, 25317, 600, 755, 80, 0),
(70023, 25318, 800, 755, 100, 0),
(70023, 25321, 1500, 755, 120, 0),
(70023, 25490, 300, 755, 50, 0),
(70023, 25498, 600, 755, 110, 0),
(70023, 25613, 1200, 755, 135, 0),
(70023, 25615, 1500, 755, 150, 0),
(70023, 25620, 2000, 755, 170, 0),
(70023, 25621, 2000, 755, 180, 0),
(70023, 26872, 2500, 755, 200, 0),
(70023, 26874, 5000, 755, 210, 0),
(70023, 26876, 3000, 755, 220, 0),
(70023, 26880, 3500, 755, 225, 0),
(70023, 26883, 4000, 755, 235, 0),
(70023, 26885, 5000, 755, 240, 0),
(70023, 26902, 10000, 755, 260, 0),
(70023, 26903, 10000, 755, 275, 0),
(70023, 26907, 10000, 755, 280, 0),
(70023, 26908, 12000, 755, 280, 0),
(70023, 26911, 15000, 755, 290, 0),
(70023, 26916, 20000, 755, 310, 0),
(70023, 26926, 50, 755, 5, 0),
(70023, 26927, 300, 755, 50, 0),
(70023, 26928, 100, 755, 30, 0),
(70023, 28896, 5000, 755, 125, 20),
(70023, 28899, 50000, 755, 200, 35),
(70023, 28901, 100000, 755, 275, 50),
(70023, 28903, 10000, 755, 300, 0),
(70023, 28905, 10000, 755, 305, 0),
(70023, 28910, 10000, 755, 300, 0),
(70023, 28914, 10000, 755, 315, 0),
(70023, 28916, 10000, 755, 300, 0),
(70023, 28917, 10000, 755, 305, 0),
(70023, 28925, 10000, 755, 300, 0),
(70023, 28936, 10000, 755, 325, 0),
(70023, 28938, 10000, 755, 300, 0),
(70023, 28948, 10000, 755, 325, 0),
(70023, 28950, 10000, 755, 300, 0),
(70023, 28953, 10000, 755, 305, 0),
(70023, 31048, 20000, 755, 310, 0),
(70023, 31049, 20000, 755, 310, 0),
(70023, 31050, 25000, 755, 320, 0),
(70023, 31051, 30000, 755, 335, 0),
(70023, 31052, 30000, 755, 335, 0),
(70023, 31252, 100, 755, 20, 5),
(70023, 32178, 100, 755, 20, 0),
(70023, 32179, 100, 755, 20, 0),
(70023, 32801, 200, 755, 50, 0),
(70023, 32807, 600, 755, 110, 0),
(70023, 32808, 2000, 755, 175, 0),
(70023, 32809, 3500, 755, 225, 0),
(70023, 34069, 10000, 755, 325, 0),
(70023, 34590, 10000, 755, 305, 0),
(70023, 34955, 2500, 755, 180, 0),
(70023, 34959, 3000, 755, 200, 0),
(70023, 34960, 10000, 755, 280, 0),
(70023, 34961, 10000, 755, 290, 0),
(70023, 36523, 600, 755, 75, 0),
(70023, 36524, 800, 755, 105, 0),
(70023, 36525, 4000, 755, 230, 0),
(70023, 36526, 10000, 755, 265, 0),
(70023, 37818, 500, 755, 65, 0),
(70023, 38068, 20000, 755, 325, 0),
(70023, 38175, 650, 755, 80, 0),
(70023, 40514, 8500, 755, 340, 0),
(70023, 41414, 10000, 755, 325, 0),
(70023, 41415, 10000, 755, 330, 0),
(70023, 41418, 30000, 755, 365, 0),
(70023, 41420, 8500, 755, 325, 0),
(70023, 41429, 10000, 755, 350, 0),
(70023, 47280, 30000, 755, 350, 0),
(70023, 51310, 350000, 755, 350, 65),
(70023, 53831, 10000, 755, 350, 0),
(70023, 53832, 10000, 755, 350, 0),
(70023, 53834, 10000, 755, 350, 0),
(70023, 53835, 10000, 755, 350, 0),
(70023, 53843, 10000, 755, 360, 0),
(70023, 53844, 10000, 755, 350, 0),
(70023, 53845, 10000, 755, 350, 0),
(70023, 53852, 10000, 755, 350, 0),
(70023, 53853, 10000, 755, 350, 0),
(70023, 53854, 10000, 755, 350, 0),
(70023, 53855, 10000, 755, 350, 0),
(70023, 53856, 10000, 755, 350, 0),
(70023, 53859, 10000, 755, 350, 0),
(70023, 53860, 10000, 755, 350, 0),
(70023, 53861, 10000, 755, 350, 0),
(70023, 53862, 10000, 755, 350, 0),
(70023, 53863, 10000, 755, 350, 0),
(70023, 53864, 10000, 755, 350, 0),
(70023, 53866, 10000, 755, 350, 0),
(70023, 53867, 10000, 755, 350, 0),
(70023, 53868, 10000, 755, 360, 0),
(70023, 53870, 10000, 755, 350, 0),
(70023, 53871, 10000, 755, 350, 0),
(70023, 53872, 10000, 755, 350, 0),
(70023, 53873, 10000, 755, 350, 0),
(70023, 53874, 10000, 755, 350, 0),
(70023, 53876, 10000, 755, 350, 0),
(70023, 53878, 10000, 755, 350, 0),
(70023, 53880, 10000, 755, 350, 0),
(70023, 53881, 10000, 755, 350, 0),
(70023, 53882, 10000, 755, 350, 0),
(70023, 53883, 10000, 755, 350, 0),
(70023, 53886, 10000, 755, 350, 0),
(70023, 53887, 10000, 755, 350, 0),
(70023, 53889, 10000, 755, 350, 0),
(70023, 53890, 10000, 755, 350, 0),
(70023, 53891, 10000, 755, 360, 0),
(70023, 53892, 10000, 755, 350, 0),
(70023, 53893, 10000, 755, 350, 0),
(70023, 53894, 10000, 755, 350, 0),
(70023, 53916, 10000, 755, 350, 0),
(70023, 53918, 10000, 755, 350, 0),
(70023, 53920, 10000, 755, 350, 0),
(70023, 53922, 10000, 755, 350, 0),
(70023, 53923, 10000, 755, 350, 0),
(70023, 53925, 10000, 755, 350, 0),
(70023, 53926, 10000, 755, 350, 0),
(70023, 53927, 10000, 755, 350, 0),
(70023, 53928, 10000, 755, 350, 0),
(70023, 53930, 10000, 755, 350, 0),
(70023, 53931, 10000, 755, 350, 0),
(70023, 53934, 10000, 755, 350, 0),
(70023, 53940, 10000, 755, 350, 0),
(70023, 53941, 10000, 755, 350, 0),
(70023, 53947, 100000, 755, 390, 0),
(70023, 53953, 100000, 755, 390, 0),
(70023, 53956, 100000, 755, 390, 0),
(70023, 53969, 100000, 755, 390, 0),
(70023, 53989, 100000, 755, 390, 0),
(70023, 54007, 100000, 755, 390, 0),
(70023, 54017, 10000, 755, 350, 0),
(70023, 55386, 120000, 755, 420, 0),
(70023, 55394, 120000, 755, 420, 0),
(70023, 55399, 120000, 755, 420, 0),
(70023, 55402, 120000, 755, 420, 0),
(70023, 56193, 30000, 755, 350, 0),
(70023, 56194, 30000, 755, 350, 0),
(70023, 56195, 120000, 755, 380, 0),
(70023, 56196, 80000, 755, 380, 0),
(70023, 56197, 100000, 755, 420, 0),
(70023, 56199, 150000, 755, 400, 0),
(70023, 56201, 150000, 755, 400, 0),
(70023, 56202, 150000, 755, 400, 0),
(70023, 56203, 150000, 755, 400, 0),
(70023, 56205, 10000, 755, 350, 0),
(70023, 56206, 20000, 755, 360, 0),
(70023, 56208, 20000, 755, 370, 0),
(70023, 56530, 20000, 755, 360, 0),
(70023, 56531, 100000, 755, 390, 0),
(70023, 58141, 30000, 755, 350, 0),
(70023, 58142, 30000, 755, 350, 0),
(70023, 58143, 30000, 755, 370, 0),
(70023, 58144, 30000, 755, 370, 0),
(70023, 58145, 50000, 755, 390, 0),
(70023, 58146, 50000, 755, 390, 0),
(70023, 59759, 150000, 755, 400, 0),
(70023, 62242, 150000, 755, 425, 0),
(70023, 62941, 10000, 755, 300, 0),
(70023, 63743, 3000, 755, 200, 0),
(70023, 64725, 100000, 755, 420, 0),
(70023, 64726, 100000, 755, 420, 0),
(70023, 64727, 100000, 755, 420, 0),
(70023, 64728, 100000, 755, 420, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70015, 0, 0, 0, 0, 0, 22975, 0, 22975, 0, 'Diane Cannings', 'Rasta-wow', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 2, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4493, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70015);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70015, 2154, 500, 165, 50, 10),
(70015, 2155, 10, 0, 0, 5),
(70015, 3812, 5000, 165, 125, 20),
(70015, 10663, 50000, 165, 200, 35),
(70015, 32550, 100000, 165, 275, 50),
(70015, 50936, 80000, 165, 390, 0),
(70015, 50938, 30000, 165, 375, 0),
(70015, 50939, 30000, 165, 370, 0),
(70015, 50940, 30000, 165, 380, 0),
(70015, 50941, 30000, 165, 370, 0),
(70015, 50942, 30000, 165, 375, 0),
(70015, 50943, 30000, 165, 380, 0),
(70015, 50944, 30000, 165, 370, 0),
(70015, 50945, 30000, 165, 375, 0),
(70015, 50946, 30000, 165, 380, 0),
(70015, 50947, 30000, 165, 375, 0),
(70015, 50948, 30000, 165, 370, 0),
(70015, 50949, 30000, 165, 380, 0),
(70015, 50950, 30000, 165, 375, 0),
(70015, 50951, 30000, 165, 370, 0),
(70015, 50952, 30000, 165, 375, 0),
(70015, 50953, 30000, 165, 380, 0),
(70015, 50954, 30000, 165, 380, 0),
(70015, 50955, 30000, 165, 370, 0),
(70015, 50956, 30000, 165, 375, 0),
(70015, 50957, 30000, 165, 370, 0),
(70015, 50958, 30000, 165, 380, 0),
(70015, 50959, 30000, 165, 370, 0),
(70015, 50960, 30000, 165, 380, 0),
(70015, 50961, 30000, 165, 375, 0),
(70015, 50962, 50000, 165, 350, 0),
(70015, 50963, 80000, 165, 395, 0),
(70015, 50964, 50000, 165, 405, 0),
(70015, 50965, 80000, 165, 425, 0),
(70015, 50966, 50000, 165, 400, 0),
(70015, 50967, 80000, 165, 425, 0),
(70015, 51301, 350000, 165, 350, 65),
(70015, 51568, 100000, 165, 400, 0),
(70015, 51569, 80000, 165, 395, 0),
(70015, 51570, 80000, 165, 395, 0),
(70015, 51571, 30000, 165, 385, 0),
(70015, 51572, 30000, 165, 385, 0),
(70015, 55199, 80000, 165, 395, 0),
(70015, 57683, 70000, 165, 400, 0),
(70015, 57690, 70000, 165, 400, 0),
(70015, 57691, 70000, 165, 400, 0),
(70015, 60583, 50000, 165, 405, 0),
(70015, 60584, 50000, 165, 400, 0),
(70015, 60599, 30000, 165, 385, 0),
(70015, 60600, 30000, 165, 385, 0),
(70015, 60601, 80000, 165, 395, 0),
(70015, 60604, 80000, 165, 395, 0),
(70015, 60605, 100000, 165, 400, 0),
(70015, 60607, 30000, 165, 385, 0),
(70015, 60608, 30000, 165, 385, 0),
(70015, 60611, 80000, 165, 395, 0),
(70015, 60613, 80000, 165, 395, 0),
(70015, 60620, 100000, 165, 400, 0),
(70015, 60622, 30000, 165, 385, 0),
(70015, 60624, 30000, 165, 385, 0),
(70015, 60627, 80000, 165, 395, 0),
(70015, 60629, 80000, 165, 395, 0),
(70015, 60630, 80000, 165, 400, 0),
(70015, 60631, 80000, 165, 380, 0),
(70015, 60637, 200000, 165, 440, 0),
(70015, 60640, 200000, 165, 440, 0),
(70015, 60643, 50000, 165, 415, 0),
(70015, 60649, 100000, 165, 425, 0),
(70015, 60651, 100000, 165, 420, 0),
(70015, 60652, 100000, 165, 420, 0),
(70015, 60655, 200000, 165, 425, 0),
(70015, 60658, 200000, 165, 420, 0),
(70015, 60660, 100000, 165, 425, 0),
(70015, 60665, 100000, 165, 420, 0),
(70015, 60666, 80000, 165, 420, 0),
(70015, 60669, 100000, 165, 425, 0),
(70015, 60671, 100000, 165, 420, 0),
(70015, 62448, 80000, 165, 425, 0),
(70015, 64661, 50000, 165, 350, 0),
(70015, 69386, 200000, 165, 450, 0),
(70015, 69388, 200000, 165, 450, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70011, 0, 0, 0, 0, 0, 18593, 0, 18593, 0, 'Blacksmithing', 'Rasta-wow', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 340, 510, 0, 127, 100, 2000, 2000, 1, 2, 8, 0, 2, 0, 0, 0, 272, 408, 102, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4321, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70011);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70011, 2020, 10, 0, 0, 5),
(70011, 2021, 500, 164, 50, 10),
(70011, 2661, 100, 164, 35, 0),
(70011, 2662, 50, 164, 1, 0),
(70011, 2664, 500, 164, 90, 0),
(70011, 2665, 100, 164, 65, 0),
(70011, 2666, 200, 164, 70, 0),
(70011, 2668, 300, 164, 105, 0),
(70011, 2670, 500, 164, 105, 0),
(70011, 2672, 500, 164, 120, 0),
(70011, 2674, 1000, 164, 125, 0),
(70011, 2675, 1000, 164, 145, 0),
(70011, 2737, 50, 164, 15, 0),
(70011, 2738, 50, 164, 20, 0),
(70011, 2739, 50, 164, 25, 0),
(70011, 2740, 200, 164, 110, 0),
(70011, 2741, 200, 164, 115, 0),
(70011, 2742, 200, 164, 120, 0),
(70011, 3116, 100, 164, 65, 0),
(70011, 3117, 1000, 164, 125, 0),
(70011, 3292, 500, 164, 95, 0),
(70011, 3293, 250, 164, 35, 0),
(70011, 3294, 500, 164, 70, 0),
(70011, 3296, 1000, 164, 130, 0),
(70011, 3319, 50, 164, 20, 0),
(70011, 3320, 100, 164, 25, 0),
(70011, 3323, 100, 164, 40, 0),
(70011, 3324, 200, 164, 45, 0),
(70011, 3326, 250, 164, 75, 0),
(70011, 3328, 500, 164, 110, 0),
(70011, 3331, 500, 164, 130, 0),
(70011, 3333, 1000, 164, 135, 0),
(70011, 3337, 1000, 164, 125, 0),
(70011, 3491, 600, 164, 105, 0),
(70011, 3501, 1000, 164, 165, 0),
(70011, 3502, 1250, 164, 170, 0),
(70011, 3506, 5000, 164, 155, 0),
(70011, 3508, 7500, 164, 180, 0),
(70011, 3539, 5000, 164, 125, 20),
(70011, 6517, 800, 164, 110, 0),
(70011, 7223, 1000, 164, 185, 0),
(70011, 7408, 300, 164, 65, 0),
(70011, 7817, 200, 164, 95, 0),
(70011, 7818, 100, 164, 100, 0),
(70011, 8768, 250, 164, 150, 0),
(70011, 8880, 100, 164, 30, 0),
(70011, 9786, 50000, 164, 200, 35),
(70011, 9916, 2500, 164, 200, 0),
(70011, 9918, 2500, 164, 200, 0),
(70011, 9920, 2500, 164, 200, 0),
(70011, 9921, 2500, 164, 200, 0),
(70011, 9926, 5000, 164, 205, 0),
(70011, 9928, 5000, 164, 205, 0),
(70011, 9931, 5000, 164, 210, 0),
(70011, 9935, 5000, 164, 215, 0),
(70011, 9959, 15000, 164, 230, 0),
(70011, 9961, 15000, 164, 230, 0),
(70011, 9968, 20000, 164, 235, 0),
(70011, 9983, 100, 164, 30, 0),
(70011, 9985, 250, 164, 125, 0),
(70011, 9986, 500, 164, 130, 0),
(70011, 9987, 500, 164, 135, 0),
(70011, 9993, 10000, 164, 210, 0),
(70011, 10001, 15000, 164, 230, 0),
(70011, 14379, 250, 164, 150, 0),
(70011, 14380, 2500, 164, 200, 0),
(70011, 15972, 7500, 164, 180, 0),
(70011, 16639, 10000, 164, 250, 0),
(70011, 16640, 10000, 164, 250, 0),
(70011, 16641, 10000, 164, 250, 0),
(70011, 19666, 100, 164, 100, 0),
(70011, 19667, 250, 164, 150, 0),
(70011, 19668, 2500, 164, 200, 0),
(70011, 19669, 10000, 164, 275, 0),
(70011, 20201, 10000, 164, 275, 0),
(70011, 29545, 15000, 164, 300, 0),
(70011, 29547, 15000, 164, 305, 0),
(70011, 29548, 20000, 164, 315, 0),
(70011, 29549, 20000, 164, 315, 0),
(70011, 29550, 25000, 164, 325, 0),
(70011, 29551, 15000, 164, 300, 0),
(70011, 29552, 18000, 164, 310, 0),
(70011, 29553, 20000, 164, 315, 0),
(70011, 29556, 22000, 164, 320, 0),
(70011, 29557, 18000, 164, 310, 0),
(70011, 29558, 20000, 164, 315, 0),
(70011, 29565, 22000, 164, 320, 0),
(70011, 29654, 15000, 164, 300, 0),
(70011, 29845, 100000, 164, 275, 50),
(70011, 32284, 25000, 164, 325, 0),
(70011, 32655, 10000, 164, 300, 0),
(70011, 34607, 15000, 164, 300, 0),
(70011, 34979, 600, 164, 100, 0),
(70011, 34981, 7500, 164, 200, 0),
(70011, 34982, 10000, 164, 300, 0),
(70011, 34983, 50000, 164, 350, 0),
(70011, 51298, 350000, 164, 350, 65),
(70011, 52567, 30000, 164, 370, 0),
(70011, 52568, 30000, 164, 350, 0),
(70011, 52569, 30000, 164, 350, 0),
(70011, 52570, 30000, 164, 375, 0),
(70011, 52571, 30000, 164, 370, 0),
(70011, 52572, 30000, 164, 360, 0),
(70011, 54550, 30000, 164, 360, 0),
(70011, 54551, 40000, 164, 395, 0),
(70011, 54552, 40000, 164, 400, 0),
(70011, 54553, 40000, 164, 400, 0),
(70011, 54554, 40000, 164, 395, 0),
(70011, 54555, 40000, 164, 405, 0),
(70011, 54556, 40000, 164, 405, 0),
(70011, 54557, 40000, 164, 390, 0),
(70011, 54917, 30000, 164, 375, 0),
(70011, 54918, 30000, 164, 380, 0),
(70011, 54941, 30000, 164, 385, 0),
(70011, 54944, 30000, 164, 385, 0),
(70011, 54945, 35000, 164, 390, 0),
(70011, 54946, 30000, 164, 395, 0),
(70011, 54947, 35000, 164, 395, 0),
(70011, 54948, 30000, 164, 400, 0),
(70011, 54949, 30000, 164, 400, 0),
(70011, 55013, 40000, 164, 390, 0),
(70011, 55014, 35000, 164, 410, 0),
(70011, 55015, 40000, 164, 415, 0),
(70011, 55017, 40000, 164, 410, 0),
(70011, 55055, 40000, 164, 395, 0),
(70011, 55056, 40000, 164, 400, 0),
(70011, 55057, 40000, 164, 405, 0),
(70011, 55058, 45000, 164, 415, 0),
(70011, 55174, 50000, 164, 390, 0),
(70011, 55177, 50000, 164, 395, 0),
(70011, 55179, 50000, 164, 400, 0),
(70011, 55181, 50000, 164, 405, 0),
(70011, 55182, 40000, 164, 410, 0),
(70011, 55200, 35000, 164, 380, 0),
(70011, 55201, 35000, 164, 380, 0),
(70011, 55202, 35000, 164, 385, 0),
(70011, 55203, 35000, 164, 385, 0),
(70011, 55204, 35000, 164, 390, 0),
(70011, 55206, 40000, 164, 405, 0),
(70011, 55298, 45000, 164, 420, 0),
(70011, 55300, 45000, 164, 420, 0),
(70011, 55301, 45000, 164, 420, 0),
(70011, 55302, 45000, 164, 425, 0),
(70011, 55303, 45000, 164, 425, 0),
(70011, 55304, 45000, 164, 425, 0),
(70011, 55305, 45000, 164, 420, 0),
(70011, 55306, 45000, 164, 420, 0),
(70011, 55307, 45000, 164, 420, 0),
(70011, 55308, 45000, 164, 420, 0),
(70011, 55309, 45000, 164, 420, 0),
(70011, 55310, 45000, 164, 425, 0),
(70011, 55311, 45000, 164, 425, 0),
(70011, 55312, 45000, 164, 425, 0),
(70011, 55369, 180000, 164, 440, 0),
(70011, 55370, 150000, 164, 440, 0),
(70011, 55371, 150000, 164, 440, 0),
(70011, 55372, 120000, 164, 440, 0),
(70011, 55373, 120000, 164, 440, 0),
(70011, 55374, 120000, 164, 440, 0),
(70011, 55375, 120000, 164, 440, 0),
(70011, 55376, 120000, 164, 440, 0),
(70011, 55377, 120000, 164, 440, 0),
(70011, 55628, 45000, 164, 400, 60),
(70011, 55641, 45000, 164, 400, 60),
(70011, 55656, 50000, 164, 415, 0),
(70011, 55732, 42000, 164, 420, 0),
(70011, 55834, 30000, 164, 360, 0),
(70011, 55835, 30000, 164, 370, 0),
(70011, 55839, 42000, 164, 420, 0),
(70011, 56234, 150000, 164, 440, 0),
(70011, 56280, 40000, 164, 410, 0),
(70011, 56357, 42000, 164, 420, 0),
(70011, 56400, 150000, 164, 440, 0),
(70011, 56549, 45000, 164, 420, 0),
(70011, 56550, 45000, 164, 420, 0),
(70011, 56551, 45000, 164, 420, 0),
(70011, 56552, 45000, 164, 420, 0),
(70011, 56553, 45000, 164, 420, 0),
(70011, 56554, 45000, 164, 425, 0),
(70011, 56555, 45000, 164, 425, 0),
(70011, 56556, 45000, 164, 425, 0),
(70011, 59405, 30000, 164, 350, 0),
(70011, 59406, 45000, 164, 430, 0),
(70011, 59436, 40000, 164, 395, 0),
(70011, 59438, 40000, 164, 400, 0),
(70011, 59440, 40000, 164, 405, 0),
(70011, 59441, 45000, 164, 415, 0),
(70011, 59442, 40000, 164, 410, 0),
(70011, 61008, 120000, 164, 425, 0),
(70011, 61009, 120000, 164, 420, 0),
(70011, 61010, 120000, 164, 420, 0),
(70011, 63182, 150000, 164, 440, 0);

REPLACE 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (70018, 0, 0, 0, 0, 0, 22974, 0, 22974, 0, 'Inscription', 'Rasta-wow', '', 0, 83, 83, 2, 35, 35, 81, 2, 2, 1, 2, 248, 372, 0, 93, 100, 2000, 2000, 8, 2, 8, 0, 2, 0, 0, 0, 198, 298, 74, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 1000, '', 0, 3, 100, 50, 10, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4493, 0, 0, '', 12340);
DELETE FROM `npc_trainer` WHERE (`entry`=70018);
INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES
(70018, 45357, 10, 0, 0, 5),
(70018, 45375, 10, 0, 0, 5),
(70018, 45376, 500, 773, 50, 10),
(70018, 45377, 5000, 773, 125, 20),
(70018, 45378, 50000, 773, 200, 35),
(70018, 45379, 100000, 773, 275, 50),
(70018, 45380, 350000, 773, 350, 65),
(70018, 48121, 400, 773, 100, 0),
(70018, 48247, 500, 773, 110, 0),
(70018, 48248, 50, 773, 35, 0),
(70018, 50598, 400, 773, 75, 0),
(70018, 50599, 750, 773, 165, 0),
(70018, 50600, 4500, 773, 215, 0),
(70018, 50601, 10000, 773, 260, 0),
(70018, 50602, 20000, 773, 310, 0),
(70018, 50603, 50000, 773, 360, 0),
(70018, 50604, 60000, 773, 410, 0),
(70018, 50605, 400, 773, 75, 0),
(70018, 50606, 750, 773, 160, 0),
(70018, 50607, 4500, 773, 210, 0),
(70018, 50608, 10000, 773, 255, 0),
(70018, 50609, 20000, 773, 295, 0),
(70018, 50610, 50000, 773, 355, 0),
(70018, 50611, 60000, 773, 405, 0),
(70018, 50612, 400, 773, 75, 0),
(70018, 50614, 750, 773, 155, 0),
(70018, 50616, 4500, 773, 205, 0),
(70018, 50617, 10000, 773, 250, 0),
(70018, 50618, 20000, 773, 290, 0),
(70018, 50619, 50000, 773, 350, 0),
(70018, 50620, 60000, 773, 400, 0),
(70018, 52739, 150, 773, 35, 0),
(70018, 52840, 400, 773, 75, 0),
(70018, 52843, 50, 773, 35, 0),
(70018, 53462, 300, 773, 75, 0),
(70018, 56943, 30000, 773, 350, 0),
(70018, 56945, 500, 773, 115, 0),
(70018, 56948, 750, 773, 150, 0),
(70018, 56951, 750, 773, 130, 0),
(70018, 56952, 20000, 773, 310, 0),
(70018, 56953, 1000, 773, 170, 0),
(70018, 56955, 300, 773, 80, 0),
(70018, 56956, 3000, 773, 200, 0),
(70018, 56957, 10000, 773, 260, 0),
(70018, 56959, 4500, 773, 220, 0),
(70018, 56961, 400, 773, 90, 0),
(70018, 56963, 300, 773, 85, 0),
(70018, 56968, 400, 773, 100, 0),
(70018, 56971, 500, 773, 115, 0),
(70018, 56972, 30000, 773, 335, 0),
(70018, 56973, 750, 773, 130, 0),
(70018, 56974, 750, 773, 155, 0),
(70018, 56976, 300, 773, 80, 0),
(70018, 56978, 400, 773, 90, 0),
(70018, 56979, 6000, 773, 225, 0),
(70018, 56980, 50000, 773, 375, 0),
(70018, 56981, 1000, 773, 175, 0),
(70018, 56982, 4500, 773, 205, 0),
(70018, 56984, 30000, 773, 325, 0),
(70018, 56985, 10000, 773, 280, 0),
(70018, 56987, 125000, 773, 400, 0),
(70018, 56991, 20000, 773, 75, 0),
(70018, 56994, 1000, 773, 175, 0),
(70018, 56995, 400, 773, 100, 0),
(70018, 56997, 500, 773, 115, 0),
(70018, 57000, 3000, 773, 200, 0),
(70018, 57001, 6000, 773, 225, 0),
(70018, 57002, 10000, 773, 260, 0),
(70018, 57003, 30000, 773, 350, 0),
(70018, 57004, 300, 773, 80, 0),
(70018, 57005, 750, 773, 130, 0),
(70018, 57006, 50000, 773, 375, 0),
(70018, 57007, 750, 773, 150, 0),
(70018, 57008, 20000, 773, 315, 0),
(70018, 57009, 400, 773, 90, 0),
(70018, 57020, 1000, 773, 180, 0),
(70018, 57022, 300, 773, 80, 0),
(70018, 57023, 4500, 773, 205, 0),
(70018, 57024, 6000, 773, 230, 0),
(70018, 57025, 10000, 773, 265, 0),
(70018, 57026, 20000, 773, 300, 0),
(70018, 57027, 400, 773, 90, 0),
(70018, 57029, 500, 773, 105, 0),
(70018, 57030, 500, 773, 120, 0),
(70018, 57031, 750, 773, 135, 0),
(70018, 57032, 750, 773, 155, 0),
(70018, 57033, 30000, 773, 335, 0),
(70018, 57036, 50000, 773, 375, 0),
(70018, 57113, 30000, 773, 340, 0),
(70018, 57114, 300, 773, 80, 0),
(70018, 57119, 400, 773, 95, 0),
(70018, 57120, 500, 773, 105, 0),
(70018, 57121, 500, 773, 120, 0),
(70018, 57122, 20000, 773, 305, 0),
(70018, 57123, 750, 773, 135, 0),
(70018, 57125, 750, 773, 160, 0),
(70018, 57129, 3000, 773, 185, 0),
(70018, 57131, 4500, 773, 210, 0),
(70018, 57132, 6000, 773, 235, 0),
(70018, 57133, 15000, 773, 285, 0),
(70018, 57151, 4500, 773, 220, 0),
(70018, 57154, 7500, 773, 240, 0),
(70018, 57156, 15000, 773, 285, 0),
(70018, 57157, 750, 773, 125, 0),
(70018, 57158, 400, 773, 95, 0),
(70018, 57161, 1000, 773, 170, 0),
(70018, 57162, 300, 773, 85, 0),
(70018, 57163, 500, 773, 110, 0),
(70018, 57165, 3000, 773, 190, 0),
(70018, 57167, 750, 773, 140, 0),
(70018, 57168, 20000, 773, 320, 0),
(70018, 57172, 30000, 773, 345, 0),
(70018, 57183, 6000, 773, 230, 0),
(70018, 57184, 500, 773, 105, 0),
(70018, 57185, 500, 773, 270, 0),
(70018, 57186, 500, 773, 120, 0),
(70018, 57187, 20000, 773, 315, 0),
(70018, 57188, 750, 773, 135, 0),
(70018, 57192, 30000, 773, 350, 0),
(70018, 57194, 300, 773, 80, 0),
(70018, 57196, 400, 773, 95, 0),
(70018, 57197, 750, 773, 160, 0),
(70018, 57198, 50000, 773, 375, 0),
(70018, 57200, 1000, 773, 180, 0),
(70018, 57201, 4500, 773, 210, 0),
(70018, 57210, 10000, 773, 265, 0),
(70018, 57213, 15000, 773, 285, 0),
(70018, 57216, 10000, 773, 270, 0),
(70018, 57219, 10000, 773, 280, 0),
(70018, 57221, 20000, 773, 300, 0),
(70018, 57222, 30000, 773, 350, 0),
(70018, 57224, 30000, 773, 330, 0),
(70018, 57225, 50000, 773, 375, 0),
(70018, 57226, 20000, 773, 305, 0),
(70018, 57227, 30000, 773, 345, 0),
(70018, 57236, 20000, 773, 300, 0),
(70018, 57238, 500, 773, 110, 0),
(70018, 57239, 300, 773, 85, 0),
(70018, 57240, 750, 773, 125, 0),
(70018, 57241, 3000, 773, 185, 0),
(70018, 57242, 4500, 773, 215, 0),
(70018, 57244, 6000, 773, 235, 0),
(70018, 57245, 750, 773, 140, 0),
(70018, 57246, 400, 773, 95, 0),
(70018, 57248, 50000, 773, 375, 0),
(70018, 57249, 750, 773, 165, 0),
(70018, 57251, 10000, 773, 275, 0),
(70018, 57252, 30000, 773, 330, 0),
(70018, 57257, 30000, 773, 350, 0),
(70018, 57259, 300, 773, 85, 0),
(70018, 57262, 750, 773, 125, 0),
(70018, 57265, 500, 773, 110, 0),
(70018, 57266, 400, 773, 95, 0),
(70018, 57269, 750, 773, 140, 0),
(70018, 57270, 4500, 773, 215, 0),
(70018, 57271, 750, 773, 165, 0),
(70018, 57272, 10000, 773, 275, 0),
(70018, 57274, 7500, 773, 240, 0),
(70018, 57275, 30000, 773, 325, 0),
(70018, 57277, 3000, 773, 190, 0),
(70018, 57703, 400, 773, 85, 0),
(70018, 57704, 400, 773, 100, 0),
(70018, 57706, 750, 773, 125, 0),
(70018, 57707, 750, 773, 150, 0),
(70018, 57708, 750, 773, 175, 0),
(70018, 57709, 3000, 773, 200, 0),
(70018, 57710, 6000, 773, 225, 0),
(70018, 57711, 10000, 773, 250, 0),
(70018, 57712, 10000, 773, 275, 0),
(70018, 57713, 20000, 773, 290, 0),
(70018, 57714, 20000, 773, 325, 0),
(70018, 57715, 50000, 773, 350, 0),
(70018, 57716, 50000, 773, 375, 0),
(70018, 58472, 50, 773, 15, 0),
(70018, 58473, 400, 773, 85, 0),
(70018, 58476, 750, 773, 175, 0),
(70018, 58478, 4500, 773, 225, 0),
(70018, 58480, 10000, 773, 270, 0),
(70018, 58481, 20000, 773, 310, 0),
(70018, 58482, 50000, 773, 370, 0),
(70018, 58483, 60000, 773, 420, 0),
(70018, 58484, 50, 773, 15, 0),
(70018, 58485, 40