Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

query posts for deletion

Quote Reply
query posts for deletion

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?


Subject Author Views Date
Thread query posts for deletion bretzke 3017 Mar 17, 2005, 8:23 AM
Thread Re: [bretzke] query posts for deletion
fmp 2916 Mar 22, 2005, 5:11 PM
Post Re: [fmp] query posts for deletion
minesite 2910 Mar 23, 2005, 12:58 AM
Post Re: [bretzke] query posts for deletion
fmp 2884 Mar 28, 2005, 4:37 AM