WordPress.org

Ready to get started?Download WordPress

Forums

Multi Site DB Cleanup of spam blogs (5 posts)

  1. Johanhorak
    Member
    Posted 1 year ago #

    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?

  2. Bas Schuiling
    Member
    Posted 1 year ago #

    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.

  3. Johanhorak
    Member
    Posted 1 year ago #

    Hi B. Schuiling Thanks.

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

  4. Bas Schuiling
    Member
    Posted 1 year ago #

    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.

  5. Johanhorak
    Member
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic