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.

[Steve_GB]

Originally Posted by Anopheles

It doesn't work!
The first item not being linked!

It worked for me and I'm very pleased to at last have the random profile image linked and fully working.

Steve

[MySaltyreef]

works 100%

[kamalia]

there's no option to create widget..i'm using vbulletin 4.1.3 classic (standard)..any idea?

[Davey-UK]

Excellent. Working 100% now in VB4.1.4

I would prefer the Latest members, rather than random members though. Could someone modify it slightly? Please.

Marked installed.

[cykelmyggen]

Originally Posted by Savage Circuits

I know this thread is old and all, but for those that were having problems with the first item not being linked I have solved the problem with the help of my Super Moderator on my website. He noticed that the following line was malformed. I am showing the original and the corrected versions in the hope it helps some of you. Take care!

PHP Code:

$output_bits = '<p align="center"'; 


And the corrected version:

PHP Code:

$output_bits = '<p align="center">'; 


Solved problem with first item not being linked, Thanks . However images aren't showing up?

[Konsolenheld]

Thanks!!

[Savage Circuits]

Yeah, I'm afraid I discontinued use of this widget until the author makes some updates. I had several reports of banned members (spammers on my site) being shown. That's not good. =(

[just77me]

Hello, does anyone has a code that works horizont -> 6 Pictures in a line? There is a guy describing that on a page bevore, but that doesn't show any pictures...

please anyone fixing the code from the first side to view pictures in a line.

Thank you very much.

Greetings

[just77me]

Hello there - can anyone help me to get the horizont version working?

[just77me]

no one there who can help me?