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

[Cees]

Hi, searched for Widget Type: PHP Direct Execution, but couldnt find it. Maybe im in the wrong place , but im going to the widgetmanager choose new widget and then select Widget Type: PHP Direct Execution? Its not in the dropdown. (using Rc2)

[Massamo]

have you updated all the way to rc2 without uploading new php files? it may not be in old files not to sure

[yilmaz]

Originally Posted by Cees

Hi, searched for Widget Type: PHP Direct Execution, but couldnt find it. Maybe im in the wrong place , but im going to the widgetmanager choose new widget and then select Widget Type: PHP Direct Execution? Its not in the dropdown. (using Rc2)

Clear the cache

[ArcadeSyndicate]

thank you, works fine

[worried]

This will definitely be my first vB 4.0 mod. I'll add this once 4.0 is officially released.

[Cees]

That did it, works great. Thanks!

[abroad]

Where can I change the background of each picture? I want to decrease the height of the white box behind the picture so that it has a similar size as the picture. Is this a specific CSS file? Where can I find it?

[ThorstenA]

I think the album permissions are not queried. It's important to not show private albums to the user. It would be nice if I could look at a "friend only" album when I am the friend of that user, of course users that are not befriended with the album author should not be shown the image.

[Massamo]

look into that sometime today it and it uses album.css and picture.css someones the album system uses