General Support: Random thumbnails on homepage

Hi,
I'd like to setup random thumbnails from my plogger installation to appear on my homepage. I'm switching our club's gallery from Gallery 2(yuck) to Plogger. We use a joomla installation and I'd like to retain some of the features. One of the main features was having a random thumbnail appear on the homepage that was then directed through to the gallery.

Has anyone done this with Plogger?

Fine.Great.its working for me.Can we get output as the mode rewrite URL?.


Thanks !!!
Pandian

anyone?

Hi memic.a,
How can I modify the number of photos showing

HI,

I used the above code, Works great. But I'm not sure exactly where to put the echo.. I put it in index.php but it shows in the head and i can't place it where i'd like. I placed it near the bottom of gallery.php but it remains in the same place.
What file is it i need to place the echo in to make it show elsewhere?

Thanks.

hi memic,

code from above shows random pics and working fine.

how have you on your site generate the cruft-free url for random pics?

i have random thumbs on www.mysite.de/index.htm on my site, plogger is in under-directory www.domain.de/plogger-dir/.
on /plogger-dir/ the cruft-free urls with trailing slash working fine, but on root dir of my site, the links from random thumbs shows www.domain.de/?level=picture&id=1402 instead of www.domain.de/plogger-dir/collection/album/picture/

have you a solution for this problem?

thanks for your help and greetings from germany
uwe

hi memic,

thanks for your help!

i change your code so:


/***Funktion für Zufallsbilder auf der Startseite***/

function get_random_picture() {

$connessione_db=mysql_connect("localhost","your_user","your_password");
mysql_select_db("your_database_name",$connessione_db);
$tabella = 'plogger_pictures';

$offset_result = mysql_query( " SELECT FLOOR(RAND() * COUNT(*)) AS `offset` FROM ".$tabella,$connessione_db);

$offset_row = mysql_fetch_array( $offset_result );

$offset = $offset_row['offset'];

$result = mysql_query( " SELECT id,description,caption,path FROM $tabella LIMIT $offset, 1 ",$connessione_db);

$row = mysql_fetch_array($result);

global $config;

$descrizione = $row['description'];

$path = $row['path'];

$nome = $row['caption'];

$id = $row['id'];

$thumb = generate_thumb($path, $id);

$pic = get_picture_by_id($id);
$album = get_album_by_id($pic["parent_album"]);
$collection = get_collection_by_id($pic["parent_collection"]);
$filename = basename($row["path"]);
$picture_name = substr($filename, 0, -4);

$pic_url = $config['baseurl']."bilder/".$collection['path'].'/'.$album['path'].'/'.$picture_name."/";


$output = '<a class="random-image-link" href="'.$pic_url.'" title="'.$nome.'"> <img id="thumb-'.$id.'" class="photos" src="'.$thumb.'" title="'.$nome.'" alt="'.$descrizione.'" width="158" height="158" /> </a>';

return $output;
}


first added the line:
global $config;

then i put my ploggerdir in to the line and change then from caption to name:
$pic_url = $config['baseurl']."bilder/".$collection['path'].'/'.$album['path'].'/'.$picture_name."/";

then i added two variables:
$filename = basename($row["path"]); / this is the picture name
$picture_name = substr($filename, 0, -4); / delete the *.jpg file-extension from url

now it works on my index, see it here on left down: >> Bilder

...
thanks also to all ploggerianer - plogger is a nice and great gallery script and it make fun.
ciao
PieperLy
ps: ahso, memic,...i live in berlin...and thanks again for your help

a little supplement with a drop of bitterness:
when you use random thumbs on site and use html tags on description, you must remove the "quotation marks"
from it - otherwise show html code beside random thumbs.

@ffd8: There is no need to modify the plog-functions.php file. There is already a plugin that does this built into version 1.0-RC1.

Log into your gallery admin section, hit the Plugins tab, and click the "Use this plugin" link for the Random Images plugin. A white box will appear with the proper code for the php include that you can add to your template.