2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2002-2010 */
6 /* Inclusive Design Institute */
8 /* This program is free software. You can redistribute it and/or */
9 /* modify it under the terms of the GNU General Public License */
10 /* as published by the Free Software Foundation. */
11 /************************************************************************/
14 $_user_location = 'public';
16 define('AT_INCLUDE_PATH', 'include/');
17 require(AT_INCLUDE_PATH.'vitals.inc.php');
19 if (isset($_POST['cancel'])) {
20 $msg->addFeedback('CANCELLED');
21 header('Location: '.$_base_href.'login.php');
25 if (isset($_GET['e'], $_GET['id'], $_GET['m'])) {
26 $id = intval($_GET['id']);
28 $e = $addslashes($_GET['e']);
30 $sql = "SELECT creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id";
31 $result = mysql_query($sql, $db);
32 if ($row = mysql_fetch_assoc($result)) {
33 $code = substr(md5($e . $row['creation_date'] . $id), 0, 10);
36 $sql = "UPDATE ".TABLE_PREFIX."members SET email='$e', last_login=NOW(), creation_date=creation_date WHERE member_id=$id";
37 $result = mysql_query($sql, $db);
39 $msg->addFeedback('CONFIRM_GOOD');
41 header('Location: '.$_base_href.'users/index.php');
44 $msg->addError('CONFIRM_BAD');
47 $msg->addError('CONFIRM_BAD');
50 } else if (isset($_GET['id'], $_GET['m'])) {
51 $id = intval($_GET['id']);
54 $sql = "SELECT email, creation_date FROM ".TABLE_PREFIX."members WHERE member_id=$id AND status=".AT_STATUS_UNCONFIRMED;
55 $result = mysql_query($sql, $db);
56 if ($row = mysql_fetch_assoc($result)) {
57 $code = substr(md5($row['email'] . $row['creation_date'] . $id), 0, 10);
60 if (defined('AUTO_APPROVE_INSTRUCTORS') && AUTO_APPROVE_INSTRUCTORS) {
61 $sql = "UPDATE ".TABLE_PREFIX."members SET status=".AT_STATUS_INSTRUCTOR.", creation_date=creation_date, last_login=NOW() WHERE member_id=$id";
63 $sql = "UPDATE ".TABLE_PREFIX."members SET status=".AT_STATUS_STUDENT.", creation_date=creation_date, last_login=NOW() WHERE member_id=$id";
65 $result = mysql_query($sql, $db);
67 if (isset($_REQUEST["en_id"]) && $_REQUEST["en_id"] <> "")
69 $msg->addFeedback('CONFIRM_GOOD');
72 require (AT_INCLUDE_PATH.'html/auto_enroll_courses.inc.php');
73 unset($_SESSION['valid_user']);
74 unset($_SESSION['member_id']);
78 <h3>" . _AT('auto_enrolled_msg'). "<br /></h3>
81 require(AT_INCLUDE_PATH.'header.inc.php');
82 echo "<div class=\"input-form\">";
83 require(AT_INCLUDE_PATH.'html/auto_enroll_list_courses.inc.php');
84 echo '<p style="text-align:center"><a href="'. $_SERVER['PHP_SELF'] . '?auto_login=1&member_id='. $id .'">' . _AT("go_to_my_start_page") . '</a></p>';
86 require(AT_INCLUDE_PATH.'footer.inc.php');
91 $msg->addFeedback('CONFIRM_GOOD');
93 // enable auto login student into "my start page"
94 $_REQUEST["auto_login"] = 1;
95 $_REQUEST["member_id"] = $id;
98 $msg->addError('CONFIRM_BAD');
101 $msg->addError('CONFIRM_BAD');
103 } else if (isset($_POST['submit'])) {
104 $_POST['email'] = $addslashes($_POST['email']);
106 $sql = "SELECT member_id, email, creation_date, status FROM ".TABLE_PREFIX."members WHERE email='$_POST[email]'";
107 $result = mysql_query($sql, $db);
109 if ($row = mysql_fetch_assoc($result)) {
111 if ($row['status'] == AT_STATUS_UNCONFIRMED) {
112 $code = substr(md5($row['email'] . $row['creation_date']. $row['member_id']), 0, 10);
114 if ($_POST["en_id"] <> "")
115 $confirmation_link = $_base_href . 'confirm.php?id='.$row['member_id'].SEP.'m='.$code.'&en_id='.$_POST["en_id"];
117 $confirmation_link = $_base_href . 'confirm.php?id='.$row['member_id'].SEP.'m='.$code;
119 /* send the email confirmation message: */
120 require(AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php');
121 $mail = new ATutorMailer();
123 $mail->From = $_config['contact_email'];
124 $mail->AddAddress($row['email']);
125 $mail->Subject = SITE_NAME . ': ' . _AT('email_confirmation_subject');
126 $mail->Body = _AT('email_confirmation_message', $_base_href, $confirmation_link)."\n\n";
129 $msg->addFeedback('CONFIRMATION_SENT');
131 $msg->addFeedback('ACCOUNT_CONFIRMED');
134 header('Location: '.$_base_href.'login.php');
137 $msg->addError('EMAIL_NOT_FOUND');
141 if (isset($_REQUEST['auto_login']))
144 $sql = "SELECT M.member_id, M.login, M.preferences, M.language FROM ".TABLE_PREFIX."members M WHERE M.member_id=".$_REQUEST["member_id"];
145 $result = mysql_query($sql, $db);
146 if ($row = mysql_fetch_assoc($result))
148 $_SESSION['valid_user'] = true;
149 $_SESSION['member_id'] = $_REQUEST["member_id"];
150 $_SESSION['course_id'] = 0;
151 $_SESSION['login'] = $row[login];
152 if ($row['preferences'] == "")
153 assign_session_prefs(unserialize(stripslashes($_config["pref_defaults"])), 1);
155 assign_session_prefs(unserialize(stripslashes($row['preferences'])), 1);
156 $_SESSION['is_guest'] = 0;
157 $_SESSION['lang'] = $row[lang];
158 session_write_close();
160 header('Location: '.AT_BASE_HREF.'bounce.php?course='.$_POST['course']);
165 require(AT_INCLUDE_PATH.'header.inc.php'); ?>
170 $savant->display('confirm.tmpl.php');
171 require(AT_INCLUDE_PATH.'footer.inc.php'); ?>