Thread: Profession trainer and weapon skill trainer

This NPC trains the First and secondary professions and the weapon skills
Included is a Query you can run to select ONLY this Trainer out of your DATABASE so you can edit the Cost values for everything since As it is EVERYTHING is FREE>

Code:

INSERT INTO trainer_defs
  (entry, required_skill, required_skillvalue, req_class, trainer_type, trainer_ui_window_message, can_train_gossip_textid, cannot_train_gossip_textid)
VALUES
  (859012, 0, 0, 0, 0, "Hi there $N, what can I do for you?", 0, 0);
INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('859012','GM Trainer','Weapon + Armor skills, Professions & GM Spells','','16','4','0','3','0','21452','0','0','0','0');
INSERT INTO `creature_proto` VALUES ('859012', '100', '100', '35', '100', '100', '100', '1', '16', '1000', '0', '1000', '1000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '360000', '5', '5', '5', '5', '5', '5', '5', '1', '1', '0', '0', '0', '0', '0', '4', '15', '20', '0', '0', '0', '0', '0', '0');

INSERT INTO `trainer_spells` VALUES ('859012','0','750','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','8737','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','264','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','5011','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','1180','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','204','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','107','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','81','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','674','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','15590','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','266','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','196','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','198','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','201','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','3127','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','200','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','3018','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','5019','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','227','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','2764','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','2567','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','197','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','199','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','202','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','5009','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','33388','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','33391','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','34090','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','34091','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','43308','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','33095','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','27028','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','21991','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','818','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','33359','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28596','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28677','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28675','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28672','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','9788','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','9787','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','29844','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','17041','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','17040','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','17039','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','13262','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28029','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','20219','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','20222','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','30350','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','2383','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28695','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','28897','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','32549','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','2580','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','2656','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','29354','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','32678','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','26790','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','26798','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','26801','0','0','0','0','1','0','0');
INSERT INTO `trainer_spells` VALUES ('859012','0','26797','0','0','0','0','1','0','0');

Query to select only this Trainer in a database to edit Training costs.

Code:

Select * FROM `trainer_spells` WHERE `entry`= 859012

Credits: Meatball of www.AC-WEB.org for original information
Kreegoth for Modifications and trainer Select Query