[Plugin: User Spam Remover] is this plugin multisite compatible?

oh, and just in case the plugin author does read this, here is the plugin I have been using so far: https://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 ??

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..

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.

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…

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).