'; ?> getOwnerByWms($serviceId); if (!(in_array(Mapbender::session()->get("mb_user_id"), $owners))) { echo "User with ID: ".Mapbender::session()->get("mb_user_id")." - You have no rights to see the requested pages!"; die; } else { echo "OwnerID: ".Mapbender::session()->get("mb_user_id")."
"; } break; case 'wfs': $owners = $admin->getOwnerByWfs($serviceId); if (!(Mapbender::session()->get("mb_user_id") == $owners)) { echo "User with ID: ".Mapbender::session()->get("mb_user_id")." - You have no rights to see the requested pages!"; die; } else { echo "OwnerID: ".Mapbender::session()->get("mb_user_id")."
"; } break; } 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_w".$serviceTypeAbbr."s_id = $1 AND fkey_mb_user_id = mb_user_id"; $v = array($serviceId); $t = array('i'); $res = db_prep_query($sql,$v,$t); $cnt = 0; $str = "Usage for W".strtoupper($serviceTypeAbbr)."S:

---

\n"; switch ($serviceType) { case 'wms': $serviceTitle = $admin->getWmsTitleByWmsId($serviceId); break; case 'wfs': $serviceTitle = $admin->getWfsTitleByWfsId($serviceId); break; } $str .= "" . $serviceId . "
" . $serviceTitle . "


\n"; $str .= ""; $str .= ""; $str .= ""; $str .= ""; $str .= ""; while ($row = db_fetch_array($res)) { $str .= "\n\t\t"; $str .= "\n\t\t\t"; $UserId[$cnt] = db_result($res,$cnt,"fkey_mb_user_id"); $str .= "\n\t\t\t"; $UserName[$cnt] = db_result($res,$cnt,"mb_user_name"); $str .= "\n\t\t\t"; $UserEmail[$cnt] = db_result($res,$cnt,"mb_user_email"); $str .= "\n\t\t\t"; $UserPhone[$cnt] = db_result($res,$cnt,"mb_user_phone"); $str .= "\n\t\t\t"; #$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

Index	ID	User Name	User Email	User Phone	Single requests
".$cnt."	".$UserId[$cnt]."	".$UserName[$cnt]."	".$UserEmail[$cnt]."	".$UserPhone[$cnt]."

\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'); $res = db_prep_query($sql,$v,$t); $row = db_fetch_array($res); //show usage of this user switch ($serviceType) { case 'wms': $sql = "SELECT count(*) as sumrequests, sum(pixel) as sumelements , max(proxy_log_timestamp) as lastaccess FROM mb_proxy_log where fkey_mb_user_id=$2 AND fkey_wms_id=$1"; break; case 'wfs': $sql = "SELECT count(*) as sumrequests, sum(features) as sumelements , max(proxy_log_timestamp) as lastaccess FROM mb_proxy_log where fkey_mb_user_id=$2 AND fkey_wfs_id=$1"; break; } $v = array($serviceId, $_REQUEST['userid']); $t = array('i','i'); $res = db_prep_query($sql,$v,$t); $row = db_fetch_array($res); $sumrequests = $row["sumrequests"]; $sumelements = $row["sumelements"]; $lastAccess = $row["lastaccess"]; $str = "Usage of Secured W".strtoupper($serviceTypeAbbr)."S:

---

\n"; $str .= "" . $serviceId . "
" . $serviceTitle . "


\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, features, request FROM mb_proxy_log where fkey_mb_user_id=$2 AND fkey_w".$serviceTypeAbbr."s_id=$1 ORDER BY proxy_log_timestamp DESC LIMIT ".$maxRequests; $v = array($serviceId, $_REQUEST['userid']); $t = array('i','i'); $res = db_prep_query($sql,$v,$t); $cnt=0; $str .= "

---

Last ".$maxRequests." Requests:
"; $str .= ""; $str .= ""; $str .= ""; while ($row = db_fetch_array($res)) { $str .= "\n\t\t"; $timestamp[$cnt] = db_result($res,$cnt,"proxy_log_timestamp"); $str .= "\n\t\t\t"; switch($serviceType){ case 'wms': $elements[$cnt] = db_result($res,$cnt,"pixel"); break; case 'wfs': $elements[$cnt] = db_result($res,$cnt,"features"); break; } $str .= "\n\t\t\t"; $request[$cnt] = db_result($res,$cnt,"request"); switch($serviceType){ case 'wms': $str .= "\n\t\t\t"; break; case 'wfs': $str .= "\n\t\t\t"; break; } $str .= ""; $cnt++; } } $str .= "

---

Total Requests: ".$sumrequests."

"; switch($serviceType){ case 'wms': $sumelements=$sumelements/1000000; $str .= "

---

Total MegaPixel: ".$sumelements."

"; break; case 'wfs': $str .= "

---

Total amount of features: ".$sumelements."

"; break; } if (!$_REQUEST['requests']) { $str .= ""; } } echo $str; ?>

timestamp	requested pixels/features	GetMap / GetFeature Request
".$timestamp[$cnt]."	".$elements[$cnt]."