Core/Scripts: Add new SpellScript hook

Adds SpellScript hook to execute scripts after succesful dispels, example could be warlock pets Devour Magic, which should only trigger when succesfully dispelling an aura.

Reworking the SQL allows this commit to be cherrypicked to 335 and 434