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

Viewing 2 reply threads


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

Viewing 2 reply threads

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.

Event Espresso