KevC wrote: ↑
Fri Oct 02, 2020 9:20 am
Is this for spam or something else?
A better idea of the bigger picture of what you're trying to do might help.
Yes its a spam(how to delete/hide mass spam posts) and a state or google censorship (the situation than your need to delete/hide posts with discussions that could bring problems(according to new laws) to forum exsitence -not in all countries this problem existes)
So i has found this solution
All post with name Lord Voldemort
will be hidden for users, and will be show as only Display this post.
for moderators - after SQL command
Code: Select all
SET phpbb_posts.post_visibility = 2
WHERE phpbb_posts.post_text LIKE '%Lord Voldemort%
Is this only solution?
Is it healthy(good) way to do it for phpbb database?