sfs importer

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")
{
die('exit');
// EXEC IPTABLES BAN $ip
//FAIL2BAN FOR VSERVERS
}
//PHP