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

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
User avatar
AlexandrBu
Registered User
Posts: 44
Joined: Tue Jan 02, 2018 6:31 am

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

Post by 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?
User avatar
Lumpy Burgertushie
Registered User
Posts: 68549
Joined: Mon May 02, 2005 3:11 am
Contact:

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

Post by 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
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 23055
Joined: Fri Aug 29, 2008 9:49 am

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

Post by Mick »

AlexandrBu wrote:
Fri Oct 02, 2020 4:00 am
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.
"The more connected we get the more alone we become" - Kyle Broflovski©
User avatar
david63
Registered User
Posts: 19028
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

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

Post by david63 »

AlexandrBu wrote:
Fri Oct 02, 2020 4:00 am
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?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70432
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

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

Post by KevC »

Is this for spam or something else?
A better idea of the bigger picture of what you're trying to do might help.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
User avatar
AlexandrBu
Registered User
Posts: 44
Joined: Tue Jan 02, 2018 6:31 am

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

Post by AlexandrBu »

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

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?
User avatar
janus_zonstraal
Registered User
Posts: 5120
Joined: Sat Aug 30, 2014 1:30 pm

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

Post by janus_zonstraal »

Preventing spam is the best option, how are you preventing it now on your board?
Sorry! My English is bat ;) !!!
Post Reply

Return to “[3.3.x] Support Forum”