forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: ashsimmonds on August 01, 2007, 12:44:35 pm

Title: Filename ⇒ File title - ONLY rename those without a title...?
Post by: ashsimmonds on August 01, 2007, 12:44:35 pm

i assume this shouldn't be too difficult... i would like to have it so that when i run a batch command from the Admin Tools which updates File Titles to whatever the FileName is, that it ONLY updates those where a title doesn't exist.

i *almost* pressed the button on my whole gallery before i thought of this, so i tested on a single album and found that this tool overwrites existing Titles, would rather not do that.

Title: Re: Filename ⇒ File title - ONLY rename those without a title...?
Post by: Nibbler on August 01, 2007, 01:45:17 pm

util.php, change

Code: [Select]

$query = cpg_db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET title = '$newtitle' WHERE pid = '$pid'");
to

Code: [Select]

$query = cpg_db_query("UPDATE {$CONFIG['TABLE_PICTURES']} SET title = '$newtitle' WHERE pid = '$pid' AND title = ''");

Title: Re: Filename ⇒ File title - ONLY rename those without a title...?
Post by: ashsimmonds on August 01, 2007, 02:22:07 pm

excellent!  thankyou very much. :)

fwiw, i think this should be standard behaviour.

also, it still lists all the files *as if* it changed them, but doesn't change them.  probly easy enough to fix but it werks good enough for me for now.

Title: Re: Filename ⇒ File title - ONLY rename those without a title...?
Post by: Joachim Müller on August 01, 2007, 07:09:52 pm

Quote from: ashsimmonds on August 01, 2007, 02:22:07 pm

fwiw, i think this should be standard behaviour.

You're right: I've added this to the todo list of the dev team (provide a checkbox that is labelled something like "only apply this if the file name field is empty" or similar and apply the needed code changes).