Code:
update spells_new set effect_base_value1=effect_base_value1*3 where effect_base_value1>0;
would make the non-damage spells more potent... heals and buffs...
Code:
update spells_new set effect_base_value1=effect_base_value1*3 where effect_base_value1 < 0;
would effect damage spells
Since damage spells remove HP the value used is negative to reflect that.
Then any changes you make have also be made in spells_us.txt so the client can use the changes.
also bear in mind... the NPC spells are in the DB as well. So the tricky part is figuring out a filter to not make all the NPC spells DT like on accident.
then you have to figure some of the PC spells are used by NPC's also, so you either have to remove them from the spell list, or make a duplicate copy that does the damage you want the NPC to do.