How to delete or hide whole post with words or urls form list?

[AlexandrBu]

Hello

I am looking for a way to hide or delete all posts(allready posted) with words(bad words) or urls(bad urls)
Not to hide or delete just a word but whole post!

Is where a way to do it from MySQLd console or some phpbb tool?

Or maybe some mod could do it?

[Lumpy Burgertushie]

there is really no way to do it all at once in default phpbb.
you could create a word censor list in the admin panel that would replace the bad words with whatever you wish.
however, that would not delete or hide the whole post.
I believe you could do some of this directly in the database with the proper queries but I have no idea what those exact queries
would have to be.

you are probably going to have to do this manually.

luck,
robret

[Mick]

Or maybe some mod could do it?

We don’t recommend ‘mods’ anymore since the introduction of extensions. You could make an extension request though and see if there are any takers.

[david63]

I am looking for a way to hide or delete all posts(allready posted) with words(bad words) or urls(bad urls)
Not to hide or delete just a word but whole post!

What about any posts that quote the post - what would you do with those?

[KevC]

Is this for spam or something else?
A better idea of the bigger picture of what you're trying to do might help.

[AlexandrBu]

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

UPDATE phpbb_posts 
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?

[janus_zonstraal]

Preventing spam is the best option, how are you preventing it now on your board?