mods/announcement_subscription/subscribe.php

   1 <?php
   2 define('AT_INCLUDE_PATH', '../../include/');
   3 require(AT_INCLUDE_PATH.'vitals.inc.php');
   4
   5 // PREPARE MAIL
   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');
   9
  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'];
  14
  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']));
  19       if(empty($check[0])){
  20         $sql = "INSERT INTO ".TABLE_PREFIX."courses_members_subscription (member_id,course_id,subscribe) VALUES(".$_SESSION['member_id'].",".$_SESSION['course_id'].",'1')";
  21       } else {
  22         $sql = "UPDATE ".TABLE_PREFIX."courses_members_subscription SET subscribe='1' WHERE course_id=".$_SESSION['course_id']." AND member_id=".$_SESSION['member_id'];
  23       }
  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');
  32   }else {
  33     die("Error: action not defined");
  34   }
  35
  36 // FIX SUBSCRIPTION IN DB
  37   mysql_query($sql) or die(mysql_error());
  38
  39 // FINISH UP MAIL AND SHIP IT OFF
  40
  41   $mail->Body    = $body;
  42
  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');
  46         //}
  47
  48         unset($mail);
  49
  50 // GO HOME
  51
  52 header('Location: ../../index.php');
  53
  54 ?>