forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: john123 on February 09, 2006, 03:54:37 pm

Title: List of images on board
Post by: john123 on February 09, 2006, 03:54:37 pm

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

Title: Re: List of images on board
Post by: Tranz on February 09, 2006, 04:58:07 pm

What "board" are you referring to?

Title: Re: List of images on board
Post by: john123 on February 09, 2006, 05:36:30 pm

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

Title: Re: List of images on board
Post by: Tranz on February 09, 2006, 05:40:32 pm

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

Title: Re: List of images on board
Post by: steverobbins on February 09, 2006, 05:52:26 pm

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.

Title: Re: List of images on board
Post by: john123 on February 09, 2006, 08:22:13 pm

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

Title: Re: List of images on board
Post by: Nibbler on February 09, 2006, 09:08:28 pm

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

Code: [Select]

<?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 />';