[Gary King]

The following is what I've got
Please give at least a big thanks to me for coding this for you

Also, the final line shows how you should display the avatar.

PHP Code:

$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" />';