Update Points Directly in the Database

  • Resolved Steven Lin

    (@stevenlinx)


    6 years, 3 months ago

    Hi,

    I’ve a need to update a large list of user points.

    Since it’s a large list, I can’t use the manual method as outlined here as it will take too long:
    https://wordpoints.org/user-guide/manually-editing-a-users-points/

    I wonder if I can update the points by directly updating the DB table.

    1.)
    Is it correct the plug-in doesn’t seem to track a total point for each user?

    So adding new rows to the DB table [prefix]_wordpoints_points_logs would be the essential operation? Meaning, does the plug-in do other stuff that I should be aware of that can affect the operation of updating points.

    2.)
    Do you have any other suggestion on how to perform such operation?

    Thank you.

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

    (@jdgrimes)

    Hi @stevenlinx,

    1.)
    Is it correct the plug-in doesn’t seem to track a total point for each user?

    Actually, the plugin does track the total points for each user. It is in the usermeta table. So, updating the logs table is still a good idea, but the essential operation would be updating the totals in the usermeta.

    2.)
    Do you have any other suggestion on how to perform such operation?

    Instead of modifying the DB directly, it would be better to write a small script/plugin that would use the functions from WordPoints to update the user points, based on the list that you have.

Viewing 1 replies (of 1 total)
  • The topic ‘Update Points Directly in the Database’ is closed to new replies.