I'm not up to date with mangos or wow, but if I remember correctly there was a character_spel table (or something like that) in characters database, which contains all the spells one character knows.
Now, there should be a field "active" which you can edit in order to disable/enable particular spell (you'll have to know spell ID) for a particular character. The spell should be removed from the spell book, but I don't know if that character will be able to learn that spell again.
For more characters or all of them, just edit that field for all of them.
By the way, as far as I know, all the spells' info is contained within the spell.dbc file and not in databases. You can edit that file to achieve something similar, too, if you know what all those fields there mean. I think there is no global switch for turning on/off particular spell, but I might be wrong.
Posted 11 months ago » Permalink