Added this mod to my 3.8.1 board.
Everything works great, catches and logs spammers trying to sign up.
Only issue I have is when I go into the log and sort it by IP address it throws a database error
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
SELECT * FROM vbstopforumspam_log AS logs
ORDER BY ip ASC, date DESC
LIMIT 0, 15;
MySQL Error : Unknown column 'ip' in 'order clause'
Error Number : 1054
Request Date : Saturday, March 12th 2011 @ 12:22:11 AM
Error Date : Saturday, March 12th 2011 @ 12:22:11 AM
Script : http://forums/admincp/vbstopforumspam.php?do=view&pp=15&orderby=ip&page=1
Referrer : http://forums/admincp/vbstopforumspam.php?do=view
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.49-log
Any help with getting this resolved?