From 8b1e83128a1a9db1c5438dadb407bed18f168e0c Mon Sep 17 00:00:00 2001 From: marijus Date: Sat, 15 Nov 2014 14:39:36 +0100 Subject: fix lost $sql_extra in recent sql query changes --- mod/photos.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mod/photos.php') diff --git a/mod/photos.php b/mod/photos.php index 95fa162c9..ab1e4b48a 100644 --- a/mod/photos.php +++ b/mod/photos.php @@ -1175,7 +1175,7 @@ function photos_content(&$a) { $r = q("SELECT p.resource_id, p.id, p.filename, p.type, p.album, p.scale, p.created FROM photo p INNER JOIN (SELECT resource_id, max(scale) scale FROM photo WHERE uid=%d AND album != '%s' AND album != '%s' - AND (photo_flags = %d or photo_flags = %d ) group by resource_id) ph + AND (photo_flags = %d or photo_flags = %d ) $sql_extra group by resource_id) ph ON (p.resource_id = ph.resource_id and p.scale = ph.scale) ORDER by p.created DESC LIMIT %d OFFSET %d", intval($a->data['channel']['channel_id']), dbesc('Contact Photos'), -- cgit v1.2.3