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']; } } }
/* modify it under the terms of the GNU General Public License */ /* as published by the Free Software Foundation. */ /****************************************************************/ /** * This file is used to generate ics file. */ $_user_location = 'public'; define('AT_INCLUDE_PATH', '../../../include/'); require AT_INCLUDE_PATH . 'vitals.inc.php'; require 'includes/classes/events.class.php'; $rows = array(); $eventObj = new Events(); //Create ics file in $ical string variable $ical = "BEGIN:VCALENDAR\nVERSION:2.0\nPRODID:-//ATutor//ATutor Calendar Module//EN"; //Get all the events of the user foreach ($eventObj->get_personal_events($_SESSION['member_id'], TRUE) as $event) { array_push($rows, $event); } //Get ATutor system events foreach ($eventObj->get_atutor_events($_SESSION['member_id'], $_SESSION['course_id'], TRUE) as $event) { array_push($rows, $event); } foreach ($rows as $row) { /*Timezone manipulation $sstamp = strtotime($row['start']) - ($_GET['hrs'] * 60 * 60); $estamp = strtotime($row['end']) - ($_GET['hrs'] * 60 * 60); $startdt = gmdate('Y-m-d H:i:s', $sstamp); $enddt = gmdate('Y-m-d H:i:s', $estamp); $part_s = explode(' ', $startdt);
$courses[] = $row['course_id']; } } $eventObj = new Events(); //Create an empty array and push all the events in it. $rows = array(); if (isset($_GET['all'])) { $member = $_SESSION['member_id']; } else { if (isset($_GET['mini'])) { $member = $_SESSION['member_id']; } else { $member = $_GET['mid']; } } foreach ($eventObj->get_personal_events($member) as $event) { if (!isset($_GET['all'])) { $event['editable'] = true; } array_push($rows, $event); } if (isset($_GET['all']) || isset($_GET['mini']) || isset($_GET['mid'])) { if (isset($_GET['all']) || isset($_GET['mini'])) { if (is_array($courses)) { $i = 0; foreach ($eventObj->get_atutor_events($_SESSION['member_id'], $courses[$i]) as $event) { array_push($rows, $event); $i++; } } else { foreach ($eventObj->get_atutor_events($_SESSION['member_id'], $_SESSION['course_id']) as $event) {