forum.coppermine-gallery.net
Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: johnfelipe on March 06, 2013, 05:36:06 am
-
Hi, please if have a solution, my need is duplicate all albums in a category to other
Tnks
-
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
-
Hi, is true but i need duplicate my albums y other cat but uploading different images.
Tnks
-
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.
-
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
-
Open each category and search for the parameter cid in your browser's address bar, e.g.
index.php?cat=4
.
-
Open each category and search for the parameter cid in your browser's address bar, e.g. .
and send you all of them?
-
Yes, if you want me to create the code for you.
-
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
-
No Coppermine footer, no support! http://documentation.coppermine-gallery.net/en/theme_copyright.htm#theme_copyright
-
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
-
Sorry, but I won't click through your gallery to collect the category IDs. Please create a list of all source category IDs.
-
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
-
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.
-
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?
-
Please just try to execute the SQL statement.
-
Please just try to execute the SQL statement.
One error:
"#1054 - Unknown column 'copyright_info' in 'field list'"
-
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
-
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.
-
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
-
I am sorry if I misunderstood the topic, but I also really need to place the album in several categories. How to do it.
-
help me to join to your code cpg15x_cms
I don't know what you're asking for.
I also really need to place the album in several categories
An album always belong to exactly one category. You could use the album keyword feature if you want to display the same pictures in different albums without uploading them more than once to your gallery. I suggest to start a thread of your own if you don't find a solution in our boards or the docs.
-
I don't know what you're asking for.
How integrate cpg15x_cms table, title and content fields in your code
Tnks
-
Instead of asking the same question again and again you should explain what exactly you want to accomplish. I guess you want to display some data from the MiniCMS plugin for your cloned albums?
-
Instead of asking the same question again and again you should explain what exactly you want to accomplish. I guess you want to display some data from the MiniCMS plugin for your cloned albums?
exactly tnks for compression
-
You'll need to find out the connected IDs of the old and new albums, which is probably an annoying task. If you again provide a list, please do it the following way:
OLD_ID1,NEW_ID1
OLD_ID2,NEW_ID2
OLD_ID3,NEW_ID3