[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 » Mon Oct 13, 2008 8:52 pm

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 » Mon Oct 13, 2008 9:32 pm

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
Registered User
Posts: 11817
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

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

Post by 3Di » Mon Oct 13, 2008 9:40 pm

lol, you still alive? ;)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
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 » Mon Oct 13, 2008 9:55 pm

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
Registered User
Posts: 11817
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

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

Post by 3Di » Mon Oct 13, 2008 10:02 pm

Ramon Fincken wrote:
3Di wrote:lol, you still alive? ;)
no, are you? :lol:
perhaps.. ;) :lol:
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
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 » Tue Oct 14, 2008 6:39 am

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 » Tue Oct 14, 2008 7:58 am

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 » Tue Oct 14, 2008 9:50 am

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 » Tue Oct 14, 2008 1:40 pm

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 » Sun Nov 09, 2008 4:59 pm

: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 » Fri Nov 21, 2008 11:02 pm

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 » Mon Nov 24, 2008 4:15 pm

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 » Mon Nov 24, 2008 4:33 pm

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 » Tue Nov 25, 2008 4:45 pm

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 » Tue Nov 25, 2008 5:06 pm

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”

Who is online

Users browsing this forum: No registered users and 11 guests