how do i delete galleries of deleted vb members?
 

how do i delete galleries of deleted vb members?

out of the thousand galleries i have, there are about 100 galleries with photos, with no matching usernames... username field is blank... how do i delete these galleries?

Are there userids assigned to these pictures because if so view the photopost profile of these galleries and there should be a delete all photos of this user link in the profile.

i click on Members Galleries and get sent here
http://www.420magazine.com/gallery/s...rs.php/cat/500

then Sort by Alphabetical Order

then i have about a hundred galleries with no attached profiles or usernames

i assume they were left behind from deleted profiles.

how do i remove these?

HMM really there is nothing you can do if there is not a userid attached to the photos. You could delete them one by one but to delete them all at once you would need to actually do some database editing to a degree. Like create a dummy test user in vbulletin and then do some mass sql query to your photos table assigning all photos with no userid to this new user. You can then use as I noted in the members profile the link to delete all photos by this user.

I can assist you with the backend query stuff if you have a database viewer/editor like phpmyadmin.

i don't mind deleting them one by one...
i spent 12 hours yesterday sifting through 26,000 and deleting about 1,000...
the only problem is, there is no link to member profiles or member galleries, because there is no member...
so yes, i loaded phpadmin and would love your help in getting rid of these please...
how do we do this?
thanks chuck.

well for one I dont know your server control panel. So you know my email just email me that link and sign in then I can go in and tweak those photos to some userid and make me an admin and we can get those images gone.

i just sent you the email and made you admin.
thanks chuck.

927 orphaned images where deleted.

thanks chuck!!!

Have a good one.