[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.
jerryT
Registered User
Posts: 278
Joined: Fri Feb 25, 2005 12:04 pm

Re: [BETA] Antispam for all fields (updated: 26-06-2008:V1.2.9)

Post by jerryT »

Issues with antiSpam 1.2.8 installed on phpBB 2.0.23

I've been away a couple of days and have come back to find 45 new spam posts..
When I tried to view them via the ACP I got SQL errors.

After a few attempts I'm still getting issues.. My forum is working fine, but I can't access the antispam acp without sql errors.

I've backed my database up and have removed all the entries in:
antispamdb
antispamdb_data
antispamdbf_fieldfest

but not from antispamdb_wordlist.

Everything appears OK, but I'm still getting timeouts and SQL errors, but only related to antispam.

Clicking the 'spam database' link I get:
An Error Occurred

DEBUG MODE

SQL Error : 2006 MySQL server has gone away

SELECT user_id, count(user_id) as count_mod_posts from phpbb_antispamdb WHERE status = 'false' AND type = 'post' group by user_id order by count_mod_posts DESC
Running the query via HeidiSQL works !!

Any ideas ? Thanks
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: 26-06-2008:V1.2.9)

Post by Ramon Fincken »

It is known to me that that page needs some redesign, trouble for you is that your database server has a heavy load allready..

I have made some adjustments in version 1.2.9 and I'm still working on a lighter code ..
However feel free to empty both the
antispamdb and antispamdb_data

tables for once.
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
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: [BETA] Antispam for all fields (updated: 26-06-2008:V1.2.9)

Post by 3Di »

lol, you still alive? ;)
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
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: 26-06-2008:V1.2.9)

Post by Ramon Fincken »

3Di wrote:lol, you still alive? ;)
no, are you? :lol:
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
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: [BETA] Antispam for all fields (updated: 26-06-2008:V1.2.9)

Post by 3Di »

Ramon Fincken wrote:
3Di wrote:lol, you still alive? ;)
no, are you? :lol:
perhaps.. ;) :lol:
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
jerryT
Registered User
Posts: 278
Joined: Fri Feb 25, 2005 12:04 pm

Re: [BETA] Antispam for all fields (updated: 26-06-2008:V1.2.9)

Post by jerryT »

I have already emptied those fields.

Error still occured until I ran mysqlcontrolcentre and repaired those fields.

Now it's working !
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: 26-06-2008:V1.2.9)

Post by Ramon Fincken »

Great ! Thanks for reply-ing :)

meanwhile 1.2.9 should enlighten your code for the database
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
jerryT
Registered User
Posts: 278
Joined: Fri Feb 25, 2005 12:04 pm

Re: [BETA] Antispam for all fields (updated: 26-06-2008:V1.2.9)

Post by jerryT »

Thanks Ramon Fincken

Any plans of making this work with phpbb3 ?

Regards
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: 26-06-2008:V1.2.9)

Post by Ramon Fincken »

yes there are, but i have to start coding with phpbb3 first ;)

Don't have the knowledge of phpbb3 that well .. ( but I've ordered a bertie3 bear !! )
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: 26-06-2008:V1.2.9)

Post by Ramon Fincken »

:idea: :idea: Note: from 2009 on all support and info for this mod will be at http://www.phpbbantispam.com due to the read only-ness of this board ( phpbb.com > phpbb2 mods ) section.
I recommend posting your questions, ideas, remarks and bugs over there as from now on.
Direct download link: http://www.phpbbantispam.com/viewtopic.php?t=1
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: 21-11-2008:V1.3.0)

Post by Ramon Fincken »

UPGRADES AVAILABLE:
Simply download the latest zipfile and easy upgrade instuctions + files are in that zipfile !

** upgrade 1.2.9 -> 1.3.0 21112008
http://phpbbantispam.com/viewtopic.php?t=151

All changes below:

-ACP: Fieldfest-
No alterations in functions.

-ACP: Management-
No alterations in functions.

-ACP: Spam Database-
* Added a lite version and indexes to the core table. If your webserver times out .. click again and a lite version will pop up.
* When approving a signup, the user is automatically added to the approved userlist.

-ACP: Testcenter-
No alterations in functions.

-ACP: Wordlist-
No alterations in functions.

-Core function-
Added a filter for 'google-analytics.com/ga.js'

-FieldFest function-
No alterations in functions.

-Semicron function-
No alterations in functions.

-Lang file-
No alterations in functions.

-API-
No alterations in functions.

-Bugfixes-
* When updating your profile the website is still checked.
http://phpbbantispam.com/viewtopic.php?t=146

* When approving an ANON post ( newtopic ) the API is not satisfied with the normal parameters.
http://phpbbantispam.com/viewtopic.php?t=145

-Language entries updated-
No new entries.

-Installation-
No alterations in functions.

Upgrade instructions are in the 1.3.0 zipfile
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
ehupp01
Registered User
Posts: 2
Joined: Mon Nov 24, 2008 4:13 pm

Re: [BETA] Antispam for all fields (updated: 21-11-2008:V1.3.0)

Post by ehupp01 »

I am now getting this after the upgrade to 1.3.0 on the spam datbase page only. :?:

Code: Select all

Warning: Cannot modify header information - headers already sent by (output started at /home/huppnet/www/connect/includes/template.php(126) : eval()'d code:1) in /home/huppnet/www/connect/admin/admin_antispam_database.php on line 55

Warning: Cannot modify header information - headers already sent by (output started at /home/huppnet/www/connect/includes/template.php(126) : eval()'d code:1) in /home/huppnet/www/connect/admin/admin_antispam_database.php on line 1010
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: 21-11-2008:V1.3.0)

Post by Ramon Fincken »

Thats correct, solution:
http://www.phpbbantispam.com/viewtopic.php?t=152



:idea: :idea: Note: from 2009 on all support and info for this mod will be at http://www.phpbbantispam.com due to the read only-ness of this board ( phpbb.com > phpbb2 mods ) section.
I recommend posting your questions, ideas, remarks and bugs over there as from now on.
Direct download link: http://www.phpbbantispam.com/viewtopic.php?t=1
Last edited by Ramon Fincken on Tue Nov 25, 2008 5:12 pm, edited 1 time in total.
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
ehupp01
Registered User
Posts: 2
Joined: Mon Nov 24, 2008 4:13 pm

Re: [BETA] Antispam for all fields (updated: 21-11-2008:V1.3.0)

Post by ehupp01 »

Thanks :D
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: 21-11-2008:V1.3.0)

Post by Ramon Fincken »

ehupp01 wrote:Thanks :D
No problemo :)

If you have any suggestions for the mod let me know !
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
Locked

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