[mysql] Query divide lvls of all players

[wesoly136]

I need a query that divide lvls of all players like there are players with lvls:
I. 100
II. 150
III. 200
and it will divide into 5 so that players will have lvls:
I. 20
II. 30
III. 40
Hope you understand my 'English maths'

 

[cbrm]

you want the samples and acc manager too?

 

[Peacy]

Oh i can make it for you if you want.

Correct me if i'm wrong: You wanna have when you create an account that you can choose between those lvls?

 

[Summ]

UPDATE `players` SET `level` = `level`/5;

Just this or any conditions?

 

[cbrm]

supposing that tfs db still fixes the exp based on new level

UPDATE `players` SET `level` = ceil(level/5) WHERE `level` > 1 AND `name` NOT LIKE "%Sample" AND `name` != "Account Manager";

Won't affect samples or acc manager
used math ceil to avoid decimals, but don't remember if they get like that in sql

 

[wesoly136]

Will test P

Thanks, works awesome

Summ
Cant rep
Cybershot
repped