From adef61b9f6d0b23de2a378c31b19393a60af12b2 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 18 Jun 2018 14:16:58 +0200 Subject: mirror-index new --- mirrors/index.php | 93 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 93 insertions(+) create mode 100644 mirrors/index.php diff --git a/mirrors/index.php b/mirrors/index.php new file mode 100644 index 0000000..85ec4e0 --- /dev/null +++ b/mirrors/index.php @@ -0,0 +1,93 @@ +`ms`.`start`" . + ") AND `ms`.`start` > UNIX_TIMESTAMP(NOW())-" . $cutoff +); + +$result = mysql_run_query( + "SELECT " . + "GROUP_CONCAT(`l_ms`.`protocol`) AS `protocols`," . + "SUBSTRING(`l_ms`.`url`,LENGTH(`l_ms`.`protocol`)+4) AS `url`," . + "`l_ms`.`country`," . + "`l_ms`.`country_code`," . + "`l_ms`.`isos`," . + "`l_ms`.`ipv4`," . + "`l_ms`.`ipv6`" . + " FROM `ls`" . + " JOIN `mirror_statuses` AS `l_ms` ON `ls`.`id`=`l_ms`.`id`" . + " GROUP BY SUBSTRING(`l_ms`.`url`,LENGTH(`l_ms`.`protocol`)+4)" +); + +$last_check = 0; +$max_count = 0; + +while($row = $result->fetch_assoc()) + $rows[] = $row; + +print_header("Mirror Overview"); + +?> +
+

Mirror Overview

+ + + + + + + + + + +\n"; + print " \n"; + print " \n"; + print " \n"; + print " \n"; + print " \n"; + if ($oddity == "odd") + $oddity = "even"; + else + $oddity = "odd"; +} + +?> + +
ServerCountryISOsProtocols
\n"; + print " " . $row["url"] . "\n"; + print " \n"; + print " \n"; + print " \n"; + print " " . $row["country"] . "\n"; + print " \n"; + if ($row["isos"]) + print " Yes\n"; + else + print " No\n"; + print " \n"; + print " " . $row["protocols"] . "\n"; + print "
+
+