+++ /dev/null
-<?php\r
-/****************************************************************************/\r
-/* ATutor */\r
-/****************************************************************************/\r
-/* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg & Heidi Hazelton */\r
-/* Adaptive Technology Resource Centre / University of Toronto */\r
-/* http://atutor.ca */\r
-/* */\r
-/* This program is free software. You can redistribute it and/or */\r
-/* modify it under the terms of the GNU General Public License */\r
-/* as published by the Free Software Foundation. */\r
-/****************************************************************************/\r
-// $Id: certificate_delete.php 7208 2008-02-20 16:07:24Z cindy $\r
-\r
-$page = 'gradebook';\r
-\r
-define('AT_INCLUDE_PATH', '../../include/');\r
-require(AT_INCLUDE_PATH.'vitals.inc.php');\r
-authenticate(AT_PRIV_GRADEBOOK);\r
-\r
-if (isset($_POST['submit_no'])) {\r
- $msg->addFeedback('CANCELLED');\r
- header('Location: gradebook_tests.php');\r
- exit;\r
-} else if (isset($_POST['submit_yes'])) {\r
- /* delete has been confirmed, delete this category */\r
- $gradebook_test_id = intval($_POST['gradebook_test_id']);\r
-\r
- $sql = "DELETE FROM ".TABLE_PREFIX."gradebook_tests WHERE gradebook_test_id=$gradebook_test_id";\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
-\r
- $sql = "DELETE FROM ".TABLE_PREFIX."gradebook_detail WHERE gradebook_test_id=$gradebook_test_id";\r
- $result = mysql_query($sql, $db) or die(mysql_error());\r
-\r
- $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
- header('Location: gradebook_tests.php');\r
- exit;\r
-}\r
-\r
-require(AT_INCLUDE_PATH.'header.inc.php');\r
-\r
-$_GET['gradebook_test_id'] = intval($_GET['gradebook_test_id']); \r
-\r
-$sql = "(SELECT g.gradebook_test_id, t.title".\r
- " FROM ".TABLE_PREFIX."gradebook_tests g, ".TABLE_PREFIX."tests t".\r
- " WHERE g.type='ATutor Test'".\r
- " AND g.id = t.test_id".\r
- " AND g.gradebook_test_id=".$_GET['gradebook_test_id'].")".\r
- " UNION (SELECT g.gradebook_test_id, a.title".\r
- " FROM ".TABLE_PREFIX."gradebook_tests g, ".TABLE_PREFIX."assignments a".\r
- " WHERE g.type='ATutor Assignment'".\r
- " AND g.id = a.assignment_id".\r
- " AND g.gradebook_test_id=".$_GET['gradebook_test_id'].")".\r
- " UNION (SELECT gradebook_test_id, title ".\r
- " FROM ".TABLE_PREFIX."gradebook_tests".\r
- " WHERE type='External'".\r
- " AND gradebook_test_id=".$_GET['gradebook_test_id'].")";\r
- \r
-$result = mysql_query($sql,$db) or die(mysql_error());\r
-\r
-if (mysql_num_rows($result) == 0) {\r
- $msg->printErrors('ITEM_NOT_FOUND');\r
-} else {\r
- $row = mysql_fetch_assoc($result);\r
- \r
- $hidden_vars['title']= $row["title"];\r
- $hidden_vars['gradebook_test_id'] = $row['gradebook_test_id'];\r
-\r
- $confirm = array('DELETE_TEST_FROM_GRADEBOOK', $row["title"]);\r
- $msg->addConfirm($confirm, $hidden_vars);\r
- \r
- $msg->printConfirm();\r
-}\r
-\r
-require(AT_INCLUDE_PATH.'footer.inc.php');\r
-\r
-?>
\ No newline at end of file