Print

[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

[Nibbler]

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

Code: [Select]

UPDATE cpg_pictures SET aid = <newaid> WHERE aid = <oldaid>
Replace <newaid> <oldaid> and cpg_ as appropriate, backup the table before running.

[phill104]

Cheers Nibbler. It worked a treat .

[madhatt]

Thanks Nib, works great for me too.