Icy Phoenix

     
 

How To Unsuscribe All Users From All Forums?

How To Unsuscribe All Users From All Forums?

Article
Reply with quote    Download Post  
Post How To Unsuscribe All Users From All Forums? 
 
Hi,

I just want to know how can I unsuscribe all users from all forums (I suposed it's a SQL sentence).

Thanks in advance.



 
tiolalu - View user's profile Send private message  
tiolalu [ Tue 23 Mar, 2010 01:27 ]
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us


How To Unsuscribe All Users From All Forums?

Comments
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
tiolalu wrote: [View Post]
(I suposed it's a SQL sentence).


Yes, with this you can change all users to 0

Code: [Download] [Hide] [Select]
UPDATE `phpbb_users` SET `user_notify` = '0';

Remember to make a backup bevor.
And change phpbb_ to you prafix

I think this only helps for new topics. ("Notify me when a reply is posted" is unchecked)
For the old ones you have to change it also in DB for every post.
I will check this



 
TheSteffen - View user's profile Send private message  
TheSteffen [ Wed 24 Mar, 2010 21:36 ]
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
Can you try my solution and tell me if it is working fine?!?

If, like I guess, is it working only for new post than we have to change more...



 
TheSteffen - View user's profile Send private message  
TheSteffen [ Wed 24 Mar, 2010 21:51 ]
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
TheSteffen, oh thanks, thanks!  

I can't try it right now, I'm trying to move the mail server and I have some problems with it.
When I try it I will tell you.



 
tiolalu - View user's profile Send private message  
tiolalu [ Thu 25 Mar, 2010 01:05 ]
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
Solution posted by Steffen actually disable notifications for all users, but do not disable past enabled notifications.

If you want just to empty notifications tables you need to empty both topics and forums notifications:

Code: [Download] [Hide] [Select]
TRUNCATE TABLE `phpbb_topics_watch;
TRUNCATE TABLE `phpbb_forums_watch`;


Replace phpbb: with your current tables prefix.



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Thu 25 Mar, 2010 14:26 ]
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
Mighty Gorgon wrote: [View Post]
Solution posted by Steffen actually disable notifications for all users, but do not disable past enabled notifications.


That is right... but I think that is not a good way. If a user decide "Always notify me of replies" NO than he should not get any e-mail when someone replies to a topic you have posted in.

What do you think?



 
TheSteffen - View user's profile Send private message  
TheSteffen [ Fri 26 Mar, 2010 12:46 ]
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
I think that it is not a good idea because if you disable it for a test you will lose all your notifications... if a user wants to reset the notifications it is enough to manually remove notifications in UCP.



 
Mighty Gorgon - View user's profile Send private message  
Mighty Gorgon [ Fri 02 Apr, 2010 09:31 ]
Reply with quote    Download Post  
Post Re: How To Unsuscribe All Users From All Forums? 
 
Hehehe
Then we should leave it like it is.  

We now have here a way to unsuscribe everything  



 
TheSteffen - View user's profile Send private message  
TheSteffen [ Sat 03 Apr, 2010 12:55 ]
Display posts from previous:    

HideWas this topic useful?

Post new topic  Reply to topic  Page 1 of 1
 
 




 


 

  cron