I've been tweaking a random users widget to include more features. However I took a break after my hard drive failed and when I started working on it again, the avatars no longer show up
I have the avatars stored in files and not in the db. The directory and sub directories are chmoded 777. I have attached a screenshot of the avatar file storage type for reference.
Here's the widget code I'm working with.
Code:
$member_count = 8;
ob_start();
require_once('./includes/functions_user.php');
require_once('./includes/functions_bigthree.php');
// Get Featured Members
$featuredusers_get = vB::$db->query_read("
SELECT ".TABLE_PREFIX."user.userid AS userid, ".TABLE_PREFIX."user.username AS username, ".TABLE_PREFIX."user.avatarrevision AS avatarrevision, ".TABLE_PREFIX."customavatar.dateline AS dateline
FROM ".TABLE_PREFIX."customavatar
LEFT JOIN ".TABLE_PREFIX."user
ON ".TABLE_PREFIX."customavatar.userid=".TABLE_PREFIX."user.userid
WHERE ".TABLE_PREFIX."customavatar.visible = 1 AND ".TABLE_PREFIX."user.usergroupid IN (2, 6, 7) AND ".TABLE_PREFIX."user.posts > 0
ORDER BY RAND()
LIMIT $member_count");
$output_bits = '<p align="left">';
while($featureduser = vB::$db->fetch_array($featuredusers_get))
{
$output_bits .= '<a href="member.php?u='.$featureduser[userid].'"><img src="/customavatars'.$featureduser[userid].'_'.$featureduser[avatarrevision].'.gif" alt="'.$featureduser[username].'"/ width="125" height="125"><br />'.$featureduser[username].'</a><br /><br />';
}
$output_bits .= '</p>';
$output = $output_bits;
ob_end_clean();