vBulletin CMS Widgets - Widget: display random image thumbnail from public albums

What it does ?
This widget displays a thumbnail image, taken randomly from any public albums and adds a "More..." link redirecting to albums.
Clicking on the thumbnail opens full sized picture in its current album.

Version history :
1.0: Initial release
1.1: Style can now be independant of template modification / Added option to display more than one thumbnail / Added option to define a custom size for the thumbnails.
1.2: You can now restrict picture fetching to a list of albums / Added fixes to the request.

Install instructions :
1- Go in to your AdminCP > vBulletin CMS > Widgets > Create new widget
2- Choose type 'PHP direct execution'
3- Give it a name (i.e: Random Picture)
4- Give it a description (i.e Random picture from public albums)
5- Save it
6- Configure it with the following code (copy/paste)

PHP Code:

// Display random images thumbnails taken from any public albums.
// Author : Sulquendi
// Version: 1.2

// -- Widget Configuration -- 
$use_vB_thumbnail_size     = false;
$use_custom_css         = false;
$twidth                 = 190;
$limit                    = 1;
$albums_list            = "";


// -- Nothing to configure below this line --
if ($use_custom_css){
    $pthumb     = 'class="pthumb"';
    $pcaption    = 'class="pcaption"';
    $pmore        = 'class="pmore"';
    $pstyle        = '';
}else{
    $pthumb     = 'style="text-align:center;"';
    $pcaption    = 'style="text-align:center;font-style:italic;font-family: Times, serif;margin-bottom:10px;"';
    $pmore        = 'style="text-align:right;display:block;"';
    $pstyle        = 'style="border: 1px solid black;padding:4px;background: white;"';
}
if ($albums_list!="") $sup_cond = "AND alb.albumid IN ($albums_list)"; else $sup_cond ="";
ob_start();
require_once(DIR . '/includes/functions_album.php');
require_once(DIR . '/includes/functions_user.php');
$pic_get = vB::$db->query_read("
    SELECT     alb.albumid, att.attachmentid, att.userid, att.caption, att.dateline, att.state, fdt.filesize, IF(fdt.thumbnail_filesize > 0, 1, 0) AS hasthumbnail, fdt.thumbnail_dateline, fdt.thumbnail_width, fdt.thumbnail_height, u.username
    FROM ".TABLE_PREFIX."album AS alb
    LEFT JOIN ".TABLE_PREFIX."attachment AS att ON alb.albumid = att.contentid
    LEFT JOIN ".TABLE_PREFIX."filedata AS fdt ON att.filedataid = fdt.filedataid
    LEFT JOIN ".TABLE_PREFIX."user AS u ON att.userid = u.userid
    WHERE alb.state = 'public' AND att.contenttypeid = '8' $sup_cond
    ORDER BY rand(" . microtime()*1000000 . ") 
   LIMIT $limit");
  $output_bits = "";
  while($pic = vB::$db->fetch_array($pic_get))
  {
    $albuminfo = fetch_albuminfo($pic[albumid]);
    $picture = prepare_pictureinfo_thumb($pic, $albuminfo);
    if ($use_vB_thumbnail_size) $size = $picture[dimensions]; else $size = "width=$twidth";
    $output_bits .= "<div $pthumb><a href=\"album.php?{$vbulletin->session->vars['sessionurl']}albumid={$pic[albumid]}&attachmentid={$picture[attachmentid]}\"><img $pstyle src=\"attachment.php?{$vbulletin->session->vars['sessionurl']}attachmentid={$picture[attachmentid]}&thumb=1&d={$picture[thumbnail_dateline]}\" alt=\"{$picture[caption_preview]}\" $size /></a>";
    $output_bits .= "</div><div $pcaption>{$picture[caption_preview]} by {$pic[username]}</div>";
  }
$output_bits .= '<span '.$pmore.'><a href="album.php" alt="To the albums">More...</a></span>';
$output = $output_bits;
ob_end_clean(); 


7- There are 5 variables you can edit in this code, to configure the widget behavior :

PHP Code:

$use_vB_thumbnail_size     = false;
$use_custom_css         = false;
$twidth                 = 190;
$limit                = 2;
$albums_list            = "1,2,3"; 


$albums_list :
define a list of albums IDs (coma-separated list) to use, when taking a picture randomly.
You can also specify only one ID.
note: if you leave this variable empty, ALL public albums will be used.

$use_vB_thumbnail_size :
false = the widget will use $twidth to set up the width of the thumbnail.
true = default vBulletin thumbnail size will be used.

$twidth:
Width of a thumbnail (in pixel.)
will only be used if $use_vB_thumbnail_size is set to false.

$limit:
# of thumbnails you want to display in the widget.

$use_custom_css
false = the styling of widget elements will be performed inside the widget itself (using style="" html tag.)
true = the styling will be performed by CSS, thus a template needs to be manually edited : vbcms.css

.pthumb {
	text-align:center;
}
.pthumb img {
	border: 1px solid black;
	padding:4px;
	background: white;
}
.pcaption {
	text-align:center;
	font-style:italic;
	font-family: "Times New Roman", Times, serif;
	margin-bottom:10px;
}
.pmore {
	text-align:right;
	display:block;
}

8- Your widget is ready to be added to your CMS with AdminCP > vBulletin CMS > Widgets > Layout Manager

Screenshot : see below.

[da prez]

Is there any way to show moving animated .gifs ?

Forget it.

Previously there was a post about changing thumb=1 to thumb=0 ... that seem to have done it.

[Sangheili]

Originally Posted by tsafarog

I am interested in that also?

I it possible to display the latest uploaded pics?

I would also like that feature if possible.

[keyla31]

worked perfect 4.2.0

[Pirate45]

When you go into configure, this is already in the box:

PHP Code:

$output = date(vB::$vbulletin->options['dateformat']) . "<br />\n"; 


I can't quite figure out how to enter the code that is offered here. Any way I do it I end up with errors.

Do we delete that text and just paste from the box here of is it integrated with that code?

I've tried both ways and I get errors.

[Pirate45]

Disregard last question. I think I figured it out.

[Davey-UK]

Originally Posted by tsafarog

I am interested in that also?

I it possible to display the latest uploaded pics?

Originally Posted by Sangheili

I would also like that feature if possible.

Did anyone figure out how to acheive this?

[BarracodE]

Thank you. You saved me a ton of hours trying to code this myself.

To everyone wanting something more...the first thing you should say is thank you for what is already provided. The second thing you should say is how much would you charge to make it do <this> instead of holding your hand out and complaining. :up:

[Greeksgal]

Originally Posted by Pirate45

When you go into configure, this is already in the box:

PHP Code:

$output = date(vB::$vbulletin->options['dateformat']) . "<br />\n"; 


I can't quite figure out how to enter the code that is offered here. Any way I do it I end up with errors.

Do we delete that text and just paste from the box here of is it integrated with that code?

I've tried both ways and I get errors.

^^^^ This...I can't figure out where to put the code.

[Haponing]

This works perfectly for me THANK YOU! And also, what if I wanted to place the block horizontally across the forum? Is that possible?

[AlBundy]

I it possible to display the latest uploaded pics?