PDA

View Full Version : Can I un-subscribe members from a thread they can't access?


Fergal C
10-09-2011, 09:15 AM
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:

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.