Coppermine upload date

14 May 2005 · 0 comments

It’s taken me ages to locate this information and I don’t want to lose it. I have a couple of clients, the Janne Land Gallery and Momentuos, whose websites use Coppermine. I want to be able to edit the date and time a picture was uploaded. The trick is to edit the ctime in the [...]

 

It’s taken me ages to locate this information and I don’t want to lose it. I have a couple of clients, the Janne Land Gallery and Momentuos, whose websites use Coppermine. I want to be able to edit the date and time a picture was uploaded.

The trick is to edit the ctime in the MySQL database:

Upload date would be ctime, mtime is last viewed date.

The time’s stored in a special format:

the value you see for ctime is a timestamp, representing a date … The number is the number of seconds which have passed since January 1st 1970.

A handy utility for converting between human time and the number of seconds is Online Tools: Unix Timestamp Converter.

The query itself looks like this: UPDATE `cpg_pictures` SET ctime='1067890006' WHERE `filepath` LIKE '10001/'

Clip to Evernote

Be the first to comment ⇒

Tell us what you think.
Note: there may be a delay before your comment appears. I now approve all comments from new visitors, in an attempt to keep spam at bay.

Add your Comment

Older Post:

Newer Post: