Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

query posts for deletion

Quote Reply
query posts for deletion
Hello,

I have a forum that adds posts from received emails (via MailArc). Sometime ago (Blush) it got on a spam list and now there's a a bunch of spam post in this forum. I would like to delete a bunch of posts but keep others. Without going through post by post and KEEP each good one, then delete all old posts; I was hoping for another solution.

There are specific keywords that would protect the keepers. If I use a SQL statement to kill * where keywords in subject are not found, would it hose up any other part of GForum? In other words, are posts tracked in other tables that I need to fix. I don't care about user post counts (I have forced all MailArc posts to post under a generic user unless the email address of an existing user is found).

Any danger here?

Thanks!

Dave
Subject Author Views Date
Thread query posts for deletion bretzke 2423 Mar 17, 2005, 8:23 AM
Thread Re: [bretzke] query posts for deletion
fmp 2336 Mar 22, 2005, 5:11 PM
Post Re: [fmp] query posts for deletion
minesite 2330 Mar 23, 2005, 12:58 AM
Post Re: [bretzke] query posts for deletion
fmp 2304 Mar 28, 2005, 4:37 AM