Advanced search  

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]

Pages: [1]   Go Down

Author Topic: put a name into images without a name with filename  (Read 3068 times)

0 Members and 1 Guest are viewing this topic.

daniell

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
    • Central Wallpapers
put a name into images without a name with filename
« 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
« Last Edit: December 04, 2006, 03:23:22 pm by Hein »
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: put a name into images without a name with filename
« Reply #1 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.
Logged
Chief Geek at Ranium Systems

daniell

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
    • Central Wallpapers
Re: put a name into images without a name with filename
« Reply #2 on: December 04, 2006, 01:16:22 pm »
LOL

in 5000 images...  :o

i think so
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: put a name into images without a name with filename
« Reply #3 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.
Logged
Chief Geek at Ranium Systems

Nibbler

  • Guest
Re: put a name into images without a name with filename
« Reply #4 on: December 04, 2006, 01:48:56 pm »
You can do this via admin tools.
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: put a name into images without a name with filename
« Reply #5 on: December 04, 2006, 01:54:49 pm »
Oops, missed that. Apparently even Devs don't know the full functionality of coppermine ;)
Logged
Chief Geek at Ranium Systems

Gizmo

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 1015
    • BullsEye Photos
Re: put a name into images without a name with filename
« Reply #6 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.
Logged
Did you read the manual first???? Taking 2 minutes to backup your files can save you hours of wondering what you screwed up.
Billy Bullock - BullsEyePhotos Blog of Indecision

daniell

  • Coppermine novice
  • *
  • Offline Offline
  • Gender: Male
  • Posts: 29
    • Central Wallpapers
Re: put a name into images without a name with filename
« Reply #7 on: December 04, 2006, 03:17:32 pm »
gizmo that works for me  ;D
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.025 seconds with 16 queries.