/**
* Created by PhpStorm.
* User: Andrew Tait (150463)
* Date: 13/12/2015
* Time: 22:10
* Delete function for Permissions,Groups and Users
*/
$getid = htmlentities($_GET['id']);
$type = htmlentities($_GET['type']);
echo $type;
$msg = "";
if (isset($type)) {
//echo "IT works here!";
switch ($type) {
case "group":
$group_check = groupInUse($db, $getid, "Check");
echo $group_check;
if ($group_check) {
$delete_exercises = mysqli_query($db, "DELETE FROM `group` WHERE groupID = '{$getid}'");
if ($delete_exercises) {
$msg = "Delete group successful";
echo "<script> alert('Group Deleted Successfully');</script>";
$page = "./?page=admin";
header("Refresh: 2; URL=\"" . $page . "\"");
}
} else {
echo "<script> alert('Delete Group Failed');</script>";
$page = "./?page=admin";
header("Refresh: 2; URL=\"" . $page . "\"");
}
break;
//No users? Register then!
echo "<p>No users registered on the system, please <a href='./?page=register'>Register</a></p>";
}
?>
<?php
if (mysqli_num_rows($permissions) > 0) {
echo "<h2>Group Management</h2>";
if (mysqli_num_rows($groups) > 0) {
print "\n <table border=\"1\">\n <tr>\n <td>Group ID</td>\n <td>Group Name</td>\n <td>Permission Name</td>\n <td>Edit</td>\n <td>Delete</td>\n </tr>";
while ($info = mysqli_fetch_array($groups)) {
echo "<trstyle='background-color:#000000;'>";
echo "<td>" . $info['groupID'] . "</td>";
echo "<td>" . $info['groupName'] . "</td>";
echo groupName($db, $info['permissionID']);
echo '<td><a href="./?page=edit_group&id=' . $info['groupID'] . '">Edit</a></td>';
echo groupInUse($db, $info['groupID'], "Row");
echo "</tr>";
}
echo "</table>";
} else {
echo "<p>No groups registered add one below:</p>";
}
echo "<h2>Add Group</h2>";
include "includes/group/add_group.php";
}
?>
<h2>Permissions Management</h2>
<?php
if (mysqli_num_rows($permissions) > 0) {
print "\n <table border=\"1\">\n <tr>\n <td>Permission ID</td>\n <td>Permission Name</td>\n <td>Create Content</td>\n <td>Create Comments</td>\n <td>Vote</td>\n <td>Edit Vote (Admin)</td>\n <td>Edit Content</td>\n <td>Edit Comments</td>\n <td>View Content</td>\n <td>View Comments</td>\n <td>Edit</td>\n <td>Delete</td>\n </tr>";
