Moving picture directories Moving picture directories
 

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 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 ;)