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.

[Boosted Panda]

Can you make this avatar instead?

[slumbermann]

Originally Posted by Boosted Panda

Can you make this avatar instead?

yes sure... give me some time then i will make an avatar version too...

[slumbermann]

Originally Posted by Boosted Panda

Can you make this avatar instead?

to show the profile picture using avatar function use this code instead

$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 user.userid AS userid, user.username AS username, customavatar.dateline AS dateline FROM ".TABLE_PREFIX."customavatar
	LEFT JOIN ".TABLE_PREFIX."user
			ON ".TABLE_PREFIX."customavatar.userid=".TABLE_PREFIX."user.userid
    WHERE 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].'" alt="'.$newuser[username].'"/><br />'.$newuser[username].'</a><br />';
  }
  $output_bits .= '</p>';
  $output = $output_bits;
  ob_end_clean();

[Boosted Panda]

That didn't work

[slumbermann]

Originally Posted by Boosted Panda

That didn't work

do you use custom avatar?

[blake247]

Is there anyway to make the profile pics smaller?

[cykelmyggen]

I get a database error on content.php every time I put this widget on!?

Database error in vBulletin 4.0.1:

Invalid SQL:

    SELECT user.userid AS userid, user.username AS username,
customprofilepic.dateline AS dateline FROM vbcustomprofilepic
        LEFT JOIN vbuser
                        ON vbcustomprofilepic.userid=vbuser.userid
    WHERE customprofilepic.visible = 1
   ORDER BY RAND()
   LIMIT 3;

MySQL Error   : Unknown column 'user.userid' in 'field list'
Error Number  : 1054

[slumbermann]

Originally Posted by blake247

Is there anyway to make the profile pics smaller?

yes you can add in width and height to the img code example like below:

        $output_bits .= '<a href="member.php?u='.$newuser[userid].'"><img src="image.php?u='.$newuser[userid].'&dateline='.$newuser[dateline].'" alt="'.$newuser[username].' width="50px" height="50px""/><br />'.$newuser[username].'</a><br />';

Originally Posted by cykelmyggen

I get a database error on content.php every time I put this widget on!?

Database error in vBulletin 4.0.1:

Invalid SQL:

    SELECT user.userid AS userid, user.username AS username,
customprofilepic.dateline AS dateline FROM vbcustomprofilepic
        LEFT JOIN vbuser
                        ON vbcustomprofilepic.userid=vbuser.userid
    WHERE customprofilepic.visible = 1
   ORDER BY RAND()
   LIMIT 3;

MySQL Error   : Unknown column 'user.userid' in 'field list'
Error Number  : 1054

hurmm that's weird, please try this code instead

$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 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();

[kevinfx]

i got the links to the profiles, but not profile picture? what's wrong? thanks