cvs: pearweb /public_html package-stats.php

cellog          Wed Oct 18 13:27:41 2006 UTC

  Modified files:              
    /pearweb/public_html        package-stats.php 
  Log:
  might as well limit stats to approved PEAR packages...
  
http://cvs.php.net/viewvc.cgi/pearweb/public_html/package-stats.php?r1=1.73&r2=1.74&diff_format=u
Index: pearweb/public_html/package-stats.php
diff -u pearweb/public_html/package-stats.php:1.73 
pearweb/public_html/package-stats.php:1.74
--- pearweb/public_html/package-stats.php:1.73  Wed Oct 18 04:09:58 2006
+++ pearweb/public_html/package-stats.php       Wed Oct 18 13:27:41 2006
@@ -16,7 +16,7 @@
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    |          Richard Heyes <richard@xxxxxxx>                             |
    +----------------------------------------------------------------------+
-   $Id: package-stats.php,v 1.73 2006/10/18 04:09:58 cellog Exp $
+   $Id: package-stats.php,v 1.74 2006/10/18 13:27:41 cellog Exp $
  */
 
 require_once 'HTML/Form.php';
@@ -330,7 +330,7 @@
  */
 } else {
 
-       $total_packages    = number_format($dbh->getOne('SELECT COUNT(DISTINCT 
id) FROM packages'), 0, '.', ',');
+       $total_packages    = number_format($dbh->getOne('SELECT COUNT(DISTINCT 
id) FROM packages WHERE package_type="pear" and approved=1'), 0, '.', ',');
        $total_maintainers = number_format($dbh->getOne('SELECT COUNT(DISTINCT 
handle) FROM maintains'), 0, '.', ',');
        $total_releases    = number_format($dbh->getOne('SELECT COUNT(*) FROM 
releases'), 0, '.', ',');
        $total_categories  = number_format($dbh->getOne('SELECT COUNT(*) FROM 
categories'), 0, '.', ',');