index : website | |
Archlinux32 website - obsolete | gitolite user |
summaryrefslogtreecommitdiff |
author | Erich Eckner <git@eckner.net> | 2018-06-15 13:38:34 +0200 |
---|---|---|
committer | Erich Eckner <git@eckner.net> | 2018-06-15 13:38:34 +0200 |
commit | 76eda27b3d87899ea56c17aed2e6e8944892a3c6 (patch) | |
tree | aa45d31aae5a4ecc085b21d4801e95ab047b4c51 /mirrors/status.php | |
parent | e1504b8394f3aa5cad02b1bfe0f9721877c2682b (diff) |
-rw-r--r-- | mirrors/status.php | 20 |
diff --git a/mirrors/status.php b/mirrors/status.php index 7044386..1e1f274 100644 --- a/mirrors/status.php +++ b/mirrors/status.php @@ -34,7 +34,7 @@ $result = mysql_run_query( "`l_ms`.`ipv4`," . "`l_ms`.`ipv6`," . "`l_ms`.`active`," . - "AVG(IF(`a_ms`.`active`,1,0)) AS `completion`," . + "AVG(IF(`a_ms`.`active`,1,0)) AS `completion_pct`," . "COUNT(1) AS `count`" . " FROM `ls`" . " JOIN `mirror_statuses` AS `l_ms` ON `ls`.`id`=`l_ms`.`id`" . @@ -47,8 +47,22 @@ $last_check = 0; $max_count = 0; while($row = $result->fetch_assoc()) { + foreach (array( + "start", + "delay", + "duration_avg", + "duration_stddev", + "completion_pct", + "count", + "isos", + "ipv4", + "ipv6", + "active" + ) as $key) + $row[$key] = floatval($row[$key]); + $row["last_sync"] = gmdate("Y-m-d\TH:i:s\Z", $row["last_sync"]); $row["score"] = - ($row["delay"] + $row["duration_avg"] + $row["duration_stddev"]) / $row["completion"]; + ($row["delay"] + $row["duration_avg"] + $row["duration_stddev"]) / $row["completion_pct"]; $urls[] = $row; $last_check = max ($row["start"], $last_check); $max_count = max ($row["count"], $max_count); @@ -58,7 +72,7 @@ $content = array( "cutoff" => $cutoff, "check_frequency" => $cutoff/$max_count, "num_checks" => $max_count, - "last_check" => gmdate("Y-m-d\TH:i:s.v",$last_check), //"2018-06-15T07:25:06.741Z", + "last_check" => gmdate("Y-m-d\TH:i:s.v\Z",$last_check), //"2018-06-15T07:25:06.741Z", // "version" => 3, "urls" => $urls ); |