cvs: pearweb /public_html package-stats.php

cellog          Wed Oct 18 19:24:16 2006 UTC

  Modified files:              
    /pearweb/public_html        package-stats.php 
  Log:
  fix category-based stats reporting - needed SUM(ps.dl_number)
  
http://cvs.php.net/viewvc.cgi/pearweb/public_html/package-stats.php?r1=1.76&r2=1.77&diff_format=u
Index: pearweb/public_html/package-stats.php
diff -u pearweb/public_html/package-stats.php:1.76 
pearweb/public_html/package-stats.php:1.77
--- pearweb/public_html/package-stats.php:1.76  Wed Oct 18 13:37:28 2006
+++ pearweb/public_html/package-stats.php       Wed Oct 18 19:24:15 2006
@@ -16,7 +16,7 @@
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    |          Richard Heyes <richard@xxxxxxx>                             |
    +----------------------------------------------------------------------+
-   $Id: package-stats.php,v 1.76 2006/10/18 13:37:28 cellog Exp $
+   $Id: package-stats.php,v 1.77 2006/10/18 19:24:15 cellog Exp $
  */
 
 require_once 'HTML/Form.php';
@@ -318,7 +318,7 @@
        $total_categories  = $dbh->getOne(sprintf("SELECT COUNT(*) FROM 
categories WHERE parent = %d", $_GET['cid']));
 
        // Query to get package list from package_stats_table
-       $query = sprintf("SELECT ps.dl_number, ps.package, ps.release, ps.pid, 
ps.rid, ps.cid 
+       $query = sprintf("SELECT SUM(ps.dl_number), ps.package, ps.release, 
ps.pid, ps.rid, ps.cid 
                          FROM package_stats ps, packages p 
                          WHERE p.package_type = 'pear' AND p.id = ps.pid AND
                          p.category = %s GROUP BY ps.pid ORDER BY ps.dl_number 
DESC",