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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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