[Gforge-commits] gforge/common/tracker ArtifactsForUser.class, 1.5, 1.6

[tom]

Update of /cvsroot/gforge/gforge/common/tracker
In directory db.perdue.net:/tmp/cvs-serv29098

Modified Files:
        ArtifactsForUser.class 
Log Message:
Reverting changes - thx to Tim for the heads up

Index: ArtifactsForUser.class
===================================================================
RCS file: /cvsroot/gforge/gforge/common/tracker/ArtifactsForUser.class,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- ArtifactsForUser.class      7 May 2004 20:15:54 -0000       1.5
+++ ArtifactsForUser.class      7 May 2004 20:34:09 -0000       1.6
@@ -79,7 +79,7 @@
        */
        function getAssignedArtifactsByGroup() {
                $sql="SELECT * FROM artifact_vw av WHERE 
av.assigned_to=".$this->User->getID()."
-                       AND av.status_id='1', ORDER BY av.artifact_group_id, 
av.group_artifact_id, av.assigned_to, av.status_id";
+                       AND av.status_id='1' ORDER BY av.artifact_group_id, 
av.group_artifact_id, av.assigned_to, av.status_id";
                return $this->getArtifactsFromSQL($sql);
        }
 
@@ -90,11 +90,9 @@
        */
        function getSubmittedArtifactsByGroup() {
                $sql="SELECT *
-                       FROM artifact_vw av, groups g
+                       FROM artifact_vw av
                        WHERE av.submitted_by=".$this->User->getID()."
                        AND av.status_id='1'
-                       AND av.artifact_group_id = g.group_id
-                       AND g.status = 'A'
                        ORDER BY 
av.artifact_group_id,av.group_artifact_id,av.assigned_to,av.status_id";
                return $this->getArtifactsFromSQL($sql);
        }