$scope_range_2_err = $e; } $list .= "</ol>"; $error = $err->GenerateErrorLink("help/help.html", "#config_subnet", $defined['error'], $errors['val_missing'] . $list, NULL, NULL); } } // create drop list of pools if ($group === "admin") { $poolquery = "SELECT `pool-name` FROM `conf_pools` ORDER BY `pool-name` ASC"; } else { $poolquery = "SELECT `pool-name` FROM `conf_pools` WHERE `group` = \"" . $group . "\" OR `group` = \"\" ORDER BY `pool-name` ASC"; } if (($res = $db->dbQuery($val->ValidateSQL($poolquery, $dbconn), $dbconn)) !== -1) { $pools = $db->dbArrayResultsAssoc($res); if (count($pools) !== 0) { $pool = $misc->GenDropMenuWSelectedPools($pools, $pool_name, 'pool_name'); } else { $pool = $err->GenerateErrorLink("help/help.html", "#config_subnet", $defined['error'], "No pools defined", NULL, NULL); } } // create current list of dnssec security options 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 . "\"";