[Phpgroupware-cvs] CVS: sitemgr/inc class.Categories_db_SO.inc.php,1.5,1.6 class.Pages_SO.inc.php,1.5,1.6

[Patrick Walsh <address@hidden>]

Update of /cvsroot/phpgroupware/sitemgr/inc
In directory subversions:/tmp/cvs-serv13216

Modified Files:
        class.Categories_db_SO.inc.php class.Pages_SO.inc.php 
Log Message:
Minor updates for PostgreSQL support.


Index: class.Categories_db_SO.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/inc/class.Categories_db_SO.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** class.Categories_db_SO.inc.php      7 Sep 2002 06:18:58 -0000       1.5
--- class.Categories_db_SO.inc.php      11 Sep 2002 19:22:32 -0000      1.6
***************
*** 81,85 ****
  
                        // Make sure the categories table exists
!                       $this->db->query('SELECT cat_id FROM 
phpgw_sitemgr_categories WHERE 1',__LINE__,__FILE__);
                        if ($this->db->num_rows==0)
                        {
--- 81,85 ----
  
                        // Make sure the categories table exists
!                       $this->db->query('SELECT cat_id FROM 
phpgw_sitemgr_categories WHERE 1=1',__LINE__,__FILE__);
                        if ($this->db->num_rows==0)
                        {
***************
*** 111,115 ****
  
                        // Make a list of page_id's and corresponding new_id's
!                       $sql = 'SELECT page_id, cat_id FROM phpgw_sitemgr_pages 
WHERE 1';
                        $this->db->query($sql,__LINE__,__FILE__);
                        if ($this->db->num_rows())
--- 111,115 ----
  
                        // Make a list of page_id's and corresponding new_id's
!                       $sql = 'SELECT page_id, cat_id FROM phpgw_sitemgr_pages 
WHERE 1=1';
                        $this->db->query($sql,__LINE__,__FILE__);
                        if ($this->db->num_rows())

Index: class.Pages_SO.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/sitemgr/inc/class.Pages_SO.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** class.Pages_SO.inc.php      5 Sep 2002 09:06:03 -0000       1.5
--- class.Pages_SO.inc.php      11 Sep 2002 19:22:32 -0000      1.6
***************
*** 13,17 ****
                        if (!$cat_id)
                        {
!                               $sql = 'SELECT page_id FROM phpgw_sitemgr_pages 
WHERE 1 ORDER BY cat_id, sort_order ASC';
                        }
                        else
--- 13,17 ----
                        if (!$cat_id)
                        {
!                               $sql = 'SELECT page_id FROM phpgw_sitemgr_pages 
WHERE 1=1 ORDER BY cat_id, sort_order ASC';
                        }
                        else