Extract user points

  • cyberleo4u

    (@cyberleo4u)


    5 years, 5 months ago

    Thank you for your help with using this plugin – it’s great! May I ask whether it’s possible to extract user points and save them in .csv or any other way so that it can be saved or even printed accordingly?

    Thank you and good day!

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author J.D. Grimes

    (@jdgrimes)

    5 years, 5 months ago

    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.

    Thread Starter cyberleo4u

    (@cyberleo4u)

    5 years, 5 months ago

    Thank you! Will let you know if need be!

    Best Regards,
    Leonard Callus

    Thread Starter cyberleo4u

    (@cyberleo4u)

    5 years, 2 months ago

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

    Thread Starter cyberleo4u

    (@cyberleo4u)

    5 years, 2 months ago

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

    Plugin Author J.D. Grimes

    (@jdgrimes)

    5 years, 2 months ago

    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 5 years, 2 months ago by J.D. Grimes. Reason: code formatting
    Thread Starter cyberleo4u

    (@cyberleo4u)

    5 years, 2 months ago

    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.

    Thread Starter cyberleo4u

    (@cyberleo4u)

    5 years, 2 months ago

    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!

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Extract user points’ is closed to new replies.