bug in pearweb/public_html/package-stats-graph.php

From:	Alexey Borzov	Date:	Sat, 14 Jun 2003 17:23:21 +0000
Subject:	bug in pearweb/public_html/package-stats-graph.php
Groups:	php.pear.dev
Request:	Send a blank email to pear-dev+get-17462@lists.php.net to get a copy of this message

Hi! The query to get download stats is built the following way:

    $sql = sprintf("SELECT UNIX_TIMESTAMP(d.dl_when) AS date, COUNT(*) AS downloads
                          FROM packages p, downloads d
                         WHERE d.package = p.id
                           AND p.id = %s
                           %s
                     GROUP BY MONTH(d.dl_when)
                      ORDER BY YEAR(d.dl_when) DESC, MONTH(d.dl_when) DESC",

                   $_GET['pid'],
                   $release_clause = $rid > 0 ? 'AND d.release = ' . $rid : '');

Thus months of different years are grouped together. The marked line should be GROUP BY YEAR(d.dl_when), MONTH(d.dl_when)