my newest fix for the NCDB not deleting the old professions when you learn a new rank
this one if for the Alchemy profession
Code:update trainer_spells set deletespell = '2259' where cast_spell = '2280'; update trainer_spells set deletespell = '3101' where cast_spell = '3465'; update trainer_spells set deletespell = '3464' where cast_spell = '11612'; update trainer_spells set deletespell = '11611' where cast_spell = '28597'
medenus helped me link them so they can be ran as one .sql file or query and gave me the original file i modded to fix other professions