order album by last added and album pos column always 0 (zero)

[xam]

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