$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 {