Spellcrafter's Handbook

[AudioGarden21]

I forgot to mention that anything that comes before a question mark is not verified and is merely a guess. Feel free to verify and report at your leisure.

Bolded values are broken in emu, so I made them more visible without cluttering up the cells, and those are few at the moment due to the fact that I was testing only specific ones during the week out of curiosity. Note that I do put "not implemented" in some cells.

Also note that on the "Effects Type - Detailed" tab, I specify whether an effect works off a base or if it's a percentage effect. I may have missed few seeing as it's a lot to keep track of. Just make a note of it where it says "by a percent", and you'll know, otherwise assume it means a base, flat value.

[Maceblade]

This actually was pretty awesome for me thank you! For some reason I cant get spell editors to work on my PC and I have no idea why.

I do have a question tho,

lets say I wanted to increase [ALL] PC based destrimental spells could I use;

UPDATE spells_new set effect_base_value1 = effect_base_value1 * 2 where effect_base_value1 < 0 and class1 < 254 ;

Obviously I would swap out the "class" column everytime being a newb, but then that way there I wouldnt change out NPC spells.

[AudioGarden21]

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.