Moving all images from one album to another Moving all images from one album to another
 

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]

Main Menu

Moving all images from one album to another

Started by phill104, July 31, 2007, 10:46:12 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

phill104

Once every 6 months I move older images from one folder into an archive folder*, remove the old album and create a new one. At the moment I have to move each file individually which is quite time consuming. Is there a simple way to move all files from one album to another?

*It is a windsurfing website so each season gets replaced with a new one and any more than 4 seasons ago get archived in an album rotation sort of way.

http://www.windsurf.me.uk
It is a mistake to think you can solve any major problems just with potatoes.

Nibbler

Assuming you mean 'album' and not 'folder', the simplest way is to run an SQL query.

UPDATE cpg_pictures SET aid = <newaid> WHERE aid = <oldaid>

Replace <newaid> <oldaid> and cpg_ as appropriate, backup the table before running.

phill104

It is a mistake to think you can solve any major problems just with potatoes.

madhatt