[01/12/06] Spam Words

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
52
76%
Very Good
9
13%
Good
4
6%
Fair
0
No votes
Poor
3
4%
 
Total votes: 68

Billy2423
Registered User
Posts: 88
Joined: Sun Sep 28, 2003 2:23 pm
Location: USA
Name: Bill Withers
Contact:

Re: [01/12/06] Spam Words

Post by Billy2423 » Thu May 17, 2007 3:39 pm

coulsontom wrote: i get this error message on the configuration page:
please help
U did not run db_update.php to install the table

coulsontom
Registered User
Posts: 2
Joined: Thu May 17, 2007 1:36 pm

Re: [01/12/06] Spam Words

Post by coulsontom » Thu May 17, 2007 4:49 pm

Billy2423 wrote:
coulsontom wrote: i get this error message on the configuration page:
please help
U did not run db_update.php to install the table
i have run the update and this still appears:

Code: Select all

phpBB : Critical Error 

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'lukeclar_phpb1.SPAM_WORDS_CONFIG_TABLE' doesn't exist

SELECT * FROM SPAM_WORDS_CONFIG_TABLE

Line : 44
File : admin_spamwords_config.php 
however, the flag page seems to work

ben.suffolk
Registered User
Posts: 3
Joined: Sun Jan 23, 2005 10:29 pm

Re: [01/12/06] Spam Words

Post by ben.suffolk » Fri May 18, 2007 7:52 am

HI,

This looks like a great mod, but I can;t get it to work. All the admin part works. I have set up the words but it never blocks any spam.

Looking through the code I can't see any bits that call the check_spam function :-

>grep Version INSTALL.mod
## MOD Version: 1.1.3
>grep check_spam INSTALL.mod
>grep -R check_spam phpbb2_root/*
includes/spamwords.php:function check_spam($message, &$subject, &$signature)
includes/spamwords.php: check_spam($message, $subject, $signature);

I'm guessing there is something I have must have missed in some instructions somewhere along the lines, but having re read INSTALL.mod several times and looked through the code I'm not seeing it.

Regards

Ben

Skywalker3012
Registered User
Posts: 9
Joined: Sun May 20, 2007 6:48 am

Re: [01/12/06] Spam Words

Post by Skywalker3012 » Sun May 20, 2007 6:53 am

Hey big problem!

I installed the mod and then ran the db_update file for the forum I'm an admin for. Then for some reason there's a blank screen when I post. So I triple checked all the files and changed a couple of errors, and then ran the db_update again. Same error, I replaced all the files and it doesn't seem to be any different. I didn't replace the files that db_update modified because I'm unsure as to what it actually changed.

Finally, there is a seperate default theme on the board, but to be safe I copied the files to both SubSilver and the custom theme. I also edited both the files in each folder. Can anybody give tips ASAP? Thanks!

Billy2423
Registered User
Posts: 88
Joined: Sun Sep 28, 2003 2:23 pm
Location: USA
Name: Bill Withers
Contact:

Re: [01/12/06] Spam Words

Post by Billy2423 » Sun May 20, 2007 1:41 pm

db_update only installed the needed tables and does not change any files. U should have gotten a error when you ran it again saying the tables are already there. Double check your edited files, mainly the ones for posting.php and includes/functions_post.php

Skywalker3012
Registered User
Posts: 9
Joined: Sun May 20, 2007 6:48 am

Re: [01/12/06] Spam Words

Post by Skywalker3012 » Sun May 20, 2007 3:38 pm

Yea when I ran db_update a second time I got that error, but even after replacing all the files (Including the unmodified files) with the original, it still doesn't work. :(

plasmatic
Registered User
Posts: 14
Joined: Tue Dec 12, 2006 3:34 am

Re: [01/12/06] Spam Words

Post by plasmatic » Mon May 21, 2007 4:01 am

coulsontom wrote:
Billy2423 wrote:
coulsontom wrote: i get this error message on the configuration page:
please help
U did not run db_update.php to install the table
i have run the update and this still appears:

Code: Select all

phpBB : Critical Error 

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'lukeclar_phpb1.SPAM_WORDS_CONFIG_TABLE' doesn't exist

SELECT * FROM SPAM_WORDS_CONFIG_TABLE

Line : 44
File : admin_spamwords_config.php 
however, the flag page seems to work
I'm getting this same error.
I updated from phpbb 2.0.21 to 2.0.22 yesterday without a hitch. Then modded all the files the same way I did before, ran the db_update.php and saw the same error.

The tables are there, I even manually deleted them and reran db_update.php
Right now I'm looking into how the 2.0.22 update altered the tables.

Joe Belmaati
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Re: [01/12/06] Spam Words

Post by Joe Belmaati » Mon May 21, 2007 10:17 am

Make sure you edited constants.php properly.
Image

plasmatic
Registered User
Posts: 14
Joined: Tue Dec 12, 2006 3:34 am

Re: [01/12/06] Spam Words

Post by plasmatic » Mon May 21, 2007 10:34 pm

Joe Belmaati wrote:Make sure you edited constants.php properly.
Good call.
I somehow loaded in backup files from an earlier date that weren't modded.
4am installs are not a great idea I guess.

estado3
Registered User
Posts: 5
Joined: Tue Apr 03, 2007 4:50 pm

Re: [01/12/06] Spam Words

Post by estado3 » Tue May 22, 2007 5:34 pm

Is there an option to not have a spam words log, as the spam words log is having a substantial increase in the size of my database, I don't want any logs, how may I do this?

ben.suffolk
Registered User
Posts: 3
Joined: Sun Jan 23, 2005 10:29 pm

Re: [01/12/06] Spam Words

Post by ben.suffolk » Wed May 23, 2007 7:43 am

ben.suffolk wrote:Looking through the code I can't see any bits that call the check_spam function :-

>grep Version INSTALL.mod
## MOD Version: 1.1.3
>grep check_spam INSTALL.mod
>grep -R check_spam phpbb2_root/*
includes/spamwords.php:function check_spam($message, &$subject, &$signature)
includes/spamwords.php: check_spam($message, $subject, $signature);

I'm guessing there is something I have must have missed in some instructions somewhere along the lines, but having re read INSTALL.mod several times and looked through the code I'm not seeing it.
So can anybody tell me what I have missed?

Regards

ben

Joe Belmaati
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Re: [01/12/06] Spam Words

Post by Joe Belmaati » Wed May 23, 2007 11:13 am

Seriously?

Code: Select all

includes/spamwords.php: check_spam($message, $subject, $signature);
Image

jintxo
Registered User
Posts: 4
Joined: Fri May 27, 2005 3:09 pm

Re: [01/12/06] Spam Words

Post by jintxo » Fri May 25, 2007 7:16 am

Hello Joe and friends. I am using a slightly outdated version of the MOD (Installed it about a year ago) and it wasn't very effective up until now, I still had a bunch of spam even though I had the "typical" spam words list (you know cialis viagra porn etc etc.)

I found this thread and applied a couple changes to the MOD that are listed a few pages bach so that the filter would catch http and *http* in the body of the posts and I couldn't be happier with the results.

Everyone posting "legitimate" links is just posting urls without the http and the spambots all use the http in there somewhere, so the result is that I am VERY VERY VERY happy with the results of applying those small changes. Only 1 spam post since I have applied these changes (maybe about a month ago)

Many thanks to Joe and anyone else who has contributed to this MOD, maybe it could become a standard feature in phpbb software :-)

Cheers and Regards to all!!!

jintxo

Joe Belmaati
Registered User
Posts: 2110
Joined: Sun Sep 28, 2003 7:35 pm
Location: Denmark

Re: [01/12/06] Spam Words

Post by Joe Belmaati » Fri May 25, 2007 7:00 pm

Thank you so much - I sincerely appreciate it. :)
Image

Matt Skillett
Registered User
Posts: 75
Joined: Fri Dec 03, 2004 9:41 am

Re: [01/12/06] Spam Words

Post by Matt Skillett » Thu May 31, 2007 1:01 pm

At risk of sounding like an idiot... Where is the install.txt file for this mod? I didn't think there was one so I tried to guess! Apparently I have to edit constants.php...

Post Reply

Return to “[2.0.x] MOD Database Releases”