summaryrefslogtreecommitdiffstats
path: root/apps/gallery/lib/photo.php
diff options
context:
space:
mode:
Diffstat (limited to 'apps/gallery/lib/photo.php')
-rw-r--r--apps/gallery/lib/photo.php6
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));
}