cvs: pearweb /public_html package-stats.php

cellog          Fri Oct 20 23:50:16 2006 UTC

  Modified files:              
    /pearweb/public_html        package-stats.php 
  Log:
  partially fix Bug #9113 [NEW]: Package stats problems
  
  ordering was by the last ps.dl_number instead of the
  aggregate sum dl_number
  
http://cvs.php.net/viewvc.cgi/pearweb/public_html/package-stats.php?r1=1.78&r2=1.79&diff_format=u
Index: pearweb/public_html/package-stats.php
diff -u pearweb/public_html/package-stats.php:1.78 
pearweb/public_html/package-stats.php:1.79
--- pearweb/public_html/package-stats.php:1.78  Thu Oct 19 15:02:03 2006
+++ pearweb/public_html/package-stats.php       Fri Oct 20 23:50:16 2006
@@ -16,7 +16,7 @@
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    |          Richard Heyes <richard@xxxxxxx>                             |
    +----------------------------------------------------------------------+
-   $Id: package-stats.php,v 1.78 2006/10/19 15:02:03 cellog Exp $
+   $Id: package-stats.php,v 1.79 2006/10/20 23:50:16 cellog Exp $
  */
 
 require_once 'HTML/Form.php';
@@ -321,7 +321,7 @@
        $query = sprintf("SELECT SUM(ps.dl_number) AS 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",
+                         p.category = %s GROUP BY ps.pid ORDER BY dl_number 
DESC",
                      $_GET['cid']
                      );
 

-- 
PEAR CVS Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php