Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Moving all images from one album to another  (Read 6179 times)

0 Members and 1 Guest are viewing this topic.

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4886
    • Windsurf.me
Moving all images from one album to another
« on: July 31, 2007, 10:46:12 am »

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
« Last Edit: July 31, 2007, 07:36:28 pm by Nibbler »
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Nibbler

  • Guest
Re: Moving all images from one album to another
« Reply #1 on: July 31, 2007, 10:56:22 am »

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.
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4886
    • Windsurf.me
Re: Moving all images from one album to another
« Reply #2 on: July 31, 2007, 07:23:16 pm »

Cheers Nibbler. It worked a treat ;D.

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

madhatt

  • Coppermine novice
  • *
  • Country: 00
  • Offline Offline
  • Posts: 20
Re: Moving all images from one album to another
« Reply #3 on: August 01, 2007, 09:00:50 pm »

Thanks Nib, works great for me too.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 20 queries.