Multi Site DB Cleanup of spam blogs

  • Hi I have a wordpress multi install. Using phpmyadmin and looking at the DB for the multi install:

    When looking at the wp_349_options to wp_1110_options I see that 99% these blogs have a url something.kissonthefirstdate.com. These are all spam and I want to kill all these records associated with kissonthefirstdate.com

    How would I go about doing it?

Viewing 4 replies - 1 through 4 (of 4 total)

  • You could easily do it via MySQL with a like statement. Or if you have a lot of blogs make a simple script that loops through all the installed post tables with the same like script.

    Thread Starter Johanhorak

    (@johanhorak)

    Hi B. Schuiling Thanks.

    Any idea on how to construct such a script as I am a novice?

    I would make a very simple plugin out of it so you have access to all the WordPress functions ( basically just query the blogs you have, loop this over all the tables by number and do your query ).

    If you don’t know how to do it, I would advice to search for a plugin that can do it, it probably exists. Or find somebody who can make such a plugin.

    By the way on second read I see that your problem is with the installed -blogs-, not -posts- within those blogs. Doesn’t change to solution I think. But blogs you can just delete easier I guess or install some captcha’s before being able to create a blog.

    Thread Starter Johanhorak

    (@johanhorak)

    I have stopped the creation of all blogs. Only Admin can create. I will try and find a solution. Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Multi Site DB Cleanup of spam blogs’ is closed to new replies.