I need to replicate the following Form Email Plugin Email To (Eval) code, to use in the Schedule Email Plugin to obtain the email addresses.
$db =& JFactory::getDBO(); $query = "SELECT `Email` FROM `steward` WHERE `id` IN ('{calendar___chairsteward_raw}','{calendar___steward2_raw}','{calendar___steward3_raw}','{calendar___steward4_raw}')"; $db->setQuery($query); $results = $db->loadColumn();
$email_list = implode(',',$results); return $email_list;
I have copied the calendar List, added two pre-filters to provide the events within the next 7 days and setup the Schedule with an email plugin to send emails reminding the stewards of their next event. This all works when I manually type in an addresses or multiple addresses in the Email to section of the schedule email plugin.
The Schedule Email Plugin doesn't have the Email to (Eval) option.
How can I setup the email reminder to select the required email addresses?
Steve
Australia
$db =& JFactory::getDBO(); $query = "SELECT `Email` FROM `steward` WHERE `id` IN ('{calendar___chairsteward_raw}','{calendar___steward2_raw}','{calendar___steward3_raw}','{calendar___steward4_raw}')"; $db->setQuery($query); $results = $db->loadColumn();
$email_list = implode(',',$results); return $email_list;
I have copied the calendar List, added two pre-filters to provide the events within the next 7 days and setup the Schedule with an email plugin to send emails reminding the stewards of their next event. This all works when I manually type in an addresses or multiple addresses in the Email to section of the schedule email plugin.
The Schedule Email Plugin doesn't have the Email to (Eval) option.
How can I setup the email reminder to select the required email addresses?
Steve
Australia