Fix for the NCDB 2.2 secondary skills

[*TraPStaR*]

ok this is to fix the secondary skills cooking and first aid counting as professions i found the problem my friend did the sql file so here goes

1. fix for the first aid copy paste it in a notepad and save as fix_firstaid.sql

update trainer_spells set is_prof = '0' where cast_spell = '3279'

2. fix for cooking copy paste it in a notepad and save as fix_cooking.sql

update trainer_spells set is_prof = '0' where cast_spell = '2551'

if u have any problems/errors post them and ill see if i can help

P.S. i don't know if i posted this in the right place but it is a guide to fix trainers in the new ascent DB NCDB 2.2 if it is not in the correct place please let me know and ill try and do something about it thanks

[Illidan1]

It is in the right place, Nice job btw +Rep for your Contribute

[*TraPStaR*]

thanks I'm working on a set of armor "battle master" what it does is uses plus healing and spell effects so when battle master is applied to a weapon it increases the healing done when the battle master enchant proc's ahh yeah and theres 2 weapons that come with it 6):

[Illidan1]

Very nice man, Hope you get some good Rep out of it

[Daxo]

Nice bro... +Rep for you