Changeset 1035 for trunk/expressoMail1_2/inc/class.db_functions.inc.php

Timestamp:

06/20/09 01:07:18 (15 years ago)

Author:

rafaelraymundo

Message:

Ticket #558 - Adicionada funcionalidade de assinatura e criptografia de e-mails.

File:

• trunk/expressoMail1_2/inc/class.db_functions.inc.php (modified) (1 diff)

trunk/expressoMail1_2/inc/class.db_functions.inc.php

@@ -407 +407 @@
                 return $uiicalendar = $uiicalendar->import_from_mail($calendar);
         }
-        
+
+    function insert_certificate($email,$certificate,$serialnumber,$authoritykeyidentifier=null)
+        {
+                if(!$email || !$certificate || !$serialnumber || !$authoritykeyidentifier)
+                        return false;
+                // Insere uma chave publica na tabela phpgw_certificados.
+                $data = array   ('email' => $email,
+                                                 'chave_publica' => $certificate,
+                                                 'serialnumber' => $serialnumber,
+                                                 'authoritykeyidentifier' => $authoritykeyidentifier);
+
+                if(!$this->db->insert('phpgw_certificados',$data,array(),__LINE__,__FILE__)){
+                return $this->db->Error;
+        }
+        return true;
+        }
+
+        function get_certificate($email=null)
+        {
+                if(!$email) return false;
+                $result = array();
+
+                $where = array ('email' => $email,
+                                                'revogado' => 0,
+                                                'expirado' => 0);
+
+                if(!$this->db->select('phpgw_certificados','chave_publica', $where, __LINE__,__FILE__))
+        {
+            $result['dberr1'] = $this->db->Error;
+            return $result;
+        }
+                $regs = array();
+                while($this->db->next_record())
+        {
+            $regs[] = $this->db->row();
+        }
+                if (count($regs) == 0)
+        {
+            $result['dberr2'] = ' Certificado nao localizado.';
+            return $result;
+        }
+                $result['certs'] = $regs;
+                return $result;
+        }
+
+        function update_certificate($serialnumber=null,$email=null,$authoritykeyidentifier,$expirado,$revogado)
+        {
+                if(!$email || !$serialnumber) return false;
+                if(!$expirado)
+                        $expirado = 0;
+                if(!$revogado)
+                        $revogado = 0;
+
+                $data = array   ('expirado' => $expirado,
+                                                 'revogado' => $revogado);
+
+                $where = array  ('email' => $email,
+                                                 'serialnumber' => $serialnumber,
+                                                 'authoritykeyidentifier' => $authoritykeyidentifier);
+
+                if(!$this->db->update('phpgw_certificados',$data,$where,__LINE__,__FILE__))
+                {
+                        return $this->db->Error;
+                }
+                return true;
+        }
+
 }
 ?>