Hi Roger
By default, the system only send Reminder emails to paid registrants. It doesn't send reminder emails to Pending Registrants (which choose offline payment method). You can try to edit the code alitle to make it works :
1. Open the file components/com_eventbooking/models/reminder.php
2. Find the code below :
Code:
$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 '
.' FROM #__eb_registrants AS a INNER JOIN #__eb_events AS b '
.' ON a.event_id = b.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
;
3. Change it to :
Code:
$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 '
.' FROM #__eb_registrants AS a INNER JOIN #__eb_events AS b '
.' ON a.event_id = b.id '
.' WHERE (a.published=1 OR a.payment_method="os_offline") 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
;
After that, it should work as expected .
Tuan
