[01/12/06] Spam Words

Joe Belmaati · Post by **Joe Belmaati** » Wed Feb 21, 2007 6:23 pm

smokejax
You must have some other mods installed - I can only count 19 arguments in that function. PM me your functions_post.php and I'll have a look.

crispyduck
Someone actually made an add-on that does exactly that (he used a different list, though). Dunno whether he ever published the add-on.

hsteckylf
That sounds odd. PM me your admin_forums.php and I'll have a look.

Joe Belmaati · Post by **Joe Belmaati** » Wed Feb 21, 2007 8:37 pm

smokejax,
I received your PM. Someone else was having this problem some pages back and I posted a fix for it.

smokejax · Post by **smokejax** » Wed Feb 21, 2007 9:10 pm

I am also encountering this when either I or someone else, edits their post..

Screenshot

I'll dig back through, and see if I can find the fix..

Thanks Joe!

smokejax · Post by **smokejax** » Wed Feb 21, 2007 9:29 pm

I think this was the fix..

Code: Select all

#
#-----[ FIND ]------------------------------------------
# Note: this is a partial line match
#
            submit_post($mode, $post_data, $return_message,
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, $poll_length
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, $post_flagged
#

coookies · Post by **coookies** » Thu Feb 22, 2007 12:46 am

Does this run on Mysql v3.23 ?

I got this error using easymod:

Error:
Unexpected or unknown attribute "NULL", in "word_id SMALLINT(4) NOT NULL AUTO_INCREMENT", statement: 1, table: "phpbb_spam_words"

SQL:
CREATE TABLE phpbb_spam_words(word_id SMALLINT(4) NOT NULL AUTO_INCREMENT,spam_word CHAR(100) NOT NULL,PRIMARY KEY(word_id))

coookies · Post by **coookies** » Thu Feb 22, 2007 6:00 am

Not sure what the problem was - I created the tables manually via phpmyadmin and its all working now.

RevJim · Post by **RevJim** » Sun Feb 25, 2007 3:57 am

I'm running phpBB 2.0.22. I think there might be a typo in the installation instructions for this MOD. In the section for editing includes/functions_post.php it says:

Code: Select all

#-----[ IN-LINE FIND ]------------------------------------------
#
, enable_sig = $attach_sig" . $edited_sql . "
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, post_flagged = $post_flagged
#

The line of code that is being modified looks like this (end part only, it's kind of long):

Code: Select all

[snip] ...SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";

So if you inserted the new code after the code that you searched for, it would create an invalid SQL statement like this:

Code: Select all

SET post_username = '$post_username', enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . ", post_flagged = $post_flagged WHERE post_id = $post_id";

It seems like this installation instructions should be changed to:

Code: Select all

#-----[ IN-LINE FIND ]------------------------------------------
#
, enable_sig = $attach_sig
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, post_flagged = $post_flagged
#

Anyone else run into this, or am I doing something wrong?

-RJ

Joe Belmaati · Post by **Joe Belmaati** » Sun Feb 25, 2007 8:37 am

Doesn't matter - either will work. My way of doing it makes compatibility with other mods more likely.

yorktown · Post by **yorktown** » Sun Feb 25, 2007 12:57 pm

Plasmatic.... In your post:

SPam Bot Picture

You show a photo instead of the text error message. How do I do the same thing?

helmut · Post by **helmut** » Mon Feb 26, 2007 8:42 pm

yorktown wrote: ...You show a photo instead of the text error message. How do I do the same thing?

The photo is hosted on a webserver and the image is embedded using BBCode as part of the post text which looks like this for example:

Code: Select all

[img]http://www.annihilation.info/images/raisegoogle.jpg[/img]

Please note that you can see the text/code of any post by clicking on "Quote" button of the appropriate post, for example plasmatic's post.

In case you lack of a possibility to host your images you could use a free image hoster like ImageShack for example. In our forum there's a short "How to use ImageShack in phpBB forums".

Billy2423 · Post by **Billy2423** » Thu Mar 01, 2007 9:42 pm

Joe Belmaati
In the new version you do not have the

Code: Select all

#-----[ OPEN ]------------------------------------------
#
includes/usercp_register.php
#
#-----[ FIND ]------------------------------------------
#
if ( isset($HTTP_POST_VARS['submit']) )
{
#
#-----[ AFTER, ADD ]------------------------------------------
#
        include($phpbb_root_path . 'includes/spamwords.'.$phpEx);
#
#

Is there a reason for taken that out?

Also the new version when adding Mass add spam words it does not work like the old way with insertwords.php telling u if a word was added or skipped because it already exists:
That was a good feature.

And what does Spam Words Addtional Changes do as there is no Description in the txt file?

truepunk · Post by **truepunk** » Sat Mar 03, 2007 11:57 pm

I have been testing this, and it seems to work out really well, but it dosen't seem to check URLs that are posted.

What I am trying to do is any member with less then 10 posts basically can not post links at all.

Is there a way to do this without turning off BB code and A as an allowed HTML tag on the board?

truepunk · Post by **truepunk** » Sun Mar 04, 2007 1:00 am

Solved the problem. words were stored in the db using CHAR, so the extra spaces were mucking up with words and what not. Changing it to VARCHAR, updated each word and removed the white space and it worked fine.

dishdiva · Post by **dishdiva** » Sun Mar 04, 2007 5:18 am

This sounds like it would work perfect for the spammers at my site. I'm not very tech savy so please bare with me. How do I install this into my website?

I am using this version of PhpBB 2.0.21. Thank you.

alosito2 · Post by **alosito2** » Sun Mar 04, 2007 12:46 pm

Why do I get the following error every time I delete flagged messages?

Could not get post ID

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 '' at line 3

SELECT MAX(post_id) AS last_post, COUNT(post_id) AS total FROM phpbb_posts WHERE forum_id =

Line : 201
File : functions_admin.php

Rating:

advertisements