mods/_standard/forums/admin/forum_delete.php

   1 <?php\r
   2 /************************************************************************/\r
   3 /* ATutor                                                                                                                               */\r
   4 /************************************************************************/\r
   5 /* Copyright (c) 2002-2010                                              */\r
   6 /* Inclusive Design Institute                                           */\r
   7 /* http://atutor.ca                                                                                                             */\r
   8 /*                                                                                                                                              */\r
   9 /* This program is free software. You can redistribute it and/or        */\r
  10 /* modify it under the terms of the GNU General Public License          */\r
  11 /* as published by the Free Software Foundation.                        */\r
  12 /************************************************************************/\r
  13 // $Id$\r
  14 \r
  15 define('AT_INCLUDE_PATH', '../../../../include/');\r
  16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  17 \r
  18 admin_authenticate(AT_ADMIN_PRIV_FORUMS);\r
  19 \r
  20 include(AT_INCLUDE_PATH.'../mods/_standard/forums/lib/forums.inc.php');\r
  21 \r
  22 if (isset($_POST['submit_no'])) {\r
  23         $msg->addFeedback('CANCELLED');\r
  24         header('Location: forums.php');\r
  25         exit;\r
  26 } else if (isset($_POST['submit_yes'])) {\r
  27         $forum_id = intval($_POST['forum']);\r
  28 \r
  29         $sql    = "SELECT post_id FROM ".TABLE_PREFIX."forums_threads WHERE forum_id=$forum_id";\r
  30         $result = mysql_query($sql, $db);\r
  31         while ($row = mysql_fetch_array($result)) {\r
  32                 $sql     = "DELETE FROM ".TABLE_PREFIX."forums_accessed WHERE post_id=$row[post_id]";\r
  33                 $result2 = mysql_query($sql, $db);\r
  34         }\r
  35 \r
  36         $sql    = "DELETE FROM ".TABLE_PREFIX."forums_subscriptions WHERE forum_id=$forum_id";\r
  37         $result = mysql_query($sql, $db);\r
  38 \r
  39         $sql    = "DELETE FROM ".TABLE_PREFIX."forums_threads WHERE forum_id=$forum_id";\r
  40         $result = mysql_query($sql, $db);\r
  41 \r
  42         $sql = "DELETE FROM ".TABLE_PREFIX."forums_courses WHERE forum_id=$forum_id";\r
  43         $result = mysql_query($sql, $db);\r
  44         write_to_log(AT_ADMIN_LOG_DELETE, 'forums_courses', mysql_affected_rows($db), $sql);\r
  45 \r
  46         $sql    = "DELETE FROM ".TABLE_PREFIX."forums WHERE forum_id=$forum_id";\r
  47         $result = mysql_query($sql, $db);\r
  48         write_to_log(AT_ADMIN_LOG_DELETE, 'forums', mysql_affected_rows($db), $sql);\r
  49         \r
  50         $sql = "OPTIMIZE TABLE ".TABLE_PREFIX."forums_threads";\r
  51         $result = mysql_query($sql, $db);\r
  52 \r
  53         $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
  54         header('Location: forums.php');\r
  55         exit;\r
  56 }\r
  57 \r
  58 require(AT_INCLUDE_PATH.'header.inc.php'); \r
  59 \r
  60         $_GET['forum'] = intval($_GET['forum']); \r
  61 \r
  62         $row = get_forum($_GET['forum']);\r
  63 \r
  64         if (!is_array($row)) {\r
  65                 $msg->addError('FORUM_NOT_FOUND');\r
  66                 $msg->printErrors();\r
  67         } else {\r
  68 \r
  69                 $hidden_vars['delete_forum'] = TRUE;\r
  70                 $hidden_vars['forum'] = $_GET['forum'];\r
  71                 $msg->addConfirm(array('DELETE_FORUM', AT_print($row['title'], 'forums.title')), $hidden_vars);\r
  72                 $msg->printConfirm();\r
  73         }\r
  74 \r
  75 require(AT_INCLUDE_PATH.'footer.inc.php'); \r
  76 \r
  77 ?>