Windows Small problem

[Gkatt]

Hello my Vocations.xml was fucked up so now when a mage level 13 is supposed to have for example 20 hp he gave 40hp

How can i set all characters on my database to their normal hp?

thanks.

 

[hodleo]

using kito2's health formula query :

UPDATE `players` SET `healthmax` = ((`players`.`level` - 8) * 15 + 185) WHERE `vocation`= 2;
UPDATE `players` SET `health` = ((`players`.`level` - 8) * 15 + 185) WHERE `vocation`= 2;