$subnetquery = "SELECT * FROM `conf_subnets` ORDER BY `subnet-name` ASC";
} else {
$subnetquery = "SELECT * FROM `conf_subnets` WHERE `group` = \"" . $group . "\" ORDER BY `subnet-name` ASC";
}
if (($current = $db->dbQuery($val->ValidateSQL($subnetquery, $dbconn), $dbconn)) !== -1) {
$subnetlist = $db->dbArrayResultsAssoc($current);
}
// fix $_POST['checkboxes'] array
if (empty($_GET['id']) && count($subnet_checkboxes) !== 0) {
foreach ($subnet_checkboxes as $key => $value) {
$fixed[$key]['subnet-name'] = $value;
$fixed[$key]['shared-network'] = $shared_network;
}
$subnet_checkboxes = $fixed;
}
$subnet_checks = $misc->GenSubnetCheckBoxes($subnetlist, 'subnet_checkboxes[]', $_GET['skin'], $subnet_checkboxes);
/* create checkbox list of available groups */
$groupsquery = "SELECT * FROM `auth_groups` WHERE `group` != \"admin\" AND `group` != \"" . $group . "\" ORDER BY `group` ASC";
if (($res = $db->dbQuery($val->ValidateSQL($groupsquery, $dbconn), $dbconn)) !== -1) {
$groups = $db->dbArrayResultsAssoc($res);
$groups = $misc->EliminiateDuplicates($groups);
if (count($groups) !== 0) {
// figure out which boxes are currently enabled
if (!empty($_GET['id'])) {
$sql = "SELECT * FROM `auth_groups_perms` WHERE `resource` = \"" . $subnet_name . "\"";
if (($sql_res = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
$select_groups = $db->dbArrayResultsAssoc($sql_res);
}
}
$select_groups = $misc->GenGroupsCheckBoxes($groups, 'select_groups', $_GET['skin'], $select_groups, $group);
} else {
