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

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Locked
User avatar
Ramon Fincken
Registered User
Posts: 4835
Joined: Thu Oct 14, 2004 1:04 am
Location: NL, The Netherlands Amsterdam area @GMT +1
Contact:

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by Ramon Fincken » Wed Jun 27, 2007 7:27 pm

mmz interesting ;)

First of all I urge you to update to 1.2.6 for security reasons ..
Next, do you still have that entry? If so can you please copy paste all the info about that entry and PM it to me?


I'm working on 1.2.7 and it'll have lots of new functions and some more automation and checks.
Release date will be in a week or 2 ( could be 3 ;) )
Dutch quality fully managed WordPress hosting - ManagedWPHosting.nl

Before changing a file, some code or installing a MOD >> Make a backup first!

Do you like my mods? paypal me $1 :) forumsoftware[AT}creativepulses[DOT}nl [/size]
PhpBBantispam.com || Instant find your mod here

kuchiki ness
Registered User
Posts: 3
Joined: Mon May 28, 2007 10:40 pm

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by kuchiki ness » Thu Jun 28, 2007 12:34 pm

hi, im having some troubles when in run the sql_update.php

this is the error that i get
# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_version','1.2.6')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_groupbypassid','-1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_sentmail','0')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_htmlmail','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_adminmail','board@board.com')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_userposts','2')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_userdays','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_main_adminid','2')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_dbstore','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_checkremote','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_check_pm','0')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_check_post','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_check_register','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_fieldfest','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_fieldfest_regchange','1')
+++ Error: Column count doesn't match value count at row 1

# INSERT INTO `phpbb_config` VALUES ('mod_spamcheck_fieldfest_regadd','1')
+++ Error: Column count doesn't match value count at row 1
i hope, somebody knows what im doing wrong, and help me, please... thanks for ur time :roll:

jerryT
Registered User
Posts: 278
Joined: Fri Feb 25, 2005 12:04 pm

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by jerryT » Thu Jun 28, 2007 5:41 pm

Just had another spam attempt from the same user with no details..

Only seems to be this user, other users details are showing OK !

Help :(

Margelatu
Registered User
Posts: 14
Joined: Sun Oct 29, 2006 1:51 pm
Contact:

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by Margelatu » Fri Jun 29, 2007 9:25 am

I did everything this file(antispam_1.2.5_to_1.2.6.txt) says and I'm getting this: Image

What am I doing wrong?

pong38
Registered User
Posts: 11
Joined: Mon Jun 19, 2006 7:07 pm

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by pong38 » Sat Jun 30, 2007 5:49 pm

Ramon, thanks for this great mod which has saved our forum from potential spammers.

One situation + question...

The mod is stopping a lot of attempts and they they are all stored (temporarily) in de spam database.
Let say that I have 50 to 60 attempts a day... is it possible to create a mass IP ban for the ip address and ip forwarded addresses so that it will bans them all in one time instead of open the record and click on "ban this ip" ?

Somthing like "mark all" and "ban ip addresses" ;)

Greetz

Ron

BTW I am up to date all the way till 1.2.6

Lord Raiden
Registered User
Posts: 391
Joined: Sat Jun 26, 2004 11:24 pm
Contact:

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by Lord Raiden » Sun Jul 01, 2007 9:27 pm

pong38: There's no bulk banning option. I've found by now that block banning IP's works best. IE, say you get a lot of spam attempts from the subnet of 75.56.24.0/24. If you do, just ban that whole block and you're good. Otherwise, don't bother with banning IP's. The reason I say that is because very few spammers will hit your forum twice with the same IP. If one does, you'll know and you just ban that one IP, or that IP block.
Steve Lake
-Owner/Admin/Author of:
-Raiden's Realm - Bringing Linux to the World

User avatar
Ramon Fincken
Registered User
Posts: 4835
Joined: Thu Oct 14, 2004 1:04 am
Location: NL, The Netherlands Amsterdam area @GMT +1
Contact:

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by Ramon Fincken » Tue Jul 03, 2007 5:34 pm

First a message from myself:
Hi all !!

lots of new features, clean code and bugfixes will be awaiting in the 1.2.7 package :)

To the translators: I'd like to point to the new language entries ( 3 small ones ) which can be found over here:
http://www.phpbbantispam.com/viewtopic.php?t=82



Greetings,

Ramon

*************
Margelatu wrote:I did everything this file(antispam_1.2.5_to_1.2.6.txt) says and I'm getting this: Image

What am I doing wrong?

Nothing to worry about at the moment, If you feel better you can re-download the zipfile and overwrite that particular php file in the admin folder.

This will not add any funtionality, and as the DB shows its 1.2.6 I suggest waiting a few days till 1.2.7 comes out :)



*************


Thanks pong38 for the nice 'review' ;) and Lord Raiden for the swift reply !
as per Lord Raiden there is no mass banning option but ... we are working on some algorithms to determine blocks faster !
However that functionality will not be in the 1.2.7 package/upgrade


*************


Update: @pong38 Version 1.2.7 will have a mass ban and delete function.
You need to check the checkboxes in the Spam database and hit the Ban and delete function
Dutch quality fully managed WordPress hosting - ManagedWPHosting.nl

Before changing a file, some code or installing a MOD >> Make a backup first!

Do you like my mods? paypal me $1 :) forumsoftware[AT}creativepulses[DOT}nl [/size]
PhpBBantispam.com || Instant find your mod here

Margelatu
Registered User
Posts: 14
Joined: Sun Oct 29, 2006 1:51 pm
Contact:

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by Margelatu » Wed Jul 04, 2007 11:44 am

10x for the answer and KEEP UP THE GOOD JOB!

User avatar
Ramon Fincken
Registered User
Posts: 4835
Joined: Thu Oct 14, 2004 1:04 am
Location: NL, The Netherlands Amsterdam area @GMT +1
Contact:

Re: [BETA] Antispam for all fields (updated: 18-04-2007:V1.2.6)

Post by Ramon Fincken » Wed Jul 04, 2007 12:04 pm

kuchiki ness wrote:hi, im having some troubles when in run the sql_update.php

this is the error that i get

i hope, somebody knows what im doing wrong, and help me, please... thanks for ur time :roll:
have you altered your phpbb_config table?

please go to phpmyadmin / your database tool and verify that th phpbb_config table has 2 colums ( config_name and config_value )

and multiple pages with rows like:
allow_autologin 1
board_email your@mail.com
default_lang english
Dutch quality fully managed WordPress hosting - ManagedWPHosting.nl

Before changing a file, some code or installing a MOD >> Make a backup first!

Do you like my mods? paypal me $1 :) forumsoftware[AT}creativepulses[DOT}nl [/size]
PhpBBantispam.com || Instant find your mod here

User avatar
Ramon Fincken
Registered User
Posts: 4835
Joined: Thu Oct 14, 2004 1:04 am
Location: NL, The Netherlands Amsterdam area @GMT +1
Contact:

Re: [BETA] Antispam for all fields (updated: 09-07-2007:V1.2.7)

Post by Ramon Fincken » Mon Jul 09, 2007 3:31 pm

:!: ** upgrade 1.2.6 -> 1.2.7 09072007
http://www.phpbbantispam.com/viewtopic.php?t=90

All changes below:

-ACP: Fieldfest-
No alterations in functions.

-ACP: Management-
* Changed the User Interface / User input of +Group name bypass and +Main admin
* Added 2 more lines for the Max websites and Spamcheck level

-ACP: Spam Database-
* Triggerword ( spamword ) is now visible !
* Added a mass ban and delete function
* Approving guest posts is enabled ( Thanks to Will Hough: http://www.phpbbantispam.com/viewtopic.php?t=10 )

-ACP: Testcenter-
* Adapted the code to align with the Spamcheck level

-ACP: Wordlist-
No alterations in functions.

-Core function-
* Cleanup and alignment of code for most files
* Optimization of code, and functions
* Added: PM subject check
* Added: Max websites per post check
* Added: Spamcheck level ( 1 = normal, 5 = aggressive )
* Private IP's cannot be added Banned anymore

-FieldFest function-
No alterations in functions.

-Semicron function-
* New function ! : The system will automatically remove users from the
bypass group if they have triple the amount of posts needed to pass the spamcheck.
This will cut down your time removing them manually.

-Lang file-
* Added 3 more entries

-Bugfixes-
* Softened the word algoritm ( Thanks to WebSmail http://www.phpbbantispam.com/viewtopic.php?t=75 )
* All server paths have been recoded using the existing phpbb coding ( Thanks to Lord Raiden http://www.phpbbantispam.com/viewtopic.php?t=85 http://www.phpbbantispam.com/viewtopic.php?t=40 )
* All SQL lines and files variables are replaced

-Language entries updated-
No alterations in functions.

-Installation-
* Added pre-defined checks
* Implemented pre-defined variables and board_email insert

Upgrade instructions are in the 1.2.7 zipfile
Screenshots + zipfile links are in the first post
Dutch quality fully managed WordPress hosting - ManagedWPHosting.nl

Before changing a file, some code or installing a MOD >> Make a backup first!

Do you like my mods? paypal me $1 :) forumsoftware[AT}creativepulses[DOT}nl [/size]
PhpBBantispam.com || Instant find your mod here

UPABrawler
Registered User
Posts: 2
Joined: Fri Jul 13, 2007 1:45 am

Re: [BETA] Antispam for all fields (updated: 09-07-2007:V1.2.7)

Post by UPABrawler » Fri Jul 13, 2007 1:47 am

could u make a sql file the sql_update.php didnt create them on a fresh install now i get errors.
cause im getting errors liek this at the bottom
General Error

Could not query spam information

DEBUG MODE

SQL Error : 1146 Table 'd60352062.phpbb_antispamdb' doesn't exist

SELECT count(db.Id) as total FROM phpbb_antispamdb as db WHERE time >= 1184287330

Line : 859
File : functions_antispam.php


message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?

User avatar
Ramon Fincken
Registered User
Posts: 4835
Joined: Thu Oct 14, 2004 1:04 am
Location: NL, The Netherlands Amsterdam area @GMT +1
Contact:

Re: [BETA] Antispam for all fields (updated: 09-07-2007:V1.2.7)

Post by Ramon Fincken » Fri Jul 13, 2007 7:45 am

the code is there for a fresh install

Code: Select all

   $sql[] = "CREATE TABLE `" . ANTISPAMDB_TABLE . "` (
              `Id` int(6) unsigned NOT NULL auto_increment,
              `user_id` mediumint(8) default NULL,
              `ip` varchar(25) default NULL,
              `ip_forwarded` varchar(25) default NULL,
              `time` int(11) NOT NULL default '0',
              `type` varchar(40) default 'word',
              `status` varchar(8) default 'false',
              `word_triggerid` smallint(5) default NULL,
              PRIMARY KEY  (`Id`)
            )";
you can edit the sql_update.php
around line 80

Code: Select all

FIND
// Override ? Please only change this value if you want to manually override an installation
// $mod_spamcheck_version = '0';

and REPLACE WITH
// Override ? Please only change this value if you want to manually override an installation
$mod_spamcheck_version = '0';
Dutch quality fully managed WordPress hosting - ManagedWPHosting.nl

Before changing a file, some code or installing a MOD >> Make a backup first!

Do you like my mods? paypal me $1 :) forumsoftware[AT}creativepulses[DOT}nl [/size]
PhpBBantispam.com || Instant find your mod here

User avatar
xmenfile
Registered User
Posts: 163
Joined: Sun Apr 22, 2007 10:32 pm

Re: [BETA] Antispam for all fields (updated: 09-07-2007:V1.2.7)

Post by xmenfile » Wed Jul 25, 2007 5:30 pm

Great mod. Thank you so much. I can't wait for 1.2.7 version, also I want to clarify that 1.2.7 will release in Sept or July because I know in some countries they put the month before day.

BTW, I need some help. I installed it and works fine. but I had a little problem with an Approval Mod that I installed before Antispam. it freezes posts from moderates and admins. I have tried to disable Approve Post in Antispam ACP, but Approval Mod is not working. Please help.

Thank you so much,

User avatar
xmenfile
Registered User
Posts: 163
Joined: Sun Apr 22, 2007 10:32 pm

Re: [BETA] Antispam for all fields (updated: 09-07-2007:V1.2.7)

Post by xmenfile » Thu Jul 26, 2007 2:43 pm

Hi,

I have updated it to 1.2.7, but got this error. Please help
Could not update private message new/read time for user

DEBUG MODE

SQL Error : 1146 Table 'hotdeals_phpb1.ADD_PAGES_TABLE' doesn't exist

SELECT * FROM ADD_PAGES_TABLE ORDER BY page_name

Line : 487
File : page_header.php

and my ACP
Could not obtain regd user/online information

DEBUG MODE

SQL Error : 1064 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 page_id = 0' at line 1

SELECT forum_name, forum_id FROM phpbb_forums

Line : 402
File : index.php
How can uninstall what ever sql_update.php add to SQL database?

tribalismo
Registered User
Posts: 34
Joined: Sun Mar 25, 2007 5:36 pm

Re: [BETA] Antispam for all fields (updated: 09-07-2007:V1.2.7)

Post by tribalismo » Sun Jul 29, 2007 5:55 pm

Download link is not working.

Locked

Return to “[2.0.x] MODs in Development”