vBulletin CMS Widgets - Latest Album Picture v2

Create a new widget
Widget Type: PHP Direct Execution
Title: Latest Picture

Then save find it again and click the configure change top box to

global $db;

// set how many to display
$hm = '1';

// replace dateline below with rand(NOW()) if you want it random
$orderby = "dateline";


$lpictures = $db->query_read("
  SELECT *  FROM " . TABLE_PREFIX . "attachment AS attach
    WHERE attach.state = 'visible' and attach.contenttypeid = '1'
ORDER BY $orderby DESC LIMIT 0, $hm
  ");

    $cols = $db->num_rows($lpictures);

    while ($lpicture = $db->fetch_array($lpictures))
    {
    
$templater = vB_Template::create('cms_albums_albumsbits');
$templater->register('lpicture' , $lpicture);
$albumpics .= $templater->render();

$templater = vB_Template::create('cms_albums');
$templater->register('lpicture' , $lpicture);
$templater->register('albumpics' , $albumpics);
$cms_albums = $templater->render();

    }
$output = $cms_albums;

Then save

add 2 new templates below

Title: cms_albums

    <link rel="stylesheet" type="text/css" href="css.php?styleid=1&amp;langid=1&amp;d=1260794007&amp;td=ltr&amp;sheet=album.css" />

    <link rel="stylesheet" type="text/css" href="css.php?styleid=1&amp;langid=1&amp;d=1260794007&amp;td=ltr&amp;sheet=picture.css" />

<div class="block" id="album">
    <ol id="thumbnails" class="blockbody floatcontainer">
        $albumpics
</ol>    
</div>

Title: cms_albums_albumsbits

<li>

    <center><a class="picture" href="$vboptions[bburl]/attachment.php?attachmentid=$lpicture[attachmentid]"><img src="$vboptions[bburl]/attachment.php?attachmentid=$lpicture[attachmentid]" alt="$lpicture[caption]" border="0" height="100" width="200"  /></a></center>
</li>

all you need to do now is go into layout manager and add the widget where you want it

[shadowbreed]

I had the empty widget issue as well, and fixed it by using the code in post 19 instead.

This is apparently not updated in the original post yet.

Thanks for the mod!

[benative]

Originally Posted by shadowbreed

I had the empty widget issue as well, and fixed it by using the code in post 19 instead.

This is apparently not updated in the original post yet.

Thanks for the mod!

I did the same thing as you. but mine is little strange. when you click on the image it does not go to that album.. it just opens that image in a new window...

[lazytown]

In my case, the thumbs shown are extremely WIDE and the photo-shadow outline is too small.

[lazytown]

I fixed the width issue, but this widget is using the full-size images as thumbnails, thus causing a huge page load increase... It could just as easily use the actual thumbnails instead of shrinking full size images.

[AlBundy]

Hi.
It run on vb 4, but i see only attachments, but not pictures from album
it should not show attachments, only pictures.

how can i change it?
thanks!