I believe that would work, though I'm not 100% keen on sql code, but in theory that sounds like it might work. Perhaps you should export your spells_new table before attemping, in case it doesn't work, then you can simply source the old one back in.
Do keep in mind though that some spells might use a different effect line, such as effect_base_value2 instead of 1, for the damage portion of the spell.
I'm glad you found it useful. I figured there would be some people out there who didn't use the editors, or simply couldn't.
|