Spambot detector (with the use of this API)

MysteryFCM · 2009-03-23 10:32 am

EEEK! .... my bad, tblspammers is the table name, and the fld... names I mentioned above, should be fields within the tblspammers table.

It may be easier, to drop the current SBST database, and import the following;

[url]http://temerc.com/Check_Spammers/SBST 20090323 1028.sql[/url]

Last edited by MysteryFCM (2009-03-23 10:32 am)

Björn · 2009-03-23 11:00 am

Hihi...

Ok, done.

New 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 fldspammer_id='1'' at line 1

//EDIT:
First times I try the new inmported I get error. Using only single IP.

Now, I test with all fields and NOW IT RUN's :-)

http://guldforum.se/Forum/Check_Spammers/
At the bottom og page I have a link to all I blocked.
Now I run all again but only 2 is registered in database.

Last edited by Björn (2009-03-23 11:26 am)

MysteryFCM · 2009-03-23 12:49 pm

Nice one

I'll modify the code to allow for less than all fields being recorded, and will try and find a way to have it ignore the DB completely if the fields, table or DB itself have failed to be created (not sure why it's failing to create it on some systems and working fine on others)

Björn · 2009-03-23 1:01 pm

Okay, I will wait and look for new version.

Good luck and thank you for quick reply!

//Björn.

MysteryFCM · 2009-03-23 1:22 pm

No problem, thank you for being patient

MysteryFCM · 2009-03-24 7:57 pm

Date: 24-03-2009

+ Added DroneBL lookup (dronebl.org)
+ Added extra error handling to CreateDatabase() function
* Modified CreateDatabase() function (will now try to create tables even if the DB already exists)

Ref: http://www.stopforumspam.com/forum/p364 … 3A34#p3640

* Fixed error in LogSpammerToDB() function

Ref: http://www.stopforumspam.com/forum/p364 … 3A00#p3646

* Improved W3C HTML validation
* Changed $BaseMatch default value to "" (so it works as it did prior to selective matching being added)

Download:
http://support.it-mate.co.uk/?mode=Prod … searchtool

IMPORTANT: Please backup your config.php and counter.txt files BEFORE upgrading

Björn · 2009-03-24 9:00 pm

Hello and thank's for upgrade.

I moved my old sbst to other disk and make a new directory for test of this version.

Can not find any problem at the moment ;-)

Database also created (from scratch) ok.

Thank you!

//Björn.

Last edited by Björn (2009-08-04 7:10 am)

MysteryFCM · 2009-03-24 9:04 pm

Much appreciated, thanks for letting me know

Björn · 2009-03-24 9:18 pm

You make a hard work to serv us other, whe must serv you ;-)

When I only us IP and it found in fSpamList, it will not be in database, correct?

MysteryFCM · 2009-03-24 9:48 pm

If you only check an IP, and it's found in one of the databases, it will not be flagged, unless the $BaseMatch (config.php) variable is set to "".

I changed the $BaseMatch default to "$BaseMatch = "";" to make it easier for those wanting to test and filter down, instead of having to first work out what the default setting actually meant.

It should be noted however, the flag settings only apply to check_spammers_plain.php. The web interface ignores the $BaseMatch setting as it's only meant to be used for verifying manually.

MysteryFCM · 2009-03-28 2:05 am

Russ has announced a limit is to be introduced (around 1000 apparently) on how often you can query the SFS database. Sadly this is going to affect those using the Spambot Search Tool so I'll release an update soon to allow for this.

In the meantime, details can be found at;

http://www.stopforumspam.com/forum/t573-Rate-Limiting

MysteryFCM · 2009-03-28 5:09 pm

Version: 0.26

* Modified StopForumSpam query to allow for newly introduced query limit

http://www.stopforumspam.com/forum/t573-Rate-Limiting

* Modified Spamhaus query when using the web interface (CBL and PBL are still shown, but not flagged as spammer)
* Default config.php renamed to config.sample.php to allow for easier upgrade
* Default counter.php renamed to counter.sample.php to allow for easier upgrade
* Updated installation notes

MysteryFCM · 2009-04-01 9:14 pm

Spambot Search Tool: v0.27

* Fixed StopForumSpam limit exceeded message accidentally displayed when it hasn't been (they've not implemented it yet, so it couldn't have been)

if you'd like to save yourself downloading it, you can fix it by changing;

if($bSFSLimit=true){

To;

if($bSFSLimit==true){

... in check_spammers_plain.php

Download:
http://support.it-mate.co.uk/?mode=Prod … searchtool

MysteryFCM · 2009-04-30 7:29 pm

Version: 0.29

* Fixed minor bug in check_spammers_plain.php

Special thanks to twsutton (sGB user) for reporting this.
This issue surrounds an echo of the StopForumSpam return being echo'd when I was testing another feature, and evidently I forgot to disable it - for some reason this causes false positives (i.e. everyone being flagged as a spammer), irrespective of the code only checking for the presence of "TRUE".

Note, the system requirements page has also been updated to reflect the introduction of the IMAP requirement.

Download:
http://support.it-mate.co.uk/?mode=Prod … ool&act=DL

MysteryFCM · 2009-05-14 1:36 am

Version: 0.30

* Fixed LogSpammerToFile function (I forgot to replace $savetofolder with $sLogPath when moving it to a function)
+ Added extra error handling for cases where file_get_contents is enabled, but allow_url_fopen is disabled

http://temerc.com/forums/viewtopic.php?f=71&t=6789

* Modified view_spammers.php (line 27 & 31) to show the MySQL error being displayed;

http://temerc.com/forums/viewtopic.php? … 3#p3437783

* Moved more messages into en.php
* Cleaned up HTML in check_spammers.php
* Few other minor code changes

Download:
http://support.it-mate.co.uk/?mode=Prod … searchtool

DavidR · 2009-05-16 7:40 pm

I have .30 installed and when I search for spammers, at the bottom it gives me:
Table 'HIDDEN_sbst.tblspammers' doesn't exist

I created the table manually and added a username/pw to access it, but don't know what fields to put into the table. I'm fairly new to working with phpMyAdmin, so any help would be appreciated.

Thanks,
David

HIDDEN is server username, but it matches the database correctly.

Last edited by DavidR (2009-05-16 7:41 pm)

MysteryFCM · 2009-05-16 9:08 pm

Thanks for letting me know, and sorry for taking so long.

Please run the following SQL query in phpMyAdmin, and let me know if it creates it properly or not;

Note: Please delete the tblspammers table first if it exists.

CREATE TABLE IF NOT EXISTS tblspammers(fldspammer_id int NOT NULL AUTO_INCREMENT, PRIMARY KEY(fldspammer_id), fldspammer_name varchar(255), fldspammer_ip varchar(15), fldspammer_mail varchar(255), flddb_matched varchar(255), fldadded DATE, fldspammer_count int)

Can you tell me if your MySQL database server is local, or remote? (i.e. is it on the same server as your website, or an external one?)

DavidR · 2009-05-17 7:00 am

Bingo! That query did the trick. MySQL database server is local.

Your SQL query has been executed successfully (Query took 0.0362 sec)
SQL query:
CREATE TABLE IF NOT EXISTS tblspammers(
fldspammer_id int NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( fldspammer_id ) ,
fldspammer_name varchar( 255 ) ,
fldspammer_ip varchar( 15 ) ,
fldspammer_mail varchar( 255 ) ,
flddb_matched varchar( 255 ) ,
fldadded DATE,
fldspammer_count int
)

Not that I'm willing to try it, but, supposedly, with my servers, they *only* allow localhost connections to the database for security reasons and even someone else having p/w can't connect.

MysteryFCM · 2009-05-17 1:08 pm

Nice one, thanks for letting me know

Björn · 2009-05-19 1:12 pm

Hello!
Today I install your nice script in my phpbb3 forum. Seem to running ok.

When I check View Spammers at http://guldforum.se /Chk_Spam/?p=view (remove space in link) i get wrong table, first column is not date, as subject say, it is user name. Only "Blocked By" is correct, have I do something wrong or?

Also i moved my forum to a new dedicated server. I have try to copy also old sbst database but only new spammers is in list. Using WinXP (XAMPP installation) and update today to your version 0.30. Have try to export/import also via phpMyAdmin but get error. I'm not sure how do do this and my English, brrr...

Before this I have run "SpamBot Search Tool " and it is beautiful :-)

Thank you! Björn.

MysteryFCM · 2009-05-19 5:07 pm

Sorry for taking so long.

Could you try this one please?

http://hosts-file.net/misc/view_spammers.zip

What error do you get when trying to import the old DB?

Björn · 2009-05-20 5:33 am

I put this new in action. Found an extra "echo...". Check end of line 77. There is a double "...ite" align="left">'.$spammer.'</td>';

I remove this and now it work perfect! Thank you.

Have not time to get import error from phpMyAdmin now. Will do it in next week.

MysteryFCM · 2009-05-20 12:10 pm

Thanks for letting me know

MysteryFCM · 2009-05-26 10:17 pm

Version: 0.31

+ Added check to ensure config.php exists (will attempt to copy config.sample.php if it does not)
* Modified check_spammers so result is at the top of the table instead of the bottom (requested)
* Fixed bug in view_spammers.php display
+ Added error handling incase config.php and counter.txt are missing
* Default GMail server now has /novalidate-ssl by default
+ config.php now contains date_default_timezone_set('UTC')
+ config.php now contains error_reporting(E_ALL ^ E_NOTICE) to aid in debugging

Download:
http://support.it-mate.co.uk/?mode=Prod … searchtool

MysteryFCM · 2009-06-13 2:37 pm

Date: 13-06-2009

+ Added function GetSpammerCount
* Modified index.php so it uses GetSpammerCount to obtain the spammer count from the DB if $bln_SaveToDB is enabled, and counter.txt if it isn't.
* Modified spammer list output when viewing e-mail reports
* Modified IMAP code so e-mails are sorted by date order
* Modified spammer list output and display when viewing text/MySQL records
* Fixed form (index.php) display on Opera

http://support.it-mate.co.uk/?mode=Prod … searchtool

#201 2009-03-23 10:32 am

Re: Spambot detector (with the use of this API)

#202 2009-03-23 11:00 am

Re: Spambot detector (with the use of this API)

#203 2009-03-23 12:49 pm

Re: Spambot detector (with the use of this API)

#204 2009-03-23 1:01 pm

Re: Spambot detector (with the use of this API)

#205 2009-03-23 1:22 pm

Re: Spambot detector (with the use of this API)

#206 2009-03-24 7:57 pm

Re: Spambot detector (with the use of this API)

#207 2009-03-24 9:00 pm

Re: Spambot detector (with the use of this API)

#208 2009-03-24 9:04 pm

Re: Spambot detector (with the use of this API)

#209 2009-03-24 9:18 pm

Re: Spambot detector (with the use of this API)

#210 2009-03-24 9:48 pm

Re: Spambot detector (with the use of this API)

#211 2009-03-28 2:05 am

Re: Spambot detector (with the use of this API)

#212 2009-03-28 5:09 pm

Re: Spambot detector (with the use of this API)

#213 2009-04-01 9:14 pm

Re: Spambot detector (with the use of this API)

#214 2009-04-30 7:29 pm

Re: Spambot detector (with the use of this API)

#215 2009-05-14 1:36 am

Re: Spambot detector (with the use of this API)

#216 2009-05-16 7:40 pm

Re: Spambot detector (with the use of this API)

#217 2009-05-16 9:08 pm

Re: Spambot detector (with the use of this API)

#218 2009-05-17 7:00 am

Re: Spambot detector (with the use of this API)

#219 2009-05-17 1:08 pm

Re: Spambot detector (with the use of this API)

#220 2009-05-19 1:12 pm

Re: Spambot detector (with the use of this API)

#221 2009-05-19 5:07 pm

Re: Spambot detector (with the use of this API)

#222 2009-05-20 5:33 am

Re: Spambot detector (with the use of this API)

#223 2009-05-20 12:10 pm

Re: Spambot detector (with the use of this API)

#224 2009-05-26 10:17 pm

Re: Spambot detector (with the use of this API)

#225 2009-06-13 2:37 pm

Re: Spambot detector (with the use of this API)

Board footer