// fix the nested array before merging for ($x = 0; $x < count($pls); $x++) { $newarr[] = $pls[$x]['class-name']; } if (count($newarr) !== 0) { $pls_opt = array_merge($pl_ops, $newarr); //echo "<pre>"; print_r( $pls_opt ); echo "</pre>"; } else { $pls_opt = $pl_ops; } $list = $misc->GenDropMenuWSelectedPoolOpts($pls_opt, $allow_deny_op, 'allow_deny_op'); /* 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 { $select_groups = $err->GenerateErrorLink("help/help.html", "#undef", $defined['error'], "No groups defined", NULL, NULL); } } else { $select_groups = $err->GenerateErrorLink("help/help.html", "#undef", $defined['error'], $errors['db_select_err'], NULL, NULL); }
if ($group === "admin") { $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); } /* check for additional subnets this group can access */ $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) {