Spellcrafter's Handbook

[Burningsoul]

Regardless, thanks a ton Audiogarden. Concise and to the point, hats off sir.

[AudioGarden21]

Originally Posted by lerxst2112

If I was going to do it like that I'd build a batch of queries based on specific effect ids for each of the possible slots. As an example, you might want direct damage spells to be stronger but not change slows.

Yeah.. it's late, hehe. After I read over your post, it dawned on me that other effects would get doubled which you certainly would not want. You'd definitely want to limit your queries to the proper effect id, else you'll double things like slows, and such, as lerxst2112 mentioned. In any case, I don't have too much experience using that sort of code (though I do understand it) since I just search through things manually and adjust accordingly, so you'd probably want to take lerxst's advice over mine. =)

Originally Posted by Burningsoul

Regardless, thanks a ton Audiogarden. Concise and to the point, hats off sir.

You sir, are welcome. =)

[Maceblade]

I ended up doing the command shortly after just to test it out, and it appears slows use slot 2 which is also value2... also another key note for anyone attempting that, you also have to raise the "max1" column as well. That is actually a positive number already so in order to correctly apply that to damage only spells you just have to add "where value1 < 0" otherwise it will increase buffs heals and other shit.

Stuns however use value2 for damage and value1 for stun duration, I left that field alone bc i didnt want to mess with slows.

the exact command I used was;

 UPDATE spells_new set effect_base_value1 = effect_base_value1 * 2 WHERE effect_base_value1 < 0 and classes1 < 254;

and

 UPDATE spells_new set max1 = max1 * 2 WHERE effect_base_value1 <0 and classes1 < 254;

Everytime I just swapped out the number after classes until all 16 were done so then it didnt effect all damage type spells. So far it seems to have taken and I havent noticed anything stupid going on.

*edit* One thing more I forgot to mention, this only increases direct damage type spells. Lifetaps, nukes and stuff like that. DoT's are not effected with the exception of the initial damage, they DoT portion is also a slot/value2 and like I said i didnt want to mess with it.

[jsr]

The spell table isn't designed with effect__base_value_# being linked to a spell effect. There are hundreds of effects but only 12 slots.

Warriors using defensive discs will certainly appreciate your update

You want something more like this (not tested);

UPDATE spells_new 
set effect_base_value1 = effect_base_value1 * 2, 
max1 = max1 * 2 
WHERE 
effect_base_value1 < 0 and 
effectid1 = [Spell ID to modify] and
(classes1 < 254 or classes2 < 254 or classes3 < 254 or classes4..(etc)....or classes16 <254);

Repeat for each of the 12 slots. Note that putting [spell id to modify] in the query will prompt you to specify a value to match against effectid1. In your case you'd enter the value for DD spells.