coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: xplicit on January 08, 2006, 01:42:32 AM

Title: Help needed after cleaning up galleries by phpmyadmin
Post by: xplicit on January 08, 2006, 01:42:32 AM
Ok first of all sorry that I ask this question after my pretty stupid action but I thought I was smart but overlooked a part...

My intention was to remove all files from a gallery which had 15 or less hits, there were around 1000 of such files so instead of removing them in coppermine itself file by file I removed them with a very simply query in phpmyadmin. And off course this went all OK.

BUT.. and here is the problem, I (stupid stupid I know) overlooked the fact that it only removed the entry in the database but not the pictures itself...

Is there a way like reversed batch adding (so more batch removing) files which are no longer in the database? I think the solution is something like batch adding but instead of adding the pics and generating thumbs and normals, now removing all (picture) files which are not allready in the database (originals, thumbs and normals).

I can programm php myself but I can't think of a smart solution to programm this.

Can anybody help me, or guide me in the right direction, or perhaps suggest another smart way to remove the not used files anymore.

Thnx in advance for your advice.