Reset User Points to Zero

the value is in the usermeta table in the database. The key is ‘namaste_points’. You just need to delete the rows that have this key.

Thanks, Prasunsen. Unfortunately, my site is hosted by someone else and I don’t have access to the database tables. I am the creator and admin for my site, but not at the server level. Is there another way to make this simple change? It seems that this would be a common request and should have a simple command to reset scores.

You can install SQL Executioner plugin and run any SQL query. For the moment there is no built in command. Sorry folks, we are receiving way too many requests for so many things. I have only 24 hours in the day.

I understand that you are getting more requests than you can handle. This is such a cool product that there must be a huge demand and I wouldn’t even think of asking you to do any changes on my behalf. I appreciate your recommendations on how to address this problem though. Unfortunately, since I don’t know SQL, I won’t be able to use your suggestion, and that may make this product unusable for my needs. Thank you and best of luck.

Russ

I’ll give you the query, you just need to paste it:

DELETE FROM $usermeta WHERE meta_key=’namaste_points’

Just drop that line and hit Execute SQL.

I’m adding the feature in to-do but no idea when will get to it.

Note that this will delete the points of ALL users, not of a specific user.

That query worked beautifully. Thank you VERY much. Keep up the good work with this awesome product.

Thanks!

This is now available as feature in your WP Users page (extra column shows namaste points and lets you cleanup for a specific user).

Thanks, Prasunsen. This works perfectly. I really appreciate your support and efforts.

Russ