Photo / Media naming ( eliminating the dashes in filenames)

[kisii]

Ok Chuck. Since the spaces wouldn't work anymore with FFMPEG, is there a database command that I can run in myphpadmin to restore the dashes so that i can rebuild the thumbnails?

[kisii]

would something like this work:

UPDATE pp_photos SET bigimage = REPLACE(bigimage, ' ','_') WHERE cat=502
(where category is 502)??

[Chuck S]

kisli no you can not do that because remember the files also do not have dashes your kinda stuck with your old files since you hacked the code. This is why no company supports code hacking and code is developed a certain way most times.

You would have to write some specific custom script that goes through all your files and makes sure it properly renames the files and updates the database.

[kisii]

Well, actually went ahead and tried it on a category and it worked just fine.

[Chuck S]

Only if you changed the actual filename also LOL

The fixfilenames function take a file like this

image test.jpg

and makes it

image_test.php

I do not see how it would work fine simply because if your file on disk is image test.jpg just changing the name in the photos table to image_test.jpg would break the image and when you rebuild thumbs etc it will delete the image.

See what I am saying. fixfilenames alters file itself to whatever name and that name is stored in the bigimage field in the photos table. You can not change a name in the database without actually changing the physical file on disk.

[kisii]

The one that I actually ran on the database is
UPDATE gallery_photos SET title = REPLACE(title, ' ','_') WHERE cat=XXX ( where XXX is the number of the category). This i believe does not change the filename at all but rather adds the underscores where there's a space. I am not sure how the correct filename is referenced back to the new filename but so far, i haven't found any broken link to disk storage. when i hover a mouse over the thumbnails, it shows the correct filename (the unaltered one)
Now i know not to touch your code Chuck!! wink wink.

[Chuck S]

hey it it works for you fine I was merely explaining how things work code wise.