Hi halsafar,

I am dealing with these exact problems these days.

The case was the next one:

Forum with around 4000 user account with around 85% of them bots.
I needed to,

1 - Forbid new bots to come in.
2 - delete old spam messages.

I took the next steps.

delete 0post users - http://punbb.informer.com/forums/post/143634/#p143634
delete every bot user and it´s posts - I didn´t find a 1-click way. I am doing it in a custom way.

I ordered users by posts and IP address. In my case it happened that most of the spam comments come from the same IP addresses so it was not so difficult to get rid of most of it.

There are some strategies that could help you, for example to know the approximate date your forum was spotted by spam bots, so you can search for user created after that date. Or to look for some words.

As I am pretty new to this theme I would like to here more opinions and suggestions.

Scripts don´t look like very difficult so if someone explains me some patterns to look for, I could try to program something.

Saludos and thaks to all big_smile

I just remade it to make users with no messages disappear.

It works under Punbb 1.4.1

<?php

define('FORUM_IGNORE_REQUEST_URI', 1);
define('FORUM_ROOT', 'base-url-of-the-forum-change-me');
define('NUM_DAYS', 7);

include FORUM_ROOT.'include/essentials.php';

$select_query = array(
        'SELECT' => 'id',
        'FROM'   => 'users',
        'WHERE'  => '( num_posts = 0 )'
);

$query_result = $forum_db->query_build($select_query) or error(__FILE__, __LINE__);
$num_users = 0;
while ($cur_user = $forum_db->fetch_assoc($query_result))
{
        delete_user($cur_user['id'], false);
        $num_users++;
}
echo $num_users.' was removed from DB'."\n";
$forum_db->close();

?>

Hello I solved the issue.

The problem was that a line was missing in the sfs.php code.

I added this line and worked !! big_smile

require FORUM_ROOT.'include/parser.php';

As I understand this scripts lists some data of the users that post from IPs that are included in the StopForumSpam 365 day file.

I run a forum that has 4901 users (probably with 80-90% of users beeing spammers) and when I run sfs.php I get a list with just 28 users.  Is there a way to get them all?

In fact I´m getting in this 28 user list some of them that in fact aren´t spammers.

If I want to delete all the users and post, is there a way?  (not by hand smile)

Saludos

I upload the listed_ip_180_all.txt to the root of my forum, changed the line in sfs.php to point to  $filename = FORUM_ROOT.'listed_ip_180_all.txt'
then upload sfs.php to root and run script and I get.

Fatal error: Call to undefined function parse_signature() in /home/foros/public_html/punbb-1.4.1/sfs.php on line 94

I start seeking.

Can someone upload the file to other hosting?

I am trying with the listed_ip_180_all.zip I will tell you.

Saludos

6

(1 replies, posted in General discussion)

Hi,

I have been researching for a week how to get rid of horrible spam that is all around my forum.

I found very nice tools developed by keydog, grez, dimkalinux and others

fancy-stop-spam
extension-release-stopforumspamcom-antispam
extension-url-checker
extension-akismet-by-garciat-rich-pedley-grez

If I´m not missing something, those are made for not letting bots register or send spam to your forums. But what about deleting previous post.

I got rid of bots with no posts, but the ones with one o more post are still there.

I tried url_cheker but I´m getting this error.
Fatal error: Call to undefined function parse_signature() in /home/foros/public_html/punbb-1.4.1/sfs.php on line 94

Are there any other ways to deal with previous spam posts?

Any help would be appreciated smile
Muchas gracias