|
Patrick142
|
October 2, 2017 at 11:08 pm
Our site was recently hacked and the hosting company needed to restore the wordpress database as of a month prior. They did, however, create a SQL dump of the database prior to the restoration, which I have and was hoping I could locate some event details. What is/are the table/table names that would store event registration details? The client has all the emails they received, but this does not provide all the details.
Thanks!
|
|
Tony
|
October 3, 2017 at 4:30 am
Hi Patrick,
In my opinion, you would be much better off creating a dev site from the SQL dump locally installing only Event Espresso and a default theme on that site and then pulling the information using EE as normal.
There are multiple relationships created for each registration, depending on what information you want, pulling the information directly from the database is not going to be a simple task.
If you really want to take a look in the DB directly all of the EE tabls will start {site_prefix_}esp_, so, for example, one of my local sites has wp_esp_registration which stores the registration data, but that relates to an EE contact for the details and the wp_esp_question and wp_esp_answer tables for more details.
Events themselves are custom post types so stored within the wp_posts table but also like with wp_esp_datetimes and so on.
What details are you trying to pull in?
|
|
Patrick142
|
October 3, 2017 at 10:50 am
Thanks Tony. They are trying to just pull out the details of the registration such as all the family member’s names and dietary restrictions. The database was also compromised during the hack so I’m a little hesitant to point a local site at it for fear of re-infection.
|
|
Josh
|
October 3, 2017 at 11:14 am
Hi Patrick,
You can look in _esp_registration and take note of the ATT_ID and REG_ID values there. Then you can get the registrant’s personal info (First name, last name, email) from the _esp_attendee_meta table. You’ll use the ATT_ID as the key there.
Then you can get all the other info like dietary restrictions from the _esp_answer table. You’ll use the REG_ID as the key there.
|
