';
?>
getOwnerByWms($wms_id);
echo $wmsOwners;
if (!(in_array(Mapbender::session()->get("mb_user_id"), $wmsOwners))) {
echo "User with ID: ".Mapbender::session()->get("mb_user_id")." - You have no rights to see the requested pages!";
//echo "
You are: ".$admin->getOwnerByWms($wms_id);
die;
}
else {
echo "OwnerID: ".Mapbender::session()->get("mb_user_id")."
";
}
if (!isset($_REQUEST['userid'])){
//List Users wich have used the service - read the log table
$sql = "SELECT distinct fkey_mb_user_id, mb_user_name, mb_user_email, mb_user_phone from mb_proxy_log, mb_user ";
$sql .= " WHERE fkey_wms_id = $1 AND fkey_mb_user_id = mb_user_id";
#$sql = "SELECT upload_id, status, status_comment, timestamp_begin, timestamp_end, upload_url, updated FROM mb_monitor ";
#$sql .= "WHERE fkey_wms_id = $1 AND NOT status = '-2' ORDER BY upload_id DESC";
$v = array($wms_id);
$t = array('i');
$res = db_prep_query($sql,$v,$t);
$cnt = 0;
$str = "Usage for WMS:
\n";
$str .= "" . $wms_id . "
" . $admin->getWmsTitleByWmsId($wms_id) . "
\n";
$str .= "";
$str .= "";
$str .= "| Index | ID | User Name | User Email | ";
$str .= "User Phone | ";
$str .= "Single requests |
";
while ($row = db_fetch_array($res)) {
$str .= "\n\t\t";
$str .= "\n\t\t\t| ".$cnt." | ";
$UserId[$cnt] = db_result($res,$cnt,"fkey_mb_user_id");
$str .= "\n\t\t\t".$UserId[$cnt]." | ";
$UserName[$cnt] = db_result($res,$cnt,"mb_user_name");
$str .= "\n\t\t\t".$UserName[$cnt]." | ";
$UserEmail[$cnt] = db_result($res,$cnt,"mb_user_email");
$str .= "\n\t\t\t".$UserEmail[$cnt]." | ";
$UserPhone[$cnt] = db_result($res,$cnt,"mb_user_phone");
$str .= "\n\t\t\t".$UserPhone[$cnt]." | ";
#$timestamp_end = db_result($res,$cnt,"timestamp_end");
#$upload_url[$cnt] = db_result($res,$cnt,"upload_url");
#if ($status[$cnt] == '0' || $status[$cnt] == '1') {
# $response_time[$cnt] = strval($timestamp_end-$timestamp_begin) . " s";
#}
#else {
# $response_time[$cnt] = "n/a";
#}
$str .= " | ";
$str .= "
";
$cnt++;
}
$str .= "\n\t
\n\t";
}
else {
//UserID was set
//Get infos about specific user
$sql = "SELECT mb_user_id, mb_user_name, mb_user_email, mb_user_phone from mb_user ";
$sql .= " WHERE mb_user_id = $1";
$v = array($_REQUEST['userid']);
$t = array('i','i');
$res = db_prep_query($sql,$v,$t);
$row = db_fetch_array($res);
//show usage of this user
$sql = "SELECT count(*) as sumrequests, sum(pixel) as sumpixel , max(proxy_log_timestamp) as lastaccess FROM mb_proxy_log where fkey_mb_user_id=$2 AND fkey_wms_id=$1";
//$sql .= " WHERE fkey_wms_id = $1 AND fkey_mb_user_id = mb_user_id";
$v = array($wms_id,$_REQUEST['userid']);
$t = array('i','i');
$res = db_prep_query($sql,$v,$t);
$row = db_fetch_array($res);
$sumrequests = $row["sumrequests"];
$sumpixel = $row["sumpixel"];
$lastAccess = $row["lastaccess"];
//$sumpixel=0;
$str = "Usage of Secured WMS:
\n";
$str .= "" . $wms_id . "
" . $admin->getWmsTitleByWmsId($wms_id) . "
\n";
$str .= "
for User: ".$row['mb_user_name']."
";
$str .= "UserID: ".$_REQUEST['userid']."
UserEmail: ".$row['mb_user_email']."
UserPhone: ".$row['mb_user_phone']."
Last Access: ".$lastAccess."
";
//Maximum requests
$maxRequests = 50;
//case showSingleRequests
if (($_REQUEST['requests']) & ($_REQUEST['requests']) == 1 ) {
//show usage of this user
$sql = "SELECT proxy_log_timestamp, pixel, request FROM mb_proxy_log where fkey_mb_user_id=$2 AND fkey_wms_id=$1 ORDER BY proxy_log_timestamp DESC LIMIT ".$maxRequests;
$v = array($wms_id,$_REQUEST['userid']);
$t = array('i','i');
$res = db_prep_query($sql,$v,$t);
$cnt=0;
$str .= "
Last ".$maxRequests." Requests:
";
$str .= "