I am helping a client whose site has numerous plugins and 35K spam images from Zillow. They are in the media library. He also has 100K spam comments. I have since then disabled the comments. He also had over 300 users with no roles.

I have removed all users except the one with admin privileges.

How can I go about removing all pictures not uploaded by the admin?

I obviously cannot manually go through everyone, but I do not see a filter option for Author type.

  • That would have been easier before removing the users. – Gerald Schneider Mar 25 '14 at 14:46
  • If you could find/know what images the client uploaded them self, then you could delete all of them and add those images back. – Howli Mar 25 '14 at 14:49
  • Expanding Gerald's comment: open the table wp_posts in the database and check if the columns post_author, post_date or post_modified can help locate this images. – brasofilo Mar 25 '14 at 15:42
  • Thanks brasfolio. I can just query the table where post_author != "myusername". – C.Coggins Mar 25 '14 at 17:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy