MyBB Central

Full Version: Bring it back to 0
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Is there a way to bring everyone's MYPS points back to 0 and if so how?
The easiest way for the would be to use the MySQL plugin or PHPmyAdmin, so that you can run an SQL query, and then use the UPDATE function to set all the points to 0. I could get back to you with the SQL query if i investigate the table structure.

The query would be:

UPDATE mybb_users SET myps='0'

This is if you left the prefix for all your tables as mybb_ which is default. Should you have changed it, just change the prefix.
k thanks Smile
No problem, just glad to help. Did you get it to work in the end?
yea it worked perfectly Smile
nice hack there. got mine to work