cvs: pearweb / package.php package.xml /include pear-database.php /public_html index.php /public_html/feeds feeds.php index.php

cellog          Sat Oct 21 00:20:13 2006 UTC

  Modified files:              
    /pearweb    package.php package.xml 
    /pearweb/include    pear-database.php 
    /pearweb/public_html        index.php 
    /pearweb/public_html/feeds  feeds.php index.php 
  Log:
   * implement Request #9112 Changes for Popular Packages
  
http://cvs.php.net/viewvc.cgi/pearweb/package.php?r1=1.12&r2=1.13&diff_format=u
Index: pearweb/package.php
diff -u pearweb/package.php:1.12 pearweb/package.php:1.13
--- pearweb/package.php:1.12    Fri Oct 20 23:59:33 2006
+++ pearweb/package.php Sat Oct 21 00:20:12 2006
@@ -14,6 +14,7 @@
  * fix Bug #9113: Package stats problems
    - order releases in category page
    - remove stats for removed releases
+ * implement Request #9112 Changes for "Popular Packages"
 ');
 $a->resetUsesrole();
 $a->addUsesRole('web', 'Role_Web', 'pearified.com');
http://cvs.php.net/viewvc.cgi/pearweb/package.xml?r1=1.39&r2=1.40&diff_format=u
Index: pearweb/package.xml
diff -u pearweb/package.xml:1.39 pearweb/package.xml:1.40
--- pearweb/package.xml:1.39    Fri Oct 20 23:59:33 2006
+++ pearweb/package.xml Sat Oct 21 00:20:12 2006
@@ -53,7 +53,7 @@
   <active>no</active>
  </developer>
  <date>2006-10-20</date>
- <time>18:49:03</time>
+ <time>19:16:56</time>
  <version>
   <release>0.7.0</release>
   <api>0.1.1</api>
@@ -67,6 +67,7 @@
  * fix Bug #9113: Package stats problems
    - order releases in category page
    - remove stats for removed releases
+ * implement Request #9112 Changes for &quot;Popular Packages&quot;
  </notes>
  <contents>
   <dir baseinstalldir="/" name="/">
@@ -843,6 +844,7 @@
  * fix Bug #9113: Package stats problems
    - order releases in category page
    - remove stats for removed releases
+ * implement Request #9112 Changes for &quot;Popular Packages&quot;
    </notes>
   </release>
  </changelog>
http://cvs.php.net/viewvc.cgi/pearweb/include/pear-database.php?r1=1.323&r2=1.324&diff_format=u
Index: pearweb/include/pear-database.php
diff -u pearweb/include/pear-database.php:1.323 
pearweb/include/pear-database.php:1.324
--- pearweb/include/pear-database.php:1.323     Sat Oct 21 00:02:28 2006
+++ pearweb/include/pear-database.php   Sat Oct 21 00:20:13 2006
@@ -18,7 +18,7 @@
    |          Martin Jansen <mj@xxxxxxx>                                  |
    |          Gregory Beaver <cellog@xxxxxxx>                             |
    +----------------------------------------------------------------------+
-   $Id: pear-database.php,v 1.323 2006/10/21 00:02:28 cellog Exp $
+   $Id: pear-database.php,v 1.324 2006/10/21 00:20:13 cellog Exp $
 */
 
 require_once 'DB/storage.php';
@@ -1567,10 +1567,26 @@
 
     // }}}
     // {{{  proto array  release::getPopular(int) API 1.0
-    function getPopular($n = 5)
+    function getPopular($n = 5, $rss = false)
     {
         global $dbh;
-        $sth = $dbh->limitQuery('
+        if ($rss) {
+            $query = '
+            SELECT
+                packages.name, releases.version, MAX(releases.releasedate) AS 
releasedate,
+                    SUM(downloads)/((unix_timestamp(NOW()) - 
unix_timestamp(MAX(releases.releasedate)))/86400) as releasenotes
+                FROM releases, packages, aggregated_package_stats a
+                WHERE
+                    packages.id = releases.package AND
+                    packages.package_type = \'pear\' AND
+                    a.release_id = releases.id AND
+                    a.package_id = packages.id AND
+                    packages.newpk_id IS NULL AND
+                    packages.unmaintained = 0
+                GROUP BY releases.package, a.release_id
+                ORDER BY releasenotes DESC';
+        } else {
+            $query = '
             SELECT
                 packages.name, releases.version,
                     SUM(downloads)/((unix_timestamp(NOW()) - 
unix_timestamp(MAX(releases.releasedate)))/86400) as d
@@ -1583,7 +1599,9 @@
                     packages.newpk_id IS NULL AND
                     packages.unmaintained = 0
                 GROUP BY releases.package, a.release_id
-                ORDER BY d DESC', 0, $n);
+                ORDER BY d DESC';
+        }
+        $sth = $dbh->limitQuery($query, 0, $n);
         $recent = array();
         // XXX Fixme when DB gets limited getAll()
         while ($sth->fetchInto($row, DB_FETCHMODE_ASSOC)) {
http://cvs.php.net/viewvc.cgi/pearweb/public_html/index.php?r1=1.120&r2=1.121&diff_format=u
Index: pearweb/public_html/index.php
diff -u pearweb/public_html/index.php:1.120 pearweb/public_html/index.php:1.121
--- pearweb/public_html/index.php:1.120 Thu Oct 19 02:24:06 2006
+++ pearweb/public_html/index.php       Sat Oct 21 00:20:13 2006
@@ -15,7 +15,7 @@
    +----------------------------------------------------------------------+
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    +----------------------------------------------------------------------+
-   $Id: index.php,v 1.120 2006/10/19 02:24:06 cellog Exp $
+   $Id: index.php,v 1.121 2006/10/21 00:20:13 cellog Exp $
 */
 
 $recent = release::getRecent(5);
@@ -47,7 +47,7 @@
         $RSIDEBAR_DATA .= "<tr><td valign=\"top\" class=\"compact\">";
         $RSIDEBAR_DATA .= "<a href=\"/package/" . $package['name'] . "/\">";
         $RSIDEBAR_DATA .= wordwrap($package['name'],25,"\n",1) . ' ' . 
$package['version'] . '</a><br /> <small>(' .
-                          $package['d'] . ')</small></td></tr>';
+                          number_format($package['d'],2) . 
')</small></td></tr>';
     }
     $feed_link = '<a href="/feeds/" title="Information about XML feeds for the 
PEAR website"><img src="/gifs/feed.png" width="16" height="16" alt="" 
border="0" /></a>';
     $RSIDEBAR_DATA .= "<tr><td><small>* downloads per day</small></td></tr>\n";
http://cvs.php.net/viewvc.cgi/pearweb/public_html/feeds/feeds.php?r1=1.9&r2=1.10&diff_format=u
Index: pearweb/public_html/feeds/feeds.php
diff -u pearweb/public_html/feeds/feeds.php:1.9 
pearweb/public_html/feeds/feeds.php:1.10
--- pearweb/public_html/feeds/feeds.php:1.9     Fri Aug 18 14:07:12 2006
+++ pearweb/public_html/feeds/feeds.php Sat Oct 21 00:20:13 2006
@@ -15,7 +15,7 @@
    +----------------------------------------------------------------------+
    | Authors: Pierre-Alain Joye <pajoye@xxxxxxx>                          |
    +----------------------------------------------------------------------+
-   $Id: feeds.php,v 1.9 2006/08/18 14:07:12 mj Exp $
+   $Id: feeds.php,v 1.10 2006/10/21 00:20:13 cellog Exp $
 */
 
 require_once "pepr/pepr.php";
@@ -122,6 +122,16 @@
         $channel_description = 'The latest releases in PEAR.';
         break;
 
+    case 'popular':
+        include_once 'pear-database.php';
+        $items = release::getPopular(10, true);
+        foreach ($items as $i => $item) {
+            $items[$i]['releasenotes'] = 'Downloads per day: ' . 
number_format($item['releasenotes'], 2);
+        }
+        $channel_title = 'PEAR: Popular releases';
+        $channel_description = 'The most popular releases in PEAR.';
+        break;
+
     case 'user':
         $user = $argument;
         if (!user::exists($user)) {
http://cvs.php.net/viewvc.cgi/pearweb/public_html/feeds/index.php?r1=1.12&r2=1.13&diff_format=u
Index: pearweb/public_html/feeds/index.php
diff -u pearweb/public_html/feeds/index.php:1.12 
pearweb/public_html/feeds/index.php:1.13
--- pearweb/public_html/feeds/index.php:1.12    Wed Feb 23 06:30:32 2005
+++ pearweb/public_html/feeds/index.php Sat Oct 21 00:20:13 2006
@@ -15,7 +15,7 @@
    +----------------------------------------------------------------------+
    | Authors: Martin Jansen <mj@xxxxxxx>                                  |
    +----------------------------------------------------------------------+
-   $Id: index.php,v 1.12 2005/02/23 06:30:32 cellog Exp $
+   $Id: index.php,v 1.13 2006/10/21 00:20:13 cellog Exp $
 */
 response_header('Syndication Feeds');
 ?>
@@ -29,6 +29,7 @@
 
 <ul>
   <li><?php echo make_link('/feeds/latest.rss'); ?>: The latest 10 
releases</li>
+  <li><?php echo make_link('/feeds/popular.rss'); ?>: The most popular 10 
releases</li>
   <li>Package feeds per category:
     <ul>
       <li><?php echo make_link('/feeds/cat_authentication.rss'); ?>: 
Authentication</li>

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