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: album/cat id and album/cat name  (Read 7543 times)

0 Members and 1 Guest are viewing this topic.

cocostaff

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
album/cat id and album/cat name
« on: March 09, 2007, 01:30:47 pm »

Is there a simple way to get a list of Album name & Album id ?? same question for category. How the id is determined by coppermine ? Does it correspond to the rank of the album in the coppermine albumlist ?

Thanks !
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: album/cat id and album/cat name
« Reply #1 on: March 09, 2007, 02:19:13 pm »

The album and category IDs are counted upwards, so the time of creation is the criteria that is being taken into account. Not sure if cpmFetch contains a method to populate an array/list of existing albums or categories.
Logged

cocostaff

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Re: album/cat id and album/cat name
« Reply #2 on: March 09, 2007, 03:42:13 pm »

so there is no direct way to know the specific ID of an album/cat... do you think it is possible to perform a database query to list the album ID in front of the album names ?

Logged

Nibbler

  • Guest
Re: album/cat id and album/cat name
« Reply #3 on: March 09, 2007, 03:55:11 pm »

Just go into phpmyadmin and browse your album and category tables.
Logged

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: album/cat id and album/cat name
« Reply #4 on: March 09, 2007, 04:20:05 pm »

so there is no direct way to know the specific ID of an album/cat... do you think it is possible to perform a database query to list the album ID in front of the album names ?



I think you could use CpmFetch, have it return a result set and output based on that.  I figure since it is posted here, I would suggest a cpmfetch orienteed solution.

:)

Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco

cocostaff

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
Re: album/cat id and album/cat name
« Reply #5 on: March 09, 2007, 04:38:47 pm »

Nibbler's solution is simple and work well, you can export the entire coppermine_albums table in csv file ! Thanks

Vuud, i think that a cpmfetch oriented solution will be great, and calling album_title in cpmfetch function  instead of id can be more efficient.
Logged

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: album/cat id and album/cat name
« Reply #6 on: March 09, 2007, 05:07:37 pm »

Nibbler's solution is simple and work well, you can export the entire coppermine_albums table in csv file ! Thanks

Vuud, i think that a cpmfetch oriented solution will be great, and calling album_title in cpmfetch function  instead of id can be more efficient.

I probably won't implement that ... I can see the posts, hundreds of them, all due to typos :)

That being said, calling by title may be "easier" for the user, but I doubt a text search in SQL would be more efficent.

People tend to just code in CpmFetch stuff once... for that its easy enough to just look at your gallery in a web page and note the album id or cat id...

Thats my opinion anyway
Logged
Please post for help to the forum... PM me only if you are sending security related items (passwords, security problems, etc).

cpmFetch - Images, RSS feeds from CPG from outside CPG
New release notification signup also. 
See http://cpmfetch.fistfullofco
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.