Mass rename Title

[snowmaker]

I have a user who uploaded over 7000 pictures and did not give the photos titles so now the title field has been filled with the filename. Is there a way to perform a mass rename of pictures to modify the title?

[SMFHacks]

No built in way. Could be done using SQL to change all those pictures to a different single title.

[snowmaker]

Would be the tables and fields required for a SQL to rename the title to match the category or sub-category name?

[SMFHacks]

Are they user categories or general category's?

The code below will replaces title with JUST the category name as the title for all the users pictures in the general main categories.

You could do UPDATE smf_gallery_pic as p, smf_gallery_cat as SET p.title = c.title where p._ID_CAT = c.ID_CAT AND p.ID_MEMBER =####

Replace #### with the member's id

[snowmaker]

This would be in the User Galleries under the Member's name. The member has created subcategories under his section. I would like to use the subcategory name for the title.

[SMFHacks]

Try
UPDATE smf_gallery_pic as p, smf_gallery_usercat as SET p.title = c.title where p._USER_ID_CAT = c.USER_ID_CAT AND p.ID_MEMBER =####

Replace #### with the member's id