diff options
| author | marijus <mario@mariovavti.com> | 2014-11-15 14:39:36 +0100 |
|---|---|---|
| committer | marijus <mario@mariovavti.com> | 2014-11-15 14:39:36 +0100 |
| commit | 8b1e83128a1a9db1c5438dadb407bed18f168e0c (patch) | |
| tree | 1ee594ad5f0cefd66d86f53cf4289d5c97a70f8c /mod | |
| parent | ad8668be9e26c914c9dbb2146e5c26c9ffda5d4c (diff) | |
| download | volse-hubzilla-8b1e83128a1a9db1c5438dadb407bed18f168e0c.tar.gz volse-hubzilla-8b1e83128a1a9db1c5438dadb407bed18f168e0c.tar.bz2 volse-hubzilla-8b1e83128a1a9db1c5438dadb407bed18f168e0c.zip | |
fix lost $sql_extra in recent sql query changes
Diffstat (limited to 'mod')
| -rw-r--r-- | mod/photos.php | 2 |
1 files changed, 1 insertions, 1 deletions
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'), |