Tak? (Robie na bazie testowej )UPDATE `evo`.`players` SET `health` = 185 + (`players`.`level` - 8) * 5 WHERE `players`.`vocation` =1;
UPDATE `evo`.`players` SET `healthmax` = 185 + (`players`.`level` - 8) * 5 WHERE `players`.`vocation` =1;
UPDATE `evo`.`players` SET `mana` = 35 + (`players`.`level` - 8) * 30 WHERE `players`.`vocation` =1;
UPDATE `evo`.`players` SET `manamax` = 35 + (`players`.`level` - 8) * 30 WHERE `players`.`vocation` =1;
UPDATE `evo`.`players` SET `health` = 185 + (`players`.`level` - 8) * 5 WHERE `players`.`vocation` =2;
UPDATE `evo`.`players` SET `healthmax` = 185 + (`players`.`level` - 8) * 5 WHERE `players`.`vocation` =2;
UPDATE `evo`.`players` SET `mana` = 35 + (`players`.`level` - 8) * 30 WHERE `players`.`vocation` =2;
UPDATE `evo`.`players` SET `manamax` = 35 + (`players`.`level` - 8) * 30 WHERE `players`.`vocation` =2;
UPDATE `evo`.`players` SET `health` = 185 + (`players`.`level` - 8) * 10 WHERE `players`.`vocation` =3;
UPDATE `evo`.`players` SET `healthmax` = 185 + (`players`.`level` - 8) * 10 WHERE `players`.`vocation` =3;
UPDATE `evo`.`players` SET `mana` = 35 + (`players`.`level` - 8) * 15 WHERE `players`.`vocation` =3;
UPDATE `evo`.`players` SET `manamax` = 35 + (`players`.`level` - 8) * 15 WHERE `players`.`vocation` =3;
UPDATE `evo`.`players` SET `health` = 185 + (`players`.`level` - 8) * 15 WHERE `players`.`vocation` =4;
UPDATE `evo`.`players` SET `healthmax` = 185 + (`players`.`level` - 8) * 15 WHERE `players`.`vocation` =4;
UPDATE `evo`.`players` SET `mana` = 35 + (`players`.`level` - 8) * 5 WHERE `players`.`vocation` =4;
UPDATE `evo`.`players` SET `manamax` = 35 + (`players`.`level` - 8) * 5 WHERE `players`.`vocation` =4;