X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=mod%2Ffbrowser.php;h=110ca9585c9d2e5ff0e346aaf4ad4328afffadd7;hb=7823223a0595a541e1a5e011fe65f8c56c1e4d50;hp=5836efbe5290437741a04b9b201ecf84b5b6e58b;hpb=206c26ae30e711aa30cdb29d668bee9dce834c28;p=friendica.git diff --git a/mod/fbrowser.php b/mod/fbrowser.php index 5836efbe52..110ca9585c 100644 --- a/mod/fbrowser.php +++ b/mod/fbrowser.php @@ -74,9 +74,9 @@ function fbrowser_content($a){ $filename_e = $rr['filename']; } - // Take the second largest picture as preview - $p = q("SELECT `scale` FROM `photo` WHERE `resource-id` = '%s' AND `scale` > %d ORDER BY `resource-id`, `scale` LIMIT 1", - dbesc($rr['resource-id']), intval($rr['hiq'])); + // Take the largest picture that is smaller or equal 640 pixels + $p = q("SELECT `scale` FROM `photo` WHERE `resource-id` = '%s' AND `height` <= 640 AND `width` <= 640 ORDER BY `resource-id`, `scale` LIMIT 1", + dbesc($rr['resource-id'])); if ($p) $scale = $p[0]["scale"]; else