[Phpgroupware-cvs] CVS: projects/inc class.soprojects.inc.php,1.36,1.37

[Bettina Gille <address@hidden>]

Update of /cvsroot/phpgroupware/projects/inc
In directory subversions:/tmp/cvs-serv8311

Modified Files:
        class.soprojects.inc.php 
Log Message:
update filter

Index: class.soprojects.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/projects/inc/class.soprojects.inc.php,v
retrieving revision 1.36
retrieving revision 1.37
diff -C2 -r1.36 -r1.37
*** class.soprojects.inc.php    14 Apr 2002 03:41:53 -0000      1.36
--- class.soprojects.inc.php    2 May 2002 14:01:27 -0000       1.37
***************
*** 97,105 ****
                                if ($this->isprojectadmin('pad') || 
$this->isbookkeeper('pbo'))
                                {
!                                       $filtermethod = " access != 'private'";
                                }
                                else
                                {
!                                       $filtermethod = " ( coordinator=" . 
$this->account;
                                        if (is_array($this->grants))
                                        {
--- 97,105 ----
                                if ($this->isprojectadmin('pad') || 
$this->isbookkeeper('pbo'))
                                {
!                                       $filtermethod = " ( access != 'private' 
OR coordinator ='" . $this->account . "' )";
                                }
                                else
                                {
!                                       $filtermethod = " ( coordinator='" . 
$this->account . "'";
                                        if (is_array($this->grants))
                                        {
***************
*** 147,153 ****
                        $sql = "SELECT * from phpgw_p_projects WHERE 
$filtermethod $statussort $querymethod";
  
-                       $this->db2->query($sql,__LINE__,__FILE__);
-                       $this->total_records = $this->db2->num_rows();
- 
                        if ($limit)
                        {
--- 147,150 ----
***************
*** 158,161 ****
--- 155,160 ----
                                $this->db->query($sql . 
$ordermethod,__LINE__,__FILE__);
                        }
+ 
+                       $this->total_records = $this->db->num_rows();
  
                        $i = 0;