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

[Juggernaut]

So this mod won't be supported anymore by the developer?
Might as well delete it then.

[svandanam]

Originally Posted by Bergler

How do you fix that?

I fixed it by changing the layout to 2 Column + Sidebar (33%,66%, 240px)

[antua al toro]

does not work in 4.0.2.
but worked in 4.0.0 Gold

[way2xtreme]

Hello,

Do you have a way for this to work in forum sidebar?

Thanks
WC

[NNJJ]

any screen please?

[Massamo]

been away sorry have a look at it now redo it for new version

[abroad]

does not work for 4.08

[abroad]

this does not work anymore with vb 4.1.

[Sean S]

Works like a charm on vB 4.1.1 based on the updated code. I don't have the CMS so I added this to my forum home's sidebar,

http://www.amgpower.com/forums/forum.php

Thanks

[DirtRider]

I get the latest picture widget showing up but with nothing in it?