Advertisement:

Author Topic: Delete all threads that have less than 2 words  (Read 616 times)

Offline kittonium

  • Semi-Newbie
  • *
  • Posts: 62
Delete all threads that have less than 2 words
« on: July 11, 2018, 01:59:27 PM »
This will be very useful when you have hundreds of spam threads by many users.

if nobody wants to make this mod, is it safe deleting messages from phpmyadmin in the "smf_messages" table?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,514
  • Gender: Male
    • Kindred-999 on GitHub
Re: Delete all threads that have less than 2 words
« Reply #1 on: July 11, 2018, 02:35:47 PM »
why don't you just prevent spammers from registering in the first place?
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Sh@mbles

  • SMF Hero
  • ******
  • Posts: 5,016
  • Gender: Male
    • i30 Owners Club
Re: Delete all threads that have less than 2 words
« Reply #2 on: July 11, 2018, 02:45:54 PM »
^ this, plus use a minimum word count checker.

https://custom.simplemachines.org/mods/index.php?mod=1528

Quote
is it safe deleting messages from phpmyadmin in the "smf_messages" table
Yes, as long as you know what you're doing.


Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 50,250
Re: Delete all threads that have less than 2 words
« Reply #3 on: July 11, 2018, 02:49:28 PM »
usually if you have to ask you dont know enough to be doing it directly in the database.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,514
  • Gender: Male
    • Kindred-999 on GitHub
Re: Delete all threads that have less than 2 words
« Reply #4 on: July 11, 2018, 03:08:20 PM »
and to be clear... you can't just delete the row from the smf_messages table. there are other, interconnected tables
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.