[Gforge-commits] gforge/www/export rss_sfnewreleases.php,1.5,1.6

[tom]

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

Modified Files:
        rss_sfnewreleases.php 
Log Message:
Fixed a few minor field name typos... group.type_id, news_bytes.post_date, 
is_public = 1

Index: rss_sfnewreleases.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/export/rss_sfnewreleases.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- rss_sfnewreleases.php       5 May 2004 18:43:36 -0000       1.5
+++ rss_sfnewreleases.php       7 May 2004 15:47:42 -0000       1.6
@@ -32,10 +32,10 @@
                                        groups.group_id,
                                        groups.group_name,
                                        groups.unix_group_name,
-                                       groups.type,
+                                       groups.type_id,
                                        news_bytes.forum_id,
                                        news_bytes.summary,
-                                       news_bytes.date,
+                                       news_bytes.post_date,
                                        news_bytes.details 
                                FROM 
                                        news_bytes,
@@ -43,9 +43,9 @@
                                WHERE 
                                        news_bytes.group_id=groups.group_id 
                                        AND groups.status='A'
-                                       AND groups.is_public='A'
+                                       AND groups.is_public = 1
                                ORDER BY 
-                                       date 
+                                       post_date 
                                DESC",($limit * 3));