Lower magic levels by vocations in SQL?

[Rethen]

I want to like lower the magic level in vocations and sql...

like if mage, if like 90 they get like 75 (that much %~)

if pally, if have mlvl 30 get like 19-22 (that much %~)

if ek, if they have ml 10-13 lower to 9

 

[Probly]

english please?

 

[Rethen]

You can't english or? Your the one that can't read. Just help me or gtfo

 

[soul4soul]

he wants to reduce every1's ml on his server.
and he is giving examples. if they have ml90 he wants to set them back to 75 or so~ etc....

 

[Syntax]

Well I forgot most MySQL syntax so I can't help you off the top of my head but the factor you want is 1.2

90/1.2 = 75
30/1.2 = 25
11/1.2 = 9.1

So just do all players magic level divided by 1.2 and you'll be fine.

 

[Rethen]

Thanks for the maths, now I need SQL

but now i got the maths so

like if x ml higher than 75 divied it with 1.2 on mages
if under 75 do not touch

so the same on rp and ek

 

[Rethen]

Bump!