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: Getting last date uploaded on page outside Coppermine  (Read 2225 times)

0 Members and 1 Guest are viewing this topic.

johnner

  • Coppermine newbie
  • Offline Offline
  • Posts: 7
Getting last date uploaded on page outside Coppermine
« on: January 04, 2006, 07:12:43 pm »

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.
Logged

Nibbler

  • Guest
Re: Getting last date uploaded on page outside Coppermine
« Reply #1 on: January 04, 2006, 07:21:29 pm »

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

Code: [Select]
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().
Logged
Pages: [1]   Go Up
 

Page created in 0.017 seconds with 21 queries.