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.
How To Unsuscribe All Users From All Forums?
Subject: Re: How To Unsuscribe All Users From All Forums?
Yes, with this you can change all users to 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
tiolalu wrote: [View Post]
Yes, with this you can change all users to 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
Subject: 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...
If, like I guess, is it working only for new post than we have to change more...
Subject: Re: How To Unsuscribe All Users From All Forums?
TheSteffen, oh thanks, thanks! :mrorange:
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.
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.
Subject: 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:
Replace phpbb: with your current tables prefix.
If you want just to empty notifications tables you need to empty both topics and forums notifications:
TRUNCATE TABLE `phpbb_topics_watch;
TRUNCATE TABLE `phpbb_forums_watch`;
TRUNCATE TABLE `phpbb_forums_watch`;
Replace phpbb: with your current tables prefix.
Subject: Re: How To Unsuscribe All Users From All Forums?
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?
Mighty Gorgon wrote: [View Post]
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?
Subject: 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.
Subject: Re: How To Unsuscribe All Users From All Forums?
Hehehe :mricy:
Then we should leave it like it is. :mricy:
We now have here a way to unsuscribe everything :D
Then we should leave it like it is. :mricy:
We now have here a way to unsuscribe everything :D
Page 1 of 1
You cannot post new topicsYou 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
This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Powered by Icy Phoenix based on phpBB
Generation Time: 0.5464s (PHP: 5% SQL: 95%)
SQL queries: 14 - Debug Off - GZIP Enabled