$pl = "SELECT `class-name` FROM `conf_classes` WHERE `group` = \"" . $group . "\" OR `group` = '' ORDER BY `class-name` ASC"; } if (($return = $db->dbQuery($val->ValidateSQL($pl, $dbconn), $dbconn)) !== -1) { $pls = $db->dbArrayResults($return); } // 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 {