shot in the dark here… find this query in the sf-template-tags-lists.php file, function sf_latest_posts():
$posts = sfdb_select('set',
"SELECT post_id, topic_id, forum_id, post_content, post_index, ".sf_zone_datetime('post_date').",
".SFPOSTS.".user_id, guest_name, ".SFMEMBERS.".display_name FROM ".SFPOSTS."
LEFT JOIN ".SFMEMBERS." ON ".SFPOSTS.".user_id = ".SFMEMBERS.".user_id
".$where."
ORDER BY post_date DESC
LIMIT ".$limit);
and change it to
$posts = sfdb_select('set',
"SELECT post_id, topic_id, forum_id, post_content, post_index, ".sf_zone_datetime('post_date').",
".SFPOSTS.".user_id, guest_name, user_email, guestemail, ".SFMEMBERS.".display_name FROM ".SFPOSTS."
LEFT JOIN ".SFMEMBERS." ON ".SFPOSTS.".user_id = ".SFMEMBERS.".user_id
".$where."
ORDER BY post_date DESC
LIMIT ".$limit);
and then where you want the avatar to display in that same function, add this:
if ($post->user_id)
{
$icon = 'user';
if (sf_is_forum_admin($post->user_id)) $icon='admin';
} else {
$icon = 'guest';
}
$out.= sf_render_avatar($icon, $post->user_id, sf_filter_email_display($post->user_email), sf_filter_email_display($post->guestemail), false, $size);
again, this is completely untested… you will probably want to style this to your liking… there are some threads in our forum about suggested styling for this in other tags that already allow an avatar…