Hello,
I have an 18 years old forum that had been junked by spam posts overtime.
i would like to remove the posts and topics that contain specific spam keywords directly from the database
Will deleting the posts from *messages* table alone do the job? if so should the topic be removed?
Could you suggest an MYSQL query that looks for specific keywords in a message and delete related topic
Note that, Many posts we posted by guests, i just want a bulk way to clean up the site
Any advise how to move forward is well appreciated
Quote from: ryansdistrict on August 21, 2024, 05:11:15 AMi would like to remove the posts and topics that contain specific spam keywords directly from the database
I would strongly advice, if I may, against doing that. You should never delete posts, topics. members etc directly from the database.
The best way imo would be to do that through a party mod that will handle it properly.
This mod might do what you want
https://custom.simplemachines.org/index.php?mod=2427
Do not do direct database edits -- especially not deletes like that.
Multiple tables are linked to each other abd just deleting will cause all sorts of problems...