vb.org Archive - 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

Code:

.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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01236 seconds Memory Usage 1,777KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: