Solved PhpMyAdmin - Command to change magic level!

[Rollern]

Hi!

I'm hosting a war ot where every mage got magic level 70. I need to change it to 60, is it possible to change them all in once by a command in my database?

Thanks in advance

 

[EvilSkillz]

yeap you can , but i can't remember the command now ... ~ ...
fuck i have exam tomorrow so i can only remember what have i studied
but i can call someone to help you
@Ninja , come on boy

 

[Ninja]

UPDATE `players` SET `maglevel` = 60, `manaspent` = 0 WHERE `vocation` IN (1, 2, 5, 6);

 

[EvilSkillz]

UPDATE `players` SET `maglevel` = 60, `manaspent` = 0 WHERE `vocation` IN (1, 2, 5, 6);

hehe i love you my friend <3
never let me down

 

[Rollern]

hehe i love you my friend <3
never let me down

UPDATE `players` SET `maglevel` = 60, `manaspent` = 0 WHERE `vocation` IN (1, 2, 5, 6);

Thanks guys helped me ALOT