Upping damage done by spells

[Burningsoul]

Thank you for the queries and insight. What I was trying for was similar to the now-defunct Zarn Barn server, I don't remember if the mobs' spells were affected but all nukes and dots hit for 5 times the normal damage.

I did some tinkering with focus effects but I'm not too pleased with the results, I'm not sure how high the fields can go but even setting the Spelldamage to be increased by 100% is only twice as powerful... think I'll hit a glass ceiling there too quickly.

Seems like it would be best to modify a handfull of spells and make them click effects on armor/weapons.. that way when at low level and weak on resists, lowbies won't be getting 1 or 2-shot.

Either way, thank you both for the knowledge, I'll keep plugging away and see if I can make anything click.

[Caryatis]

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.