docs/mods/_core/groups/delete_group.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 } else if (isset($_POST['submit_yes'])) {\r
  26         $_POST['id'] = intval($_POST['id']);\r
  27         $_POST['type_id'] = intval($_POST['type_id']);\r
  28 \r
  29         $id = intval($_POST['id']);\r
  30         $type_id = intval($_POST['type_id']);\r
  31 \r
  32         $sql = "SELECT type_id FROM ".TABLE_PREFIX."groups_types WHERE type_id=$type_id AND course_id=$_SESSION[course_id]";\r
  33         $result = mysql_query($sql, $db);\r
  34         if ($row = mysql_fetch_assoc($result)) {\r
  35                 $module_list = $moduleFactory->getModules(AT_MODULE_STATUS_ENABLED | AT_MODULE_STATUS_DISABLED);\r
  36                 $keys = array_keys($module_list);\r
  37                 foreach ($keys as $module_name) {       \r
  38                         $module =& $module_list[$module_name];\r
  39                         $module->deleteGroup($id);\r
  40                 }\r
  41 \r
  42                 $sql = "DELETE FROM ".TABLE_PREFIX."groups WHERE group_id=$id AND type_id=$type_id";\r
  43                 $result = mysql_query($sql, $db);\r
  44 \r
  45                 if (mysql_affected_rows($db)) {\r
  46                         //remove all listings in groups_members table\r
  47                         $sql = "DELETE FROM ".TABLE_PREFIX."groups_members WHERE group_id=$id";\r
  48                         $result = mysql_query($sql, $db);\r
  49 \r
  50                         // should be handled by each module:\r
  51                         //remove all listings in tests_groups table\r
  52                         $sql = "DELETE FROM ".TABLE_PREFIX."tests_groups WHERE group_id=$id";\r
  53                         $result = mysql_query($sql, $db);\r
  54                 }\r
  55         }\r
  56 \r
  57         $msg->addFeedback('GROUP_DELETED');\r
  58         header('Location: index.php');\r
  59         exit;\r
  60 }\r
  61 \r
  62 require(AT_INCLUDE_PATH.'header.inc.php');\r
  63 \r
  64 $_GET['id'] = intval($_GET['id']);\r
  65 \r
  66 $sql = "SELECT * FROM ".TABLE_PREFIX."groups WHERE group_id=$_GET[id]";\r
  67 $result = mysql_query($sql,$db);\r
  68 if (!($row = mysql_fetch_assoc($result))) {\r
  69         $msg->printErrors('GROUP_NOT_FOUND');\r
  70         require (AT_INCLUDE_PATH.'footer.inc.php');\r
  71         exit;\r
  72 }\r
  73 \r
  74 $sql = "SELECT title FROM ".TABLE_PREFIX."groups_types WHERE type_id=$row[type_id] AND course_id=$_SESSION[course_id]";\r
  75 $result = mysql_query($sql,$db);\r
  76 if (!($type_row = mysql_fetch_assoc($result))) {\r
  77         $msg->printErrors('GROUP_NOT_FOUND');\r
  78         require (AT_INCLUDE_PATH.'footer.inc.php');\r
  79         exit;\r
  80 }\r
  81 \r
  82 unset($hidden_vars);\r
  83 $hidden_vars['id'] = $_GET['id'];\r
  84 $hidden_vars['type_id'] = $row['type_id'];\r
  85 \r
  86 $msg->addConfirm(array('DELETE_GROUP',AT_print($row['title'], 'groups.title')), $hidden_vars);\r
  87 $msg->printConfirm();\r
  88 \r
  89 require(AT_INCLUDE_PATH.'footer.inc.php');\r
  90 ?>