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'));
}