| Author |
 Topic Search  Topic Options
|
rgelb 
Newbie
Joined: 04 August 2005
Status: Offline
Points: 15
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: How to clean out spam?
Posted: 28 October 2010 at 6:11pm |
My forum (running at v9.5) has been completely overrun by spam. I didn't pay attention to it for a couple of months and now 99% of the entries are junk.
Are there tools to help me clean it out? I looked in the control panel and could find nothing to help me.
I am also pretty handy with Access SQL, so if someone could post a DELETE query to delete all posts after a certain date, that would do the trick as well.
Thank you.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 October 2010 at 7:25pm |
You would need to go through and delete each topic or post within the main forum.
Also have a look at the page below to prevent getting more spam in your forum:-
|
|
|
|
JohnnyW
Newbie
Joined: 29 July 2007
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 November 2010 at 6:27pm |
|
Hi Bruce,
I think this is an issue which could do with a bit of work in future versions. Cleaning out spam posts and spammers is a tedious and time consuming task on WebWiz. You have to go into the user account then find all their posts delete them and ban the user. When your forum gets hit hard with them then it takes up a lot of valuable time.
I'm a developer myself so relitivly easily wrote my own mod called the 'spamming p**k' button for admins which sits under the post options menu. If there's a spammer hit the forum by hitting the page it'll delete all their posts, ban their account and their IP address. It has certainly cut down on a lot of wasted time and I'm sure it'd be a welcome addition to future versions as the problem is only going to get worse unfortunatly.
|
|
rgelb
Newbie
Joined: 04 August 2005
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 November 2010 at 5:09pm |
|
Bruce, understood. However, can u post a SQL script to get rid of all posts after a certain date? It's just easier and faster than going one by one.
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 November 2010 at 5:18pm |
|
Why don't you use Forum Tools, batch delete topics, and clean them out that way. However, you risk losing topics that you may want remaining
|
|
|
|
rgelb
Newbie
Joined: 04 August 2005
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 November 2010 at 5:25pm |
|
@MrTWS Because that Batch Delete Topics deletes ones that haven't been posted in for x days/weeks/months. I need to delete everything that's been posted in the last 6 months.
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 November 2010 at 5:33pm |
Hi RGelb How many actual posts are we talking about? I found a link here (okay it is for wordpress) but it may give you a heads up on what code to run on an SQL query: LinkI typed in "SQL script to get rid of all posts after a certain date" I don't know if this helps or hinders, but Bruce will be the man who can give you a definitive answer - I'm only guessing
|
|
|
|
rgelb
Newbie
Joined: 04 August 2005
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 November 2010 at 5:36pm |
|
@MrTws - We are talking about 6 months of spam (probably several thousand entries). Thanks for the link - but yeah, its for WordPress - difference schema.
|
|
