Icy Phoenix

     
 


Post new topic  Reply to topic 
Page 1 of 1
 
 
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.
 



 
tiolaluSend private messageVisit poster's website  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
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
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
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
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
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.
 



 
tiolaluSend private messageVisit poster's website  
Back to topPage bottom
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.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
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
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
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.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
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
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support
 
TheSteffenSend private message  
Back to topPage bottom
Post new topic  Reply to topic  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron