coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: udgang99 on July 12, 2006, 11:30:13 PM

Title: Change uploader name for picture + change date?
Post by: udgang99 on July 12, 2006, 11:30:13 PM
Two question :

1: Is there a way where I can upload a bunch of pictures, and later change the name of the uploader from me to someone else? Like if I uploaded a picture that wasn't mine, and after the "owner" of that picture has signed up, I change the credite from me to him.

2. I have a bunch of "old" pictures, that I'd like to date back to when they were created. Like if I uploaded a picture today, but wanted to set a "fake" uploaddate to like "january 1st 2001" ? This way, if I sorted the pictures after "date" this (faked) old picture would read as the oldest.
Title: Re: Change uploader name for picture + change date?
Post by: Nibbler on July 12, 2006, 11:36:33 PM
One shall be the number of questions thou shalt ask and the number of the questions shall be one !

You can modify the database directly.

UPDATE cpg_pictures SET `owner_id` = '7' ,`owner_name` = 'user name' WHERE pid = 123

Where 123 is the numberof the pic to change ownership thereof.
Title: Re: Change uploader name for picture + change date?
Post by: udgang99 on July 12, 2006, 11:57:49 PM
Thank you, kind sir!

I take it that that was the answere for question number 1 ... I'll post the second question in another thread, then (here: http://forum.coppermine-gallery.net/index.php?topic=33817.0) !

Again - thanks!!!


****
edit: Hmmmm - seems like I'm not clever enough to actually find that database ... would that be accessible via an ftp-client? Or do I have to go through the mySQl-stuff???

***
edit: I figured it out !!
answer: Yes, I have to go through the mySQL "system"...