Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: List of images on board  (Read 3253 times)

0 Members and 1 Guest are viewing this topic.

john123

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
List of images on board
« 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
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: List of images on board
« Reply #1 on: February 09, 2006, 04:58:07 pm »

What "board" are you referring to?
Logged

john123

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: List of images on board
« Reply #2 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
Logged

Tranz

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Female
  • Posts: 6149
Re: List of images on board
« Reply #3 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. :(
Logged

steverobbins

  • Contributor
  • Coppermine novice
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 35
  • photographer
    • Steve Robbins' Personal Website
Re: List of images on board
« Reply #4 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.

john123

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: List of images on board
« Reply #5 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
Logged

Nibbler

  • Guest
Re: List of images on board
« Reply #6 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 />';
Logged
Pages: [1]   Go Up
 

Page created in 0.021 seconds with 20 queries.