I have been playing around with this for about 30 minutes now trying to help you out and im on one last hope that I figured it out but its doubtful.
I used:
Code:
UPDATE spells_new set buffdurationformula = 11 where buffgroup = 32
spell group 32 seems to be associated with all cleric HP buffs like Aegolism, Courage and Temerity. buffdurationformula 11 is supposed to set the formula to = the entire duration yet seems to not over power the level scaling. Spell group 32 does not change every cleric HP buff its random ones, like tenacity is spell group 1032.
If I knew the buffs I wanted to change the formula for I would do it this way;
Code:
UPDATE spells_new set buffdurationformula = 11 where id = 9820 and id = etc etc etc
... you get the point.
*I stand corrected I did get it using that code, however I would do more research on the exact "spell group" before doing it as I did, or perhaps put all the spells you want into a spell group and then you can change them together if you do not like the results. You can effecitvely cast Temerity rk 3 on a lvl 1 using buff bot for a 2 hour duration.
Threaded Mode
