diff options
| author | Mario Vavti <mario@mariovavti.com> | 2015-10-16 12:24:27 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2015-10-16 12:24:27 +0200 |
| commit | c49198fd71f332666d2660e5d8e7563d50be5e10 (patch) | |
| tree | febbfc9ea386d161d38d15e3da662804b7b36354 | |
| parent | a756c0b18228982743049f7691229ba55e83983f (diff) | |
| download | volse-hubzilla-c49198fd71f332666d2660e5d8e7563d50be5e10.tar.gz volse-hubzilla-c49198fd71f332666d2660e5d8e7563d50be5e10.tar.bz2 volse-hubzilla-c49198fd71f332666d2660e5d8e7563d50be5e10.zip | |
this is all the info we need
| -rw-r--r-- | mod/photos.php | 5 |
1 files changed, 1 insertions, 4 deletions
diff --git a/mod/photos.php b/mod/photos.php index e484880e3..55d59b848 100644 --- a/mod/photos.php +++ b/mod/photos.php @@ -300,10 +300,7 @@ function photos_post(&$a) { } } - // @FIXME This query includes data of all thumbnails and could probably - // be made much more memory efficient. - - $p = q("SELECT * FROM `photo` WHERE `resource_id` = '%s' AND `uid` = %d ORDER BY `scale` DESC", + $p = q("SELECT type, is_nsfw, description, resource_id, scale, allow_cid, allow_gid, deny_cid, deny_gid FROM photo WHERE resource_id = '%s' AND uid = %d ORDER BY scale DESC", dbesc($resource_id), intval($page_owner_uid) ); |