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: Upload Dates  (Read 2343 times)

0 Members and 1 Guest are viewing this topic.

Fallen310

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Upload Dates
« on: January 31, 2008, 01:19:54 am »

Hi im new here, just looking for some help in something. I searched the boards but for some reason couldnt respond to that thread and it didn't have my answer really ..

I wanted to know if its possible to change the uploaded date on a gallery's album such as "Last Uploaded on July 1st, 2007"
From research i see it is possible, but i am very confused about the MySQL coding that i have found. Im not sure what is supposed to be in the fields,

This is the code i found but it doesn't seem to work when i enter it and hit "Go"

`cpg_pictures` SET ctime='1067890006' WHERE `filepath` LIKE '10001/'


So .. what do i put in place of "filepath" and "LIKE"

Thanks for the help! Please assist asap if possible!
Logged

Fallen310

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Upload Dates
« Reply #1 on: January 31, 2008, 08:24:26 pm »

Anyone? I really need help and need this answer before the weekend - i don't mean to sound pushy or anything

Please answer ...
Logged

Nibbler

  • Guest
Re: Upload Dates
« Reply #2 on: January 31, 2008, 08:30:40 pm »

You shouldn't manually edit the database if you have no idea what you are doing...

You don't change filepath to anything. filepath is the name of a database field.
You don't change LIKE to anything because LIKE is part of the SQL command.

The only things to change are the number you are setting ctime to, the path you are checking against, and possibly the table name prefix. You also need to add the command UPDATE at the start of the line you posted.
Logged

Fallen310

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Upload Dates
« Reply #3 on: February 04, 2008, 10:08:51 pm »

Ive manually edited things before in the database but im really looking to need to change the upload dates. I don't think it should be too hard but i think i need a little bit more tips
Do you have a sample code i could look at, like the one to change the view counts in the database, and tell me where to put them in the database for changing upload dates?


Logged

Fallen310

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: Upload Dates
« Reply #4 on: February 04, 2008, 10:12:29 pm »

Also -- if you do change the upload dates, do the files in the table "Last Uploaded" move around into last uploaded order, like by 'date order' in which they were last uploaded??
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 21 queries.