Hello,
I have a forum that adds posts from received emails (via MailArc). Sometime ago (
) 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
I have a forum that adds posts from received emails (via MailArc). Sometime ago (
) 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
query posts for deletion