SQL script masters, need to translate to a query pls

[denvee]

If ChaReborn = 40 and
ChaPower + ChaStrong + ChaStrength + ChaSpirit + ChaDex + ChaStRemain is less than 65535
then set
ChaPower =0, ChaStrong =0, ChaStrength =0, ChaSpirit =0 ChaDex =0 ChaStRemain = 65535


can a sql master help me get this in a query form?

basically i want a query to set all the 40 rb characters who has stats less than 65535 to reset all stats to zero and place 65535 on the remaining stats holder...

so requirement is 40 rb and total stats is less than 65535

[MentaL]

[denvee]

no one?

[tearhear18]

you mean reset i can do it in php?
if reborn level = 40 reset stats? to 0 then all the total stats will be stored?

sample i have dex=100 pow=100 int=150 then my reborn level=40

you can put a trigger set the reborn level to 0 and then set chatstatsremain to = 350 ??

or explain more so i can help you..

[denvee]

i have my auto reborn set wrongly and some characters has jump RB meaning lack of stats... so what i want to do is create a query to have all the lacking stats be put back in... therefore adding all the pow+dex+bla bla if less than 65535 then reset all pow dex vit bla bla to zero and put 65535 on remaining stats....

oh and i already fix the autoreborn so it doesnt jump.... i just need to fix the old characters...

requirement is ChaReborn = 40 and
ChaPower + ChaStrong + ChaStrength + ChaSpirit + ChaDex + ChaStRemain > 65535
then set
ChaPower =0, ChaStrong =0, ChaStrength =0, ChaSpirit =0 ChaDex =0 ChaStRemain = 65535

without that 40 RB requirement then even the 20rb character will have the 65535 total stats.... my reborn system does not reset the stats every RB it just adds to it

[tearhear18]

okie i can help you.. add it on your control panel...

FIX MY STATS

this function :

check character if Character Reborn is equal to 40 and if total stats is below 65535

DO->>Reset all stats and insert
ChaStRemain= 65535

====================
i will do this function later in php