forum.coppermine-gallery.net
Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Fallen310 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!
-
Anyone? I really need help and need this answer before the weekend - i don't mean to sound pushy or anything
Please answer ...
-
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.
-
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?
-
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??