cvs: pearweb /public_html package-stats.php

cellog          Wed Oct 18 13:32:15 2006 UTC

  Modified files:              
    /pearweb/public_html        package-stats.php 
  Log:
  remove unnecessary DISTINCT from package count query
  only list PEAR releases
  
http://cvs.php.net/viewvc.cgi/pearweb/public_html/package-stats.php?r1=1.74&r2=1.75&diff_format=u
Index: pearweb/public_html/package-stats.php
diff -u pearweb/public_html/package-stats.php:1.74 
pearweb/public_html/package-stats.php:1.75
--- pearweb/public_html/package-stats.php:1.74  Wed Oct 18 13:27:41 2006
+++ pearweb/public_html/package-stats.php       Wed Oct 18 13:32:15 2006
@@ -16,7 +16,7 @@
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    |          Richard Heyes <richard@xxxxxxx>                             |
    +----------------------------------------------------------------------+
-   $Id: package-stats.php,v 1.74 2006/10/18 13:27:41 cellog Exp $
+   $Id: package-stats.php,v 1.75 2006/10/18 13:32:15 cellog Exp $
  */
 
 require_once 'HTML/Form.php';
@@ -330,9 +330,10 @@
  */
 } else {
 
-       $total_packages    = number_format($dbh->getOne('SELECT COUNT(DISTINCT 
id) FROM packages WHERE package_type="pear" and approved=1'), 0, '.', ',');
+       $total_packages    = number_format($dbh->getOne('SELECT COUNT(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_releases    = number_format($dbh->getOne('SELECT COUNT(*) FROM 
releases r, packages p
+                          WHERE r.package = p.id AND p.package_type="pear"'), 
0, '.', ',');
        $total_categories  = number_format($dbh->getOne('SELECT COUNT(*) FROM 
categories'), 0, '.', ',');
     $total_downloads   = number_format($dbh->getOne('SELECT SUM(dl_number) 
FROM package_stats'), 0, '.', ',');
        $query             = "SELECT sum(ps.dl_number) as dl_number, 
ps.package, ps.pid, ps.rid, ps.cid