Stopforumspam iptables

    CREATE TABLE IF NOT EXISTS `stopforumspam` (
      `ip` varchar(32) NOT NULL,
      `id` int(32) NOT NULL auto_increment,
      `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
      PRIMARY KEY  (`id`),
      UNIQUE KEY `ip` (`ip`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=287040 ;
    ##IMPORTER SCRIPT

    #!/bin/bash
    wget http://www.stopforumspam.com/downloads/bannedips.zip
    unzip ./bannedips.zip >>/dev/null
    rm newips.csv
    sed 's/,/\n/g' bannedips.csv > newips.csv
    P=password
    D=database
    U=user
    mysql -u$U -p$P  -D$D<<< 'TRUNCATE stopforumspam ; '
    mysql -u$U -p$P  -D$D<<< ' LOAD DATA LOCAL INFILE "./newips.csv" INTO TABLE stopforumspam FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "\n" (ip);'

    ##BASH

    //PHP
    $ip=$_SERVER['REMOTE_ADDR'];
    $result = dbquery("SELECT * FROM stopforumspam WHERE ip='".$ip."'"); //php-fusion query
     $numrows = dbrows($result); //php-fusion query
    echo $numrows; //php-fusion query
    if($numrows=="1")
    {
    file_put_contents('ips.txt', $ip . "\n", FILE_APPEND);
    die('');
    // EXEC IPTABLES BAN $ip
    //FAIL2BAN FOR VSERVERS
    }
    //PHP


//CRONJOB SCRIPT TO BAN

#!/bin/bash
sort -u PATHtoDOMAIN1/ips.txt|uniq > neuips.txt
''> PATHtoDOMAIN1/ips.txt
#DOMAIN2 ETC..
sort -u  PATHtoDOMAIN2/ips.txt|uniq >> neuips.txt
''> PATHtoDOMAIN2/ips.txt/ips.txt

URLFILE=neuips.txt

for i in `cat $URLFILE`; do
iptables -A INPUT -s $i -j DROP
done