I'm trying to display a table of results for particular users who have submitted answers to quizzes. The problem is that the mysql database I am working with has a funky value for the user's ID.
I'm working off of the plugin WP Simple Survey, which allows the admin to create a number of surveys and weight answers with "points." The only data table that has a unique value for the user's id is "submitter_id," but the format is not the regular WP user id expressed as a number. Instead it looks like this:
wpss_4fc2636f6814a
I need a way to translate this to a typical user_id or user_login in the wp_users table so I can make a plugin that will display users' total scores.
UPDATE: From the suggestion below, it appears the submitter_id is being created by the uniqid function in PHP. Apparently, it's a unique string that reflects the current time.
So... the only thing to do now (I think) is to create a variable based on a mysql query that will retrieve the current logged in user's id and set that to the 'submitter_id.'
submitter_id
is generated and reverse that in your own plugin.