Print Page - Set image title to albumname

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

coppermine-gallery.com/forum

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