Mass prune forums if certain words in threads?

[Meirion]

Hi there,

I'd like to have a mass prune on all my forums, basically deleting any thread containing certain words. We are having a mass profanity clear out!

How could this be done, would it need just a big mySQL query or a bit of a hack?
If possible it would be nice to keep a private archive or backup of all the deleted threads, for future reference.

Any help appreciated. :up:
Thanks
Meza

[MindTrix]

Have you tried adding the profanity words to vBulletin's built in bad words censoring thing lol, found in the admin control panel under vBulletin options?

Im guessing that adding the words here will blank them from all previous posts but im not too sure. Got too be worth a shot though

[Infopro]

Recently I ran a query on my DB to change every instance of my old forums links thread to thread, to reflect a change in the URL. It worked great.
I changed every instance of (example) domain.net/forums/ to forums.domain.net

I would think you could do the same for a word you don't like.
All of this can be done right from the admin panel.

VB rocks.

[Meirion]

Hi guys, thanks for the suggestions. However I actually want to delete from the DB any post containing these words.

I thought I could use the search index table to get a list of post IDs for the words, and then do some SQL like this...

DELETE from POSTS where ID = 1 OR 2 OR 5 OR 9 OR 13 OR etc etc etc for all of the post-IDs

Do you think that would work? Then would I have to update counters and delete those word's rows from the search index table?

[Meirion]

anyone else?