cvs: php-master-web /scripts mirror-summary
| From: | Gabor Hojtsy | 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