From c49198fd71f332666d2660e5d8e7563d50be5e10 Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Fri, 16 Oct 2015 12:24:27 +0200 Subject: this is all the info we need --- mod/photos.php | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) (limited to 'mod') 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) ); -- cgit v1.2.3