From 190727abb94c75911cf67624ee7020ff66a19451 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 10 Jul 2018 09:03:22 +0200
Subject: mirrors/active.php new

---
 mirrors/active.php | 49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 mirrors/active.php

(limited to 'mirrors/active.php')

diff --git a/mirrors/active.php b/mirrors/active.php
new file mode 100644
index 0000000..2294fb4
--- /dev/null
+++ b/mirrors/active.php
@@ -0,0 +1,49 @@
+<?php
+require_once "../init.php";
+
+require_once BASE . "/lib/mysql.php";
+require_once BASE . "/lib/format.php";
+
+$result = mysql_run_query(
+  "SELECT " .
+  "`mirror_statuses`.`protocol`," .
+  "`mirror_statuses`.`url`," .
+  "`mirror_statuses`.`country`," .
+  "`mirror_statuses`.`country_code`," .
+  "`mirror_statuses`.`last_sync`," .
+  "`mirror_statuses`.`start`," .
+  "`mirror_statuses`.`isos`," .
+  "`mirror_statuses`.`ipv4`," .
+  "`mirror_statuses`.`ipv6`," .
+  "`mirror_statuses`.`active`," .
+  "(`mirror_statuses`.`active` AND (`mirror_statuses`.`start` > UNIX_TIMESTAMP(NOW()) - 3600)) AS `recently_active`" .
+  " FROM `mirror_statuses`" .
+  " JOIN (" .
+    "SELECT " .
+    "`mirror_statuses`.`url`," .
+    "MAX(`mirror_statuses`.`start`) AS `start`" .
+    " FROM `mirror_statuses` GROUP BY `url`" .
+  ") AS `max_mirror`" .
+  " ON `mirror_statuses`.`url`=`max_mirror`.`url`" .
+  " AND `mirror_statuses`.`start`=`max_mirror`.`start`" .
+  " ORDER BY `mirror_statuses`.`url`"
+);
+
+while($row = $result->fetch_assoc()) {
+  foreach (array(
+    "start",
+    "isos",
+    "ipv4",
+    "ipv6",
+    "active"
+  ) as $key)
+    $row[$key] = floatval($row[$key]);
+  foreach (array(
+    "start",
+    "last_sync"
+  ) as $key)
+    $row[$key] = gmdate("Y-m-d\TH:i:s\Z", $row[$key]);
+  $content[] = $row;
+}
+
+export_as_requested($content);
-- 
cgit v1.2.3-70-g09d2