The following is what I've got :)
Please give at least a big thanks to me for coding this for you :p
Also, the final line shows how you should display the avatar.
$userid = "1";
$getinfo=$DB_site->query_first("SELECT userfield.*, user.* FROM user
LEFT JOIN userfield ON (user.userid = userfield.userid)
WHERE user.userid = '".$userid."'");
################################
// ############### DISPLAY USER'S AVATAR ###############
if ($getinfo['avatarid'] != 0)
{
// using a predefined avatar
$avatar = $DB_site->query_first("SELECT * FROM avatar WHERE avatarid = $getinfo[avatarid]");
$avatarid = $avatar['avatarid'];
eval('$currentavatar = "' . gettemplate('modifyavatarbit') . '";');
// store avatar info in $bbavatar for later use
$bbavatar = $avatar;
// if no category explicitly requested, set to display the category containing user's avatar
//$categoryid = iif($categoryid==0,$avatar['imagecategoryid'],0);
}
else
{
// not using a predefined avatar, check for custom
if ($avatar = $DB_site->query_first("SELECT dateline FROM customavatar WHERE userid=$getinfo[userid]"))
{
// using a custom avatar
if ($vboptions['usefileavatar'])
{
$getinfo['avatarurl'] = "$vboptions[avatarurl]/avatar$getinfo[userid]_$getinfo[avatarrevision].gif";
}
else
{
$getinfo['avatarurl'] = "avatar.php?userid=$getinfo[userid]&dateline=$avatar[dateline]";
}
eval('$currentavatar = "' . gettemplate('modifyavatarbit_custom') . '";');
}
else
{
// no avatar specified
$nouseavatarchecked = HTML_CHECKED;
$avatarchecked[0] = '';
eval('$currentavatar = "' . gettemplate('modifyavatarbit_noavatar') . '";');
}
}
// get rid of any lingering $avatar variables
unset($avatar);
################################
print '<img src="'.$getinfo['avatarurl'].'" border="0" alt="'.$getinfo['username'].'\'s avatar" />';