Anti-Spam Options - Is Bot: Registration Time Check

This mod calculates the time it takes to go between these two pages:

• /forum/register.php?do=register
• /forum/register.php?do=addmember

The point is to try and prevent bots from registering at your forum when the time between the two pages is humanly impossible, assuming that humans actually take the time to complete the registration page.

Should a user be blocked from registering at your forum, an email will be sent to your vB webmasteremail address and the user will see the vB noregister phrase message, so no screenshot is necessary.

[tpn87]

Wow... this plugin has saved me so much time with bogus registrations. Thanks so much for this!

[KURTZ]

i still love this mod! :P

The following user name with email address was blocked by the Is Bot mod: AllAdobeOEMSoftDownload - somesingoemforu@gmail.com (1 seconds transpired)

on Beta 4!

[WreckRman2]

Originally Posted by Lionel

ok, this is how I auto ban them. I set mine to 5 seconds

In the Is Bot plugin at register_addmember_process, right before Put

PHP Code:

$db->query_write("UPDATE " . TABLE_PREFIX . "setting  SET value = IF(value <> '', CONCAT(value, ' ', $isbot_ipaddy) WHERE varname ='banip'"); 
 
$db->query_write("UPDATE " . TABLE_PREFIX . "datastore  SET data = IF(data <> '', CONCAT(data, ' ', $isbot_email) WHERE title ='banemail'"); 


And let them try again with a longer time frame :-)

Exactly what I was hoping for however when I add this code it returns an SQL error:

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE setting SET value = IF(value <> '', CONCAT(value, ' ', ) WHERE varname ='banip';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') WHERE varname ='banip'' at line 1
Error Number : 1064
Date : Wednesday, February 13th 2008 @ 12:16:03 AM
Script : http://rchangout.com/forums/register.php?do=addmember
Referrer : http://rchangout.com/forums/register.php
IP Address : 64.184.169.176
Username : Flienceintito
Classname : vB_Database

[WreckRman2]

I'm not sure what IF(value <> '', does however I got errors from it.

I also had to change $isbot_ipaddy to $isbot_ip

I then had to change $isbot_ip to '$isbot_ip' , otherwise it would return an error splitting up the IP address.
------

So I ended up with this and it works fine... Thanks!

$db->query_write("UPDATE setting SET value = CONCAT(value, ' ', '$isbot_ip') WHERE varname ='banip'");

[Boofo]

Originally Posted by KURTZ

i still love this mod! :P

The following user name with email address was blocked by the Is Bot mod: AllAdobeOEMSoftDownload - somesingoemforu@gmail.com (1 seconds transpired)

on Beta 4!

With the reCAPTCHA, is this still needed on beta 4? And what is your time setting at?

[KURTZ]

Originally Posted by Boofo

With the reCAPTCHA, is this still needed on beta 4? And what is your time setting at?

yes, i've reCAPTCHA enabled, and you just saw that this hack still blocks "something" ... damn i don't remember the time that i've settled ... maybe 5 or 3 seconds ...

[Boofo]

With reCAPTCHA, I doubt they would have gotten through. I have Guests sitting at "Registering" constantly in the Who's Online but no one has registered that wasn't legit.

[KURTZ]

Bobby i don't know ... you can see what's happened on my site ...

[KURTZ]

other two blocked ...

The following user name with email address was blocked by the Is Bot mod: AnaebSpone - anaebspone@loanforums.biz (0 seconds transpired)

The following user name with email address was blocked by the Is Bot mod: sombdodablaby - inefarege@bk.ru (3 seconds transpired)

[Boofo]

I think what is happening is this hack is catching them before they have a chance to go at reCAPTCHA. If you didn't have this installed, reCAPTCHA would stop them, if you have it enabled. It never hurts to have 2 lines of defense.