Solved Change the amount of mana for all players.

[ohman]

Hi, I did a mistake on my server. I was going to change how fast the mana is regenerate for knights and elite knights. But I did wrong and changed instead the mana amount when leveling up, instead of 5 mana per level they got 10 for 1 day. Now I changed back. But all players that took level has more mana is still more than it should be.

Is there any way to change mana for all knights and elite knights, like this: level * 5 = mana amount in like sql? Thanks!

 

[Ninja]

UPDATE `players` SET `mana` = `level` * 5, `manamax` = `level` * 5 WHERE `vocation` = 4;

 

[ohman]

Do the server need to be offline? or can I do it in "close server" function? So only gods is allowed to loggin. Thanks!

 

[Ninja]

Server can be online but players needs to be offline while executing this query in PMA.

 

[ohman]

Ok, thanks!

 

[ohman]

Btw Ninja, your smart! Maybe you can solve this problem: http://otland.net/threads/my-server-dont-show-loot-message.207231/#post-1986434 Thanks!