- if($a->theme['template_engine'] === 'internal') {
- $filename_e = template_escape($rr['filename']);
- }
- else {
- $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']));
- if ($p)
+ // 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",
+ DBA::escape($rr['resource-id']));
+ if ($p) {