Thanks, got it.

FYI once "banned" via an infraction to MU status, reversing the infraction does not lift the MU status - must do so within Mod or Admin control panel.

Yep, thats a feature missing from the vb infractions system, hopefully one that will be addressed in vb4.

I am getting these database errors.

I have a 60 second mySQL timeout and a max MU response time of 60 as well.

So by reducing the MU response to something like 45 that should resolve these timeout errors?

One 'feature' I wish MU had was a log so I could tell easily when someone has been 'hit' by the MU as well as how they were hit. If it wasn't for the error message from vBulletin about the database timeout, I wouldn't easily see what was happening.

In any case, this mod rocks! Thanks! =)

Yes, if you reduce the MU response time you should be ok.

An SQL timeout of 60 seems a bit low, I use 180.

I think a log would be a bit OTT really. :)

Very creative nice job. Using this.

Installed, and thanks

OK thanks =)

I am running multiple boards and sites on the server and until I ran MU I wasn't getting any errors except when the mySQL server was really offline.

Well, I wanted to know if issues were being cased my MU or if there was another reason, so a log would have helped. Also I have a user that was banned, and it would give me an idea that I was properly targeting them. =)

I am using an app that I wrote to parse the HTTP log as well as another plug in to see when they are on. But it would have been nice to see something like the last 100 instances of MU.

VB should include on 4.0!

Absoluetly love this...Thanks!

Adding on to the SQL database errors noted by others above, ones in which the punch line is "MySQL Error : MySQL server has gone away," I do believe that most of these have to do with the MU hack. But, isn't this what the MU modification is supposed to do? Delay response?

I have this one particular spammer I MU'ed who is particularly determined to get back on my forums. Or maybe he doesn't even realize he has been MU'ed and just thinks this is the way it is!

Anyway, the errors typically read like this:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT forumid, moderatorid, permissions, permissions2
FROM moderator
WHERE userid = 313 AND forumid != -1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, August 25th 2009 @ 05:38:44 PM
Error Date : Tuesday, August 25th 2009 @ 05:39:15 PM
Script : http://www.XXXYYYXXX.com/forums/
Referrer : http://www.XXXYYYXXX.com/index.php
IP Address : 95.XXX.X.XX
Username : _________
Classname : vB_Database
MySQL Version :

Where the username: ____________ is the user I MU'ed.

(By the way...just FYI, through these database errors I have noticed that the culprit logs on with different (but very similar) IP addresses. So, banning an IP address is not an effective means to keep away a determined spammer.)

But the odd thing is...I am also occasionally getting these database errors for unregistered users:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1251271198,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 26th 2009 @ 02:19:58 AM
Error Date : Wednesday, August 26th 2009 @ 02:22:24 AM
Script : http://www.XXXYYYXXX.com/forums/cron...and=1251271196
Referrer : http://www.XXXYYYXXX.com/forums/XX-d...ns/___________
IP Address : 97.XX.XXX.XX
Username : Unregistered
Classname : vB_Database
MySQL Version :

And wonder if these cron errors also have to do with this MU add on.