Changeset 17758 for extensions/EStat/lib/statDBGlobal.class.inc.php

Timestamp:

Sep 5, 2012, 4:15:54 PM (12 years ago)

Author:

grum

Message:

version 0.1.0b

. Fix install bugs
. Manage anonymous directories
. Manage CSV export options settings
. Fix IPadress<=>country association bug & improve join performances
. Fix bug on IP filter
. Improve performances for history consult

File:

• extensions/EStat/lib/statDBGlobal.class.inc.php (modified) (4 diffs)

extensions/EStat/lib/statDBGlobal.class.inc.php

@@ -223 +223 @@
             SELECT uaType, IPadress, catId, $year, $month, SUM(visits), country
             FROM period.statIP
-            GROUP BY uaType, IPadress, catId;
+            GROUP BY uaType, IPadress, catId, country;
 
         REPLACE INTO main.statUA (uaData, uaValue, uaVersion, year, month, visits)
@@ -486 +486 @@
     if(!isset($filter['country'])) $filter['country']=null;
 
+    $filter['IPadress']=$this->checkIPFilter($filter['IPadress']);
     // check filter values - getOperator check and 'clean' the filter
     $filter['IPadress']=$this->getOperator($filter['IPadress'], 'IP');
@@ -543 +544 @@
       case ASDF_GET_ROWS:
           $sql=$select." FROM statip ".$where.$groupBy.$orderBy.$limit;
-
           $sqlStm=$this->dbHandle->prepare($sql);
           foreach($IPList as $num=>$IP)
@@ -1245 +1245 @@
             );
           $this->dbHandle->exec("CREATE UNIQUE INDEX iIP ON statIP ('uaType', 'IPadress', 'catId', 'year', 'month');");
-          $this->dbHandle->exec("CREATE UNIQUE INDEX iIPPeriod ON statIP ('year', 'month', 'IPadress', 'uaType');");
+          $this->dbHandle->exec("CREATE INDEX iIPPeriod ON statIP ('year', 'month', 'IPadress', 'uaType');");
         }