From 1bdfa0fa9de78c1139c300292d9d47e8e11d3ab0 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 10 Jul 2018 09:20:53 +0200
Subject: lib/format.php: accepts different content for each format, now;
 mirrors/active.php is obsolete - is included in mirror/status.php now

---
 mirrors/active.php | 50 --------------------------------------------------
 1 file changed, 50 deletions(-)
 delete mode 100644 mirrors/active.php

(limited to 'mirrors/active.php')

diff --git a/mirrors/active.php b/mirrors/active.php
deleted file mode 100644
index a3958b7..0000000
--- a/mirrors/active.php
+++ /dev/null
@@ -1,50 +0,0 @@
-<?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",
-    "recently_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