DUPLICATE ALBUMS IN OTHER CAT

[johnfelipe]

Hi, please if have a solution, my need is duplicate all albums in a category to other

Tnks

[Αndré]

Instead of creating dupes I suggest to use the album keyword feature:
http://documentation.coppermine-gallery.net/en/albums.htm#album_prop_controls_album_keyword
http://documentation.coppermine-gallery.net/en/keywords.htm#keywords_album

[johnfelipe]

Hi, is true but i need duplicate my albums y other cat but uploading different images.

Tnks

[Αndré]

So you just want to create albums with different content but the same name as in another category? If you don't want to use the album manager, you have to create a corresponding MySQL query or tell me the source and target category IDs if you ask me to create it for you.

[johnfelipe]

So you just want to create albums with different content but the same name as in another category? If you don't want to use the album manager, you have to create a corresponding MySQL query or tell me the source and target category IDs if you ask me to create it for you.

Source and target category IDs?, how do that, phpmyadmin or?

Tnks

[Αndré]

Open each category and search for the parameter cid in your browser's address bar, e.g.

index.php?cat=4

.

[johnfelipe]

Open each category and search for the parameter cid in your browser's address bar, e.g. .

and send you all of them?

[Αndré]

Yes, if you want me to create the code for you.

[johnfelipe]

Yes, if you want me to create the code for you.

Hi again, http://200.116.127.78/nuevasplantillas2013/index.php?cat=4, is four (4) the CID, and have subcategories, i need all albmus, no categorized in http://200.116.127.78/nuevasplantillas2013/index.php?cat=136.

Tnks

[Αndré]

No Coppermine footer, no support! http://documentation.coppermine-gallery.net/en/theme_copyright.htm#theme_copyright

[johnfelipe]

No Coppermine footer, no support! http://documentation.coppermine-gallery.net/en/theme_copyright.htm#theme_copyright

YES you're right, and I told the technicians to be changed, please refresh the page

[Αndré]

Sorry, but I won't click through your gallery to collect the category IDs. Please create a list of all source category IDs.

[johnfelipe]

Sorry, but I won't click through your gallery to collect the category IDs. Please create a list of all source category IDs.

7
8
9
10
11
12
13
14
15
16
17
18
19
20
28
29
45
46
47
48
49
50
51
66
67
119

Tnks

[Αndré]

Here's the prepared SQL statement:

INSERT INTO cpg15x_albums (title, description, visibility, uploads, comments, votes, pos, category, owner, thumb, keyword, alb_password, alb_password_hint, moderator_group, alb_hits, copyright_info) (SELECT title, description, visibility, uploads, comments, votes, pos, 136, owner, thumb, keyword, alb_password, alb_password_hint, moderator_group, alb_hits, copyright_info FROM cpg15x_albums WHERE category IN (7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 28, 29, 45, 46, 47, 48, 49, 50, 51, 66, 67, 119))

If your table prefix isn't cpg15x_, you have to adjust it twice.

[johnfelipe]

Here's the prepared SQL statement:
If your table prefix isn't cpg15x_, you have to adjust it twice.

I have prefix, but with cms content?

[Αndré]

Please just try to execute the SQL statement.

[johnfelipe]

Please just try to execute the SQL statement.

One error:

"#1054 - Unknown column 'copyright_info' in 'field list'"

[johnfelipe]

One error:

"#1054 - Unknown column 'copyright_info' in 'field list'"

I delete two parts with this table, and it works, but CMS field and photo portal is not appear

TNKS

[Αndré]

copyright_info is probably a column I added for somebody's mod in my database, sorry. However, I still don't know how your CMS and "photo portal" is related to your request. If you have modded anything, you have to adjust the query accordingly, as nobody knows your current setup.

[johnfelipe]

copyright_info is probably a column I added for somebody's mod in my database, sorry. However, I still don't know how your CMS and "photo portal" is related to your request. If you have modded anything, you have to adjust the query accordingly, as nobody knows your current setup.

Yes your right, but help me to join to your code cpg15x_cms

Tnks