2 /****************************************************************/
4 /****************************************************************/
5 /* Copyright (c) 2002-2010 */
6 /* Inclusive Design Institute */
9 /* This program is free software. You can redistribute it and/or*/
10 /* modify it under the terms of the GNU General Public License */
11 /* as published by the Free Software Foundation. */
12 /****************************************************************/
15 $_user_location = 'users';
16 define('AT_INCLUDE_PATH', '../include/');
17 require(AT_INCLUDE_PATH.'vitals.inc.php');
19 if (!$_SESSION['valid_user']) {
20 require(AT_INCLUDE_PATH.'header.inc.php');
21 $msg->printErrors('LOGIN_ENROL');
22 require(AT_INCLUDE_PATH.'footer.inc.php');
26 $course = intval($_REQUEST['course']);
31 $sql = "SELECT access, member_id FROM ".TABLE_PREFIX."courses WHERE course_id=$course";
32 $result = mysql_query($sql, $db);
33 $course_info = mysql_fetch_assoc($result);
35 if ($_POST['submit']) {
36 $_SESSION['enroll'] = AT_ENROLL_YES;
38 if ($course_info['access'] == 'private') {
39 $sql = "INSERT INTO ".TABLE_PREFIX."course_enrollment VALUES ($_SESSION[member_id], $course, 'n', 0, '"._AT('student')."', 0)";
40 $result = mysql_query($sql, $db);
42 // send the email - if needed
43 if ($system_courses[$course]['notify'] == 1) {
44 $mail_list = array(); //initialize an array to store all the pending emails
46 //Get the list of students with enrollment privilege
47 $module =& $moduleFactory->getModule('_core/enrolment');
48 $sql = "SELECT email, first_name, last_name, `privileges` FROM ".TABLE_PREFIX."members m INNER JOIN ".TABLE_PREFIX."course_enrollment ce ON m.member_id=ce.member_id WHERE ce.privileges > 0 AND ce.course_id=$course";
49 $result = mysql_query($sql, $db);
50 while ($row = mysql_fetch_assoc($result)){
51 if (query_bit($row['privileges'], $module->getPrivilege())){
52 unset($row['privileges']); //we don't need the privilege to flow around
57 //Get instructor information
58 $ins_id = $system_courses[$course]['member_id'];
59 $sql = "SELECT email, first_name, last_name FROM ".TABLE_PREFIX."members WHERE member_id=$ins_id";
60 $result = mysql_query($sql, $db);
61 $row = mysql_fetch_assoc($result);
64 //Send email notification to both assistants with privileges & Instructor
65 foreach ($mail_list as $row){
66 $to_email = $row['email'];
67 $tmp_message = $row['first_name'] .' ' . $row['last_name']."\n\n";
68 $tmp_message .= _AT('enrol_messagenew', $system_courses[$course]['title'], AT_BASE_HREF );
69 if ($to_email != '') {
70 require(AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php');
72 $mail = new ATutorMailer;
73 $mail->From = $_config['contact_email'];
74 $mail->FromName = $_config['site_name'];
75 $mail->AddAddress($to_email);
76 $mail->Subject = _AT('enrol_message3');
77 $mail->Body = $tmp_message;
80 require(AT_INCLUDE_PATH.'header.inc.php');
81 $msg->printErrors('SENDING_ERROR');
82 require(AT_INCLUDE_PATH.'footer.inc.php');
89 $msg->addFeedback('APPROVAL_PENDING');
90 header('Location: index.php');
93 $sql = "INSERT INTO ".TABLE_PREFIX."course_enrollment VALUES ($_SESSION[member_id], $course, 'y', 0, '"._AT('student')."', 0)";
94 $result = mysql_query($sql, $db);
98 $sql = "SELECT * FROM ".TABLE_PREFIX."course_enrollment WHERE member_id=$_SESSION[member_id] AND course_id=$course";
99 $result = mysql_query($sql, $db);
100 $row_in = mysql_fetch_assoc($result);
102 // request has already been made
103 if ($row_in['member_id'] == $_SESSION['member_id'] ) {
104 $msg->addFeedback('ALREADY_REQUESTED');
105 header('Location: ./index.php');
109 require(AT_INCLUDE_PATH.'header.inc.php');
112 <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
113 <input type="hidden" name="course" value="<?php echo $course; ?>">
114 <div class="input-form">
116 <?php echo _AT('private_enroll'); ?>
119 <div class="row buttons">
120 <input type="submit" name="submit" value="<?php echo _AT('request_enrollment'); ?>" />
125 <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>