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

[dancop]

Is there a way to limit the widget to pull the pictures from the given album only not from all the albums?

[Juggernaut]

Yes the pictures are to small, but otherwise this is a good widget

[dodgechargerfan]

I like this a lot but I am seeing the same problem as others - the picture is smaller than the box so there's a lot of white background to look at.

[Bergler]

Like this,

[Bergler]

Originally Posted by Bergler

Like this,

How do you fix that?

[Moondust]

I need the last 6 Pictures from ALL Pictures on my Forum.... and display it in the Forumhome under the Navbar.... please code this... many People miss this Addon :-)

[Moondust]

Its not work in 4.0.1 ? Only the Date see, but not a Picture.

[Juggernaut]

^^ It does work on 4.0.1, I have it in my forum, butthis is only for the homepage, it's not
for the navbar, you want New Album Picture Forum Home mod for that.

[Moondust]

Originally Posted by Destron

^^ It does work on 4.0.1, I have it in my forum, butthis is only for the homepage, it's not
for the navbar, you want New Album Picture Forum Home mod for that.

This Widget is for the CMS, really... but is not work... show only the Date from today.


I am search a Mod for all Pictures, not only the Album Pictures :-)

[Juggernaut]

<i>^^ You have to make the template edit as swell, after you create the widget.
Yes a mod for all pictures would be great, and it would be awesome to have
a mod like that.</i>