User Data & REGISTRATION_DETAIL for SQL Query

Hi Tuan & others,

We use Event Booking on multiple websites. We have many custom fields.

Our client would like to directly query the User Registration Data (such as contact info, event info, and related custom fields) from the SQL database tables for import into a CRM system.

The client has a separate developer to do this work.

The Event Booking "Registration Email Messages" contain the User information that the developer would to pull from the SQL database. This includes the data represented by the "REGISTRATION_DETAIL" tags.

We are sending the Developer the SQL database tables which correspond to the Event Booking component so he can write his code.

Question: Can you recommend which Event Booking php files relate to the "Registration Email Messages" - We would like to send these files to the Developer so he can understand the logic of how the files are pull data from the database. He has asked for this since the emails contain all the info he will need to pull. This will help the Developer write his code.

For example, the following file in the directory "/componenets/com_eventbooking/emailtemplates/email_individual_detail.php" seems to be important but we do not have enough knowledge to be certain.

We are happy to Pay $$ for Advice on this topic.

This is very important to us.

Thanks to anyone who can help.

Dante O.

Hi Dante

1. Tell him that there are two tables hold the data of the registration record

- #__eb_registrants contains basic information such as first_name, last_name, event_id, transaction_id, payment amounts...

-#__eb_field_values store data of custom fields (custom fields which are created by admin of the site, not pre-populated custom fields). These custom fields has id >=14

2. If he want to look at the logic, he can look at the file components/com_eventbooking/helper/helper.php, there are two useful methods:

- buildTags
- getEmailContent (this method build the data which is used for [REGISTRATION_DETAIL] tag in the email message

Hope it helps

Regards,

Tuan