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.

[slumbermann]

Originally Posted by kevinfx

were you able to figure out what wrong with using this code with vb version 4.0?

thank you

Hi,

I just tested the code with vb 4.0 and it works with no problem. Please make sure your user have profile picture or avatars uploaded, else there will be no picture shown.

[slumbermann]

Originally Posted by blake247

Thanks for the tip! Great widget!

Ur welcome...

[kevinfx]

that's weird because the usernames listed do have profile pictures .... Do i need to change anything in the code?
my vb is 4.0 patch level 1. also i store profile pics and avatars on the server (file system) not in the database.... would that make a different?

[slumbermann]

Originally Posted by kevinfx

that's weird because the usernames listed do have profile pictures .... Do i need to change anything in the code?

You don't need to change anything in the code, you just need to choose either to use the profile picture or avatar, currently i separated the code, so each will only work with one source, i will try to integrate both into the code.

when you create the widget, it show empty box or what? could you please explain your problem, i will try my best to help

[kevinfx]

when i create the widget, it shows some code in there. I replaced it everything with your code.

Thank you

[slumbermann]

Originally Posted by kevinfx

when i create the widget, it shows some code in there. I replaced it everything with your code.

Thank you

and when you add it to your layout manager? what are shown on the front page?

[kevinfx]

just 3 links (user names) to profiles without the profile pictures... looks like the widget was able to pull all users that have profile pix, but unable to display profile pix on the CMS

because i store profile pix on the server instead db, the profile pix URL is, for example :

/forum/customprofilepics/profilepic1_1.gif ..... not image.php?u=xxx

[slumbermann]

Originally Posted by kevinfx

just 3 links (user names) to profiles without the profile pictures... looks like the widget was able to pull all users that have profile pix, but unable to display profile pix on the CMS

because i store profile pix on the server instead db, the profile pix URL is, for example :

/forum/customprofilepics/profilepic1_1.gif ..... not image.php?u=xxx

ok, so that was the reason, could you please PM me your website url?

[Martyh]

Can it be set to pull from a specific user group ?

[slumbermann]

Originally Posted by Martyh

Can it be set to pull from a specific user group ?

yes you can, but there additional code to be added, how many group do you need? just one or some groups?