mods/_standard/announcements/delete_news.php

   1 <?php
   2 /****************************************************************/
   3 /* ATutor                                                                                                               */
   4 /****************************************************************/
   5 /* Copyright (c) 2002-2010                                      */
   6 /* Inclusive Design Institute                                   */
   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
  14 define('AT_INCLUDE_PATH', '../../../include/');
  15 require(AT_INCLUDE_PATH.'vitals.inc.php');
  16
  17 authenticate(AT_PRIV_ANNOUNCEMENTS);
  18
  19 if (isset($_POST['submit_no'])) {
  20         $msg->addFeedback('CANCELLED');
  21         header('Location: '.AT_BASE_HREF.'mods/_standard/announcements/index.php');
  22         exit;
  23 } else if (isset($_POST['submit_yes'])) {
  24         $_POST['form_news_id'] = intval($_POST['form_news_id']);
  25
  26         $sql = "DELETE FROM ".TABLE_PREFIX."news WHERE news_id=$_POST[form_news_id] AND course_id=$_SESSION[course_id]";
  27         $result = mysql_query($sql, $db);
  28
  29         /* update announcement RSS: */
  30         if (file_exists(AT_CONTENT_DIR . 'feeds/' . $_SESSION['course_id'] . '/RSS1.0.xml')) {
  31                 @unlink(AT_CONTENT_DIR . 'feeds/' . $_SESSION['course_id'] . '/RSS1.0.xml');
  32         }
  33         if (file_exists(AT_CONTENT_DIR . 'feeds/' . $_SESSION['course_id'] . '/RSS2.0.xml')) {
  34                 @unlink(AT_CONTENT_DIR . 'feeds/' . $_SESSION['course_id'] . '/RSS2.0.xml');
  35         }
  36
  37         $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
  38         header('Location: '.AT_BASE_HREF.'mods/_standard/announcements/index.php');
  39         exit;
  40 }
  41
  42 $_section[0][0] = _AT('delete_announcement');
  43
  44 require(AT_INCLUDE_PATH.'header.inc.php');
  45
  46         $_GET['aid'] = intval($_GET['aid']);
  47
  48         $sql = "SELECT * FROM ".TABLE_PREFIX."news WHERE news_id=$_GET[aid] AND course_id=$_SESSION[course_id]";
  49
  50         $result = mysql_query($sql,$db);
  51         if (mysql_num_rows($result) == 0) {
  52                 $msg->printErrors('ITEM_NOT_FOUND');
  53         } else {
  54                 $row = mysql_fetch_assoc($result);
  55
  56                 $hidden_vars['delete_news']  = TRUE;
  57                 $hidden_vars['form_news_id'] = $row['news_id'];
  58
  59                 $confirm = array('DELETE_NEWS', AT_print($row['title'], 'news.title'));
  60                 $msg->addConfirm($confirm, $hidden_vars);
  61
  62                 $msg->printConfirm();
  63         }
  64
  65 require(AT_INCLUDE_PATH.'footer.inc.php');
  66
  67 ?>