Does this work? In EXTRA.css putI am trying to change the background of the image box in grid view. Half is appearing in our template colour and the other half white.
I have searched the templates, style properties and css files but I can not find where it is being set (might be the problem).
Any help would be good.
Thanks
.thumbnailHolder .thumbnail {
background-color: #FFFFFF !important;
}How about this?
.thumbnailHolder .boxModelFixer {
background-color: black !important;
}
The RAND() query actually started caused the loading time on my index page to slow way down as more images were added. One way you can mitigate the performance issue is explained in this blog post.
That sounds like a great compromise. Would you mind sharing your exact block code?
This is my modified function from XfRu_UserAlbums_Model_Images
public function getRandomImages()
{
$max_id = $this->_getDb()->fetchOne('SELECT MAX(image_id) FROM xfr_useralbum_image');
$limit = XenForo_Application::get('options')->XfRu_UA_displayImages;
$rand_count = $limit * 3;
for ($i = 0; $i < $rand_count; $i++)
$random_ids[] = mt_rand(1, $max_id);
$sql = '
SELECT `image`.*, `user`.user_id, `user`.username, `album`.title AS albumTitle,
' . self::$dataColumns . '
FROM xfr_useralbum_image AS `image`
INNER JOIN xfr_useralbum_image_data AS `data` ON
(`data`.data_id = `image`.data_id)
INNER JOIN xfr_useralbum AS `album` ON
(`album`.album_id = `image`.album_id)
INNER JOIN xf_user AS `user` ON
(`user`.user_id = `album`.user_id)
WHERE `album`.album_type = "public" AND moderation = 0 AND image_id IN ('.implode($random_ids , ',').')
';
return $this->prepareImages($this->fetchAllKeyed($this->limitQueryResults($sql, $limit), 'image_id'));
}
Check your server logs. I had that error when I initially installed the add-on, too. The answer (which I can't remember) was in my webserver log.
In my server log is nothing, but I made another test: I think it's a problem with Chrome, when I upload pictures with Firefox everything works fine, but with Chrome I have these problems.
