I am busy going through the LeeFish pages trying to optimise them a bit and I have a bit of a problem with image sizes from XThreads when used in a plugin.
The XThreads images have a nifty feature where you can set the width and height for thumbnail images without "breaking" the image proportions. I have this set up in all threads where I display XThread images (got me one point more on the page speed test ) but I am unsure how to apply this image resizing feature to plugins that call the image.
Here is an example plugin query:
PHP Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
$query=$db->query("
SELECT a.updatetime, a.md5hash, a.uploadtime, a.aid, a.attachname, a.filename, a.field, t.*
FROM ".TABLE_PREFIX."xtattachments a
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=a.tid)
WHERE t.visible=1 AND a.field='pfpic' AND t.closed NOT LIKE 'moved|%' AND t.fid IN ('".implode("','",$gallery_tid_array)."')
ORDER BY t.tid DESC
LIMIT 1
");while($gallery=$db->fetch_array($query)){$gallery_username= htmlspecialchars_uni($gallery['username']);$gallery_title= htmlspecialchars_uni($gallery['subject']);$gallery_postlink= get_thread_link(intval($gallery['tid']));$gallery_datetime= my_date($mybb->settings['dateformat'],$gallery['uploadtime']).' '.my_date($mybb->settings['timeformat'],$gallery['uploadtime']);$gallery_att_thumb= xthreads_get_xta_url($gallery).'/thumb160x120';eval("\$gallery_gallery_gallery .= \"".$templates->get("gallery_gallery_gallery")."\";");}
Where would I need to modify that query to be able to return the height and width? Not as fixed values as that would distort the thumb, but using the variable values as in the threadfields?
This is how I have it set up in my custom threadfields:
$query = $db->query("
SELECT a.updatetime, a.md5hash, a.thumbs, a.uploadtime, a.aid, a.attachname, a.filename, a.field, t.*
FROM ".TABLE_PREFIX."xtattachments a
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=a.tid)
WHERE t.visible=1 AND a.field='pfpic' AND t.closed NOT LIKE 'moved|%' AND t.fid IN ('".implode("','", $gallery_tid_array)."')
ORDER BY t.tid DESC
LIMIT 1
");
while($gallery = $db->fetch_array($query))
{
$gallery_username = htmlspecialchars_uni($gallery['username']);
$gallery_title = htmlspecialchars_uni($gallery['subject']);
$gallery_postlink = get_thread_link(intval($gallery['tid']));
$gallery_datetime = my_date($mybb->settings['dateformat'], $gallery['uploadtime']).' '.my_date($mybb->settings['timeformat'], $gallery['uploadtime']);
$gallery_thumb = xthreads_get_xta_url($gallery).'/thumb160x120';
if($gallery['thumbs'])
{
$gallery['thumbs'] = unserialize($gallery['thumbs']);
}
eval("\$gallery_gallery_gallery .= \"".$templates->get("gallery_gallery_gallery")."\";");
}
My images display ok (just like they did before) but the image dimensions are not applied (i.e. when I look in page speed it still says no image dimensions specified). Do I need to change something in the HTML template?