[sotonin]

OK. I tried above code on a fresh DB. it didnt work. after some modification i got the trainers to work properly. Of course after we release the db it wont matter. But this is a quick fix in case you ever fubar your gms or something

UPDATE npc_types SET class = 29 WHERE lastname LIKE 'Shaman_Guildmast%';
UPDATE npc_types SET class = 25 WHERE lastname LIKE 'Druid_Guildmast%';
UPDATE npc_types SET class = 21 WHERE lastname LIKE 'Cleric_Guildmast%';
UPDATE npc_types SET class = 20 WHERE lastname LIKE 'Warrior_Guildmast%';
UPDATE npc_types SET class = 26 WHERE lastname LIKE 'Monk_Guildmast%';
UPDATE npc_types SET class = 22 WHERE lastname LIKE 'Paladin_Guildmast%';
UPDATE npc_types SET class = 24 WHERE lastname LIKE 'Shadow_Knight_Guildmast%';
UPDATE npc_types SET class = 23 WHERE lastname LIKE 'Ranger_Guildmast%';
UPDATE npc_types SET class = 28 WHERE lastname LIKE 'Rogue_Guildmast%';
UPDATE npc_types SET class = 34 WHERE lastname LIKE 'BeastLord_Guildmast%';
UPDATE npc_types SET class = 27 WHERE lastname LIKE 'Bard_Guildmast%';
UPDATE npc_types SET class = 27 WHERE lastname LIKE 'Berserker_Guildmast%';
UPDATE npc_types SET class = 31 WHERE lastname LIKE 'Wizard_Guildmast%';
UPDATE npc_types SET class = 30 WHERE lastname LIKE 'Necromancer_Guildmast%';
UPDATE npc_types SET class = 32 WHERE lastname LIKE 'Magician_Guildmast%';
UPDATE npc_types SET class = 33 WHERE lastname LIKE 'Enchanter_Guildmast%';