docs/mods/_core/groups/delete_type.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 $page = 'tests';\r
  16 define('AT_INCLUDE_PATH', '../../../include/');\r
  17 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
  18 \r
  19 authenticate(AT_PRIV_GROUPS);\r
  20 \r
  21 if (isset($_POST['submit_no'])) {\r
  22         $msg->addFeedback('CANCELLED');\r
  23         header('Location: index.php');\r
  24         exit;\r
  25 } \r
  26 else if (isset($_POST['submit_yes'])) {\r
  27         $type_id = abs($_POST['id']);\r
  28 \r
  29         $sql = "DELETE FROM ".TABLE_PREFIX."groups_types WHERE type_id=$type_id AND course_id=$_SESSION[course_id]";\r
  30         mysql_query($sql, $db);\r
  31         if (mysql_affected_rows($db) == 1) {\r
  32                 $sql = "SELECT group_id FROM ".TABLE_PREFIX."groups WHERE type_id=$type_id";\r
  33                 $result = mysql_query($sql, $db);\r
  34                 while ($row = mysql_fetch_assoc($result)) {\r
  35                         $sql = "DELETE FROM ".TABLE_PREFIX."groups_members WHERE group_id=$row[group_id]";\r
  36                         mysql_query($sql, $db);\r
  37 \r
  38                         // should be handled by each module:\r
  39                         //remove all listings in tests_groups table\r
  40                         $sql = "DELETE FROM ".TABLE_PREFIX."tests_groups WHERE group_id=$row[group_id]";\r
  41                         mysql_query($sql, $db);\r
  42                 }\r
  43                 $sql = "DELETE FROM ".TABLE_PREFIX."groups WHERE type_id=$type_id";\r
  44                 $result = mysql_query($sql, $db);\r
  45         }\r
  46 \r
  47         $msg->addFeedback('GROUP_TYPE_DELETED');\r
  48         header('Location: index.php');\r
  49         exit;\r
  50 }\r
  51 \r
  52 require(AT_INCLUDE_PATH.'header.inc.php');\r
  53 \r
  54 $_GET['id'] = intval($_GET['id']);\r
  55 \r
  56 $sql = "SELECT * FROM ".TABLE_PREFIX."groups_types WHERE type_id=$_GET[id] AND course_id=$_SESSION[course_id]";\r
  57 $result = mysql_query($sql,$db);\r
  58 if (!($row = mysql_fetch_assoc($result))) {\r
  59         $msg->printErrors('GROUP_TYPE_NOT_FOUND');\r
  60         require (AT_INCLUDE_PATH.'footer.inc.php');\r
  61         exit;\r
  62 }\r
  63 \r
  64 unset($hidden_vars);\r
  65 $hidden_vars['id'] = $_GET['id'];\r
  66 \r
  67 $msg->addConfirm(array('DELETE_GROUP_TYPE',$row['title']), $hidden_vars);\r
  68 $msg->printConfirm();\r
  69 \r
  70 require(AT_INCLUDE_PATH.'footer.inc.php');\r
  71 ?>