From 0c0ae928dcd483211a92303eb2b202453d02a86e Mon Sep 17 00:00:00 2001
From: jfd <jfd@underverse>
Date: Mon, 30 Jul 2012 20:46:14 +0200
Subject: escape all identifiers with backticks

---
 lib/filecache.php | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'lib/filecache.php')

diff --git a/lib/filecache.php b/lib/filecache.php
index 9e999f12989..719f419b37c 100644
--- a/lib/filecache.php
+++ b/lib/filecache.php
@@ -59,7 +59,7 @@ class OC_FileCache{
 			$root='';
 		}
 		$path=$root.$path;
-		$query=OC_DB::prepare('SELECT ctime,mtime,mimetype,size,encrypted,versioned,writable FROM *PREFIX*fscache WHERE path_hash=?');
+		$query=OC_DB::prepare('SELECT `ctime`,`mtime`,`mimetype`,`size`,`encrypted`,`versioned`,`writable` FROM `*PREFIX*fscache` WHERE `path_hash`=?');
 		$result=$query->execute(array(md5($path)))->fetchRow();
 		if(is_array($result)){
 			return $result;
@@ -206,12 +206,12 @@ class OC_FileCache{
 			$path=$root.$file;
 			self::delete(self::getFileId($path));
 		}elseif($file!=-1){
-			$query=OC_DB::prepare('SELECT id FROM *PREFIX*fscache WHERE parent=?');
+			$query=OC_DB::prepare('SELECT `id` FROM `*PREFIX*fscache` WHERE `parent`=?');
 			$result=$query->execute(array($file));
 			while($child=$result->fetchRow()){
 				self::delete(intval($child['id']));
 			}
-			$query=OC_DB::prepare('DELETE FROM *PREFIX*fscache WHERE id=?');
+			$query=OC_DB::prepare('DELETE FROM `*PREFIX*fscache` WHERE `id`=?');
 			$query->execute(array($file));
 		}
 	}
-- 
cgit v1.2.3