'; ?> '.$testMatch.' is not valid.
'; echo 'Parameter
serviceType
is not valid (wms, wfs).
'; die(); } $serviceType = $testMatch; $testMatch = NULL; } if (isset($_REQUEST["id"]) & $_REQUEST["id"] != "") { //validate integer $testMatch = $_REQUEST["id"]; //give max 99 entries - more will be to slow $pattern = '/^[0-9]*$/'; if (!preg_match($pattern,$testMatch)){ echo 'Parameter
id
is not valid (integer).
'; die(); } $id = $testMatch; $testMatch = NULL; } $sql = "SELECT upload_id, status, status_comment, timestamp_begin, timestamp_end, upload_url, updated FROM mb_monitor "; switch ($serviceType) { case "wms": $sql .= "WHERE fkey_wms_id = $1 AND NOT status = '-2' ORDER BY upload_id DESC"; break; case "wfs": $sql .= "WHERE fkey_wfs_id = $1 AND NOT status = '-2' ORDER BY upload_id DESC"; break; } $v = array($id); $t = array('i'); $res = db_prep_query($sql,$v,$t); $cnt=0; while ($row = db_fetch_array($res)) { $upload_id[$cnt] = db_result($res,$cnt,"upload_id"); $status[$cnt] = intval(db_result($res,$cnt,"status")); $comment[$cnt] = db_result($res,$cnt,"status_comment"); $timestamp_begin = db_result($res,$cnt,"timestamp_begin"); $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"; } $cnt++; } $str = "
"._mb("Monitoring results")."
\n";//Monitoring Ergebnisse switch ($serviceType) { case "wms": $str .= "
" . $id . "
" . $admin->getWmsTitleByWmsId($id) . "
\n"; break; case "wfs": $str .= "
" . $id . "
" . $admin->getWfsTitleByWfsId($id) . "
\n"; break; } $str .= "
"; $str .= "
date
"._mb("Status")."
"._mb("Response time")."
";//Status Antwortzeit for ($k=0; $k
"; $str .= "\n\t\t\t
"; $str .= "\n\t\t\t
" . $comment[$k] . "
"; $str .= "\n\t\t\t
" . $response_time[$k] . "
"; # $str .= "\n\t\t\t
log
"; } $str .= "\n\t
\n\t"; echo $str; ?>
![](../img/trafficlights/". $img. " "Connect to service")