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: Backdating pictures / Setting a creation date  (Read 2209 times)

0 Members and 1 Guest are viewing this topic.

morningstar

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Backdating pictures / Setting a creation date
« on: August 10, 2009, 09:47:38 pm »

Sorry if this is in the wrong place/repeat of a previous topic. I've looked and looked and looked all over the forums and in the docs and have not been able to find anything about this topic. Also, CPG-contrib.org is down, so if there's anything there about this, then I haven't been able to read it. :-[

Does Coppermine support image backdating or the ability to specify a creation date, either naively or thorough a plugin or hack? I have a lot of material dating back several years that I'd like to post, displaying from newest first to oldest last. Being able to backdate or otherwise sort by some kind of creation date would make uploading and managing all of these pictures so much easier, especially if I run across old work in the future and decide to post it.

I'm using CPG 1.4.25 that's been bridged successfully with phpBB3.0.2.

Thanks :)
Logged

onthepike

  • Guest
Re: Backdating pictures / Setting a creation date
« Reply #1 on: August 11, 2009, 12:34:58 am »

I believe this is very possible via phpMyAdmin (or equivalent), though I haven't tried it or sought an option to do so within Coppermine. I'm sure if there's a way to do so via CPG, someone will chime in with a better suggestion.

Meanwhile, I believe you can accomplish this via accessing phpMyAdmin, selecting your Coppermine database, selecting cpg_pictures, click browse in the upper tab, then manually edit the mtime entry. I believe that the ctime entry will change automatically as the image is updated, but I'm not 100% sure. If not, or if ctime needs also be changed, you'll need a Unix time converter. You can find one here: http://www.onlineconversion.com/unix_time.htm

I don't advise "tinkering" with the database unless you're sure you know what you're doing. Merely a suggestion here. But if you do decide to edit the database, please make a backup first. And be sure the backup isn't corrupt. If you download a copy of your database, and open it to find an error or warning message, I would first seek guidance for that issue before proceeding. Best to be safe before anything else.

Hope this helps some. Lately, my help hasn't been very good :(
Logged

Pascal YAP

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: fr
  • Offline Offline
  • Gender: Male
  • Posts: 13833
  • Hello World :-)
    • CPG 1.5.x ExperiMental website
Re: Backdating pictures / Setting a creation date
« Reply #2 on: August 11, 2009, 01:12:00 am »

via PhpMyAdmin, go to Tables about your files (cpgxxx_pictures) and modify Ctime parameter.

Try this URL to obtain a new Ctime code =>
http://www.4webhelp.net/us/timestamp.php
Logged

morningstar

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: Backdating pictures / Setting a creation date
« Reply #3 on: August 11, 2009, 01:26:05 am »

I just went into the database and checked what you mentioned, and this backdating would totally be possible by manually editing the mtime and possibly ctime if it doesn't auto correct. Unfortunately it seems like having to manually edit both the ctime and mtime would be really labor intensive, especially for large numbers of pictures (200+). So, possible in theory but not really practical in execution. Thanks for posting about it, though. :) I'm still green when it comes to stuff like this, but I'm glad to learn more about how the database functions.

Unfortunately, this seems like it would have the negative side effect of messing up the most recently posted filmstrip if both the mtime and ctime are changed.

I'm thinking a plugin would have to add an extra field within _pictures where the user can manually enter a creation date on upload, and then it would also have to add an option in the display dropdown menu to make Coppermine sort by date in this new field while still allowing it to index new uploads based on the ctime/mtime. I think. I'm just guessing. ;D

I'm hoping this kind of plugin already exists.  :)
Logged
Pages: [1]   Go Up
 

Page created in 0.032 seconds with 20 queries.