SimpleMachines / SMF2.1

Sources/CacheAPI-sqlite.php

Spacing +11 added lines, -11 removed lines

@@ -24,7 +24,7 @@ 
    * @var string The path to the current $cachedir directory.
    */
   private $cachedir		= null;
-  private $cacheDB		= null;
+  private $cacheDB = null;
   private $cacheTime	= null;
 
 	public function __construct()
@@ -36,7 +36,7 @@ 
 		// Set our default cachedir.
 		$this->setCachedir();
 
-		$database = $this->cachedir.'/'.'SQLite3Cache.db3';
+		$database = $this->cachedir . '/' . 'SQLite3Cache.db3';
 
 		$this->cacheDB = new SQLite3($database);
 		$this->cacheDB->busyTimeout(1000);
@@ -44,7 +44,7 @@ 
 			$this->cacheDB->exec('CREATE TABLE cache (key text unique, value blob, ttl int);');
 			$this->cacheDB->exec('CREATE INDEX ttls ON cache(ttl);');
 		}
-		$this->cacheTime	= time();
+		$this->cacheTime = time();
 
 	}
 
@@ -66,12 +66,12 @@ 
 	 */
 	public function getData($key, $ttl = null)
 	{
-		$ttl		= time();
-		$query	= 'SELECT value FROM cache WHERE key = \''.$this->cacheDB->escapeString($key).'\' AND ttl >= '.$ttl.' LIMIT 1';
+		$ttl = time();
+		$query = 'SELECT value FROM cache WHERE key = \'' . $this->cacheDB->escapeString($key) . '\' AND ttl >= ' . $ttl . ' LIMIT 1';
 		$result	= $this->cacheDB->query($query);
 
 		$value		= null;
-		while($res = $result->fetchArray(SQLITE3_ASSOC)) { 
+		while ($res = $result->fetchArray(SQLITE3_ASSOC)) { 
 			$value = $res['value'];
 		}
 
@@ -84,9 +84,9 @@ 
 	public function putData($key, $value, $ttl = null)
 	{
 
-		$ttl		= $this->cacheTime + $ttl;
-		$query	= 'REPLACE INTO cache VALUES (\''.$this->cacheDB->escapeString($key).'\', \''.$this->cacheDB->escapeString($value).'\', '.$this->cacheDB->escapeString($ttl).');';
-		$result	= $this->cacheDB->exec($query);
+		$ttl = $this->cacheTime + $ttl;
+		$query = 'REPLACE INTO cache VALUES (\'' . $this->cacheDB->escapeString($key) . '\', \'' . $this->cacheDB->escapeString($value) . '\', ' . $this->cacheDB->escapeString($ttl) . ');';
+		$result = $this->cacheDB->exec($query);
 
 		return $result;
 	}
@@ -97,8 +97,8 @@ 
 	public function cleanCache($type = '')
 	{
 
-		$query	= 'DELETE FROM cache;';
-		$result	= $this->cacheDB->exec($query);
+		$query = 'DELETE FROM cache;';
+		$result = $this->cacheDB->exec($query);
 
 		return $result;