I wouldn't run the queries tharkun posted(in case anybody else wants to) as those will change values for every spell effect, not just Heals and DDs/DoTs. Many types of spells use those fields to link to other spells and such, not to mention that not all heals and DD/DoTs put their dmg in effect value 1.
If you wanted to go that route, you would need to add a WHERE `effectid1`='0' || `effectid1`='79' as those would be the only spell effects you would want to modify with those queries. Ideally you would run those for all 12 effectids.
|