index : archweb32 | |
Archlinux32 website | gitolite user |
summaryrefslogtreecommitdiff |
-rw-r--r-- | mirrors/active.php | 50 |
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); |