Extract user points

There isn’t a feature like this available, but if you have access to phpMyAdmin or another database interface through your hosting control panel, you could export the user points that way. If that might be an option for you, I could help you craft the database query that you would need to run.

Thank you! Will let you know if need be!

Best Regards,
Leonard Callus

I have access now. What do I need to do please?
Thank you so much!!

As in I have access to the hosting control panel and I’m using hostgator

You would run a query on the wp_usermeta table using phpMyAdmin or another similar program. The table names may be slightly different if the prefix is different than wp_. You will also need to change the wordpoints_points-points to replace points with the slug of your points type (e.g., wordpoitns_points-credits).

SELECT users.display_name AS user, meta.meta_value AS points
FROM wp_users AS users
LEFT JOIN wp_usermeta AS meta
ON users.ID = meta.user_ID
AND meta.meta_key = 'wordpoints_points-points'
ORDER BY COALESCE(CONVERT(meta.meta_value, SIGNED INTEGER), 0) DESC, ID ASC

phpMyAdmin should give you the option to export the results as CSV.

• This reply was modified 6 years, 1 month ago by J.D. Grimes. Reason: code formatting

Hmmm for some reason I can’t find wp_usermeta under the list of databases :/ . They all start with wp_ however there’s isn’t one with that name.

Oh wait I managed!! Thank you so so much. Not sure if it made the whole difference but I used the wp_social-users table and ran the query from there and it worked. Thank you once again!