function GenMapMenu($table, $field, $order)
{
global $defined;
$db = new dbConn();
$val = new ValidateStrings();
if (empty($table) || empty($field)) {
return -1;
}
$conn = $db->dbConnect($defined['dbhost'], $defined['username'], $defined['password'], $defined['dbname']);
if (empty($order)) {
$query = "SELECT {$field} FROM `{$table}`";
} else {
$query = "SELECT {$field} FROM `{$table}` ORDER BY `{$order}`";
}
$query = $val->ValidateSQL($query, $conn);
if (($value = $db->dbQuery($query, $conn)) === -1) {
return -1;
}
if ($db->dbNumRows($value) === -1 || $db->dbNumRows($value) === 0) {
return -1;
} else {
$list = "<form method=\"get\" action=\"{$_SERVER['PHP_SELF']}\"><b>Existing rides:</b> <select name=\"mapper\" onChange=\"jumpMenu('parent',this,0)\"><option value=\"NULL\">Select Map / Route...</option>";
$list .= "<option>------------------------------</option>";
foreach ($db->dbArrayResultsAssoc($value) as $key => $val) {
$url = $_SERVER['PHP_SELF'] . "?lat=" . $val['lat'] . "&lon=" . $val['lon'] . "&z=" . $val['zoom'] . "&mType=" . $val['type'] . "&driveFrom=" . $val['from'] . "&driveTo=" . $val['to'] . "&driveVia=" . $val['via'] . "&locale=en";
$list .= "<option name=\"{$url}\" value=\"{$url}\">" . $val['name'] . "</option>";
}
$list .= "</select></form>";
$data = $list;
}
$db->dbFreeData($conn);
$db->dbCloseConn($conn);
return $data;
}
$FILE = "manage.pools.tpl";
// initialize a db connection handle
$dbconn = $db->dbConnect($defined['dbhost'], $defined['username'], $defined['password'], $defined['dbname']);
// provide count of online users
$online = "SELECT * FROM `admin_sessions`";
$ret = $db->dbQuery($val->ValidateSQL($online, $dbconn), $dbconn);
$usersoline = $db->dbNumRows($ret);
// decode our authentication token to get our group membership
$user_details = $encrypt->DecodeAuthToken($_SESSION['token']);
$group = base64_decode($user_details[3]);
// get an array of subnets the ISC DHCPD service may listen on
$query = "SELECT `name`, `broadcast` FROM `conf_adapters` ORDER BY `broadcast` ASC";
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_subnets", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$tmp = $db->dbArrayResultsAssoc($value);
// filter for empty stuff
for ($x = 0; $x < count($tmp); $x++) {
if (!empty($tmp[$x]['broadcast'])) {
$interface_list[$tmp[$x]['name']] = $tmp[$x]['broadcast'];
}
}
}
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_pools", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
if ($group === "admin") {
$query = "SELECT * FROM `conf_pools` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
$peer_address_err = $e;
}
if (empty($peer_port)) {
$list .= "<li>Peer Port Field is missing</li>";
$peer_port_err = $e;
}
$list .= "</ol>";
$error = $err->GenerateErrorLink("help/help.html", "#config_dnssec", $defined['error'], $errors['val_missing'] . $list, NULL, NULL);
}
} else {
// perform a lookup on current values to display for editing
$query = "SELECT * FROM `conf_failover`";
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_failover", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$id = $data[0]['id'];
$peer_name = $data[0]['peer name'];
$primary = $data[0]['type'];
$address = $data[0]['address'];
$port = $data[0]['port'];
$peer_address = $data[0]['peer address'];
$peer_port = $data[0]['peer port'];
$max_response_delay = $data[0]['max-response-delay'];
$max_unacked_updates = $data[0]['max-unacked-updates'];
$mclt = $data[0]['mclt'];
$split = $data[0]['split'];
$load_balance_max_seconds = $data[0]['load balance max seconds'];
}
}
// Assign form variables
// generate our sql command
$insert = "INSERT INTO `conf_hosts` ( `hostname`, `mac-address`, `ip-address`, `subnet-name`, `pxe-group` ) VALUES ( \"" . $tmp[$x]['hostname'] . "\",\"" . $tmp[$x]['mac_address'] . "\", \"" . $tmp[$x]['ip_address'] . "\", \"" . $tmp[$x]['subnet'] . "\", \"" . $tmp[$x]['pxe_group'] . "\" )";
// insert records or prompt for duplicate errors
if (($value = $db->dbQuery($val->ValidateSQL($insert, $dbconn), $dbconn)) === -1) {
// found an existing record?
if (eregi("duplicate", $db->dbCatchError())) {
// assign an error message
$error = $err->GenerateErrorLink("help/help.html", "#import_host", $defined['error'], "Duplicate records found during import, please review and modify the data below accordingly.", NULL, NULL);
// since we have a duplicate and not an invalid record give them the correct template
$error_template = "admin.import.hosts.errors.tpl";
// find the duplicate record so the user can edit it
$find = "SELECT * FROM `conf_hosts` WHERE `hostname` = \"" . $tmp[$x]['hostname'] . "\" OR `mac-address` = \"" . $tmp[$x]['mac_address'] . "\" OR `ip-address` = \"" . $tmp[$x]['mac_address'] . "\" LIMIT 1";
if (($value = $db->dbQuery($val->ValidateSQL($find, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#import_host", $defined['error'], "An error occured when attempting to lookup the duplicate record in which '" . $tmp[$x]['hostname'] . "' conflicts with.", NULL, NULL);
} else {
$found = $db->dbArrayResultsAssoc($value);
}
// populate our subnets list for our imported record
$sub = "SELECT `subnet-name` FROM `conf_subnets` ORDER BY `subnet-name` ASC";
if (($return = $db->dbQuery($val->ValidateSQL($sub, $dbconn), $dbconn)) !== -1) {
$subs = $db->dbArrayResultsAssoc($return);
}
if (count($subs) === 0) {
$subnet = "No subnets defined";
} else {
$subnet = $misc->GenDropMenuWSelectedSubnets($subs, $tmp[$x]['subnet'], 'subnet_tmp');
// quick check to ensure subnet from import matches existing subnet group
if (!in_array($tmp[$x]['subnet'], $subs) && !empty($tmp[$x]['subnet'])) {
$subnet_err[$x] = $err->GenerateErrorImg($defined['error'], "help/help.html#import_host", '800', '800');
$list .= "<li>Subnet field from import does match current list of existing subnet groups</li>";
}
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$message = $err->GenerateErrorLink("help/help.html", "#user_edit", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
if ($group === "admin") {
$query = "SELECT * FROM `auth_users` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
} else {
$query = "SELECT * FROM `auth_users` WHERE `group` = \"" . $group . "\" AND `id` = \"" . $_GET['id'] . "\" LIMIT 1";
}
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
echo $query;
$message = $err->GenerateErrorLink("help/help.html", "#user_edit", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$user_id = $data[0]['id'];
$user_username = $data[0]['username'];
$user_fname = $data[0]['first'];
$user_lname = $data[0]['last'];
$user_access_level = $data[0]['level'];
$user_group = $data[0]['group'];
$user_department = $data[0]['dept'];
$user_contact = $data[0]['contact'];
$user_phone = $data[0]['phone'];
$user_email = $data[0]['email'];
$message = $err->GenerateErrorLink("help/help.html", "#edit_user", $defined['good'], "You are currently editing record #" . $user_id, NULL, NULL);
}
}
}
// check for form submission first
// provide count of online users
$online = "SELECT * FROM `admin_sessions`";
$ret = $db->dbQuery($val->ValidateSQL($online, $dbconn), $dbconn);
$usersoline = $db->dbNumRows($ret);
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$message = $err->GenerateErrorLink("help/help.html", "#group_edit", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
$query = "SELECT * FROM `auth_groups` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
echo $query;
$message = $err->GenerateErrorLink("help/help.html", "#group_edit", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$group_id = $data[0]['id'];
$group_name = $data[0]['group'];
$group_manager = $data[0]['manager'];
$group_contact = $data[0]['contact'];
$group_description = $data[0]['description'];
$message = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['good'], "You are currently editing record #" . $group_id, NULL, NULL);
}
}
}
// check for form submission first
if (!empty($_POST)) {
// setup our form variables
$group_name = $_POST['group_name'];
$group_manager = $_POST['group_manager'];
$group_contact = $_POST['group_contact'];
$group = base64_decode($user_details[3]);
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_dnssec", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
//if( $group === "admin" ) {
$query = "SELECT * FROM `conf_dns_opts` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
//} else {
// $query = "SELECT * FROM `conf_dns_opts` WHERE `id` = \"" . $_GET['id'] . "\" AND `group` = \"" . $group . "\" LIMIT 1";
//}
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_dnssec", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$id = $data[0]['id'];
$zone = $data[0]['zone'];
$primary = $data[0]['type'];
$dnssec_enabled = $data[0]['dnssec-enabled'];
$dnssec_key = $data[0]['dnssec-key'];
}
}
}
// begin our validation on submitted data
if (!empty($_POST)) {
// re-assign vars for processing and template assignment
$id = $_POST['id'];
$zone = $_POST['zone'];
$primary = $_POST['primary'];
$dnssec_enabled = $_POST['dnssec_enabled'];
$FILE = "manage.subnets.tpl";
// initialize a db connection handle
$dbconn = $db->dbConnect($defined['dbhost'], $defined['username'], $defined['password'], $defined['dbname']);
// provide count of online users
$online = "SELECT * FROM `admin_sessions`";
$ret = $db->dbQuery($val->ValidateSQL($online, $dbconn), $dbconn);
$usersoline = $db->dbNumRows($ret);
// decode our authentication token to get our group membership
$user_details = $encrypt->DecodeAuthToken($_SESSION['token']);
$group = base64_decode($user_details[3]);
// get an array of subnets the ISC DHCPD service may listen on
$query = "SELECT `name`, `broadcast` FROM `conf_adapters` ORDER BY `broadcast` ASC";
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_subnets", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$tmp = $db->dbArrayResultsAssoc($value);
// filter for empty stuff
if (count($tmp) > 0) {
for ($x = 0; $x < count($tmp); $x++) {
if (!empty($tmp[$x]['broadcast'])) {
$interface_list[$tmp[$x]['name']] = $tmp[$x]['broadcast'];
}
}
} else {
$error = $err->GenerateErrorLink("help/help.html", "#config_subnets", $defined['error'], "It seems the list of available network interfaces that the DHCPD service may bind to is unavailable", NULL, NULL);
}
}
/* get array of resources available for this users group membership */
if ($group === "admin") {
$sql = "SELECT * FROM `auth_groups_perms` WHERE `type` = \"subnet\" AND `allowed` = \"" . $group . "\"";
} else {
$group = base64_decode($user_details[3]);
// Look for a GET id post to edit existing host records
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
if ($group === "admin" || !empty($_GET['allow']) && $val->ValidateInteger($_GET['allow']) === 0) {
$query = "SELECT * FROM `conf_hosts` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
} else {
$query = "SELECT * FROM `conf_hosts` WHERE `group` = \"" . $group . "\" AND `id` = \"" . $_GET['id'] . "\" LIMIT 1";
}
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#host_search", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
/* check resource permissions */
if ($group !== "admin") {
$resource = "SELECT * FROM `auth_groups_perms` WHERE ( `group` = \"" . $group . "\" OR `allowed` = \"" . $group . "\" ) AND `type` = \"host\" AND `resource` = \"" . $data[0]['mac-address'] . "\"";
} else {
$resource = "SELECT * FROM `auth_groups_perms` WHERE `resource` = \"" . $data[0]['mac-address'] . "\"";
}
if (($value = $db->dbQuery($val->ValidateSQL($resource, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_subnets", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$ch = $db->dbArrayResultsAssoc($value);
if (count($ch) > 0 || $data[0]['group'] === $group) {
$id = $data[0]['id'];
$hostname = $data[0]['hostname'];
$mac_address = $data[0]['mac-address'];
$ip_address = $data[0]['ip-address'];
$group = base64_decode($user_details[3]);
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_dnssec", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
//if( $group === "admin" ) {
$query = "SELECT * FROM `conf_dnssec_opts` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
//} else {
// $query = "SELECT * FROM `conf_dnssec_opts` WHERE `id` = \"" . $_GET['id'] . "\" WHERE `group` = \"" . $group . "\" LIMIT 1";
//}
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_dnssec", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$id = $data[0]['id'];
$key_name = $data[0]['key-name'];
$algorithm = $data[0]['algorithm'];
$key = $data[0]['key'];
}
}
}
// begin our validation on submitted data
if (!empty($_POST)) {
// re-assign vars for processing and template assignment
$id = $_POST['id'];
$key_name = $_POST['key_name'];
$algorithm = $_POST['algorithm'];
$key = $_POST['key'];
// check each post element
$group = base64_decode($user_details[3]);
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_shared", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
if ($group === "admin") {
$query = "SELECT * FROM `conf_shared_networks` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
} else {
$query = "SELECT * FROM `conf_shared_networks` WHERE `group` = \"" . $group . "\" AND `id` = \"" . $_GET['id'] . "\" LIMIT 1";
}
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_shared", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$id = $data[0]['id'];
$shared_network = $data[0]['shared-network-name'];
// populate list of assigned subnets by shared-network-name
if ($group === "admin") {
$sql = "SELECT `subnet-name`, `shared-network` FROM `conf_subnets` WHERE `shared-network` = \"" . $shared_network . "\"";
} else {
$sql = "SELECT `subnet-name`, `shared-network` FROM `conf_subnets` WHERE `shared-network` = \"" . $shared_network . "\" AND `group` = \"" . $group . "\"";
}
if (($nets = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_shared", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$subnet_checkboxes = $db->dbArrayResultsAssoc($nets);
$error = $err->GenerateErrorLink("help/help.html", "#config_subnet", $defined['good'], "You are currently editing the shared-network named '" . $shared_network . "'", NULL, NULL);
}
}
if ($level->ChkLevel($_SESSION['token']) === "root" || $level->ChkLevel($_SESSION['token'] === "user")) {
// define some variables for the template etc.
$FILE = "loggedin.tpl";
//hidediv( 'graphs' ); preLoader( 'templates/images/graphs/graph.hosts.php', 'templates/images/graphs/graph.leases.php', 'templates/images/graphs/graph.pxe.php', 'templates/images/graphs/graph.subnets.php', 'templates/images/graphs/graph.traffic.php' );
$JS = " hidediv( 'subnets'); hidediv( 'adapters' );";
$FORM = NULL;
$page = "admin.manage.users.php";
// decode the auth token for our username data
$user_details = $encrypt->DecodeAuthToken($_SESSION['token']);
$username = base64_decode($user_details[0]);
// get an array of subnets the ISC DHCPD service may listen on
$query = "SELECT `name`, `broadcast` FROM `conf_adapters` ORDER BY `broadcast` ASC";
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_subnets", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$tmp = $db->dbArrayResultsAssoc($value);
// filter for empty stuff
for ($x = 0; $x < count($tmp); $x++) {
if (!empty($tmp[$x]['broadcast'])) {
$interface_list[$tmp[$x]['name']] = $tmp[$x]['broadcast'];
}
}
}
// show the user the list of interfaces and their broadcast address
if (($ilist = $misc->GenTableFromAssocArray($interface_list)) === -1) {
$adapters = $err->GenerateErrorLink("help/help.html", "#config_subnet", $defined['error'], "There are no interfaces configured", NULL, NULL);
} else {
$adapters = $misc->GenTableFromAssocArray($interface_list);
}
// check service status
if ($misc->GetDHCPDStatus() === 0) {
function GetAvailableIPAddresses($value, $subnet)
{
//echo "<pre>"; print_r( $value ); echo "</pre>";
global $defined;
$db = new dbConn();
$val = new ValidateStrings();
// initialize a db connection handle
$dbconn = $db->dbConnect($defined['dbhost'], $defined['username'], $defined['password'], $defined['dbname']);
// process available scope IP's minus IP's engaged in `conf_leases` table
preg_match('/([0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3})\\.([0-9]{1,3})/', $value['scope-range-1'], $start);
preg_match('/([0-9]{1,3}\\.[0-9]{1,3}\\.[0-9]{1,3})\\.([0-9]{1,3})/', $value['scope-range-2'], $end);
// populate a range of valid octets to use
for ($x = $start[2]; $x < $end[2]; $x++) {
$tmp[] = $start[1] . "." . $x;
}
// mathmatica bitch
$x = 1;
for ($i = $start[2]; $i < $end[2]; $i++) {
$total[$key] = $x;
$x++;
}
// now get list of IP's in use as noted by the `conf_leases` table
$sql = "SELECT `ip` FROM `conf_leases` WHERE `ip` LIKE \"" . $start[1] . "%\"";
if (($return = $db->dbQuery($val->ValidateSQL($sql, $dbconn), $dbconn)) !== -1) {
if ($db->dbNumRows($return) !== 0) {
$leases = $db->dbArrayResultsAssoc($return);
}
}
// mathmatics
$amnt = $total[$key];
$in_use = count($leases);
$unused = $amnt - $in_use;
// populate empty list
if (count($tmp) !== 0) {
$x = 0;
foreach ($tmp as $key => $value) {
for ($i = 0; $i < count($leases); $i++) {
if (!in_array($value, $leases[$i])) {
$empty[$x][] = $value;
$x++;
}
}
}
$empty = $this->EliminiateDuplicates($empty);
}
// put everything in a simple array, wuka wuka
$ip_counts[$subnet]['total'] = $amnt;
$ip_counts[$subnet]['total_used'] = $in_use;
$ip_counts[$subnet]['total_unused'] = $unused;
$ip_counts[$subnet]['detail_used'] = $leases;
$ip_counts[$subnet]['detail_unused'] = $empty;
// Free db handle and close connection(s)
$db->dbFreeData($dbconn);
$db->dbCloseConn($dbconn);
// give it to them raw, raw
return $ip_counts;
}
$group = base64_decode($user_details[3]);
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateInteger($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_pxegroup", $defined['error'], $errors['val_num'], NULL, NULL);
} else {
// populate the form with database information if already configured
if ($group === "admin") {
$query = "SELECT * FROM `conf_pxe_groups` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1";
} else {
$query = "SELECT * FROM `conf_pxe_groups` WHERE `group` = \"" . $group . "\" AND `id` = \"" . $_GET['id'] . "\" LIMIT 1";
}
if (($value = $db->dbQuery($val->ValidateSQL($query, $dbconn), $dbconn)) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_pxegroup", $defined['error'], $errors['db_select'], NULL, NULL);
} else {
$data = $db->dbArrayResultsAssoc($value);
$id = $data[0]['id'];
$pxe_group_name = $data[0]['pxe-group-name'];
$pxe_server = $data[0]['pxe-server'];
$bootp_filename = $data[0]['bootp-filename'];
$assigned_subnet = $data[0]['assigned-subnet'];
}
}
}
// begin our validation on submitted data
if (!empty($_POST)) {
// re-assign vars for processing and template assignment
$id = $_POST['id'];
$pxe_group_name = $_POST['pxe_group_name'];
$pxe_server = $_POST['pxe_server'];
$bootp_filename = $_POST['bootp_filename'];
// define some variables for the template etc.
$JS = " hidediv('perms');";
$FILE = "manage.classes.tpl";
// initialize a db connection handle
$dbconn = $db->dbConnect($defined['dbhost'], $defined['username'], $defined['password'], $defined['dbname']);
// provide count of online users
$online = "SELECT * FROM `admin_sessions`";
$ret = $db->dbQuery($val->ValidateSQL($online, $dbconn), $dbconn);
$usersoline = $db->dbNumRows($ret);
// decode our authentication token to get our group membership
$user_details = $encrypt->DecodeAuthToken($_SESSION['token']);
$group = base64_decode($user_details[3]);
// create list of class options
$optsquery = "DESCRIBE `conf_classes_opts`";
if (($current = $db->dbQuery($val->ValidateSQL($optsquery, $dbconn), $dbconn)) !== -1) {
$optslist = $db->dbArrayResultsAssoc($current);
}
if (count($optslist) === 0) {
$class_option = "Class Options table missing";
} else {
foreach ($optslist as $key => $value) {
if ($value['Field'] !== "id") {
$encoded[$value['Field']] = $value['Type'];
}
}
$encoded = json_encode($encoded);
}
// Look for a GET id post to edit existing dnssec keys
if (!empty($_GET['id'])) {
if ($val->ValidateParagraph($_GET['id']) === -1) {
$error = $err->GenerateErrorLink("help/help.html", "#config_classes", $defined['error'], $errors['val_num'], NULL, NULL);