[Phpgroupware-cvs] CVS: fax/inc class.manager.inc.php,1.5,1.6

[Marco Andriolo-Stagno (MAS!) <address@hidden>]

Update of /cvsroot/phpgroupware/fax/inc
In directory subversions:/tmp/cvs-serv26324/inc

Modified Files:
        class.manager.inc.php 
Log Message:
bugfix: changed 'user' field on db to 'faxuser' to avoid incompatibilty with
postgresql. (not fully tested). Please note my new mail address too:
address@hidden .



Index: class.manager.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/fax/inc/class.manager.inc.php,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -r1.5 -r1.6
*** class.manager.inc.php       9 Dec 2002 16:28:44 -0000       1.5
--- class.manager.inc.php       8 Apr 2003 09:23:48 -0000       1.6
***************
*** 454,458 ****
              if (!$_POST['cover'])
                        {
!                 $query = 'SELECT prefs FROM phpgw_fax_prefs WHERE 
user="'.$user_login.'"';
                  $this->db->query($query, __LINE__, __LINE__);
                  $this->db->next_record();
--- 454,458 ----
              if (!$_POST['cover'])
                        {
!                 $query = 'SELECT prefs FROM phpgw_fax_prefs WHERE 
faxuser="'.$user_login.'"';
                  $this->db->query($query, __LINE__, __LINE__);
                  $this->db->next_record();
***************
*** 916,920 ****
              $cp = $gs['cover_path'];
                        
!             $query = "SELECT prefs FROM phpgw_fax_prefs WHERE 
user='".$user_login."'";
                        
              $this->db->query($query, __LINE__, __FILE__);
--- 916,920 ----
              $cp = $gs['cover_path'];
                        
!             $query = "SELECT prefs FROM phpgw_fax_prefs WHERE 
faxuser='".$user_login."'";
                        
              $this->db->query($query, __LINE__, __FILE__);
***************
*** 1018,1032 ****
                           );
                        
!             $test = "SELECT user FROM phpgw_fax_prefs WHERE user='".$user."'";
              $this->db->query($test, __LINE__, __FILE__);
              if ($this->db->next_record())
                        {
                  # found
!                 $query = "UPDATE phpgw_fax_prefs SET 
prefs='".serialize($prefs). "' WHERE user='".$user."'";
                        }
              else 
                        {
                  # not found
!                 $query = "INSERT INTO phpgw_fax_prefs (user,prefs) VALUES 
('".$user."', '".serialize($prefs)."')";
                        }
                        
--- 1018,1032 ----
                           );
                        
!             $test = "SELECT faxuser FROM phpgw_fax_prefs WHERE 
faxuser='".$user."'";
              $this->db->query($test, __LINE__, __FILE__);
              if ($this->db->next_record())
                        {
                  # found
!                 $query = "UPDATE phpgw_fax_prefs SET 
prefs='".serialize($prefs). "' WHERE faxuser='".$user."'";
                        }
              else 
                        {
                  # not found
!                 $query = "INSERT INTO phpgw_fax_prefs (faxuser,prefs) VALUES 
('".$user."', '".serialize($prefs)."')";
                        }