Moving picture directories Moving picture directories
 

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

Main Menu

Moving picture directories

Started by Concorde Rules, December 09, 2006, 06:17:25 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Concorde Rules

right, I run www.concorde-photos.co.uk.

The G-BBDG section has been going in one folder, so 2004, 2005 and 2006 photos are all in one folder, making it dam hard to find adding new folders.

I want to move the folders into another folders with the respective year, so 2005 photo folders go into a 2005 folder.

Using this link:
http://forum.coppermine-gallery.net/index.php?topic=32477.0

I see I have to use PHP My admin, I've basically familar with it.

Now its says this:

UPDATE cpg_pictures SET filepath = '/new/file/path/' WHERE filepath = '/old/file/path/';


Im not *quite* sure how it should be.


Lets say I want to move the 2nddecember2006 folder to 2006.

Would it be:
UPDATE cpg_pictures SET filepath = '/albums/concorde/202_bbdg/2006/2nddecember2006' WHERE filepath = '/albums/concorde/202_bbdg/2nddecember2006';



Would this be run in: Run SQL query/queries on database (Main one or cpg_pictures?)

Cheers :)


Concorde Rules

ahaha, lol! dont it myself.

Easy that :)

Just takes a while..

Gotta update the site while im at it, new updates every week it seems ;)