[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