forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: seanophobia on June 11, 2005, 07:53:49 pm

Title: Search Keywords Question
Post by: seanophobia on June 11, 2005, 07:53:49 pm

Is there any way to add search keywords to all pictures in a album, because i wish to add the same keywords to all the files in the album, but going through and adding to each pic is improbably when many of my albums have 1000+ pics...?

Title: Re: Search Keywords Question
Post by: Nibbler on June 12, 2005, 03:35:04 pm

You can apply the keywords directly from the database using phpmyadmin.

Code: [Select]

UPDATE cpg_pictures SET keywords = CONCAT(`keywords`, ' yournewkeyword') WHERE aid = 123
Use the prefix you chose during installation instead of cpg_ and the album number you want to update instead of 123. Backup your pics table beforehand.