$sql = "SELECT `resource`, `allowed` FROM `auth_groups_perms` WHERE `type` = \"subnet\" AND `allowed` = \"" . $group . "\" AND `group` != \"" . $group . "\"";
if (($extra = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
$extra = $db->dbArrayResultsAssoc($extra);
foreach ($extra as $key => $value) {
$sql = "SELECT * FROM `conf_subnets` WHERE `subnet-name` = \"" . $value['resource'] . "\" LIMIT 1";
if (($s = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
$subnetlist_remainder = array_merge($misc->EliminiateDuplicates($db->dbArrayResultsAssoc($s)));
}
}
}
// combine our arrays
if (count($subnetlist_remainder) !== 0) {
$subnetlist = array_merge($subnetlist, $subnetlist_remainder);
}
//echo "<pre>"; print_r( $resources ); echo "</pre>";
$subnets = $misc->GenJumpMenuBoxSubnets($subnetlist, 'subnets', $_GET['skin']);
/* 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 {
