2 define('AT_INCLUDE_PATH', '../../include/');
3 require(AT_INCLUDE_PATH.'vitals.inc.php');
6 $sql = "SELECT email FROM ".TABLE_PREFIX."members WHERE member_id=".$_SESSION['member_id'];
7 $user_email = mysql_fetch_assoc(mysql_query($sql));
8 require(AT_INCLUDE_PATH . 'classes/phpmailer/atutormailer.class.php');
10 $mail = new ATutorMailer;
11 $mail->AddAddress($user_email['email'], get_display_name($_SESSION['member_id']));
12 $mail->FromName = $_config['site_name'];
13 $mail->From = $_config['contact_email'];
15 // SUBSCRIBE OR UNSUBSCRIBE? TAKE APPROPRIATE ACTION
16 if ($_GET['a'] == "subscribe"){
17 // CHECK FOR EXISTING TABLE ENTRY
18 $check = mysql_fetch_row(mysql_query("SELECT COUNT(*) FROM ".TABLE_PREFIX."courses_members_subscription WHERE course_id=".$_SESSION['course_id']." AND member_id=".$_SESSION['member_id']));
20 $sql = "INSERT INTO ".TABLE_PREFIX."courses_members_subscription (member_id,course_id,subscribe) VALUES(".$_SESSION['member_id'].",".$_SESSION['course_id'].",'1')";
22 $sql = "UPDATE ".TABLE_PREFIX."courses_members_subscription SET subscribe='1' WHERE course_id=".$_SESSION['course_id']." AND member_id=".$_SESSION['member_id'];
24 $mail->Subject = _AT('announcement_subscribe_subject');
25 $body = _AT('announcement_subscribe_body', $_SESSION['course_title'], AT_BASE_HREF.'bounce.php?course='.$_SESSION['course_id']);
26 $msg->addFeedback('ANNOUNCEMENTSUB_SUBSCRIBE');
27 }elseif ($_GET['a'] == "unsubscribe"){
28 $sql = "UPDATE ".TABLE_PREFIX."courses_members_subscription SET subscribe='0' WHERE course_id=".$_SESSION['course_id']." AND member_id=".$_SESSION['member_id'];
29 $mail->Subject = _AT('announcement_subscribe_subject');
30 $body = _AT('announcement_unsubscribe_body', $_SESSION['course_title'], AT_BASE_HREF.'bounce.php?course='.$_SESSION['course_id']);
31 $msg->addFeedback('ANNOUNCEMENTSUB_UNSUBSCRIBE');
33 die("Error: action not defined");
36 // FIX SUBSCRIPTION IN DB
37 mysql_query($sql) or die(mysql_error());
39 // FINISH UP MAIL AND SHIP IT OFF
43 // UNCOMMENT THE FOLLOWING 3 LINES IF YOU WANT ATUTOR TO SEND AN EMAIL TO THE USER WHEN THE USER SUBSCRIBES/UNSUBSCRIBES TO A NEWSFEED
44 //if(!$mail->Send()) {
45 // $msg->addError('SENDING_ERROR');
52 header('Location: ../../index.php');