How can I move a Public Album to Private "Member Gallery"...

[FizzGiGG]

Hello guys and gals, I am looking for assistance with a large task I have.  I am in the process of migrating from Menalto to CPG, and I am using the convertor written by Aditya Mooley at THIS LINK.  The script is working great, and I am greatful to Aditya for providing it to the community.

My problem is that the albums I am moving are ending up in the index of the Gallery.  The albums are actually "member galleries" (or at least need to be), and have to be moved to the appropriate member gallery.  Currently the way things are it is not an option (at least I don't see it).  Is there a way to move an album into a specific member gallery (/userpic/username/album) AND make them the owner of the album and files etc.?

I have a few thousand files and a bunch of albums that have to be moved.  Any kind of help I can get would be so very helpful.

Thanks!

user: cpgtest
pass: test

SOHCHonda.com
SOHCHonda.com Gallery

[Joachim Müller]

as far as I know there's no control in coppermine's user interface to accomplish this, but if you know your way around in phpMyAdmin you should be able to do what you're up to: you'll have to loop through the albums table and modify the entries in the category column to move the albums from public categories into personal ones. In coppermine's pictures table, you'll have to edit the owner_id column to reflect the user_id of the user (this is quite a huge task, I suggest reviewing the idea to grant people ownership of their files if you have many thousands of them).
If you don't want to edit all of those entries manually in phpMyAdmin, you'll have to come up with some queries to run in phpMyAdmin's sql tab or even write a small php script that does the needfull. Once you successfully converted your db from menalto to coppermine, make sure to create a dump of your mysql tables - there might go something wrong when directly messing with the core db entries.

[FizzGiGG]

Well, I could maybe come up with a query or two but I am definitely not proficient at SQL.  I can query a few things, but to manipulate the data would be a disaster.  Maybe someone would be willing to write something for me? It can just be SQL, no need for an actual php script. (unless they are feeling ambitious )

Thanks for the reply gaugau,