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

[kevinfx]

how do i display pix in 2 column (side by side like this : pix 1 | pix 2

thanks

[Verionia]

How do I display this as a block on the forum?

[ARadarDetector]

I added this to my cms homepage: http://www.Radar-Detector.net

As you can see the pictures don't fill that box up fully, I went into template to make the edit to make it bigger not sure which one i need to increase? How would I make the preview images seen on my homepage appear bigger to fill out the boxes more?

Thanks!

[gsipromotions]

Originally Posted by woffie

I get an error when I use this.

Fatal error: Call to a member function query_read() on a non-object in /home/myforums/public_html/myforums/forums/packages/vbcms/widget/execphp.php(171) : eval()'d code on line 6

Yep, I got that as well.

[worried]

The center tag in your script isn't working for me. I think there is css from the album.css or picture.css that fixes the left margin. However, I see ARadarDetector's is centered perfectly. I have mine installed in vB 4.0 Gold.

[kersti]

How do I add in two new templates?

[antua al toro]

Originally Posted by kersti

How do I add in two new templates?

+1
i wonder
maybe i don't get it, spend 3 hours and didn't find how to add new templates.
help, please

[ahmedipa]

thank you so much

[Juggernaut]

Thank you very much for this widget, it's awesome

[aberg]

Originally Posted by abroad

the pictures need to be larger...how is it possible to change it?

That's my question to, but there is no answer yet.
Is there someone who knows a solution?

Originally Posted by kersti

How do I add in two new templates?

In the admin menu go to Styles & Templates.
Click on Style Manager
In the drop down menu click on Add New Template.
If you have more styles you must add templates for each style