+++ /dev/null
-<?php\r
-\r
-// simple cron script to run daily\r
-\r
-function fha_refresher_cron() {\r
- global $db, $system_courses, $_config;\r
-\r
- require_once(AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php');\r
-\r
- $mail = new ATutorMailer;\r
-\r
- $subject = _AT('fha_ref_automatic_email_reminder');\r
-\r
- $sql = "SELECT * FROM ".TABLE_PREFIX."fha_refresher WHERE enabled=1";\r
- $result = mysql_query($sql, $db);\r
- while ($row = mysql_fetch_assoc($result)) {\r
- $refresh_period_seconds = time() - ($row['refresh_period'] * 24 * 60 * 60);\r
- $max_refresh_period = $row['max_refresh_period'] * 24 * 60 * 60;\r
-\r
- // these are used in the mail footer\r
- $_SESSION['course_id'] = $row['course_id'];\r
- $_SESSION['course_title'] = $system_courses[$row['course_id']]['title'];\r
-\r
- $sql = "SELECT member_id, MAX(UNIX_TIMESTAMP(date_taken)) AS date_taken FROM ".TABLE_PREFIX."tests_results WHERE test_id=$row[test_id] AND final_score >= $row[pass_score] GROUP BY member_id";\r
- $test_result = mysql_query($sql, $db);\r
-\r
- while ($test_row = mysql_fetch_assoc($test_result)) {\r
- $refresh_difference = $test_row['date_taken'] - $refresh_period_seconds;\r
- if ((abs($refresh_difference) < $max_refresh_period) && ($refresh_difference < 0)) {\r
- $refresh_difference = abs($refresh_difference);\r
- if ((round($refresh_difference / 24 / 60 / 60) % $row['reminder_period']) == 0) {\r
- $sql = "SELECT login, email FROM ".TABLE_PREFIX."members WHERE member_id=$test_row[member_id]";\r
- $member_result = mysql_query($sql, $db);\r
- $member_row = mysql_fetch_assoc($member_result);\r
- \r
- $mail->From = $_config['contact_email'];\r
- $mail->AddAddress($member_row['email']);\r
- $mail->Subject = $subject;\r
- $mail->Body = _AT('fha_ref_automatic_email_body',$_SESSION['course_title'], $member_row['login']);\r
-\r
- $mail->Send();\r
-\r
- $mail->ClearAllRecipients();\r
- }\r
- }\r
- }\r
- }\r
-}\r
-?>
\ No newline at end of file