aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2015-10-16 12:24:27 +0200
committerMario Vavti <mario@mariovavti.com>2015-10-16 12:24:27 +0200
commitc49198fd71f332666d2660e5d8e7563d50be5e10 (patch)
treefebbfc9ea386d161d38d15e3da662804b7b36354
parenta756c0b18228982743049f7691229ba55e83983f (diff)
downloadvolse-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.php5
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)
);