Mapping Database User ID between WordPress and Learnpress

  • I’m a noob at databases, so I need some help. I want to understand how the user_id in WordPress is mapped to the learnpress user_id.
    When I am looking at the data in the table ‘wp_users’ I see (ID, user_login, user_pass,…)
    the ID range is between 1 and 36.

    If I look at ‘learnpress_user_item_results’ we have (ID, user_item_id, result)
    now here the ID range is 1 to 21, so the ID in wp_users and this table is not representing the same ID.

    My question is, how can I figure out what learnpress ID corresponds with what wordpress ID?

Viewing 1 replies (of 1 total)
  • Plugin Support brianvu-tp

    (@briantp)

    Hi,

    Table “learnpress_user_item_results” will save results users are learning or finished course, it joins to table “learnpress_user_items” via “user_item_id” to know user_id and course_id, So if you want to map user_id of WP with user_id of LP you need to use clause to join SQL

    Thanks

Viewing 1 replies (of 1 total)
  • The topic ‘Mapping Database User ID between WordPress and Learnpress’ is closed to new replies.