[Gforge-commits] gforge/www/export rss_sfnews.php,1.4,1.5

[tom]

Update of /cvsroot/gforge/gforge/www/export
In directory db.perdue.net:/tmp/cvs-serv17883/www/export

Modified Files:
        rss_sfnews.php 
Log Message:
Added group_id parameter to rss_sfnews.php; did some more date->post_date 
fixes, too

Index: rss_sfnews.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/export/rss_sfnews.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- rss_sfnews.php      9 Jan 2003 20:57:12 -0000       1.4
+++ rss_sfnews.php      5 Mar 2004 19:57:47 -0000       1.5
@@ -24,8 +24,12 @@
 if (!$limit) $limit = 10;
 if ($limit > 100) $limit = 100;
 
-$res = db_query('SELECT forum_id,summary,date,details,group_id FROM news_bytes 
'
-       .'WHERE is_approved=1 ORDER BY date DESC',$limit);
+$where_clause = " WHERE is_approved=1 ";
+if ($group_id) {
+       $where_clause = " where group_id=".$group_id;
+}
+$sql = "SELECT forum_id,summary,post_date,details,group_id FROM news_bytes 
".$where_clause." order by post_date desc";
+$res = db_query($sql, $limit);
 
 // ## one time output
 print " <channel>\n";