All IPs in CSV with not all IP?

tryme · 2009-12-07 5:58 am

Hi,

Could you tell me why in file All IPs in CSV is only 26576 IP when on main page stopforumspam.com is information about 514517 spammers?

Thank you.

zaphod · 2009-12-07 11:15 am

The search, and lookup will provide up to the larger amount.

The CSV however is only a past 90(?) days storage.

Zap

Russ · 2009-12-07 11:23 am

Not to mention the CSV has all the dupes removed.

Wow-winners · 2010-02-03 11:34 am

The CSV I just downloaded has the ISP's in a horizontal layout, which is finite in Excel, and not in the vertical numeric orientation which is infinite. Any way to get the infinite version rather than the horizontal finite one?

Thanks in advance.

pedigree · 2010-02-03 12:07 pm

The new site offers a download with that, in the meantime, there is some php on the site here that will do what you want.

something like

$csvarray = explode(",", @get_file_contents("http://www.stopforumspam.com/downloads/bannedips.csv"));

gives you an array. This is typed in from the top of my head and hasnt been tested at all.

zaphod · 2010-02-04 1:23 am

ZB Block just does a fast pattern match on the CSV. It would be happy with ww1.xx1.yy1.zz1,cookie monster,ww2.xx2.yy2.zz2 .So I've never cared, EXCEPT when compiling my own during a recent bit of nastiness...
then I used notpad++ to find "," and replace with ",\n" (\n=newline)...

then I used gnu tools to remove dupes from the combined db, then reversed the above process.

Zap

#1 2009-12-07 5:58 am

All IPs in CSV with not all IP?

#2 2009-12-07 11:15 am

Re: All IPs in CSV with not all IP?

#3 2009-12-07 11:23 am

Re: All IPs in CSV with not all IP?

#4 2010-02-03 11:34 am

Re: All IPs in CSV with not all IP?

#5 2010-02-03 12:07 pm

Re: All IPs in CSV with not all IP?

#6 2010-02-04 1:23 am

Re: All IPs in CSV with not all IP?

Board footer