New Note (20 Jul 07): Mr. Mist has improved on my and Simon’s work – his version can be found here, please give it a look!
NOTE: This post now contains the latest version alluded to in the comments – it can be copy/pasted from below, or downloaded in .ZIP format here.
Since moving to my new host and installing WordPress, I’ve spent a LOT of time looking at and installing plugins. One that I’m very happy to be using – after years of having to manually block and delete comment/trackback spam – is Bad Behavior. The one downside (or upside, depending on how informed you want to be!) is that it all works “behind the scenes”, and there is no easy way for the user to see what the program has been doing.
I came across the Bad Behavior Log Reader, and immediately downloaded a copy – but alas, it was written for an older version of BB. Fortunately for me, it was not complicated, and despite my complete lack of knowledge of MySQL and extremely limited (but growing daily!) knowledge of PHP, I was able to massage it into a form that works for the current version. I even added a little bit of functionality to make the output more user-friendly.
I left a comment on the original author’s board explaining this, and mentioned I’d post about it here in case anyone wanted to use and/or expand on my changes, so… with no further ado, here’s the code:
(Note: If you’d like my version of this reader, please use the download link (here’s another, if you missed the first).