errorpage("MYSQL DATABASE ERROR", mysqli_connect_error(), $charset, CMUM_TITLE, $_SERVER["REQUEST_URI"], CMUM_VERSION, CMUM_BUILD, CMUM_MOD);
exit;
}
$sql = $mysqli->query("SELECT * FROM admins ORDER BY user");
while ($res = $sql->fetch_array()) {
print "<tr>";
print "<td>" . $res["user"] . "</td>";
print "<td>" . $res["name"] . "</td>";
if ($res["admlvl"] == "0") {
print "<td>Administrator</td>";
} elseif ($res["admlvl"] == "1") {
print "<td>Manager</td>";
} elseif ($res["admlvl"] == "2") {
print "<td>Group manager</td>";
}
print "<td>" . idtogrp($res["ugroup"]) . "</td>";
if ($res["enabled"] == "1") {
print "<td><a id=\"admlnkenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"disableadmin('" . $res["id"] . "');\"><div id=\"admenabled-" . $res["id"] . "\"><span class=\"label label-success\">Enabled</span></div></a></td>";
} else {
print "<td><a id=\"admlnkenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"enableadmin('" . $res["id"] . "');\"><div id=\"admenabled-" . $res["id"] . "\"><span class=\"label label-important\">Disabled</span></div></a></td>";
}
print "<td>";
print "<div class=\"btn-group pull-right\">";
print "<button data-toggle=\"dropdown\" class=\"btn btn-small\">Actions <span class=\"caret\"></span></button>";
print "<ul class=\"dropdown-menu\">";
if ($res["enabled"] == "1") {
print "<li><a href=\"admins.php?action=edit&uid=" . $res["id"] . "\">Edit</a><a href=\"admins.php?action=chpass&uid=" . $res["id"] . "\">Change password</a><a id=\"aadmenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"disableadmin('" . $res["id"] . "');\">Disable</a><a href=\"admins.php?action=delete&uid=" . $res["id"] . "\">Delete</a></li>";
} else {
print "<li><a href=\"admins.php?action=edit&uid=" . $res["id"] . "\">Edit</a><a href=\"admins.php?action=chpass&uid=" . $res["id"] . "\">Change password</a><a id=\"aadmenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"enableadmin('" . $res["id"] . "');\">Enable</a><a href=\"admins.php?action=delete&uid=" . $res["id"] . "\">Delete</a></li>";
}
print "</ul>";
function expusrcsv($usrgrp)
{
if (file_exists("config.php")) {
require "config.php";
} else {
require "../config.php";
}
$csvout = "";
$profvalues = "";
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if (isset($usrgrp) && $usrgrp != "") {
$usql = $mysqli->query("SELECT * FROM users WHERE usrgroup='" . $usrgrp . "'");
} else {
$usql = $mysqli->query("SELECT * FROM users");
}
while ($usrdata = $usql->fetch_array()) {
$profiles = "";
if ($usrdata["profiles"] == "") {
$profiles = "";
} else {
$dbprof = unserialize($usrdata["profiles"]);
if ($dbprof != "" && $dbprof != "N;") {
foreach ($dbprof as $useprof) {
$psql = $mysqli->query("SELECT cspvalue FROM profiles WHERE id='" . $useprof . "'");
$profdata = $psql->fetch_array();
$profvalues .= $profdata["cspvalue"] . " ";
}
$profiles = trim($profvalues);
$profdata = "";
$profvalues = "";
} else {
$profiles = "";
}
}
if ($usrdata["comment"] != "") {
$comment = str_replace("\n", " ", $usrdata["comment"]);
$comment = str_replace("\r", " ", $comment);
$comment = preg_replace("/\\s+/", " ", $comment);
} else {
$comment = $usrdata["comment"];
}
$csvout .= $usrdata["user"] . ";" . $usrdata["password"] . ";" . $usrdata["displayname"] . ";" . $usrdata["ipmask"] . ";" . $profiles . ";" . $usrdata["maxconn"] . ";" . $usrdata["admin"] . ";" . $usrdata["enabled"] . ";" . $usrdata["mapexclude"] . ";" . $usrdata["debug"] . ";" . $comment . ";" . $usrdata["email"] . ";" . htmlspecialchars($usrdata["customvalues"]) . ";" . $usrdata["ecmrate"] . ";" . $usrdata["startdate"] . ";" . $usrdata["expiredate"] . ";" . idtogrp($usrdata["usrgroup"]) . ";" . $usrdata["boxtype"] . ";" . $usrdata["macaddress"] . ";" . $usrdata["serialnumber"] . ";" . $usrdata["added"] . ";" . idtoadmin($usrdata["addedby"]) . ";" . $usrdata["changed"] . ";" . idtoadmin($usrdata["changedby"]) . ";\n";
}
mysqli_close($mysqli);
return trim($csvout);
}
