WordPress.org

Ready to get started?Download WordPress

Forums

User Spam Remover
is this plugin multisite compatible? (6 posts)

  1. Ovidiu
    Member
    Posted 3 years ago #

    can't go ahead and test it on a live and working multisite installation so I thought I'd ask here.

    for a multisite installation this would be an invaluable tool to keep it clean :-)

    http://wordpress.org/extend/plugins/user-spam-remover/

  2. Ovidiu
    Member
    Posted 3 years ago #

    oh, and just in case the plugin author does read this, here is the plugin I have been using so far: http://plugins.paidtoblog.com/wpmu-power-tools/

    its really great but it seems the author is not going to update if very frequently so maybe you find some inspiration there
    for your own plugin :-)

  3. Ovidiu
    Member
    Posted 3 years ago #

    oh and btw. could this plugin also include an option of automatically removing comments held in moderation after a customizable time-span? that would be really great for multisite installations, i.e. if you have 1000 blogs and they all have 1000 comments held in moderation that could get out of hand quickly..

  4. AntaresMHD
    Member
    Posted 3 years ago #

    I've "used" this plugin in my multisite since I created it years ago and it never really worked, I guess it wasn't compatible after all.
    I noticed, however, that lately it has been displaying an error message in the log that says:

    2011-06-21T00:34:31-0430 Could not retrieve user list. Table '***.wp_1_users' doesn't exist

    But it's weird since the main user table is in wp_users instead.

  5. Ovidiu
    Member
    Posted 3 years ago #

    hm but whats up with those stars? ***.wp_1_users

    I mean obviously wp_ is your prefix there shouldn't be anything in front of it?

    Have you had a look at the link I provided?
    MAybe you can help me come up with the rules your plugin uses to do its magic, since the other plugin can execute it...

  6. joelhardi
    Member
    Plugin Author

    Posted 2 years ago #

    The plugin isn't for multisite, but I'm looking into what it would take to adapt it for multisite use.

    At first glance it looks like there would be scaling issues, because checking whether a user has created any posts, comments or links would mean joining to 3 more tables for every blog. So, 100 blogs means 300 more joins.

    At minimum I'll just put in an is_multisite() check to show a nice message that the plugin isn't for multisite.

    Currently the plugin appears to run normally on multisite (on WordPress SVN trunk, currently at 3.3-aortic-dissection), the problem is that it deletes all users who haven't posted to your primary blog (i.e. wp_posts) even if they've posted to another blog (i.e. wp_1_posts).

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic