Thanks for the fix in the event reminder. It is working nicely. My recommendation is to add the tag
[EVENT_LOCATION] to the email.
Here is the code change required to make it happen:
com_eventbooking\site\models\reminder.php
Code:
line 44 change SQL query to bring in eb_locations
$sql = 'SELECT a.id, a.first_name, a.last_name, a.email, a.register_date, a.transaction_id, b.id as event_id, b.title AS event_title, b.event_date, b.location_id, c.name as location_name, c.address, c.city, c.zip '
.' FROM #__eb_registrants AS a INNER JOIN #__eb_events AS b '
.' ON a.event_id = b.id INNER JOIN #__eb_locations AS c ON b.location_id = c.id '
.' WHERE a.published=1 AND a.is_reminder_sent = 0 AND b.enable_auto_reminder=1 AND (DATEDIFF(b.event_date, NOW()) <= b.remind_before_x_days) AND (DATEDIFF(b.event_date, NOW()) >=0) ORDER BY b.event_date, a.register_date '
.' LIMIT '.$numberEmailSendEachTime
& add event_location line at ~67:
$replaces['event_location'] = $row->location_name.' ('.$row->address.', '.$row->city.', '.$row->zip.')';
Can add in state if desired.
Tested and working on my system
