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