Print Page - put a name into images without a name with filename

Title: put a name into images without a name with filename
Post by: daniell on December 04, 2006, 01:07:24 PM

i want to know if theres a way to put the filename ( eg. jessicaalba.jpg ) as the name of that image on cpg!?!?!

maybe with phpmyadmin.. this is possible?!

thankz

Title: Re: put a name into images without a name with filename
Post by: Abbas Ali on December 04, 2006, 01:10:24 PM

Go to "Edit Files" of the album and copy the filenames to the "Title" field. This should solve your purpose i guess.

Title: Re: put a name into images without a name with filename
Post by: daniell on December 04, 2006, 01:16:22 PM

LOL

in 5000 images... :o

i think so

Title: Re: put a name into images without a name with filename
Post by: Abbas Ali on December 04, 2006, 01:24:20 PM

In that case run the following query in phpMyAdmin (Replace cpg1410_ with your table prefix).

Code Select


UPDATE cpg1410_pictures SET title=filename;

Remember to take a backup of the database before you do so. Running update queries directly from phpMyAdmin is quite risky in case you make mistake.

Above query will set the title of each picture in your gallery to its filename overwriting any previous titles.

Title: Re: put a name into images without a name with filename
Post by: Nibbler on December 04, 2006, 01:48:56 PM

You can do this via admin tools.

Title: Re: put a name into images without a name with filename
Post by: Abbas Ali on December 04, 2006, 01:54:49 PM

Oops, missed that. Apparently even Devs don't know the full functionality of coppermine ;)

Title: Re: put a name into images without a name with filename
Post by: Gizmo on December 04, 2006, 02:01:06 PM

Beat me to it Nibbler. You can have the file "title" changed to the file "name" minus the extension in the admin tools. So the title will read "jessicaalba" and not "jessicaalba.jpg" which is a much cleaner look. Is this OK or were you asking something that deals only with the title? It's a bit confusing I know.

Title: Re: put a name into images without a name with filename
Post by: daniell on December 04, 2006, 03:17:32 PM

gizmo that works for me ;D

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: daniell on December 04, 2006, 01:07:24 PM