List of images on board

[john123]

Hi I have only recently started to use this superb script and it is proving very good so far.

I wish to be able to list the images on the boards either by title or image name or both for admin purposes. I need the list as a "check off" menu which I can print out.

I have searched the forum but can not find anything that relates.

Has anyone got any ideas how I can achieve this result.
Thanks John

[Tranz]

What "board" are you referring to?

[john123]

sorry - I didn't make myself too clear.

I would like a text list of the images that are in my galleries either by title or image name that I could then print out.

Is that possible?
John

[Tranz]

Yes, it's possible. Someone who's a mysql superstar could come up with the code. Sad to say I'm not that superstar.

[steverobbins]

http://www.steverobbins.co.uk/gallery/viewtitle.php

Is this what you are looking for, if so, I'll post the code, it's quite simple but I'm not going to support it, it's just a quick hack from my own website.

Regards
Steve.

[john123]

Hi Steve
That is very close to what I was looking for except i didn't want a list of the albums - I wanted a list of the actual photos (files) - could your hack do that?

John

[Nibbler]

Just save this code into a file, upload it into your Coppermine folder and run it from your browser.

Code Select Expand


<?php

define('IN_COPPERMINE', 1);

require 'include/init.inc.php';

$result = cpg_db_query("SELECT filepath, filename FROM {$CONFIG['TABLE_PICTURES']} ORDER by filepath, filename");

while ($file = mysql_fetch_assoc($result)) echo $file['filepath'] . $file['filename'] . '<br />';