Getting last date uploaded on page outside Coppermine

[johnner]

Is there anyway to just get the date that the last image was uploaded?  I would like to include a link on my main page that says Images last uploaded x/xx/xxxx, and then a link to the latest uploads.  Any info would be greatly appreciated.

[Nibbler]

Run a mysql query to get the ctime of the pic with the highest pid.

Code Select Expand

SELECT ctime FROM prefix_pictures ORDER BY pid DESC LIMIT 1

That will give you the unix timestamp for the latest addition which you can format as you like using date().