diff options
Diffstat (limited to 'apps/gallery/lib/sharing.php')
-rw-r--r-- | apps/gallery/lib/sharing.php | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/apps/gallery/lib/sharing.php b/apps/gallery/lib/sharing.php index fffeca032a3..e79692392a8 100644 --- a/apps/gallery/lib/sharing.php +++ b/apps/gallery/lib/sharing.php @@ -23,7 +23,7 @@ class OC_Gallery_Sharing { private static function getEntries($token) { - $sql = 'SELECT * FROM *PREFIX*gallery_sharing WHERE token = ?'; + $sql = 'SELECT * FROM `*PREFIX*gallery_sharing` WHERE `token` = ?'; $stmt = OCP\DB::prepare($sql); return $stmt->execute(array($token)); } @@ -44,7 +44,7 @@ class OC_Gallery_Sharing { $r = self::getEntries($token); if ($row = $r->fetchRow()) { $galleryId = $row['gallery_id']; - $sql = 'SELECT * FROM *PREFIX*gallery_albums WHERE album_id = ?'; + $sql = 'SELECT * FROM `*PREFIX*gallery_albums` WHERE `album_id` = ?'; $stmt = OCP\DB::prepare($sql); $r = $stmt->execute(array($galleryId)); if ($row = $r->fetchRow()) @@ -57,7 +57,7 @@ class OC_Gallery_Sharing { $r = self::getEntries($token); if ($row = $r->fetchRow()) { $galleryId = $row['gallery_id']; - $sql = 'SELECT * FROM *PREFIX*gallery_albums WHERE album_id = ?'; + $sql = 'SELECT * FROM `*PREFIX*gallery_albums` WHERE `album_id` = ?'; $stmt = OCP\DB::prepare($sql); $r = $stmt->execute(array($galleryId)); if ($row = $r->fetchRow()) @@ -66,23 +66,23 @@ class OC_Gallery_Sharing { } public static function updateSharingByToken($token, $recursive) { - $stmt = OCP\DB::prepare('UPDATE *PREFIX*gallery_sharing SET recursive = ? WHERE token = ?'); + $stmt = OCP\DB::prepare('UPDATE `*PREFIX*gallery_sharing` SET `recursive` = ? WHERE `token` = ?'); $stmt->execute(array($recursive, $token)); } public static function getEntryByAlbumId($album_id) { - $stmt = OCP\DB::prepare('SELECT * FROM *PREFIX*gallery_sharing WHERE gallery_id = ?'); + $stmt = OCP\DB::prepare('SELECT * FROM `*PREFIX*gallery_sharing` WHERE `gallery_id` = ?'); return $stmt->execute(array($album_id)); } public static function addShared($token, $albumId, $recursive) { - $sql = 'INSERT INTO *PREFIX*gallery_sharing (token, gallery_id, recursive) VALUES (?, ?, ?)'; + $sql = 'INSERT INTO `*PREFIX*gallery_sharing` (`token`, `gallery_id`, `recursive`) VALUES (?, ?, ?)'; $stmt = OCP\DB::prepare($sql); $stmt->execute(array($token, $albumId, $recursive)); } public static function remove($albumId) { - $stmt = OCP\DB::prepare('DELETE FROM *PREFIX*gallery_sharing WHERE gallery_id = ?'); + $stmt = OCP\DB::prepare('DELETE FROM `*PREFIX*gallery_sharing` WHERE `gallery_id` = ?'); $stmt->execute(array($albumId)); } } |