FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » How To » Deleting a users subscription
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Deleting a users subscription [message #8177] Wed, 15 January 2003 09:19 Go to next message
malc is currently offline  malc   United Kingdom
Messages: 3
Registered: November 2002
Location: UK
Karma: 0
Junior Member
I have a user who is subscribed to receive notifications when a new topic is created, however their address is creating a bounce. Is it possible through the interface to delete their subscription? If not, what tables in the database do I need to look at?

Many thanks

Mal

Report message to a moderator

Re: Deleting a users subscription [message #8185 is a reply to message #8177] Wed, 15 January 2003 15:06 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Only the user themself can delete their own subscriptions via a 'nice' web control panel. If you want to unsubscribe a user manually you can do it by running the following two queries:


DELETE FROM PREFIX_forum_notify WHERE user_id=USER's_ID
DELETE FROM PREFIX_thread_notify WHERE user_id=USER's_ID

P.S. substitute PREFIX with your SQL prefix you've specified during installation.

FUDforum Core Developer

Report message to a moderator

Re: Deleting a users subscription [message #8187 is a reply to message #8185] Wed, 15 January 2003 15:14 Go to previous messageGo to next message
malc is currently offline  malc   United Kingdom
Messages: 3
Registered: November 2002
Location: UK
Karma: 0
Junior Member
Hmm .. don't know how I missed that when looking at the tables.

Anyway, done the job .. many thanks.

Report message to a moderator

Unsubscribe all (Re: Deleting a users subscription) [message #27017 is a reply to message #8185] Wed, 24 August 2005 18:39 Go to previous messageGo to next message
Astoria is currently offline  Astoria   United States
Messages: 227
Registered: April 2004
Karma: 0
Senior Member
Ilia wrote on Wed, 15 January 2003 07:06

Only the user themself can delete their own subscriptions via a 'nice' web control panel. If you want to unsubscribe a user manually you can do it by running the following two queries:


DELETE FROM PREFIX_forum_notify WHERE user_id=USER's_ID
DELETE FROM PREFIX_thread_notify WHERE user_id=USER's_ID

P.S. substitute PREFIX with your SQL prefix you've specified during installation.


I have a user who subscribed to a bunch of threads, who now wants to switch to subscribing by forums, but he can find no way to do a "mass delete" of all his thread_notify subscriptions.

It would be nice to have "Unsubscribe all forums" and "Unsubscribe all topics" links as features in User CP ==> Subscriptions.

Report message to a moderator

Re: Unsubscribe all (Re: Deleting a users subscription) [message #27031 is a reply to message #27017] Wed, 24 August 2005 23:29 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Added in CVS.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Login / No Login for different forums
Next Topic: Create a poll problem
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 12:26:34 GMT 2024

Total time taken to generate the page: 0.02847 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software