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

Dude...Post shit in the right thread...
This isnt a guide...its a release...releases go in discussion...and stop double posting shit