cvs: pearweb /public_html package-stats.php

cellog          Wed Oct 18 04:09:59 2006 UTC

  Modified files:              
    /pearweb/public_html        package-stats.php 
  Log:
  remove last reference to downloads table
  
http://cvs.php.net/viewvc.cgi/pearweb/public_html/package-stats.php?r1=1.72&r2=1.73&diff_format=u
Index: pearweb/public_html/package-stats.php
diff -u pearweb/public_html/package-stats.php:1.72 
pearweb/public_html/package-stats.php:1.73
--- pearweb/public_html/package-stats.php:1.72  Wed Oct 18 01:33:21 2006
+++ pearweb/public_html/package-stats.php       Wed Oct 18 04:09:58 2006
@@ -16,7 +16,7 @@
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    |          Richard Heyes <richard@xxxxxxx>                             |
    +----------------------------------------------------------------------+
-   $Id: package-stats.php,v 1.72 2006/10/18 01:33:21 cellog Exp $
+   $Id: package-stats.php,v 1.73 2006/10/18 04:09:58 cellog Exp $
  */
 
 require_once 'HTML/Form.php';
@@ -334,7 +334,7 @@
        $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, '.', ',');
-    $total_downloads   = number_format($dbh->getOne('SELECT COUNT(*) FROM 
downloads'), 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 
                              FROM package_stats ps, packages p
                              WHERE p.id = ps.pid AND p.package_type = 'pear'