[BETA] Antispam for all fields (updated: 10-01-2009:V1.3.1)

[Ramon Fincken]

Excellent work!
I removed the old version and installed this new one. And it's working perfectly!

Do you really think it's necessary to to include the "replacement" field in the spam words table, "antispamdb_words"?
The import SQL could just grab the word field from the "phpbb_words" table.

Also, since the "antispamdb_words" table has an autoincrement primary key, the SQL could exlude "word_id" and also exclude "replacement". This would make it easier to add new lists of words.

Anyway, I'll create an SQL query that will insert both lists as linked in the first post of this topic. It'll take me a little while, though.. I'll get back in an hour or so.

Thanks !

well I just might do something with that in future...
If a user adds a new word in the spam wordlist the replacement field is hidden

I'll be watching your SQL development
If you got any other suggestion feel free to do so

Rfn

[meeciteewurkor]

Here's a link to the SQL I used to insert all the spam words into the table:

http://meeciteewurkor.com/antispam_words.txt

Notice that I use the prefix "phpbb_". If yours is different simply do a "find and replace" on the text file to use your own prefix.

I'll probably update this list later and remove the field "replacement" along with it's value "*beep*".

Note that there may be duplicate words in this list, as I took them straight from the two links provided in the first post of this topic.

[Ramon Fincken]

thanks

If you use the scripts to create a PHP file over here:

Don't know how to run this query? Use PhpBBinstallers phpbb_sql_generator.php and it will generate a PHP file that you can place in the root of phpBB2 and run with your browser.

http://www.phpbbinstallers.com/phpbb_sql_generator.php

it will automatically find your DB prefix

[Ramon Fincken]

New features in next releases: ( Beeing tested right now )
* Approve post / reply V1.1.8
* Remove this record V1.1.8

[Ramon Fincken]

Updated new features for version 1.1.8 ( beeing tested right now )

* Approve post / reply V1.1.8
* Remove this record V1.1.8
* Quick ban this IP V1.1.8
* Normal IP's are green, Banned IP's are Bold,red V1.1.8

[Ramon Fincken]

Update !

** upgrade 1.1.7 -> 1.1.8 05102006
* Approve post / reply
* Approve registration / user
* Remove this record
* Quick ban this IP
* Normal IP's are green, Banned IP's are Bold,red

Upgrade instructions are in the 1.1.8 zipfile

insert_post
http://www.phpbb.com/phpBB/viewtopic.php?t=45535

insert_user
http://www.phpbb.com/phpBB/viewtopic.php?t=177543

quick_ban
http://www.phpbb.com/phpBB/viewtopic.php?t=307345

[meeciteewurkor]

Excellent! Will install this weekend.
The post/reply approve feature will be excellent.

I got a false positive on a new member the other day, and lost the message the member had written. Had to apologize...

Thanks for your hard work!
I'll let you know if there are any bugs or anything.

Oh, and the mod has been catching spammers left and right, and I add meaningful spam words to my growing word list. I'll post it sometime this weekend with SQL.

[Ramon Fincken]

Thanks


If you had the database version installed at that time the vars should be in your database ...

If you are not sure.. do a phpmyadmin lookup in the phpbb_antispamdb table..

look for the status = false AND type = post
you can change type from 'word' to 'post' and V1.1.8 will give you the possibility to import/approve the post !

[jommi]

Hi, and thanks for the wonderful mod!

v. 1.1.6 worked fine. I upgraded first to 1.1.7 and now to 1.1.8.

A problem:

All these bugs are solved in 1.1.7 release

When I go to "Wordlist" in admin panel, the page is blank.

From 1.1.6->1.1.7, the files admin_antispam_fields.php and admin_antispam_wordlist.php could not co-exist; the left panel in the admin panel is empty. I suspect it has something to do with the above fix. If I remove either of the files, the panel shows (showing the remaining entry in the antispam section). If I remove the //functions-section completely from either of the files, the left panel shows (but of course the entry is not usable).

From 1.1.7 -> 1.1.8, the same is true, but now with three files: admin_antispam_database.php admin_antispam_wordlist.php admin_antispam_fields.php. Again, only one can exist at a time; otherwise the left navigation panel in the ACP is empty, thus rendering the panel unusable.

All the files seem to work well, when used independently (e.g. I could generate the wordlist), but if I have all the files, the left panel is blank (just no lines of html).

A debugging note:
in the file upgrades/antispam_1.1.6_to_1.1.7.txt, there is a duplicate entry in the SQL-query section. The third CREATE-query is a copy of the second; in the antispam_1.1.7.txt the query is correct.

Thanks!

[Ramon Fincken]

I'll look for those bugs today...

Many thanks for your feedback !

[Ramon Fincken]

file updated .. you missed the

Code: Select all

CREATE TABLE `phpbb_antispamdb_words` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL default '',
  `replacement` char(100) NOT NULL default '',
  PRIMARY KEY  (`word_id`)
) TYPE=MyISAM;

bit...

if you install this + upgrade to 1.1.8 do you still have the admin panel problem?

If so... which admin_antispam_ file(s) do cause the error ?

[meeciteewurkor]

Ramon,
Got 1.1.8 running fine now.
In the Control panel, how do I get the message warning me to update my database to go away?

Also, are users given a message if their post is held for moderation? I had a guy yesterday try to post 8 times, before I finally noticed and got his name under the "bypass words" group (which didn't work btw for some reason)

Also, in the control panel, where it says "bypass this usergroup".
I selected the "bypass words" group and entered -1 into the box, and saved the settings, and yet the person I mentioned before still was unable to post.
??

Thanks! Other than that, it's still killing spammers...

[Ramon Fincken]

**
-1 means don't bypass ANY usergroup

however... if this user is a member for (x) days and has posted (y) posts ... he will also be free of the check.

**
did you run the update from 1.1.7 ?

Code: Select all

# 
#-----[ SQL ]------------------------------------------ 
# 
# What is SQL ? >> http://www.phpbbinstallers.com/board/viewtopic.php?t=2 
#
# Got PhpMyadmin ? >> run the SQL query's there
#
UPDATE `phpbb_config` SET `config_value`='1.1.8' WHERE `config_name`='mod_spamcheck_version';

ALTER TABLE `phpbb_antispamdb`
  ADD COLUMN `status` varchar(8) NULL DEFAULT 'false';

What do your 3 version lines tell you?
I got these:

Code: Select all

Information
Database version 	1.1.8
File version (hardcoded) 	1.1.8
Version info 	Both versions are OK.
Make sure to update them on a regular basis!

[Ramon Fincken]

Also, are users given a message if their post is held for moderation? I had a guy yesterday try to post 8 times, before I finally noticed and got his name under the "bypass words" group (which didn't work btw for some reason)

Not yet... wil be in 1.1.9 ...

[meeciteewurkor]

hmm.. weird.
I ran the upgrade SQL from the upgrade instructions. It should have worked.

I totally forgot about phpbb_config having values for the spam mod. I checked the database version and it says 1.1.7. Can I just change that manually? Not really a big deal, I guess, but since the versions are changing so quickly, it would probably be a good idea to change it, eh?
My version lines look like this:
Database version 1.1.7
File version (hardcoded) 1.1.8
Version info You need to upgrade your: antispam-database!


Ok, bypassing usergroups. Apparently, I changed the group "Bypass words" to -1. At least I think I did. The dropdown list still has it with it's orginal group ID. What do I need to do exactly to have this usergroup bypassed? It's much more easy for me to add a user to a group than to have to moderate their posts. Know what I mean? 8)