[Phpgroupware-cvs] CVS: felamimail/inc class.socaching.inc.php,1.1.1.1.2.1,1.1.1.1.2.2

[Lars Kneschke <address@hidden>]

Update of /cvsroot/phpgroupware/felamimail/inc
In directory subversions:/tmp/cvs-serv2710

Modified Files:
      Tag: Version-0_9_14-branch
        class.socaching.inc.php 
Log Message:
try to delete entries, before insert

so there can't be a old entry in the database already


Index: class.socaching.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/felamimail/inc/class.socaching.inc.php,v
retrieving revision 1.1.1.1.2.1
retrieving revision 1.1.1.1.2.2
diff -C2 -r1.1.1.1.2.1 -r1.1.1.1.2.2
*** class.socaching.inc.php     25 Feb 2002 23:58:37 -0000      1.1.1.1.2.1
--- class.socaching.inc.php     31 Mar 2002 10:18:41 -0000      1.1.1.1.2.2
***************
*** 153,175 ****
                function updateImapStatus($_status, $firstUpdate)
                {
!                       if ($firstUpdate == true)
!                       {
!                               $query = sprintf("insert into 
phpgw_felamimail_folderstatus ".
!                                        
"(accountid,hostname,foldername,accountname,messages,recent,unseen,uidnext,uidvalidity)
 ".
!                                        
"values('%s','%s','%s','%s','%s','%s','%s','%s','%s')",
!                                        $this->accountid, 
addslashes($this->hostname),
!                                        addslashes($this->foldername), 
addslashes($this->accountname),
!                                        $_status->messages, $_status->recent, 
$_status->unseen, $_status->uidnext,
!                                        $_status->uidvalidity);
!                       }
!                       else
!                       {
!                               $query = sprintf("update 
phpgw_felamimail_folderstatus ".
!                                        "set messages='%s', recent='%s', 
unseen='%s', uidnext='%s', uidvalidity='%s' ".
!                                        "where accountid='%s' and 
hostname='%s' and foldername = '%s' and accountname='%s'",
!                                        $_status->messages, $_status->recent, 
$_status->unseen, $_status->uidnext,
!                                        $_status->uidvalidity, 
$this->accountid, addslashes($this->hostname),
!                                        addslashes($this->foldername), 
addslashes($this->accountname));
!                       }
                        $this->db->query($query);
                }
--- 153,169 ----
                function updateImapStatus($_status, $firstUpdate)
                {
!                       $query = sprintf("delete from 
phpgw_felamimail_folderstatus where ".
!                                "accountid='%s' and hostname='%s' and 
foldername='%s' and accountname='%s'",
!                                $this->accountid, addslashes($this->hostname),
!                                addslashes($this->foldername), 
addslashes($this->accountname));
!                       $this->db->query($query);
! 
!                       $query = sprintf("insert into 
phpgw_felamimail_folderstatus ".
!                                
"(accountid,hostname,foldername,accountname,messages,recent,unseen,uidnext,uidvalidity)
 ".
!                                
"values('%s','%s','%s','%s','%s','%s','%s','%s','%s')",
!                                $this->accountid, addslashes($this->hostname),
!                                addslashes($this->foldername), 
addslashes($this->accountname),
!                                $_status->messages, $_status->recent, 
$_status->unseen, $_status->uidnext,
!                                $_status->uidvalidity);
                        $this->db->query($query);
                }