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

philip Fri Apr 3 01:03:35 2009 UTC Modified files: /php-master-web/scripts mirror-summary Log: Added column for the SQLite check, and fixed padding for xxxx.php.net domains and x.y.zz releases http://cvs.php.net/viewvc.cgi/php-master-web/scripts/mirror-summary?r1=1.23&r2=1.24&diff_format=u Index: php-master-web/scripts/mirror-summary diff -u php-master-web/scripts/mirror-summary:1.23 php-master-web/scripts/mirror-summary:1.24 --- php-master-web/scripts/mirror-summary:1.23 Mon Jan 7 02:29:58 2008 +++ php-master-web/scripts/mirror-summary Fri Apr 3 01:03:35 2009 @@ -25,7 +25,7 @@ list($checktime) = mysql_fetch_row($lct); // Select all mirrors ordered by hostname -$query = "SELECT maintainer, hostname, id, UNIX_TIMESTAMP(lastupdated) AS lastupdate, " . +$query = "SELECT maintainer, hostname, id, has_search, UNIX_TIMESTAMP(lastupdated) AS lastupdate, " . "phpversion, (DATE_SUB(FROM_UNIXTIME($checktime), INTERVAL 3 DAY) < lastchecked) AS active, " . "(DATE_SUB(FROM_UNIXTIME($checktime), INTERVAL 7 DAY) < lastupdated) AS current, active AS enabled, acmt, ocmt " . "FROM mirrors ORDER BY hostname"; @@ -83,7 +83,7 @@ $body .= "\nAnd now for the rest of the mirrors:\n" . "----------------------------------------------------------------------------------------\n" - . " Host \t\t PHP Version \t\t Last Updated\n" + . " Host \t\t PHP Version \t\t SQLite \t\t Last Updated\n" . "----------------------------------------------------------------------------------------\n"; /* A note about the padding - given that email readers produce interesting results for spacing, @@ -108,7 +108,15 @@ for ($i=0; $i < $total; $i++) { if ($hosts[$i]['active'] && $hosts[$i]['current']){ - $body .= sprintf(" %s%s%s%s%s\n", $hosts[$i]['hostname'], pad(11, "hostname"), $hosts[$i]['phpversion'], pad(5, "phpversion"), date("F j, Y, g:i a", $hosts[$i]['lastupdate'])); + + $has_search = empty($hosts[$i]['has_search']) ? 'N' : 'Y'; + + $body .= sprintf(" %s%s%s%s%s%s%s\n", + $hosts[$i]['hostname'], pad(12, 'hostname'), + $hosts[$i]['phpversion'], pad(6, 'phpversion'), + $has_search, pad(1, 'has_search'), + date('F j, Y, g:i a', $hosts[$i]['lastupdate']) + ); } }