Latest Album Picture v2

[Massamo]

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;she et=album.css" />

<link rel="stylesheet" type="text/css" href="css.php?styleid=1&amp;langid=1&amp;d=1260794007&amp;td=ltr&amp;she et=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]

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 :cool:

[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

[merlin_de]

Hello,
it works not in my cms. There is a Box with the title "Latest Picture", but without content. I have upload a new albumpicture, but nothing happens.
In the Template "cms_albums_almbumsbits" is a href to "album-picture.php". Where can i find this file ?
Greets,Micha

[Allan]

Do you have one screen please ?

[merlin_de]

Hello Allan,
many thanks for your answer. I can?t believe it: I had deleted the old (and incompatible) vB3 Styles in the ACP now, and it works:eek:. Maybee this will help other users who have problems with this nice widget.
However, here my screenshot from a working hack ;)

https://vborg.vbsupport.ru/external/2009/12/67.jpg

Greets,Micha

[abroad]

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

[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

[AWMGolfer]

Is there a way this can work on the new forum sidebar?

[AndrewSpearin]

Thanks for this, I was able to adapt it to suit a needed feature perfectly :)

http://npac.ca/2010

[abroad]

there is a problem with pictures which are set to private. Those are not displayed. The album is only displayed empty. They need to be filtered out.

[Massamo]

This will fix the problem updated first post too


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 albumpicture.*, album.*, user.username, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "attachment AS albumpicture
LEFT JOIN " . TABLE_PREFIX . "album AS album ON(album.albumid = albumpicture.contentid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = album.userid)
WHERE album.state = 'public' and albumpicture.contenttypeid = '8'
ORDER BY $orderby DESC LIMIT 0, $hm
");


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

while ($lpicture = $db->fetch_array($lpictures))
{
$lpicture['musername'] = fetch_musername($lpicture);
$lpicture['title'] = trim(strip_quotes($lpicture['title']));


$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;

[abroad]

thanks a lot!

[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]

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]

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 :D

[aberg]

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?

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

[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 :D

[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]

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]

^^ 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>

[Juggernaut]

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

[svandanam]

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?

[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! :D

[benative]

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! :D

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!