cvs: pearweb /public_html package-stats.php
| From: | Pierre-Alain Joye | Date: | Tue, 13 Aug 2002 15:31:19 +0000 |
| Subject: | cvs: pearweb /public_html package-stats.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-5717@lists.php.net to get a copy of this message | ||
pajoye Tue Aug 13 11:31:19 2002 EDT
Modified files:
/pearweb/public_html package-stats.php
Log:
Group total of downloads by package in the main stat page
Provide the latest release number
Index: pearweb/public_html/package-stats.php
diff -u pearweb/public_html/package-stats.php:1.34 pearweb/public_html/package-stats.php:1.35
--- pearweb/public_html/package-stats.php:1.34 Mon Aug 5 11:06:32 2002
+++ pearweb/public_html/package-stats.php Tue Aug 13 11:31:19 2002
@@ -16,7 +16,7 @@
| Authors: Martin Jansen <mj@php.net> |
| Richard Heyes <richard@php.net> |
+----------------------------------------------------------------------+
- $Id: package-stats.php,v 1.34 2002/08/05 15:06:32 pajoye Exp $
+ $Id: package-stats.php,v 1.35 2002/08/13 15:31:19 pajoye Exp $
*/
require_once "HTML/Form.php";
@@ -300,7 +300,7 @@
$total_releases = number_format($dbh->getOne("SELECT COUNT(*) FROM
package_stats"), 0, '.', ',');
$total_categories = number_format($dbh->getOne("SELECT COUNT(*) FROM categories"),
0, '.', ',');
$total_downloads = number_format($dbh->getOne("SELECT COUNT(*) FROM downloads"),
0, '.', ',');
- $query = "SELECT dl_number, package, release, pid, rid, cid FROM package_stats
ORDER BY dl_number DESC";
+ $query = "SELECT sum(dl_number) as dl_number, package, max(release) as release,
pid, rid, cid FROM package_stats GROUP BY pid ORDER BY dl_number DESC";
}
@@ -350,7 +350,7 @@
echo "<table border=\"0\" width=\"100%\" cellpadding=\"2\"
cellspacing=\"2\">\n";
echo "<tr align=\"left\" bgcolor=\"#cccccc\">\n";
echo "<th>Package name</th>\n";
- echo "<th>Releases</th>\n";
+ echo "<th>Last release</th>\n";
echo "<th><u># of downloads</u></th>\n";
echo "<th> </th>\n";
echo "</tr>\n";
@@ -371,7 +371,7 @@
echo "<td>\n" . $row['package'] . "</td>\n";
echo "<td>" . $row['release'] . "</td>\n";
echo "<td>" . number_format($row['dl_number'], 0, '.',
',') . "</td>\n";
- echo "<td>[". make_link("/package-stats.php?cid=" .
$row['cid'] . "&pid=" . $row['pid'] . "&rid=" .
$row['rid'], "Details") . "]</td>\n";
+ echo "<td>[". make_link("/package-stats.php?cid=" .
$row['cid'] . "&pid=" . $row['pid'] , "Details") .
"]</td>\n";
echo "</tr>\n";
}
echo "</table>\n";