Thanks Russ, that really helps with manual adds.  That blasted API is nearly impossible to remember.

Just to clarify - shall we submit data for all spambot registration attempts or only for those that make it through email confirmation?

Merry/Happy Christmas to all forum readers today!

That would be nice, I'm adding it to the list...thanks.

Right, so I've added a "last seen" element to the API XML data. I figured it would be useful for making a determination of threat when evaluating an IP address or whatever. It returns the last time the entry was seen in the database in YYYY-MM-DD HH:MM:SS format, so you could figure out how long ago it was active.

This link: http://www.stopforumspam.com/forum/spammers

will show you all of the entries you have submitted. On the far right of the table, there's a delete button if you need to remove it from the list for some reason.

I've been playing with it and it seems to work, so try it out as needed. It will be linked from the forum header shortly.

You could also relabel the boxes to leave no doubt:

Spammer's username:
Spammer's email:
Spammer's IP:

Then no one would enter their own info in the boxes.

Except perhaps an honest spammer...

Nah!  Can't remember the last time I saw one of those.   ;^)

Not a very useful update, but I've created an iPhone/iPod touch webclip icon, on the chance someone uses one of these to check the site.

Lots of changes/upgrades recently.

- Removal script now available for self-removal from the list
- Data is now available on DNSBL
- APIs page updated with more detailed information
- API post form works better with more detailed error reporting
- Country pages are paginated now
- Geo IP data updated from MaxMind

If you noticed the homepage loads a lot faster now, it's because we switched to a Smarty template and caching system (pedigree wrote it). Now the entries are updated once per minute, and the required number of SQL queries to build the page have been reduced from thousands down to just a handful.

I notice that submitted e-mail addresses with periods inserted to segment the username now also show up in intact form, with the periods removed. Good job! Thanks.

What happened... the MySQL password was wrong ?

Anyway, it made me realize that my code needs some work as it crashed my contact page since the returned data was not XML :-(

Hi

I don't know how often you update your files in the download section, but if it's not daily, maybe put a "Last updated: xx/xx/xx" behind the files?

Thanks

Last edited by SuperHebbe (2010-08-09 7:11 am)

This is a copy/paste of the new download page, without all the HTML formatting of course

Downloads and Contributions

Here are some files generated from our data that may be useful. We hope to add more in the future.

Something you'd like to see here? Ask us.

    * All IPs in CSV (one line, comma seperated) - limited to 2 downloads per IP per day
    * Just the domains in CSV (from the Spammer Domains page) - limited to 2 downloads per IP per day

IP numbers by Time

These file provide details of all IP numbers logged within the last 1 day, 7 days, 30 days, 90 days and 1 year, in the following format (Excel compatible CSV)

"109.104.183.88","1","2010-03-14 09:30:39"
"109.104.187.89","71","2010-03-27 01:53:34"
"109.104.189.87","8","2009-11-11 07:41:20"

1st column is the IP number, 2nd is the number of times that IP number been reported in the period for which the file was generated, 3rd column is the last seen date/time (EST) for that IP

      Updated once per hour
    * listed_ipfreq_1.zip - Last 24 hours, limited to 6 downloads per IP per day, last update 09-Aug 09:35 EDT
    * listed_ipfreq_7.zip - Last 7 days, limited to 2 downloads per IP per day, last update 09-Aug 09:35 EDT
      Updated once per day, midnight EST/EDT
    * listed_ipfreq_30.zip - Last 30 days, limited to 2 downloads per IP per day, last update 09-Aug 09:37 EDT
    * listed_ipfreq_90.zip - Last 90 days, limited to 2 downloads per IP per day, last update 09-Aug 09:37 EDT
    * listed_ipfreq_365.zip - Last 365 days, limited to 2 downloads per IP per day, last update 09-Aug 09:37 EDT