Changeset 548 for trunk/expressoAdmin1_2/inc/class.db_functions.inc.php

Timestamp:

11/06/08 17:27:54 (15 years ago)

Author:

eduardoalex

Message:

Desenvolvimento da tarefa #371

File:

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

trunk/expressoAdmin1_2/inc/class.db_functions.inc.php

@@ -37 +37 @@
                         $result[] = $this->db->row();
                 return $result;
+        }
+/*
+        *       Reativa os usuários desabilitados por tempo inativo modificando o seu ultimo acesso para o dia atual.
+        */
+        function reativar_usuario_inativo($uidNumber) {
+                
+        /*      $sql = "insert into phpgw_access_log (sessionid,loginid,ip,li,lo,account_id) values ('expirescontrol','teste','10.10.10.10','0','0','1') ";
+                        $this->db->query($sql);*/
+                
+                $sql = "select * from phpgw_access_log where account_id=$uidNumber order by li desc limit 1";
+        
+                $this->db->query($sql);
+                $this->db->next_record();
+                $linha = $this->db->row();
+
+                
+                if(count($linha)>0) {
+                        $sql = "insert into phpgw_access_log (sessionid,loginid,ip,li,lo,account_id) values ('expirescontrol','".$linha["loginid"]."','0.0.0.0','".time()."','0','".$linha["account_id"]."')";
+                        
+                        $this->db->query($sql);
+                }
+        }
+
+        
+        function inserir_usuario_log_controle_inativo($uid,$uidNumber) {
+                        $sql = "insert into phpgw_access_log (sessionid,loginid,ip,li,lo,account_id) values ('expirescontrol','".$uid."','0.0.0.0','".time()."','0','".$uidNumber."')";
+                        
+                        $this->db->query($sql);
         }