All pastes #445113 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-04-17 18:26 UTC
rendered paste body
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Mining Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Blacksmithing Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='First Aid Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Fishing Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Cooking Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Herbalism Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Skinning Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Lockpicking Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname`='Leatherworking Trainer';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Trainer and Supplies%';
UPDATE `creature_template` SET `trainer_type`='2' WHERE `subname` LIKE '%Trainer & Supplies%';