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: order album by last added and album pos column always 0 (zero)  (Read 3047 times)

0 Members and 1 Guest are viewing this topic.

xam

  • Coppermine newbie
  • Offline Offline
  • Posts: 1
order album by last added and album pos column always 0 (zero)
« on: February 20, 2005, 11:57:51 am »

Hi,

I was trying to use the tip posted at http://forum.coppermine-gallery.net/index.php?topic=1379&postdays=0&postorder=asc&highlight=order+date&start=0
about adding DESC to get the album list displayed by "created last".

But this does not work since all albums created via the xppublish mechanism seem to to always set pos to 0 (zero).
Albums created by hand seem to work ok.

Thus I "hacked" my way around it and put in order by a.aid DESC instead (which now relies on aid to always be higher on newer albums).

But anyhow this only give me "half" of what i want.
I would like the album list to be sorted by "last added picture date" - so most recent additions comes first.

Any tips on doing that ?

Best regards,
Max
Logged
Pages: [1]   Go Up
 

Page created in 0.023 seconds with 19 queries.