vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Can I un-subscribe members from a thread they can't access? (https://vborg.vbsupport.ru/showthread.php?t=271696)

Fergal C 10-09-2011 09:15 AM

Can I un-subscribe members from a thread they can't access?
 
I have a thread in a non-public area of my forum, that includes removed spam posts. One of our members has contacted me to say that he is getting emails re new posts being added to this thread. Is it possible for me to disable all subscriptions to this thread, or perhaps to the forum that it is in?

Thanks!

kh99 10-09-2011 11:47 AM

You could execute one or both of these SQL queries:

Code:

DELETE FROM subscribethread WHERE threadid = T

DELETE FROM subscribeforum WHERE forumid = F


of course you'd change T and F to the threadid and forumid you want to remove subscriptions from.

This is pretty safe as long as you're careful not to make a typo, but it's always a good idea to have a recent backup before doing anything like this.

Fergal C 10-16-2011 09:21 AM

Thanks a lot for the reply and for the suggestion kh99. Unfortunately that's a bit too technical for me at the moment. I was hoping that there was a way to do it in the ACP.

kh99 10-16-2011 11:22 AM

Well, of course you *can* execute SQL from the ACP, but I understand what you mean.


All times are GMT. The time now is 06:23 PM.

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.01089 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)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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