vBulletin CMS Widgets - Widget - Show random members with picture

#Function:

• Show random members which have profile picture
• Clickable picture and username to go to member's profile page

#Installation:

1. Go to Admin CP > vBulletin CMS > Widgets > create new widget
2. Widget type > PHP Direct Execution . Title > Random Members . Description > Show random members
3. click save
4. then click configure and put the code below

#code to use custom profile picture as the source of picture

$member_count = 3;

  ob_start();
  require_once('./includes/functions_user.php');
  require_once('./includes/functions_bigthree.php');
  // Get Random Members
  $newusers_get = vB::$db->query_read("
    SELECT ".TABLE_PREFIX."user.userid AS userid, ".TABLE_PREFIX."user.username AS username, ".TABLE_PREFIX."customprofilepic.dateline AS dateline FROM ".TABLE_PREFIX."customprofilepic
	LEFT JOIN ".TABLE_PREFIX."user
			ON ".TABLE_PREFIX."customprofilepic.userid=".TABLE_PREFIX."user.userid
    WHERE ".TABLE_PREFIX."customprofilepic.visible = 1
   ORDER BY RAND()
   LIMIT $member_count");
  $output_bits = '<p align="center"';
  while($newuser = vB::$db->fetch_array($newusers_get))
  {
        $output_bits .= '<a href="member.php?u='.$newuser[userid].'"><img src="image.php?u='.$newuser[userid].'&dateline='.$newuser[dateline].'&type=profile" alt="'.$newuser[username].'"/><br />'.$newuser[username].'</a><br />';
  }
  $output_bits .= '</p>';
  $output = $output_bits;
  ob_end_clean();

#code if you want to use custom avatar as the main source for the picture

$member_count = 3;

  ob_start();
  require_once('./includes/functions_user.php');
  require_once('./includes/functions_bigthree.php');
  // Get Random Members
  $newusers_get = vB::$db->query_read("
    SELECT ".TABLE_PREFIX."user.userid AS userid, ".TABLE_PREFIX."user.username AS username, ".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
   ORDER BY RAND()
   LIMIT $member_count");
  $output_bits = '<p align="center"';
  while($newuser = vB::$db->fetch_array($newusers_get))
  {
        $output_bits .= '<a href="member.php?u='.$newuser[userid].'"><img src="image.php?u='.$newuser[userid].'&dateline='.$newuser[dateline].'" alt="'.$newuser[username].'"/><br />'.$newuser[username].'</a><br />';
  }
  $output_bits .= '</p>';
  $output = $output_bits;
  ob_end_clean();

Note: You can edit the amount of members you want to show by changing the $member_count from 3 to whatever value you want.

[karlm]

This works nicely on vb4.0.2 thank you kindly...

[karlm]

One small issue I just noticed... It doesn't exclude members from the banned group. Could this be considered for future updates please?

[Steve_GB]

Karlm,

I notice you also have the same problem mentioned earlier in this thread, that your first image of the three doesn't actually link to anything.. the other 2 do.

Re the banned folks, until you get a way to do that one idea for a work around would be to delete their profile pictures and then they won't be displayed.

Steve

[karlm]

Hmm, how odd - I've just checked using Chrome, Firefox and even MSIE - and could not replicate the unlinked profile issue you've addressed.

Eitherway, I appreciate your tip for the banned members problem. Thanking you kindly!

[Professional2]

sorry i dont have this option:
Go to Admin CP > vBulletin CMS > Widgets > create new widget

[Steve_GB]

Originally Posted by karlm

Hmm, how odd - I've just checked using Chrome, Firefox and even MSIE - and could not replicate the unlinked profile issue you've addressed.

Eitherway, I appreciate your tip for the banned members problem. Thanking you kindly!

Karim,

For me using IE8, the first profile image on your site has no link at all. The other two do. Others have reported that problem on their site in this thread. I also saw it on my site when I installed this. I suspect there is a tiny change needed to the code.

IE8 does do things its own way and does not support a lot of css 3 etc. Those using it see commas at the end of most lists in vBulletin, and extra spaces in some widgets, and so on. This all gets mentioned in places on vBulletin.com - they seem to say it is because IE8 doesn't support commands like last-child that they are using. A number of browsers are said not to.

Steve

[desi-boy]

nice man but i need some thing like ( Attachment) can u creat some thing likhe this 1

[Verionia]

Id like something similar to the post above of top users, newest members, etc. I can place even in forum sidebars or below navbar with or without style.

[baerwurz]

Very nice.

I can see the link to userprofile and the avatar of the user, but guests only see the link to the userprofile?

Any Tip how to change this?

[Antiblank]

I can tell the function is working for my Avatars but I'm also not getting images, I'm assuming this is because I'm storing the avatars via filesystem instead of using the database.

If you came up with an option for this as I see a few other people had the issue I'd appreciate the choice for avatars NOT being stored in the database.