cvs: php-master-web /scripts mirror-summary

From: Date: Mon, 06 Jan 2003 11:36:42 +0000
Subject: cvs: php-master-web /scripts mirror-summary
Groups: php.mirrors 
Request: Send a blank email to php-mirrors+get-14790@lists.php.net to get a copy of this message
goba Mon Jan 6 06:36:42 2003 EDT Modified files: /php-master-web/scripts mirror-summary Log: Also use the last mirror check time here to see if a mirror is inactive... Index: php-master-web/scripts/mirror-summary diff -u php-master-web/scripts/mirror-summary:1.7 php-master-web/scripts/mirror-summary:1.8 --- php-master-web/scripts/mirror-summary:1.7 Thu Jan 2 12:24:35 2003 +++ php-master-web/scripts/mirror-summary Mon Jan 6 06:36:42 2003 @@ -14,10 +14,14 @@ mysql_connect("localhost","nobody","") or die("unable to connect to database"); mysql_select_db("php3"); +// Select last mirror check time from table +$lct = mysql_query("SELECT UNIX_TIMESTAMP(lastchecked) FROM mirrors ORDER BY lastchecked DESC LIMIT 1"); +list($checktime) = mysql_fetch_row($lct); + // Select all mirrors ordered by hostname $query = "SELECT maintainer, hostname, id, UNIX_TIMESTAMP(lastupdated) AS lastupdate, " . - "phpversion, (DATE_SUB(NOW(), INTERVAL 3 DAY) < lastchecked) AS active, " . - "(DATE_SUB(NOW(), INTERVAL 7 DAY) < lastupdated) AS current " . + "phpversion, (DATE_SUB(FROM_UNIXTIME($checktime), INTERVAL 3 DAY) < lastchecked) AS active, " . + "(DATE_SUB(FROM_UNIXTIME($checktime), INTERVAL 7 DAY) < lastupdated) AS current " . "FROM mirrors ORDER BY hostname"; // Execute SQL query

« previous php.mirrors (#14790) next »