Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: List of images on board  (Read 3121 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.017 seconds with 19 queries.