Support

Home › Forums › WP User Integration › Where is user_id stored in the esp tables?

Where is user_id stored in the esp tables?

Posted: April 19, 2018 at 6:12 pm


BoostersInABox

April 19, 2018 at 6:12 pm

I am using WP User Integration. I am running some queries and need to pull some information from the wp_users table. Where is the user_id stored? I found a reference to it in the esp_transaction table in the TXN_session_data field. I could try and pull it from there, but wanted to see if it is in its own field in another esp table. THANKS!


Tony

  • Support Staff

    •

April 20, 2018 at 5:39 am

Hi there,

It’s not, the ID of the EE contact that is linked to the user account is saved as EE_Attendee_ID as a user option, so its saved in {prefix}_usermeta

For example – http://take.ms/tD60X

user_id 1 links with the EE contact with ID 62.
user_id 13 links with EE contact 372 and so on.

Is that what you are looking for?


BoostersInABox

April 20, 2018 at 11:54 am

Tony,
This is EXACTLY what I was looking for. Thank you so much!!

Stacy

The support post ‘Where is user_id stored in the esp tables?’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Get online help with the WP User Integration add-on by creating a support topic in this forum. Offer member pricing with the WP User Integration. WP User Integration documentation.

Status: closed

Updated by  BoostersInABox 6 years ago ago

Topic Tags

Tagged: 

Notifications

This topic is: resolved
Event Espresso