[Release] Grand Master Proffesions

[bueslum]

A lot of the databases lately have grand master trainers that don't actually teach the skill, for those of you that have that problem here is the sql to fix it. Where it says 'changeme' in red change it to the trainer spawn id.

Blacksmithing

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,51298,0,200000,29844,164,350,60,29844,0);

Leatherworking

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,51301,0,200000,32549,165,350,60,32549,0);

Jewelcrafting

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,51310,0,200000,28897,755,350,60,28897,0);

Herbalism

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,50301,0,200000,0,182,350,60,0,0);

Alchemy

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,51303,0,200000,28596,171,350,60,28596,0);

Skinning

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,50307,0,200000,32678,393,350,60,32678,0);

Tailoring

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,51398,0,200000,26790,197,350,60,26790,0);

Engineering

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45380,0,200000,30350,202,350,60,30350,0);

Enchanting

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,51312,0,200000,28029,333,350,60,28029,0);

Inscription

insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45375,0,000100,0,0,0,5,0,1);
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45376,0,000500,0,773,50,10,45357,0);
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45377,0,005000,0,773,125,20,45358,0);
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45378,0,050000,0,773,200,35,45359,0);
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45379,0,100000,0,773,275,50,45360,0);
insert into `trainer_spells`(`entry`,`cast_spell`,`learn_spell`,`spellcost`,`reqspell`,`reqskill`,`reqskillvalue`,`reqlevel`,`deletespell`,`is_prof`) values (changeme,45380,0,200000,0,773,350,60,45361,0);

A lot of inscription trainers don't have any training skills so here is all of them.

[jokerofsouls]

Thanks +Rep

[y2kss66]

very nice job!
edit: +Rep!

[th3gam3]

got one for mangos?

[bueslum]

Sorry I don't use MaNGOS.

[Ziddy1337]

Very nice release mate.

+Rep for you.