summaryrefslogtreecommitdiff
path: root/mirrors/active.php
diff options
context:
space:
mode:
Diffstat (limited to 'mirrors/active.php')
-rw-r--r--mirrors/active.php50
1 files changed, 0 insertions, 50 deletions
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);