= c.next and fr.status = 1 and c.status = 1 and c.report_id is not null and c.email is not null"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) exit(); while ($val = $res->fetchRow()) { // We have jobs to execute in user language. // Get favorite report details. $options = ttFavReportHelper::getReportOptions($val['report_id']); if (!$options) continue; // Skip not found report. // Recycle global $user object, as user settings are specific for each report. $user = new ttUser(null, $options['user_id']); if (!$user->id) continue; // Skip not found user. // Skip users with disabled Notifications plugin. if (!$user->isPluginEnabled('no')) continue; // Recycle $i18n object because language is user-specific. $i18n->load($user->lang); // Check condition on a report. $condition_ok = true; if ($val['report_condition']) $condition_ok = ttReportHelper::checkFavReportCondition($options, $val['report_condition']); // Email report if condition is okay. if ($condition_ok) { if (ttReportHelper::sendFavReport($options, $val['subject'], $val['email'], $val['cc'])) echo "Report ".$val['report_id']. " sent.
"; else echo "Error while emailing report...
"; } // Calculate next execution time. $next = tdCron::getNextOccurrence($val['cron_spec'], $now + 60); // +60 sec is here to get us correct $next when $now is close to existing "next". // This is because the accuracy of tdcron class appears to be 1 minute. // Update last and next values in tt_cron. $sql = "update tt_cron set last = $now, next = $next where id = ".$val['id']; $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) continue; } echo "Done!";