How to delete SPAM from site?

Entire FORUM section has over 4k worth of SPAM posts within hours.  How can I remove this in one clean swoop without deleting my categories and subcategories?  I have a soft launch right now so I do have members posting. 

How to block China from posting?

www.OperationEnduringFitness.com

As for blocking..

http://www.boonex.com/forums/topic/China-is-invading-help-me-with-form-field-validation.htm

For removing forum post; do you know how to edit your Dolphin database?

 I do not know how but I am sure I can learn.  Suggestions?  Thanks so much.

Have you enable the spam tools in your Admin panel?

Do you have akismet enabled? "Akismet API Key" under yoursite/administration/advanced_settings.php

under "Security"

A very easy process to stop the bots, divide your join form into two separate pages, that is also covered in the same posting.

This was referenced as well,

http://www.boonex.com/forums/topic/How-To-Block-The-Entire-Planet-From-Joining-Your-Site-well-almost.htm

 Do not have it enabled BUT have a great mod that has fixed this issue , JOIN BY COUNTRY which I haven't had any spammers since. Just the spammers before, have clogged my forum/discussion board. Can't clear them out 1 by 1 as there are too many. Suggestions?

Settings -> Pruning, maybe? 

I believe running these two sql queries on your database should wipe out all posts from a particular user:

DELETE FROM `bx_forum_post` WHERE `user` = "aikraigtimo";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "aikraigtimo";

You'd have to change the names of the users for each spammer and run the queries for each one.  Suggest you back up your database before running any queries.

There may still be some artifacts left in other forum DB tables, but nothing that will show up visibly on your site.  Nevertheless, you should look at all the forum tables after cleaning the bx_forum_post and bx_forum_topic tables for stuff left behind by the same users.

This is a good example of Boonex wisdom in action, ie, where they believe that if you delete a user, it is best to leave all their forum posts behind, in case they made some sort of monumentally profound post that the community could not live without.

These would be good additions to Deano's Tools module

Delete all forum posts by a user, and every single trace of their existence.

Sorry. No more new additions to the tools for a while.

I have a mod planned for cleaning up the database.

Write down any that you are aware of. I will want to know about them all.

I am reluctant to even post this. Two of my ideas/plans were grabbed and developed before i even had a chance to. I am starting to keep most of my plans quiet for now.

I have a mod planned for cleaning up the database.

Cool...if you do it, put me down for an order!

Write down any that you are aware of.

I posted about a week ago about this. If it's possible to delete any ratings the user has done, that would be great!

Two of my ideas/plans were grabbed and developed before i even had a chance to

I saw one of the situations where this happened...pretty low move if you ask me.

keep most of my plans quiet for now

Good idea!

Make that 2 orders!  Deano Tools mod has been good to me. THANK YOU for your work.

Ok, what's a good quote/fee for this issue? Don't deal with SQL and don't want to make any mistakes.  

Take a look @ my forums (SMH) and see the damage they've done. 

Www.Operationenduringfitness.Com 

You can execute sql queries using Deano's tools.  Just paste these in the sql query tool and hit send.  It should get rid of a ton of spam posts.  To get rid of others, replace the user name in the queries with the ones you want to delete.

DELETE FROM `bx_forum_post` WHERE `user` = "aikraigtimo";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "aikraigtimo";
DELETE FROM `bx_forum_post` WHERE `user` = "dpndpiai";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "dpndpiai";
DELETE FROM `bx_forum_post` WHERE `user` = "roferroniroll";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "roferroniroll";
DELETE FROM `bx_forum_post` WHERE `user` = "esoamesquivirg";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "esoamesquivirg";
DELETE FROM `bx_forum_post` WHERE `user` = "waberwaldlawa";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "waberwaldlawa";
DELETE FROM `bx_forum_post` WHERE `user` = "itnaitonorm";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "itnaitonorm";
DELETE FROM `bx_forum_post` WHERE `user` = "toiatojuan";
DELETE FROM `bx_forum_topic` WHERE `first_post_user` = "toiatojuan";

AWESOME!!!

I wouldn't waste any time clearing out all that spam if I were you.  Google will be implementing new algorithms to filter out spam sites from search results, and right now, spam is about 99% of your content.

So, there is nothing I can do at all? 

 RE:

 About what?  I just told you how to delete those spam posts.

 I was referencing this below. The way I read it that even if I do clean it, it wouldn't help 

I read it as this.

"I wouldn't waste any time clearing out all that spam if I were you"

Means to me one of the following.

1) Do it now.
2) Do not waste any time.
3) Quickly
4) Now.
5) Get yo arse moving.
6) Get it in gear.

And many others.

Before googles search engine penalizes your site for having spam content.

What I meant by that, was do it soon, before Google decides your site is nothing but a spam site.  So, what are you waiting for? Do it.

 LOL. I could have saved myself the time, and just waited for you to clarify.

That's OK Deano... now maybe he'll get the idea

I will also be a customer for "Deano's Tools Deluxe".  I don't see Boonex changing things so every single thing a user ever posted is deleted, when that user is deleted.  There are times when it will be necessary though.

You should add forum posts delete, to your tools module, and sell it in the market as an advanced copy of Deano's Tools Deluxe..... then up the price as you add stuff.

yup - got the idea.  Thanks. 

JUST WANT TO EXTEND MY GRATITUDE TO YOU ALL WHO HELPED.  The SQL query only took 5 minutes and all the spam is gone!  ONE spammer did majority of the postings and it cleared right UP.  AMAZING!

Thank you all for breaking it down for me in layman's terms lol.  If I can do it, anyone can.  NOW, to clear my forum posting number to reflect how many postings are truly in there. It is still showing over 24k when its only 13.

THANKS AGAIN!

The Join By Country mod should cut down on recurrences, but it's not a fix-all.  You should consider using Maxmind's proxy detection service, which will prevent spammers from joining your site through a US based anonymous proxy server (This happens often).

http://www.maxmind.com/app/proxy

I have a post about it in the Tips forum.  All it takes is a few line lines of code added to join.php, and it will send the user to a 404 error page.  10,000 queries is only $50, and should be enough to repel a lot of join attempts. The two together, are why I can make Posts Like This One and not get a single spammer registration.... I don't even use Dolphin's built in anti-spam tools.

great!

If you sign up for the Maxmind service, this is all it takes to integrate it into Dolphin:

<?php

$license_key = 'License_Key_Here';
$ipaddress = $_SERVER['REMOTE_ADDR'];
$query = "https://minfraud1.maxmind.com/app/ipauth_http?l=" . $license_key
  . "&ipaddr=" . $ipaddress;
$score = file_get_contents($query);
$numericScore = str_replace("proxyScore=", "", $score);
//echo "$numericScore";

if ($numericScore > .5) {
header( 'Location: 404.html' ) ;
}


define('BX_INDEX_PAGE', 1);

require_once( './inc/header.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'design.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'admin.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'db.inc.php' );

bx_import('BxTemplJoinPageView');

The code in red is added to join.php   The header( 'Location: 404.html' ) ; line sends the would be spammer to 404.html.   If you wanted to be really nasty, you could use this line:

header( 'Location: http://english-1343967356.spampoison.com' ) ;

According to spampoison.com, bots visiting their site will be trapped in an asyss of never ending fake bot food.