diff options
Diffstat (limited to 'apps/gallery/lib/photo.php')
-rw-r--r-- | apps/gallery/lib/photo.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/apps/gallery/lib/photo.php b/apps/gallery/lib/photo.php index f073ac9cbbb..1d304ce4357 100644 --- a/apps/gallery/lib/photo.php +++ b/apps/gallery/lib/photo.php @@ -52,17 +52,17 @@ class OC_Gallery_Photo { } public static function removeById($id) { - $stmt = OCP\DB::prepare('DELETE FROM *PREFIX*gallery_photos WHERE photo_id = ?'); + $stmt = OCP\DB::prepare('DELETE FROM `*PREFIX*gallery_photos` WHERE `photo_id` = ?'); $stmt->execute(array($id)); } public static function removeByAlbumId($albumid) { - $stmt = OCP\DB::prepare('DELETE FROM *PREFIX*gallery_photos WHERE album_id = ?'); + $stmt = OCP\DB::prepare('DELETE FROM `*PREFIX*gallery_photos` WHERE `album_id` = ?'); $stmt->execute(array($albumid)); } public static function changePath($oldAlbumId, $newAlbumId, $oldpath, $newpath) { - $stmt = OCP\DB::prepare("UPDATE *PREFIX*gallery_photos SET file_path = ?, album_id = ? WHERE album_id = ? and file_path = ?"); + $stmt = OCP\DB::prepare('UPDATE `*PREFIX*gallery_photos` SET `file_path` = ?, `album_id` = ? WHERE `album_id` = ? AND `file_path` = ?'); $stmt->execute(array($newpath, $newAlbumId, $oldAlbumId, $oldpath)); } |