MyBB Codes

Full Version: Myps Denomination
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi, is it possible, to devide all myps for all users by 10, for example, if user has 1000 myps, after this denomination he will have 100 myps etc....

Dont know if its possible, maybe some database rule or something.. its very important to me, exdiogene helpBig Grin
Using a query in PHPmyAdmin you can easily achieve this. First select your "users" table and in the SQL query box, type this :

UPDATE `mybb_users` SET `myps`=`myps` / 10

Make sure you have backed up your database just in case before altering it. Better be cautious than sorry!
thank you for help Rej, I will try this on saturdayWink
Reference URL's