public static function flagAR($subscriberID, $subscribeARA)
{
$db = JFactory::getDBO();
foreach ($subscribeARA as $subscribeAR) {
//get the id of the ar with the max delay in subscribeARA
$maxDelayAR = jNews_Mailing::maxDelayAR($subscribeAR);
if (empty($maxDelayAR)) {
return true;
}
//we insert an entry in the queue that will flag that the last mail in the ar has been already sent to the user
//here insert in the delay column the listid of the AR so that we will no longer get the listid of the mailing through another query
$time = time();
$senddate = $time + $maxDelayAR->delay * 60;
$query = 'INSERT IGNORE INTO `#__jnews_queue`(subscriber_id, type, mailing_id, delay, send_date,suspend)';
$query .= 'VALUES(' . $subscriberID . ',8,' . $maxDelayAR->id . ',' . $subscribeAR . ',' . $senddate . ',1)';
$db->setQuery($query);
$db->query();
}
return false;
}
