I think I was the one who state the $user_avatar string ... this is a dreamboard MOD code ... why is it in the avatar MOD's topic ? ...
The user_avatar field has already been discussed there.
However, change the above with :
$posts = "
SELECT ".get_user_table_field("", "user_id"). get_user_table_field(",", "user_name"). get_user_table_field(",", "user_level")." user_posts, user_joindate, user_signature, user_avatar
FROM ".USERS_TABLE."
WHERE ".get_user_table_field("", "user_id")." = ".$thrstarter_id;
$result = $site_db->query($posts);
while ($user = $site_db->fetch_array($result)) {
$post_count = $user['user_posts'];
$user_id = $user['user_id'];
$user_rank = $user['user_level'];
$date_registered = (isset($user['user_joindate'])) ? format_date($boardconfig['date_format'], $user['user_joindate']) : REPLACE_EMPTY;
$signature = format_boardtext ($user['user_signature'],$boardconfig['html_board'], $boardconfig['wordwrap_board'], $boardconfig['bb_board'], $boardconfig['bb_image_board'], 1);
$user_avatar = $user['user_avatar'];
$user_avatar_current = ($config['avatar_use'] && @file_exists(TEMPLATE_PATH."/avatars/".$user_avatar)) ? "<img src=\"".TEMPLATE_PATH."/avatars/".$user_avatar."\">" : get_gallery_image("blank.gif");
}
Note: Code edited above.