coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 upload => Topic started by: ktwenrick on May 10, 2006, 02:09:02 AM

Title: moving user galleries pics to reg. albums
Post by: ktwenrick on May 10, 2006, 02:09:02 AM
I have searched around the boards and found this http://forum.coppermine-gallery.net/index.php?topic=22895.0  but not sure if it can help me since its for 1.3x

i was wondering if anyone has a solution for moving photos that users have uploaded into the User Galleries and allowing the admin (myself) to move them into regular albums, so that they are more organized and visitors can find them much eaiser.. thanks to anyone who can help me.
Title: Re: moving user galleries pics to reg. albums
Post by: wahhsabee on September 12, 2006, 08:00:57 AM
I'm bumping this because it's old and it needs to be addressed.

I'd really love to be able to do this right now. :o

Title: Re: moving user galleries pics to reg. albums
Post by: Joachim Müller on September 12, 2006, 08:11:48 AM
Files can be moved at any time by going to "edit files" next to the thumbnail that represents the album and then using the dropdown field to move the pics.
Title: Re: moving user galleries pics to reg. albums
Post by: wahhsabee on September 18, 2006, 09:17:12 AM
Quote from: GauGau on September 12, 2006, 08:11:48 AM
Files can be moved at any time by going to "edit files" next to the thumbnail that represents the album and then using the dropdown field to move the pics.

This allows you, the admin/s, to move individual files within a user's gallery into any other galleries, but is there a way to move entire albums?

Yes, I can move files within albums by selecting each file within the users album, but that is very time consuming and you risk not selecting the appropriate album (more files to move, more dropdowns, more margin for error).

I might be overlooking something, but is there a way to move whole albums?

Title: Re: moving user galleries pics to reg. albums
Post by: Joachim Müller on September 18, 2006, 09:30:49 AM
Currently, you can't move albums from the user galleries to the public ones using the coppermine UI. Only "fast" option is to use a third-party tool like phpMyAdmin.
Title: Re: moving user galleries pics to reg. albums
Post by: wahhsabee on September 18, 2006, 09:34:46 AM
Thanks for the quick reply!

I see. Are there plans for it in the future?

And can you point me in the proper direction for the mysql queries?

Title: Re: moving user galleries pics to reg. albums
Post by: Joachim Müller on September 18, 2006, 09:39:05 AM
Quote from: wahhsabee on September 18, 2006, 09:34:46 AM
I see. Are there plans for it in the future?
Being considered. Not that easy though, as quota needs to be taken into account.

Quote from: wahhsabee on September 18, 2006, 09:34:46 AM
I see. Are there plans for it in the future?
Use phpMyAdmin's user interface. Change the albums table, modifying the category column. Backup before you start your modifications.
Title: Re: moving user galleries pics to reg. albums
Post by: wahhsabee on September 18, 2006, 09:44:35 AM
Quote from: GauGau on September 18, 2006, 09:39:05 AM
Being considered. Not that easy though, as quota needs to be taken into account.
Use phpMyAdmin's user interface. Change the albums table, modifying the category column. Backup before you start your modifications.


You're a finely tuned, well lubed machine at quick replies!

Thanks for the tips. I'll give it a shot.

I'll report back (hopefully with good news.) :o
Title: Re: moving user galleries pics to reg. albums
Post by: wahhsabee on September 18, 2006, 09:50:58 AM
Holy crap that was easy.

Why didn't I think of that before!

I think even easier than using cpg gui. That would require more clicks!

Title: Re: moving user galleries pics to reg. albums
Post by: DonSpliff on September 19, 2006, 09:22:57 AM
Hello.

Can you explain in a few words how you did it ?

Thanks in advance.
Title: Re: moving user galleries pics to reg. albums
Post by: no way on September 20, 2006, 10:21:11 AM
It's very simple:
First open your phpMyAdmin.
Select your database.
Open  cpg149_albums
View entries and change the number of the category...

that's it
Title: Re: moving user galleries pics to reg. albums
Post by: DonSpliff on September 20, 2006, 02:43:09 PM
Thanks Dude.
Title: Re: moving user galleries pics to reg. albums
Post by: natrlhy on February 23, 2007, 12:01:00 AM
Thanks, this post helped me move an album from one catagory to another.  I also got more comfortable with phpMyAdmin. Modified other fields like the pid, ctime, etc. I made sure I created a backup/dump of the database first though.