$secopts = "SELECT * FROM `conf_dnssec_opts` ORDER BY `key-name`";
//} else {
// $secopts = "SELECT * FROM `conf_dnssec_opts` WHERE `group` = \"" . $group . "\" ORDER BY `key-name`";
//}
if (($current = $db->dbQuery($val->ValidateSQL($secopts, $dbconn), $dbconn)) !== -1) {
$dnssecopts = $db->dbArrayResultsAssoc($current);
}
$dnssec_opt = $misc->GenJumpMenuBoxDNSSEC($dnssecopts, 'dnssecopt', $_GET['skin']);
// populate our `algorithm` list
$alg = "SELECT `name` FROM `admin_config_algorithm` ORDER BY `name`";
if (($return = $db->dbQuery($val->ValidateSQL($alg, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_dnssec", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$algs = $db->dbArrayResultsAssoc($return);
}
$algorithm = $misc->GenDropMenuWSelected($algs, $algorithm, 'algorithm');
// Assign form variables
$tpl->assign('error', $error, NULL, NULL);
$tpl->assign('dnssec_opt', $dnssec_opt, NULL, NULL);
$tpl->assign('id', $val->ValidateXSS($id), NULL, NULL);
$tpl->assign('key_name', $val->ValidateXSS($key_name), NULL, NULL);
$tpl->assign('algorithm', $algorithm, NULL, NULL);
$tpl->assign('key', $val->ValidateXSS($key), NULL, NULL);
// assign error messages
$tpl->assign('dnssec_opt_err', $dnssec_opt_err, NULL, NULL);
$tpl->assign('key_name_err', $key_name_err, NULL, NULL);
$tpl->assign('algorithm_err', $algorithm_err, NULL, NULL);
$tpl->assign('key_err', $key_err, NULL, NULL);
// Do some cleaning before leaving
$misc->CleanUpVars($_POST, NULL);
// Perform analyze, repair and optimize on used tables