function calendar_cron()
{
require 'includes/classes/events.class.php';
require AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php';
//Iterate through each member's preference
$sql = "SELECT * FROM %scalendar_notification WHERE 1=1";
$rows_notify = queryDB($sql, array(TABLE_PREFIX));
$event_obj = new Events();
foreach ($rows_notify as $row) {
//Send email only when preference is 1
if ($row['status'] == 1) {
$all_events = array();
$mail = new ATutorMailer();
//Get personal events
$personal_events = $event_obj->get_personal_events($row['memberid']);
foreach ($personal_events as $event) {
$all_events[] = $event;
}
//Get course events
$sql_q = "SELECT course_id FROM %scourse_enrollment WHERE member_id = %d";
$rows_enrolled = queryDB($sql_q, array(TABLE_PREFIX, TABLE_PREFIX));
foreach ($rows_enrolled as $row_q) {
$course_events = $event_obj->get_atutor_events($row['memberid'], $row_q['course_id']);
foreach ($course_events as $event) {
$all_events[] = $event;
}
}
//Iterate through each event and keep only those events which will start tomorrow
$email_msg = _AT('calendar_noti_mail_1') . "\n";
$index = 1;
foreach ($all_events as $id => $event) {
if (strtotime(substr($event['start'], 0, 10)) == strtotime('tomorrow')) {
$email_msg .= _AT('calendar_noti_mail_2') . " #" . $index . " \n";
$email_msg .= _AT('calendar_noti_mail_3') . ": " . substr($event['start'], 0, 10) . " \n";
$email_msg .= _AT('calendar_noti_mail_4') . ": " . substr($event['end'], 0, 10) . " \n";
$email_msg .= _AT('calendar_noti_mail_5') . ": " . $event['title'] . " \n\n";
$index++;
}
}
//Send email using ATutor mailer
$mail->From = $_config['contact_email'];
$mail->FromName = $_config['site_name'];
$mail->AddAddress($_config['contact_email']);
$mail->Subject = $stripslashes(_AT('calendar_noti_title'));
$mail->Body = $email_msg;
$sql_email = "SELECT email FROM %smembers WHERE member_id = %d";
$row_email = queryDB($sql_email, array(TABLE_PREFIX, $row['memberid']), TRUE);
$mail->AddBCC($row_email['email']);
$mail->Send();
unset($mail);
//For testing
// echo "<br/>".$email_msg."<br/>".$row_email['mail'];
}
}
}
/**
* Add a job posting to the database.
* @param string job title
* @param string description
* @param Array categories id
* @param int 1 if public; 0 otherwise.
* @param string Closing date for this job post, mysql TIMESTAMP format
* @precondition ATutor Mailer class imported.
*/
function addJob($title, $description, $categories, $is_public, $closing_date)
{
require AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php';
global $addslashes, $db, $msg, $_config, $_base_href;
if ($_SESSION['jb_employer_id'] < 1) {
$msg->addError();
//authentication error
exit;
} else {
include AT_JB_INCLUDE . 'Employer.class.php';
$employer = new Employer($_SESSION['jb_employer_id']);
$employer_id = $employer->getId();
}
$title = $addslashes($title);
$description = $addslashes($description);
$is_public = isset($is_public) ? 1 : 0;
$closing_date = $addslashes($closing_date);
$approval_state = $_config['jb_posting_approval'] == 1 ? AT_JB_POSTING_STATUS_UNCONFIRMED : AT_JB_POSTING_STATUS_CONFIRMED;
$sql = 'INSERT INTO ' . TABLE_PREFIX . "jb_postings (employer_id, title, description, is_public, closing_date, created_date, revised_date, approval_state) VALUES ({$employer_id}, '{$title}', '{$description}', {$is_public}, '{$closing_date}', NOW(), NOW(), {$approval_state})";
$result = mysql_query($sql, $db);
$posting_id = mysql_insert_id();
//add to posting category table
if (!empty($categories)) {
foreach ($categories as $id => $category) {
$category = intval($category);
$sql = 'INSERT INTO ' . TABLE_PREFIX . "jb_posting_categories (posting_id, category_id) VALUES ({$posting_id}, {$category})";
mysql_query($sql, $db);
//send out notification if the person is subscribed to the category.
$sql = 'SELECT m.member_id, m.email FROM ' . TABLE_PREFIX . 'jb_category_subscribes cs LEFT JOIN ' . TABLE_PREFIX . "members m ON cs.member_id=m.member_id WHERE category_id={$category}";
$result = mysql_query($sql, $db);
$post_link = $_base_href . AT_JB_BASENAME . 'view_post.php?jid=' . $posting_id;
if ($result) {
while ($row = mysql_fetch_assoc($result)) {
$mail = new ATutorMailer();
$mail->AddAddress($row['email'], get_display_name($row['member_id']));
$body = _AT('jb_subscription_msg', $title, $this->getCategoryNameById($category), $post_link);
$body .= "\n\n";
$body .= _AT('jb_posted_by') . ": " . htmlentities_utf8($employer->getCompany()) . "\n";
$mail->FromName = $_config['site_name'];
$mail->From = $_config['contact_email'];
$mail->Subject = _AT('jb_subscription_mail_subject');
$mail->Body = $body;
if (!$mail->Send()) {
$msg->addError('SENDING_ERROR');
}
unset($mail);
}
}
}
}
if (!$result) {
//TODO: db error message
$msg->addError();
}
}
$mail->From = $_config['contact_email'];
if (defined('AT_EMAIL_CONFIRMATION') && AT_EMAIL_CONFIRMATION && $_POST['status'] == AT_STATUS_UNCONFIRMED) {
$code = substr(md5($_POST['email'] . $now . $m_id), 0, 10);
$confirmation_link = AT_BASE_HREF . 'confirm.php?id=' . $m_id . SEP . 'm=' . $code;
/* send the email confirmation message: */
$mail->Subject = $_config['site_name'] . ': ' . _AT('email_confirmation_subject');
$body .= _AT('admin_new_account_confirm', $_config['site_name'], $confirmation_link) . "\n\n";
} else {
$mail->Subject = $_config['site_name'] . ": " . _AT('account_information');
$body .= _AT('admin_new_account', $_config['site_name']) . "\n\n";
}
$body .= _AT('web_site') . ' : ' . AT_BASE_HREF . "\n";
$body .= _AT('login_name') . ' : ' . $_POST['login'] . "\n";
$body .= _AT('password') . ' : ' . $_POST['form_password2'] . "\n";
$mail->Body = $body;
$mail->Send();
$msg->addFeedback('PROFILE_CREATED_ADMIN');
header('Location: ' . AT_BASE_HREF . 'mods/_core/users/users.php');
exit;
}
}
$onload = 'document.form.login.focus();';
$savant->assign('languageManager', $languageManager);
$savant->assign('no_captcha', true);
if (!isset($_POST['status'])) {
if (defined('AT_EMAIL_CONFIRMATION') && AT_EMAIL_CONFIRMATION) {
$_POST['status'] = AT_STATUS_UNCONFIRMED;
} else {
$_POST['status'] = AT_STATUS_STUDENT;
}
}
$recipient_list .= "<li>" . $recip . "</li>";
$subject = $_POST['subject'];
$body = $_POST['body'];
$mail = new ATutorMailer();
$mail->From = $row['email'];
$mail->FromName = $row['first_name'] . ' ' . $row['last_name'];
$subject = str_replace('{AT_FNAME}', $fname_list[$recip], $subject);
$subject = str_replace('{AT_LNAME}', $lname_list[$recip], $subject);
$body = str_replace('{AT_FNAME}', $fname_list[$recip], $body);
$body = str_replace('{AT_LNAME}', $lname_list[$recip], $body);
$body = str_replace('{AT_EMAIL}', $recip, $body);
$body = str_replace('{AT_USER}', $login_list[$recip], $body);
$mail->Subject = $subject;
$mail->AddAddress($recip);
$mail->Body = $body;
if (!$mail->Send()) {
$msg->addError('SENDING_ERROR');
header('Location: ' . $_SERVER['PHP_SELF']);
exit;
}
unset($mail);
}
$list_feedback = array('COURSE_EMAIL_RECIPIENT_LIST', $recipient_list);
$msg->addFeedback($list_feedback);
header('Location: ' . $_base_href . 'tools/index.php');
exit;
}
}
}
require AT_INCLUDE_PATH . 'header.inc.php';
$sql = "SELECT COUNT(*) AS cnt FROM %scourse_enrollment C, %smembers M WHERE C.course_id=%d AND C.member_id=M.member_id AND M.member_id<>%d ORDER BY C.approved, M.login";
public function send_mail($entity_type, $entity_id, $post_id)
{
// We need the automailer
require AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php';
//Also, we need to know what ballpark we're in
$ent_param = $this->entity_switch($entity_type);
// Now, what are we going to send?
$fetch = !empty($ent_param[content_head]) ? $ent_param[content_head] . "," . $ent_param[content_body] : $ent_param[content_body];
$sql = "SELECT {$fetch} FROM {$ent_param['content_table']} WHERE {$ent_param['content_id']} = '{$post_id}'";
$post = queryDB($sql, array());
//Get all subscribers
$sql = "SELECT t1.email, t1.member_id FROM " . TABLE_PREFIX . "members t1, {$ent_param['sub_table']} t2 WHERE t2.{$ent_param['sub_id']} = '{$entity_id}' AND t1.member_id=t2.member_id";
$rows_subscribers = queryDB($sql, array());
//get system email
$sysinfo = $this->get_system_email();
//Send lots of mails
foreach ($rows_subscribers as $subscriber) {
$mail = new ATutorMailer();
$mail->AddAddress($subscriber['email'], get_display_name($subscriber['member_id']));
$body = $ent_param[mail_header];
$body .= "<hr />";
$body .= _AT('posted_by') . ": " . get_display_name($_SESSION['member_id']) . "<br />";
$body .= !empty($ent_param[content_head]) ? "<h2>" . $post[$ent_param[content_head]] . "</h2><br />" : '';
$body .= format_content($post[$ent_param[content_body]], $_POST['formatting'], $glossary) . "<br />";
$mail->CharSet = 'utf-8';
$mail->ContentType = 'text/html';
$mail->FromName = $sysinfo['site_name'];
$mail->From = $sysinfo['contact_email'];
$mail->Subject = $ent_param[mail_subject];
$mail->Body = $body;
if (!$mail->Send()) {
$msg->addError('SENDING_ERROR');
}
unset($mail);
}
}
function add_users($user_list, $enroll, $course)
{
global $db;
global $msg;
global $_config;
global $addslashes;
require_once AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php';
if (defined('AT_EMAIL_CONFIRMATION') && AT_EMAIL_CONFIRMATION) {
$status = AT_STATUS_UNCONFIRMED;
} else {
$status = AT_STATUS_STUDENT;
}
foreach ($user_list as $student) {
if (!$student['remove']) {
$student['uname'] = $addslashes($student['uname']);
$student['email'] = $addslashes($student['email']);
$student['fname'] = $addslashes($student['fname']);
$student['lname'] = $addslashes($student['lname']);
if (!$student['exists']) {
$sql = "INSERT INTO %smembers \n\t\t\t\t (login,\n\t\t\t\t password,\n\t\t\t\t email,\n\t\t\t\t first_name,\n\t\t\t\t last_name,\n\t\t\t\t gender,\n\t\t\t\t status,\n\t\t\t\t preferences,\n\t\t\t\t creation_date,\n\t\t\t\t language,\n\t\t\t\t inbox_notify,\n\t\t\t\t private_email)\n\t\t\t\t VALUES \n\t\t\t\t ('{$student['uname']}',\n\t\t\t\t '" . sha1($student[uname]) . "',\n\t\t\t\t '{$student['email']}',\n\t\t\t\t '{$student['fname']}',\n\t\t\t\t '{$student['lname']}',\n\t\t\t\t 'n', \n\t\t\t\t {$status}, \n\t\t\t\t '{$_config['pref_defaults']}', \n\t\t\t\t NOW(),\n\t\t\t\t '{$_config['default_language']}', \n\t\t\t\t {$_config['pref_inbox_notify']}, \n\t\t\t\t 1)";
$result = queryDB($sql, array(TABLE_PREFIX));
if ($result == 1) {
$m_id = at_insert_id();
$student['exists'] = _AT('import_err_email_exists');
$role = "Student";
$sql = "INSERT INTO %scourse_enrollment (member_id, course_id, approved, last_cid, role) VALUES (%d, %d, '%s', 0, '%s')";
$result = queryDB($sql, array(TABLE_PREFIX, $m_id, $course, $enroll, $role));
if ($result > 0) {
$enrolled_list .= '<li>' . $student['uname'] . '</li>';
if (defined('AT_EMAIL_CONFIRMATION') && AT_EMAIL_CONFIRMATION) {
$sql = "SELECT email, creation_date FROM %smembers WHERE member_id=%d";
$row = queryDB($sql, array(TABLE_PREFIX, $m_id), TRUE);
$code = substr(md5($row['email'] . $row['creation_date'] . $m_id), 0, 10);
// send email here.
$confirmation_link = AT_BASE_HREF . 'confirm.php?id=' . $m_id . SEP . 'm=' . $code;
$subject = $_config['site_name'] . ': ' . _AT('email_confirmation_subject');
$body = _AT(array('new_account_enroll_confirm', $_SESSION['course_title'], $confirmation_link)) . "\n\n";
} else {
$subject = $_config['site_name'] . ': ' . _AT('account_information');
$body = _AT(array('new_account_enroll', AT_BASE_HREF, $_SESSION['course_title'])) . "\n\n";
}
//$body .= SITE_NAME.': '._AT('account_information')."\n";
$body .= _AT('web_site') . ' : ' . AT_BASE_HREF . "\n";
$body .= _AT('login_name') . ' : ' . $student['uname'] . "\n";
$body .= _AT('password') . ' : ' . $student['uname'] . "\n";
$mail = new ATutorMailer();
$mail->From = $_config['contact_email'];
$mail->AddAddress($student['email']);
$mail->Subject = $subject;
$mail->Body = $body;
$mail->Send();
unset($mail);
} else {
$already_enrolled .= '<li>' . $student['uname'] . '</li>';
}
} else {
//$msg->addError('LIST_IMPORT_FAILED');
}
} else {
if (!$student['err_disabled']) {
$sql = "SELECT member_id FROM %smembers WHERE email='%s'";
$rows_members = queryDB($sql, array(TABLE_PREFIX, $student['email']), TRUE);
$role = "Student";
if (count($rows_members) > 0) {
$row = $rows_members;
$m_id = $row['member_id'];
$sql = "INSERT INTO %scourse_enrollment (member_id, course_id, approved, last_cid, role) VALUES (%d, %d, '%s', 0, '%s')";
$result = queryDB($sql, array(TABLE_PREFIX, $m_id, $course, $enroll, $role));
if ($result > 0) {
$enrolled_list .= '<li>' . $student['uname'] . '</li>';
} else {
$sql = "REPLACE INTO %scourse_enrollment (member_id, course_id, approved, last_cid, role) VALUES (%d, %s, '%s', 0, '%s')";
$result = queryDB($sql, array(TABLE_PREFIX, $m_id, $course, $enroll, $role));
$enrolled_list .= '<li>' . $student['uname'] . '</li>';
}
$subject = $_config['site_name'] . ': ' . _AT('email_confirmation_subject');
$body = _AT(array('enrol_message_approved', $_SESSION['course_title'], AT_BASE_HREF)) . "\n\n";
$body .= _AT('web_site') . ' : ' . AT_BASE_HREF . "\n";
$body .= _AT('login_name') . ' : ' . $student['uname'] . "\n";
$mail = new ATutorMailer();
$mail->From = $_config['contact_email'];
$mail->AddAddress($student['email']);
$mail->Subject = $subject;
$mail->Body = $body;
$mail->Send();
unset($mail);
}
} else {
if ($student['err_disabled']) {
$not_enrolled_list .= '<li>' . $student['uname'] . '</li>';
}
}
}
}
}
if ($already_enrolled) {
$feedback = array('ALREADY_ENROLLED', $already_enrolled);
$msg->addFeedback($feedback);
}
if ($enrolled_list) {
$feedback = array('ENROLLED', $enrolled_list);
$msg->addFeedback($feedback);
}
if ($not_enrolled_list) {
$feedback = array('NOT_ENROLLED', $not_enrolled_list);
$msg->addFeedback($feedback);
}
}
/**
* Enrolls students into course enrollement
* @access private
* @param array $list the IDs of the members to be added
* @author Shozub Qureshi
*/
function enroll($list)
{
global $db, $msg, $_config, $course_id, $owner;
require AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php';
$num_list = count($list);
$members = '(member_id=' . $list[0] . ')';
for ($i = 0; $i < $num_list; $i++) {
$id = intval($list[$i]);
$members .= ' OR (member_id=' . $id . ')';
$sql = "INSERT INTO " . TABLE_PREFIX . "course_enrollment VALUES ({$id}, {$course_id}, 'y', 0, '', 0)";
$result = mysql_query($sql, $db);
if (mysql_affected_rows($db) != 1) {
$sql = "UPDATE " . TABLE_PREFIX . "course_enrollment SET approved='y' WHERE course_id={$course_id} AND member_id={$id}";
$result = mysql_query($sql, $db);
}
}
//get First_name, Last_name of course Instructor
$sql_from = "SELECT first_name, last_name, email FROM " . TABLE_PREFIX . "members WHERE member_id = {$owner}";
$result_from = mysql_query($sql_from, $db);
$row_from = mysql_fetch_assoc($result_from);
$email_from_name = $row_from['first_name'] . ' ' . $row_from['last_name'];
$email_from = $row_from['email'];
//get email addresses of users:
$sql_to = "SELECT email FROM " . TABLE_PREFIX . "members WHERE ({$members})";
$result_to = mysql_query($sql_to, $db);
while ($row_to = mysql_fetch_assoc($result_to)) {
// send email here.
$login_link = AT_BASE_HREF . 'login.php?course=' . $course_id;
$subject = SITE_NAME . ': ' . _AT('enrol_message_subject');
$body = SITE_NAME . ': ' . _AT('enrol_message_approved', $_SESSION['course_title'], $login_link) . "\n\n";
$mail = new ATutorMailer();
$mail->From = $_config['contact_email'];
$mail->FromName = $_config['site_name'];
$mail->AddAddress($row_to['email']);
$mail->Subject = $subject;
$mail->Body = $body;
if (!$mail->Send()) {
$msg->addError('SENDING_ERROR');
}
unset($mail);
}
}
/**
* Enrolls students into course enrollement
* @access private
* @param array $list the IDs of the members to be added
* @author Shozub Qureshi
*/
function enroll($list)
{
global $msg, $_config, $course_id, $owner;
require AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php';
$num_list = count($list);
$members = '(member_id=' . $list[0] . ')';
for ($i = 0; $i < $num_list; $i++) {
$id = intval($list[$i]);
$members .= ' OR (member_id=' . $id . ')';
$sql = "REPLACE INTO %scourse_enrollment VALUES (%d, %d, 'y', 0, 'Student', 0)";
$result_enrolled = queryDB($sql, array(TABLE_PREFIX, $id, $course_id));
if ($result_enrolled != 1) {
$sql = "UPDATE %scourse_enrollment SET approved='y' WHERE course_id=%d AND member_id=%d";
$result = queryDB($sql, array(TABLE_PREFIX, $course_id, $id));
}
}
//get First_name, Last_name of course Instructor
$sql_from = "SELECT first_name, last_name, email FROM %smembers WHERE member_id = %d";
$row_from = queryDB($sql_from, array(TABLE_PREFIX, $owner), TRUE);
$email_from_name = $row_from['first_name'] . ' ' . $row_from['last_name'];
$email_from = $row_from['email'];
//get email addresses of users:
$sql_to = "SELECT email FROM %smembers WHERE (%s)";
$rows_to = queryDB($sql_to, array(TABLE_PREFIX, $members));
foreach ($rows_to as $row_to) {
// send email here.
$login_link = AT_BASE_HREF . 'login.php?course=' . $course_id;
$subject = SITE_NAME . ': ' . _AT('enrol_message_subject');
$body = SITE_NAME . ': ' . _AT('enrol_message_approved', $_SESSION['course_title'], $login_link) . "\n\n";
$mail = new ATutorMailer();
$mail->From = $_config['contact_email'];
$mail->FromName = $_config['site_name'];
$mail->AddAddress($row_to['email']);
$mail->Subject = $subject;
$mail->Body = $body;
if (!$mail->Send()) {
$msg->addError('SENDING_ERROR');
}
unset($mail);
}
}
function add_users($user_list, $enroll, $course) {
global $db;
global $msg;
global $_config;
global $addslashes;
require_once(AT_INCLUDE_PATH.'classes/phpmailer/atutormailer.class.php');
if (defined('AT_EMAIL_CONFIRMATION') && AT_EMAIL_CONFIRMATION) {
$status = AT_STATUS_UNCONFIRMED;
} else {
$status = AT_STATUS_STUDENT;
}
foreach ($user_list as $student) {
if (!$student['remove']) {
$student['uname'] = $addslashes($student['uname']);
$student['email'] = $addslashes($student['email']);
$student['fname'] = $addslashes($student['fname']);
$student['lname'] = $addslashes($student['lname']);
if (!$student['exists']) {
$sql = "INSERT INTO ".TABLE_PREFIX."members
(login,
password,
email,
first_name,
last_name,
gender,
status,
preferences,
creation_date,
language,
inbox_notify,
private_email)
VALUES
('$student[uname]',
'". sha1($student[uname]). "',
'$student[email]',
'$student[fname]',
'$student[lname]',
'n',
$status,
'$_config[pref_defaults]',
NOW(),
'$_config[default_language]',
$_config[pref_inbox_notify],
1)";
$result = mysql_query($sql, $db);
if (mysql_affected_rows($db) == 1) {
$m_id = mysql_insert_id($db);
$student['exists'] = _AT('import_err_email_exists');
$sql = "INSERT INTO ".TABLE_PREFIX."course_enrollment (member_id, course_id, approved, last_cid) VALUES ($m_id, $course, '$enroll', 0)";
if ($result = mysql_query($sql,$db)) {
$enrolled_list .= '<li>' . $student['uname'] . '</li>';
if (defined('AT_EMAIL_CONFIRMATION') && AT_EMAIL_CONFIRMATION) {
$sql = "SELECT email, creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$m_id";
$result = mysql_query($sql, $db);
$row = mysql_fetch_assoc($result);
$code = substr(md5($row['email'] . $row['creation_date'] . $m_id), 0, 10);
// send email here.
$confirmation_link = AT_BASE_HREF . 'confirm.php?id='.$m_id.SEP.'m='.$code;
$subject = $_config['site_name'].': '._AT('email_confirmation_subject');
$body = _AT(array('new_account_enroll_confirm', $_SESSION['course_title'], $confirmation_link))."\n\n";
} else {
$subject = $_config['site_name'].': '._AT('account_information');
$body = _AT(array('new_account_enroll',AT_BASE_HREF, $_SESSION['course_title']))."\n\n";
}
//$body .= SITE_NAME.': '._AT('account_information')."\n";
$body .= _AT('web_site') .' : '.AT_BASE_HREF."\n";
$body .= _AT('login_name') .' : '.$student['uname'] . "\n";
$body .= _AT('password') .' : '.$student['uname'] . "\n";
$mail = new ATutorMailer;
$mail->From = $_config['contact_email'];
$mail->AddAddress($student['email']);
$mail->Subject = $subject;
$mail->Body = $body;
$mail->Send();
unset($mail);
} else {
$already_enrolled .= '<li>' . $student['uname'] . '</li>';
}
} else {
//$msg->addError('LIST_IMPORT_FAILED');
}
} else if (! $student['err_disabled']) {
$sql = "SELECT member_id FROM ".TABLE_PREFIX."members WHERE email='$student[email]'";
$result = mysql_query($sql, $db);
if ($row = mysql_fetch_assoc($result)) {
$m_id = $row['member_id'];
$sql = "INSERT INTO ".TABLE_PREFIX."course_enrollment (member_id, course_id, approved, last_cid, role) VALUES ($m_id, $course, '$enroll', 0, '$role')";
if($result = mysql_query($sql,$db)) {
$enrolled_list .= '<li>' . $student['uname'] . '</li>';
} else {
$sql = "REPLACE INTO ".TABLE_PREFIX."course_enrollment (member_id, course_id, approved, last_cid, role) VALUES ($m_id, $course, '$enroll', 0, '$role')";
$result = mysql_query($sql,$db);
$enrolled_list .= '<li>' . $student['uname'] . '</li>';
}
$subject = $_config['site_name'].': '._AT('email_confirmation_subject');
$body = _AT(array('enrol_message_approved',$_SESSION['course_title'],AT_BASE_HREF))."\n\n";
$body .= _AT('web_site') .' : '.AT_BASE_HREF."\n";
$body .= _AT('login_name') .' : '.$student['uname'] . "\n";
$mail = new ATutorMailer;
$mail->From = $_config['contact_email'];
$mail->AddAddress($student['email']);
$mail->Subject = $subject;
$mail->Body = $body;
$mail->Send();
unset($mail);
}
} else if ($student['err_disabled']) {
$not_enrolled_list .= '<li>' . $student['uname'] . '</li>';
}
}
}
if ($already_enrolled) {
$feedback = array('ALREADY_ENROLLED', $already_enrolled);
$msg->addFeedback($feedback);
}
if ($enrolled_list) {
$feedback = array('ENROLLED', $enrolled_list);
$msg->addFeedback($feedback);
}
if ($not_enrolled_list) {
$feedback = array('NOT_ENROLLED', $not_enrolled_list);
$msg->addFeedback($feedback);
}
}
