e059087bffa532ef838941e3167b9b50e19a2797
[atutor.git] / mods / patcher / patch_delete.php
1 <?php\r
2 /****************************************************************************/\r
3 /* ATutor                                                                                                                                       */\r
4 /****************************************************************************/\r
5 /* Copyright (c) 2002-2008 by Greg Gay, Joel Kronenberg & Heidi Hazelton        */\r
6 /* Adaptive Technology Resource Centre / University of Toronto                          */\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: certificate_delete.php 7208 2008-02-20 16:07:24Z cindy $\r
14 \r
15 define('AT_INCLUDE_PATH', '../../include/');\r
16 require(AT_INCLUDE_PATH.'vitals.inc.php');\r
17 admin_authenticate(AT_ADMIN_PRIV_PATCHER);\r
18 \r
19 if (isset($_POST['submit_no'])) {\r
20         $msg->addFeedback('CANCELLED');\r
21         header('Location: myown_patches.php');\r
22         exit;\r
23 } else if (isset($_POST['submit_yes'])) {\r
24         /* delete has been confirmed, delete this category */\r
25         $myown_patch_id = intval($_POST['myown_patch_id']);\r
26 \r
27         $sql = "DELETE FROM ".TABLE_PREFIX."myown_patches WHERE myown_patch_id=$myown_patch_id";\r
28         $result = mysql_query($sql, $db) or die(mysql_error());\r
29 \r
30         write_to_log(AT_ADMIN_LOG_DELETE, 'myown_patches', mysql_affected_rows($db), $sql);\r
31 \r
32         $sql = "DELETE FROM ".TABLE_PREFIX."myown_patches_dependent WHERE myown_patch_id=$myown_patch_id";\r
33         $result = mysql_query($sql, $db) or die(mysql_error());\r
34 \r
35         write_to_log(AT_ADMIN_LOG_DELETE, 'myown_patches_dependent', mysql_affected_rows($db), $sql);\r
36 \r
37         $sql = "DELETE FROM ".TABLE_PREFIX."myown_patches_files WHERE myown_patch_id=$myown_patch_id";\r
38         $result = mysql_query($sql, $db) or die(mysql_error());\r
39 \r
40         write_to_log(AT_ADMIN_LOG_DELETE, 'myown_patches_files', mysql_affected_rows($db), $sql);\r
41 \r
42         $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');\r
43         header('Location: myown_patches.php');\r
44         exit;\r
45 }\r
46 \r
47 //require('../../include/header.inc.php');\r
48 require(AT_INCLUDE_PATH.'header.inc.php');\r
49 \r
50 $_GET['myown_patch_id'] = intval($_GET['myown_patch_id']); \r
51 \r
52 $sql = "SELECT myown_patch_id, atutor_patch_id FROM ".TABLE_PREFIX."myown_patches m WHERE m.myown_patch_id=$_GET[myown_patch_id]";\r
53 $result = mysql_query($sql,$db) or die(mysql_error());\r
54 \r
55 if (mysql_num_rows($result) == 0) {\r
56         $msg->printErrors('ITEM_NOT_FOUND');\r
57 } else {\r
58         $row = mysql_fetch_assoc($result);\r
59         \r
60         $hidden_vars['atutor_patch_id']= $row['atutor_patch_id'];\r
61         $hidden_vars['myown_patch_id']  = $row['myown_patch_id'];\r
62 \r
63         $confirm = array('DELETE_MYOWN_PATCH', $row['atutor_patch_id']);\r
64         $msg->addConfirm($confirm, $hidden_vars);\r
65         \r
66         $msg->printConfirm();\r
67 }\r
68 \r
69 require(AT_INCLUDE_PATH.'footer.inc.php');\r
70 \r
71 ?>