forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: grrrrr on June 06, 2009, 03:07:47 pm

Title: Set image title to albumname
Post by: grrrrr on June 06, 2009, 03:07:47 pm

Is there an easy way to set the "image title" attribute in my database to the "albumname"?
either by hand, everytime i add new picturesvia an sql-script, or automatically for now and ever?

Title: Re: Set image title to albumname
Post by: grrrrr on June 06, 2009, 04:05:41 pm

by hand:

Code: [Select]

UPDATE coppermine_pictures cp
JOIN coppermine_albums ca ON ( cp.aid = ca.aid )

SET cp.title = ca.title