vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Mass prune forums if certain words in threads? (https://vborg.vbsupport.ru/showthread.php?t=59512)

Meirion 01-02-2004 03:50 PM

Mass prune forums if certain words in threads?
 
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. :D :up:
Thanks
Meza

MindTrix 01-02-2004 06:15 PM

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 01-03-2004 10:10 AM

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. :D

VB rocks.

Meirion 01-05-2004 10:01 AM

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 01-05-2004 04:48 PM

anyone else?


All times are GMT. The time now is 08:22 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01043 seconds
  • Memory Usage 1,710KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete