[SQL] query needed

[Yaze]

Hello dear otland, i need a sql query

that will update all players with
voc 1 heatlh 100 healthmax 100, manamax 100,manamax 100
voc 2 heatlh 200 healthmax 200, manamax 200,manamax 200
voc 3 heatlh 300 healthmax 300, manamax 200,manamax 300
voc 4 heatlh 400 healthmax 400, manamax 200,manamax 400



thanks

Kind Regards,


Ohyeah - http://www.xanteria.net

 

[EvulMastah]

update players set health = vocation * 100, healthmax = health, mana = health, manamax = health where vocation > 0 and vocation < 5