Here is something I took out of the nuke port and modified to work for the standalone, now I didn't test this but it should work let me know we can post it under hacks...
<?php
// ------------------------------------------------------------------------- //
// Coppermine Photo Gallery 1.2.0 //
// ------------------------------------------------------------------------- //
// Copyright (C) 2002,2003 Gregory DEMAR <gdemar@wanadoo.fr> //
// http://www.chezgreg.net/coppermine/ //
// ------------------------------------------------------------------------- //
// Updated by the Coppermine Dev Team //
// (http://coppermine.sf.net/team/) //
// see /docs/credits.html for details //
// ------------------------------------------------------------------------- //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// ------------------------------------------------------------------------- //
// hack from the nuke port for the standalone version //
// by gtroll //
// modify aid!=4 AND aid!=6 AND aid!=7 //
// to fit the album(s) you want not to show //
// ------------------------------------------------------------------------- //
define('IN_COPPERMINE', true);
require('include/init.inc.php');
$numberpic=5; // you can change the number of pictures here
global $prefix, $dbi;
function truncate_string444($str)
{
$maxlength = 20; // maximum lenght of name in block
if (strlen($str) > $maxlength)
return substr($str, 0, $maxlength)." ...";
else
return $str;
}
$content="<center>";
$result = db_query("SELECT count(*) from cpg_pictures WHERE aid!=4 AND aid!=6 AND aid!=7", $dbi);
$nbEnr = mysql_fetch_array($result);
$count = $nbEnr[0];
while ($stop<$numberpic)
{
srand(time()+$stop);
$random_number = rand(0, $count-1);
$result2 = db_query("SELECT pid, aid, filepath, filename from cpg_pictures WHERE aid!=4 AND aid!=6 AND aid!=7 AND approved='YES' LIMIT $random_number,1", $dbi); // aid numbers can be changed as need to respect permissions
$picture = mysql_fetch_array($result2);
$img = "<img src=\"{$picture['filepath']}thumb_{$picture['filename']}\" border=\"0\">";
$content .= "<a href=\"displayimage.php&album=random&cat=&pos=-{$picture['pid']}\">$img<br>" . truncate_string444($picture['filename']) . "</a><br><br>";
$stop++;
}
$content .= "<br><a href=\"index.php">Go to gallery</a></center>";
print $content;
?>
include this where you want the images to show or save as a file and include in your main page like
<? include('pathname/filename');?>