8
@Mamba
yea totally random. people are pming me about it so i'm posting the code here:
global $xoopsDB;
$sql = "SELECT u.uid, u.user_avatar FROM ".$xoopsDB->prefix("users")." u, ".$xoopsDB->prefix("groups_users_link")." g, ".$xoopsDB->prefix("profile_profile")." p WHERE u.uid = g.uid AND u.uid = p.profile_id AND u.level > 0 AND user_avatar <> 'blank.gif' AND u.uid NOT IN (1) ORDER BY RAND()";
$result = $xoopsDB->query($sql, 45);
while (list($uid, $user_avatar) = $xoopsDB->fetchRow($result))
{
echo '<div align="center" style="float: left; padding:2px;"><a href="' . XOOPS_URL . '/userinfo.php?uid=' . $uid . '"><img src="' . XOOPS_URL . '/uploads/' . $user_avatar . '" alt="Avatar" height="30" width="30"/></a></div>';
}
echo '<br><br><br><br><br><br><br>';
it'd be cool to see this block here on XOOPS
as in regard to the featured member feature. you need to purchase a pro membership plan via the subscription module. i've created a new group and made some special options available for its members only.
