Changeset 7126 for trunk/header.session.inc.php

Timestamp:

08/29/12 14:12:16 (12 years ago)

Author:

angelo

Message:

Ticket #3075 - Corrigir tamanho de tabela de logs do Expresso

File:

• trunk/header.session.inc.php (modified) (1 diff)

trunk/header.session.inc.php

@@ -26 +26 @@
 if (isset($GLOBALS['phpgw']) && !isset($_SESSION['connection_db_info'])){ 
         $_SESSION['phpgw_info']['admin']['server']['sessions_checkip'] = $GLOBALS['phpgw_info']['server']['sessions_checkip'];
-        if($GLOBALS['phpgw_info']['server']['use_https'] == 1) { 
-                $new_ip = (isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR']."," : ""). $_SERVER['REMOTE_ADDR']; 
-                $GLOBALS['phpgw']->db->query("UPDATE phpgw_access_log SET ip='$new_ip' WHERE account_id <> 0 and lo = 0 and sessionid='{$GLOBALS['sessionid']}'",__LINE__,__FILE__); 
+        if($GLOBALS['phpgw_info']['server']['use_https'] == 1){ 
+                $new_ip = (isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR']."," : ""). $_SERVER['REMOTE_ADDR'];               
+                if(strlen($new_ip)>30){
+                        $ip_exploded = explode(",",$new_ip);
+                        $new_ip = "";
+                        for($i=0;$i<2;$i++)
+                                $new_ip .= isset($ip_exploded[$i])?(($i==1?",":"").trim($ip_exploded[$i])):("");
+                        if(strlen($new_ip)>30)
+                                $new_ip = $ip_exploded[0];
+                }               
+                $GLOBALS['phpgw']->db->query("UPDATE phpgw_access_log SET ip='$new_ip' WHERE account_id <> 0 and lo = 0 and sessionid='{$GLOBALS['sessionid']}'",__LINE__,__FILE__);
         } 
          $GLOBALS['phpgw']->db->query("select trim(sessionid),".($_SESSION['phpgw_info']['admin']['server']['sessions_checkip'] ? "ip," : "")."browser from phpgw_access_log where account_id <> 0 and lo = 0 and sessionid='{$GLOBALS['sessionid']}' limit 1",__LINE__,__FILE__);