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.

[alfanexus]

Originally Posted by 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.

I have tried it on a system with avatars in database and this worked. I have also tried on a system with avatars stored on filesystem ad this did not work, so I think you are right.

So I would also appreciate a choice for avatars NOT being stored in the database

It would also be great to limit the ramdom users to the last 500 og 1000 users logged in Or someother option that dident show Inactive users.

Anyway this is still a great widget for the once who can use it Thanks

[Antiblank]

I modified it a little to work with custom avatars stored in the file system. Might not be the best way but it works, hopefully this helps out.

$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."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
   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="/customavatars/avatar'.$newuser[userid].'_'.$newuser[avatarrevision].'.gif" alt="'.$newuser[username].'"/><br />'.$newuser[username].'</a><br />';
  }
  $output_bits .= '</p>';
  $output = $output_bits;
  ob_end_clean();

[Antiblank]

Regardless which setup you are using, if you want to limit it just to a single usergroup find line:

After

$member_count = 3;

Add

$usergroup_limit = 6;

Find

    WHERE ".TABLE_PREFIX."customavatar.visible = 1

Replace with

    WHERE ".TABLE_PREFIX."customavatar.visible = 1 AND ".TABLE_PREFIX."user.usergroupid = $usergroup_limit

Now just change the usergroup_limit number to match the usergroup you want to display. 6 for example is Administrators.

[TripleChin]

This is a nice add-on. I am completely new to Vb and php. If someone could advise me of how to limit this to logged in members, that would be great. Again, nice add-on.

[BadgerDog]

Installed and works great in CMS with v4.03 .. thanks .. :up:

Any chance of getting similar piece of code to create a "block" for the side block function in v4?

Regards,
Badger:up:

[goxy63]

Installed nominated and rated, thank you very much for this widget code

Is there a way to show this horizontaly not verticaly?
That is can we display avatars/profile pic left to right instead up and down?

[Taurus MFF]

Originally Posted by goxy63

Installed nominated and rated, thank you very much for this widget code

Is there a way to show this horizontaly not verticaly?
That is can we display avatars/profile pic left to right instead up and down?

I second the request to display images horizontally!

nice mod, installed & working great on CMS v4.0.3

[JayCat]

Originally Posted by archet1337

Is it possible to make this work with Forum Blocks as well?

I'd really like that too

[vivamexico55]

In 4.04 for some reason only the 2nd or 3rd avatar can be clicked, not the first. I can't find why...

[mse2k]

Hallo ... i use VB 4.0.6 ... the widget shows the name of the user but not a picture ... what`s wrong? THX