Changeset 7616 for extensions/GMaps/gmaps_root.class.inc.php

Timestamp:

Nov 4, 2010, 1:42:14 AM (13 years ago)

Author:

grum

Message:

fix bug:2004 - Cache table becomes very huge
fix bug:2005 - Category map is not displayed when a [gmaps] map is inserted in category description

File:

• extensions/GMaps/gmaps_root.class.inc.php (modified) (2 diffs)

extensions/GMaps/gmaps_root.class.inc.php

@@ -85 +85 @@
       $this->section_name=$this->getPluginNameFiles();
 
-      $this->setTablesList(array('maps', 'category_maps', 'cache', 'kmlfiles'));
+      $this->setTablesList(array('maps', 'category_maps', 'cache', 'cache_id', 'kmlfiles'));
       $this->css = new GPCCss(dirname($this->getFileLocation()).'/'.$this->getPluginNameFiles().".css");
     }
@@ -312 +312 @@
     }
 
+
+    /**
+     * returns a new requestId for the cache
+     */
+    protected function getCacheRequestId()
+    {
+      global $user;
+
+      $returned=0;
+
+      // new requestId
+      $sql="INSERT INTO ".$this->tables['cache_id']."
+            VALUES ('', '".$user['id']."', '".date('Y-m-d h:i:s')."');";
+      $result=pwg_query($sql);
+      if($result)
+      {
+        $returned=pwg_db_insert_id();
+      }
+
+      return($returned);
+    }
+
+    /**
+     * update date for a cache requestId
+     */
+    protected function updateCacheRequestId($requestId)
+    {
+      global $user;
+
+      // new requestId
+      $sql="UPDATE ".$this->tables['cache_id']."
+            SET `date` = '".date('Y-m-d h:i:s')."'
+            WHERE requestId='$requestId';";
+      pwg_query($sql);
+    }
+
+    /**
+     * clean the cache : cache values older than given number of second are
+     * deleted
+     *
+     * @param Integer $time : number of second
+     */
+    protected function cleanCache($time=300)
+    {
+      $date=date('Y-m-d h:i:s', time()-$time);
+
+      $sql="DELETE FROM ".$this->tables['cache']." pgc
+              USING ".$this->tables['cache']." pgc
+                JOIN ".$this->tables['cache_id']." pgci
+                ON pgc.requestId = pgci.requestId
+            WHERE pgci.`date` < '$date';";
+      pwg_query($sql);
+
+      $sql="DELETE FROM ".$this->tables['cache_id']."
+            WHERE `date` < '$date';";
+      pwg_query($sql);
+    }
+
   } //class