}
while ($logdata = $sql->fetch_array()) {
print "<tr>";
print "<td>" . $logdata["timestamp"] . "</td>";
if ($logdata["activity"] == "1") {
print "<td>" . idtoadmin($logdata["adminid"]) . " added " . $logdata["data"] . " (userid: " . $logdata["userid"] . ")</td>";
}
if ($logdata["activity"] == "2") {
print "<td>" . idtoadmin($logdata["adminid"]) . " edited " . $logdata["data"] . " (userid: " . $logdata["userid"] . ")</td>";
}
if ($logdata["activity"] == "3") {
print "<td>" . idtoadmin($logdata["adminid"]) . " deleted " . $logdata["data"] . " (userid: " . $logdata["userid"] . ")</td>";
}
if ($logdata["activity"] == "4") {
print "<td>" . idtoadmin($logdata["adminid"]) . " enabled " . $logdata["data"] . " (userid: " . $logdata["userid"] . ")</td>";
}
if ($logdata["activity"] == "5") {
print "<td><" . idtoadmin($logdata["adminid"]) . " disabled " . $logdata["data"] . " (userid: " . $logdata["userid"] . ")</td>";
}
print "</tr>";
}
mysqli_close($mysqli);
?>
</tbody>
</table>
</div>
<div class="control-group">
<div class="controls">
</div>
</div>
</form>
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);
}
?>
</div>
</div>
</div>
<div class="span5">
<div class="control-group">
<div class="controls">
Last changed: <?php
if ($usrres["changed"] != "0000-00-00 00:00:00") {
print $usrres["changed"];
}
?>
<br>
Last changed by: <?php
if ($usrres["changedby"] != "") {
print idtoadmin($usrres["changedby"]);
}
?>
</div>
</div>
</div>
</div>
</form>
<button class="btn" name="bedit" value="Save" onclick="checkeditusername();">Save</button>
</div>
</div>
</div>
</div>
</div>
<?php
require "includes/footer.php";
$usrexp = checkstartexpire($res["startdate"], $res["expiredate"], $res["enabled"]);
print "<tr>";
if ($res["admin"] == "1") {
print "<td>" . $res["user"] . " <span class=\"label label-warning\">A</span></td>";
} else {
print "<td>" . $res["user"] . "</td>";
}
print "<td>" . $res["displayname"] . "</td>";
if ($setres["extrausrtbl"] == "1") {
print "<td>" . $res["password"] . "</td>";
} elseif ($setres["extrausrtbl"] == "2") {
print "<td>" . printdate($res["startdate"]) . "</td>";
} elseif ($setres["extrausrtbl"] == "3") {
print "<td>" . printdate($res["expiredate"]) . "</td>";
} elseif ($setres["extrausrtbl"] == "4") {
print "<td>" . idtoadmin($res["addedby"]) . "</td>";
}
print "<td>" . idtogrp($res["usrgroup"]) . "</td>";
if ($usrexp == "0") {
print "<td><a id=\"usrlnkenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"enableuser('" . $res["id"] . "','" . $_SESSION[$secretkey . "userlvl"] . "','" . $_SESSION[$secretkey . "usergrp"] . "','" . $_SESSION[$secretkey . "userid"] . "');\"><div id=\"usrenabled-" . $res["id"] . "\"><span class=\"label label-important\">Disabled</span></div></a></td>";
} elseif ($usrexp == "1") {
print "<td><a id=\"usrlnkenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"disableuser('" . $res["id"] . "','" . $_SESSION[$secretkey . "userlvl"] . "','" . $_SESSION[$secretkey . "usergrp"] . "','" . $_SESSION[$secretkey . "userid"] . "');\"><div id=\"usrenabled-" . $res["id"] . "\"><span class=\"label label-success\">Enabled</span></div></a></td>";
} elseif ($usrexp == "2") {
print "<td><a id=\"usrlnkenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"enableuser('" . $res["id"] . "','" . $_SESSION[$secretkey . "userlvl"] . "','" . $_SESSION[$secretkey . "usergrp"] . "','" . $_SESSION[$secretkey . "userid"] . "');\"><div id=\"usrenabled-" . $res["id"] . "\"><span class=\"label label-warning\">Not Started</span></div></a></td>";
} elseif ($usrexp == "3") {
print "<td><a id=\"usrlnkenabled-" . $res["id"] . "\" href=\"javascript:void(0);\" onclick=\"enableuser('" . $res["id"] . "','" . $_SESSION[$secretkey . "userlvl"] . "','" . $_SESSION[$secretkey . "usergrp"] . "','" . $_SESSION[$secretkey . "userid"] . "');\"><div id=\"usrenabled-" . $res["id"] . "\"><span class=\"label label-warning\">Expired</span></div></a></td>";
} else {
print "<td></td>";
}
if ($_SESSION[$secretkey . "fetchcsp"] == "1" && $cspconnstatus == "1") {
if (isset($cspuserlist[$res["user"]])) {