Advertisement:

Author Topic: Mass Delete Unapproved Posts  (Read 170 times)

Offline Groover2

  • Newbie
  • *
  • Posts: 3
Mass Delete Unapproved Posts
« on: February 06, 2019, 05:47:13 PM »
My forum has been attacked by spammers. I have used quick moderation to remove the 97 spam topics but the bulk of the spam is in unapproved topic replies.

How can I mass-delete these replies? I can't see them on the forum because they are not approved. I can only see them in the Moderation Center, which only shows me 10 at a time. To delete all 10 I have to click three times so I am looking at 3708 x 3 = 11,124 mouse clicks.

Is there a better way?

I've read that trying to do this through MySQL results in a messed up database.

Running 2.0.15. Thanks.

Offline jangofett

  • Newbie
  • *
  • Posts: 4
Re: Mass Delete Unapproved Posts
« Reply #1 on: February 06, 2019, 07:11:58 PM »
My forum has been attacked by spammers. I have used quick moderation to remove the 97 spam topics but the bulk of the spam is in unapproved topic replies.

How can I mass-delete these replies? I can't see them on the forum because they are not approved. I can only see them in the Moderation Center, which only shows me 10 at a time. To delete all 10 I have to click three times so I am looking at 3708 x 3 = 11,124 mouse clicks.

Is there a better way?

I've read that trying to do this through MySQL results in a messed up database.

Running 2.0.15. Thanks.

we got attacked by a bunch of russian ones so I added a captcha at registration. I get a few complaints about the captcha for registration but it knocked out the spam. this forum has you run the captcha to even post.

Offline Groover2

  • Newbie
  • *
  • Posts: 3
Re: Mass Delete Unapproved Posts
« Reply #2 on: February 07, 2019, 11:21:28 AM »
Thanks. Already have anti-spam in place but it doesn't work very well at all. I will probably be making a new topic on that subject.

Offline Groover2

  • Newbie
  • *
  • Posts: 3
Re: Mass Delete Unapproved Posts
« Reply #3 on: February 07, 2019, 12:57:08 PM »
OK, well, here is what I did:

delete from `smf_messages` where approved = '0';

Members -> Seatch for Members -> Posts = 0, delete all

Maintenance -> Routine -> Find and repair any errors -> fix all

Maintenance -> Database -> Optimize tables - saved 166Mb from smf_messages!

Seems to be OK.