users/private_enroll.php

   1 <?php
   2 /****************************************************************/
   3 /* ATutor                                                                                                               */
   4 /****************************************************************/
   5 /* Copyright (c) 2002-2007 by Greg Gay & Joel Kronenberg        */
   6 /* Adaptive Technology Resource Centre / University of Toronto  */
   7 /* http://atutor.ca                                                                                             */
   8 /*                                                              */
   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 /****************************************************************/
  13 // $Id$
  14
  15 $_user_location = 'users';
  16 define('AT_INCLUDE_PATH', '../include/');
  17 require(AT_INCLUDE_PATH.'vitals.inc.php');
  18
  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');
  23         exit;
  24 }
  25
  26 $course = intval($_REQUEST['course']);
  27 if ($course == 0) {
  28         exit;
  29 }
  30
  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);
  34
  35 if ($_POST['submit']) {
  36         $_SESSION['enroll'] = AT_ENROLL_YES;
  37
  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);
  41
  42                 // send the email - if needed
  43                 if ($system_courses[$course]['notify'] == 1) {
  44
  45                         $ins_id = $system_courses[$course]['member_id'];
  46                         $sql    = "SELECT email, first_name, last_name FROM ".TABLE_PREFIX."members WHERE member_id=$ins_id";
  47                         $result = mysql_query($sql, $db);
  48                         $row    = mysql_fetch_assoc($result);
  49
  50                         $to_email = $row['email'];
  51                         $tmp_message  = $row['first_name']  .' ' . $row['last_name']."\n\n";
  52                         $tmp_message .= _AT('enrol_messagenew', $system_courses[$course]['title'], AT_BASE_HREF );
  53
  54                         if ($to_email != '') {
  55                                 require(AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php');
  56
  57                                 $mail = new ATutorMailer;
  58                                 $mail->From     = $_config['contact_email'];
  59                                 $mail->FromName = $_config['site_name'];
  60                                 $mail->AddAddress($to_email);
  61                                 $mail->Subject = _AT('enrol_message3');
  62                                 $mail->Body    = $tmp_message;
  63
  64                                 if (!$mail->Send()) {
  65                                    require(AT_INCLUDE_PATH.'header.inc.php');
  66                                    $msg->printErrors('SENDING_ERROR');
  67                                    require(AT_INCLUDE_PATH.'footer.inc.php');
  68                                    exit;
  69                                 }
  70                                 unset($mail);
  71                         }
  72                 }
  73                 require(AT_INCLUDE_PATH.'header.inc.php');
  74                 $msg->printFeedbacks('APPROVAL_PENDING');
  75                 require(AT_INCLUDE_PATH.'footer.inc.php');
  76                 exit;
  77         } else {
  78                 $sql    = "INSERT INTO ".TABLE_PREFIX."course_enrollment VALUES ($_SESSION[member_id], $course, 'y', 0, '"._AT('student')."', 0)";
  79                 $result = mysql_query($sql, $db);
  80         }
  81 }
  82
  83 $sql    = "SELECT * FROM ".TABLE_PREFIX."course_enrollment WHERE member_id=$_SESSION[member_id] AND course_id=$course";
  84 $result = mysql_query($sql, $db);
  85 $row_in = mysql_fetch_assoc($result);
  86
  87 // request has already been made
  88 if ($row_in['member_id'] == $_SESSION['member_id'] ) {
  89         $msg->addFeedback('ALREADY_REQUESTED');
  90         header('Location: ./index.php');
  91         exit;
  92 }
  93
  94 require(AT_INCLUDE_PATH.'header.inc.php');
  95 ?>
  96
  97 <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  98 <input type="hidden" name="course" value="<?php echo $course; ?>">
  99 <div class="input-form">
 100         <div class="row">
 101                 <?php echo _AT('private_enroll'); ?>
 102         </div>
 103
 104         <div class="row buttons">
 105                 <input type="submit" name="submit" value="<?php echo _AT('request_enrollment'); ?>" />
 106         </div>
 107 </div>
 108 </form>
 109
 110 <?php   require(AT_INCLUDE_PATH.'footer.inc.php'); ?>