Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Set image title to albumname  (Read 1923 times)

0 Members and 1 Guest are viewing this topic.

grrrrr

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Set image title to albumname
« 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?
Logged

grrrrr

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Set image title to albumname
« Reply #1 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
Logged
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.