Re: pear weekly news

Ok, have just made the files and changes required to add a (extremely) simple publishing system on pear.php.net Changes pearweb/news/2002mmdd.html - the html for the weekly articles pearweb/public_html/news.php - a simple script that looks back 6 weeks, checks existance of a file in pearweb/news/*, either displays the index or the article + a summary of the releases that week... ** this currently depends on the Date.php class being available????? other changes : /include/pear-database.php - patch below -- adds a getDateRange to the releases class. can you give me karma for the pearweb (if i dont have it already) ++ or object now or forever regret it :) This should get things up and going - we can look later at Caching etc. regards alan RCS file: /repository/pearweb/include/pear-database.php,v retrieving revision 1.99 diff -u -r1.99 pear-database.php

--- pear-database.php   5 Jul 2002 01:36:00 -0000       1.99

+++ pear-database.php 5 Jul 2002 10:05:56 -0000 @@ -23,7 +23,7 @@ require_once 'DB/storage.php'; require_once 'PEAR/Common.php'; require_once 'HTTP.php'; - +require_once dirname(__FILE__). '/xmlrpc-cache.php'; // {{{ validate() function validate($entity, $field, $value /* , $oldvalue, $object */) { @@ -675,6 +675,44 @@

                                "FROM packages, releases ".
                                "WHERE packages.id = releases.package ".
                                "ORDER BY releases.releasedate DESC", 0, $n);
+        $recent = array();
+        // XXX Fixme when DB gets limited getAll()
+        while ($sth->fetchInto($row, DB_FETCHMODE_ASSOC)) {
+            $recent[] = $row;
+        }
+        return $recent;
+    }

+

+    // }}}
+    // {{{  proto array  release::getRecent([int])

+

+    function getDateRange($start,$end)
+    {
+        global $dbh;
+       +        $recent = array();
+        if (!is_numeric($start)) {
+            return $recent;
+        }
+        if (!is_numeric($end)) {
+            return $recent;
+        }
+        $start_f = date('Y-m-d 00:00:00',$start);
+        $end_f = date('Y-m-d 00:00:00',$end);
+       +        $sth = $dbh->limitQuery("SELECT packages.id AS id, ".
+                                "packages.name AS name, ".
+                                "packages.summary AS summary, ".
+                                "packages.description AS description, ".
+                                "releases.version AS version, ".
+                                "releases.releasedate AS releasedate, ".
+                                "releases.releasenotes AS releasenotes, ".
+                                "releases.doneby AS doneby, ".
+                                "releases.state AS state ".
+                                "FROM packages, releases ".
+                                "WHERE packages.id = releases.package ".
+                                "AND releases.releasedate > '{$start_f}' AND releases.releasedate < '{$end_f}'".
+                                "ORDER BY releases.releasedate DESC",0,50);
        $recent = array();
        // XXX Fixme when DB gets limited getAll()
        while ($sth->fetchInto($row, DB_FETCHMODE_ASSOC)) {

Martin Jansen wrote:

On Fri Jul 05, 2002 at 01:4642PM +0800, Alan Knowles wrote:

I put together a draft for a weekly news letter here http://www.akbkhome.com/pear_weekly_news/5%20Jun%202000/ I could just keep putting it up on my site, but if anyone has any ideas - let me know..

You can put this up on pear.php.net so that more people will see this, but please be consistent with the other scripts that are running there. If you have more questions, just drop a note here or on pear-webmaster@php.net. - Martin