// perform permissions check with access level and group data if ($level->ChkLevel($_SESSION['token']) === "admin" || $level->ChkLevel($_SESSION['token']) === "user") { // define some variables for the template etc. $JS = " hidediv('extras'); hidediv('perms');"; $FILE = "manage.leases.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]); // attempt to process leases if file changed $misc->GetCurrentLeases($defined['leases']); // 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", "#lease_search", $defined['error'], $errors['val_num'], NULL, NULL); } else { // populate the form with database information if already configured if ($group === "admin") { $query = "SELECT * FROM `conf_leases` WHERE `id` = \"" . $_GET['id'] . "\" LIMIT 1"; } else { $query = "SELECT * FROM `conf_leases` 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", "#lease_search", $defined['error'], $errors['db_select'], NULL, NULL); } else { $data = $db->dbArrayResultsAssoc($value);