General Support: How to include an album with only the x last thumbs to appears

Hi there, let me tell you first your script is neat! Thank you very much !

I have a question i can't solve by myself : I'm including an album in some php pages and it's working great.
Can you tell me if there's a way, to include an album with only, let say, the last 3 photos added in this album ?

My php include is calling the url photos/?level=album&id=2, is there by example a variable i could add in this url to specify i want only the X last photos of this album to appear in my include ??

Thank you for helping me !

There is a script that I use to display the latest 3 images added to my Plogger gallery on an external page. Perhaps you could modify that to do what you are wanting?

This is the script that I use. It displays the latest 3 images added to the entire gallery, not one specific album, and it does indeed link you directly to the large image of each of the thumbs.

You need to change the result for the variables $siteurl and $amount to match your plogger install and the number of images you want displayed. You also need to change the url in the tag at the end to match your plogger install.

Save this code as latest-images.php, upload it to your plogger directory (same level as the files included in the beginning of the code), then add a php include ( <?php include('ploggerdirectory/latest-images.php'); ?> ) to the page you want to display the thumbnails on.

<?php
include_once("plog-globals.php");
include_once("plog-load_config.php");
include_once("plog-functions.php");

global $config;

$amount="3"; //How many images do you want shown?

//The URL of your Plogger directory E.G. http://yoursite.com/ploggerdirectory ***IMPORTANT*** DO NOT INCLUDE A TRAILING SLASH
$siteurl="http://www.yourdomain.tld/ploggerdirectory";

$q = "SELECT * from plogger_pictures order by `id` DESC LIMIT $amount";
$result= mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$path=$row["path"];

$number=strrpos($path, '/');
$number=$number+1;
$url=substr($path, $number);
?>

<a href="<?php echo "$siteurl"; ?>/index.php?level=picture&id=<?php echo "$id"; ?>"><img class="imgborder" src="http://www.yourdomain.tld/ploggerdirectory/thumbs/<? echo "$id"; ?>-<?php echo "$url"; ?>" border="0" /></a><br /><br />
<?php } ?>

I have a css class assigned to the thumbnails (class="imgborder") that I use to style the thumbs on the page where they are displayed. Here's what I use - you can alter it or remove it, depending on what your needs are.

.imgborder {
background-color: #eee;
border: 2px solid #999;
padding: 5px;
}

Quick question, the latest-images.php script works great but how would you invoke it from within a html page?

If anyone wants to only show the latest x-images from a specific collection instead of the whole gallery just change this:
$q = "SELECT * from plogger_pictures order by `id` DESC LIMIT $amount";
with:
$q = "SELECT * from plogger_pictures WHERE `parent_collection` = 2 order by `id` DESC LIMIT $amount";
and change the `parent_collection` = X to match the number of the collection you want the pictures to be displayed from.