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: How to get the ids of the albums in the gallery?  (Read 9611 times)

0 Members and 1 Guest are viewing this topic.

brem

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • BREM experience
How to get the ids of the albums in the gallery?
« on: September 07, 2006, 11:21:13 pm »
Well, title says it all.

thansk :P
Logged
coppermine embarked system integrator
birdietechnologies.com
martinbreton.com

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: How to get the ids of the albums in the gallery?
« Reply #1 on: September 08, 2006, 01:28:22 am »
Quote from: brem on September 07, 2006, 11:21:13 pm
Well, title says it all.

thansk :P


What, you mean the album id's?  Like just a list...

1
2
3
4
5
6

etc?

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

brem

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • BREM experience
Re: How to get the ids of the albums in the gallery?
« Reply #2 on: September 08, 2006, 04:20:41 pm »
Yes.

Because I can't (we can't) assume that all indexes are used. Some of them could have been erased during the lifetime of the gallery.


Logged
coppermine embarked system integrator
birdietechnologies.com
martinbreton.com

Nibbler

  • Guest
Re: How to get the ids of the albums in the gallery?
« Reply #3 on: September 08, 2006, 04:35:40 pm »
Is this related to cpmFetch?

Just run an sql query to collect them all:

Code: [Select]
SELECT aid FROM {$CONFIG['TABLE_ALBUMS']}
Logged

brem

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • BREM experience
Re: How to get the ids of the albums in the gallery?
« Reply #4 on: September 08, 2006, 04:41:23 pm »
True that. I just thought cmpfetch would have a ready function for that... since you can use indexes in parameters... i don't know... I guess I don't yet have set my mind on how I should be using coppermine / cmpfetch yet.

Basically, I want to be able to use coppermine, as a easy and ready mean to add, remove albums and media (pitures and video, sounds), but I want to use this content outside of coppermine, in a web application.

So I want the users of my application to be able to parse through albums and medias therein.
I know I can do it all by sql queries, but I'm lazy (a programmer quality), and I was hoping there would be an api to make it easier to retrieve information.

There. You have my story now. :)
Logged
coppermine embarked system integrator
birdietechnologies.com
martinbreton.com

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: How to get the ids of the albums in the gallery?
« Reply #5 on: September 08, 2006, 06:13:29 pm »
There's an api, but no api documentation yet ;)
Logged

brem

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • BREM experience
Re: How to get the ids of the albums in the gallery?
« Reply #6 on: September 08, 2006, 06:26:54 pm »
Do I have to download the plug-ins package?
Logged
coppermine embarked system integrator
birdietechnologies.com
martinbreton.com

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: How to get the ids of the albums in the gallery?
« Reply #7 on: September 08, 2006, 08:38:38 pm »
no, not related.
Logged

brem

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • BREM experience
Re: How to get the ids of the albums in the gallery?
« Reply #8 on: September 08, 2006, 09:01:38 pm »
GauGau, the API you are referring to, is it the "main" php files of coppermine or another package?

thanks...
Logged
coppermine embarked system integrator
birdietechnologies.com
martinbreton.com

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: How to get the ids of the albums in the gallery?
« Reply #9 on: September 09, 2006, 05:43:54 am »
Logged

vuud

  • Moderator
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1803
  • [cpmfetch.fistfullofcode.com]
    • Fist Full Of Code
Re: How to get the ids of the albums in the gallery?
« Reply #10 on: September 10, 2006, 05:07:18 pm »
Quote from: brem on September 08, 2006, 04:20:41 pm
Yes.
Because I can't (we can't) assume that all indexes are used. Some of them could have been erased during the lifetime of the gallery.

Brem, I answered another question that could easily be modified to collect all of the Album Id's.  Not as good as a cpmFetch built in function, but it would work...

http://forum.coppermine-gallery.net/index.php?topic=36045.msg169416#msg169416
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

brem

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 6
    • BREM experience
Re: How to get the ids of the albums in the gallery?
« Reply #11 on: September 11, 2006, 04:14:37 pm »
Muchos gracias, as they say in Mexico to both of you vudd and Gaugau. :)
Logged
coppermine embarked system integrator
birdietechnologies.com
martinbreton.com
Pages: [1]   Go Up
« previous next »
 

Page created in 0.016 seconds with 13 queries.