+- MyBB Codes (http://www.mybbcodes.com)
+-- Forum: Babjusi's Previous Forum General Stuff (/forumdisplay.php?fid=42)
+--- Forum: General Support (/forumdisplay.php?fid=46)
+--- Thread: Myps Denomination (/showthread.php?tid=1687)
Myps Denomination - Mobius - 08-24-2010 01:47 AM
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 help
RE: Myps Denomination - exdiogene - 08-24-2010 03:10 PM
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!
RE: Myps Denomination - Mobius - 08-25-2010 01:26 AM
thank you for help Rej, I will try this on saturday
