[Gforge-commits] gforge/www/my index.php,1.28,1.29

[tom]

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

Modified Files:
        index.php 
Log Message:
Fixed bug #788: Site admin's 'my page' shows news postings from deleted projects

Index: index.php
===================================================================
RCS file: /cvsroot/gforge/gforge/www/my/index.php,v
retrieving revision 1.28
retrieving revision 1.29
diff -u -d -r1.28 -r1.29
--- index.php   18 Apr 2004 09:46:58 -0000      1.28
+++ index.php   4 May 2004 15:04:45 -0000       1.29
@@ -286,7 +286,7 @@
        exit_assert_object($newsgroup,'Group');
        $perm =& $newsgroup->getPermission( session_get_user() );
        if ($perm && is_object($perm) && $perm->isAdmin()) {
-               $sql="SELECT * FROM news_bytes WHERE is_approved=0";
+               $sql="SELECT * FROM news_bytes nb, groups g WHERE 
nb.is_approved=0 and nb.group_id = g.group_id and g.status = 'A'";
                $result=db_query($sql);
                $rows=db_numrows($result);
                if ($rows) {