`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"; } ?>

Server	Country	ISOs	Protocols
\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 "