Hello.
I installed "MyAlerts" and so far it's conflicting with all members being auto-subscribed to all posts.
How can I remove all subscriptions that the members have.
Also turn off automatic subscriptions, for all members and new ones that will register in the future?
In your phpMyAdmin run the following SQL queries:
DELETE FROM `xxxxforumsubscriptions` WHERE 1
DELETE FROM `xxxxthreadsubscriptions` WHERE 1
UPDATE `xxxxusers` SET `subscriptionmethod`=0 WHERE 1
where xxxx is the table prefix of your database.
This will delete everything which is connected with subscriptions.
(2015-06-07, 12:45 PM)Alcatraz93 Wrote: [ -> ] (2015-06-06, 08:42 PM)Ad Bakker Wrote: [ -> ]In your phpMyAdmin run the following SQL queries:
DELETE FROM `xxxxforumsubscriptions` WHERE 1
DELETE FROM `xxxxthreadsubscriptions` WHERE 1
UPDATE `xxxxusers` SET `subscriptionmethod`=0 WHERE 1
where xxxx is the table prefix of your database.
This will delete everything which is connected with subscriptions.
This will:- Delete all current subscriptions.
- Disable auto subscription?
yes, the first 2 delete all existing forum and thread subscription, the last sets subscription method of all users to "no subscription" (when they start a thread or contribute to an existion one).
However, users can change this setting in their UserCP Options. To make that impossible you will need a (small) plugin. Let it know when you need help with that.
(2015-06-07, 02:46 PM)Ad Bakker Wrote: [ -> ] (2015-06-07, 12:45 PM)Alcatraz93 Wrote: [ -> ] (2015-06-06, 08:42 PM)Ad Bakker Wrote: [ -> ]In your phpMyAdmin run the following SQL queries:
DELETE FROM `xxxxforumsubscriptions` WHERE 1
DELETE FROM `xxxxthreadsubscriptions` WHERE 1
UPDATE `xxxxusers` SET `subscriptionmethod`=0 WHERE 1
where xxxx is the table prefix of your database.
This will delete everything which is connected with subscriptions.
This will:- Delete all current subscriptions.
- Disable auto subscription?
yes, the first 2 delete all existing forum and thread subscription, the last sets subscription method of all users to "no subscription" (when they start a thread or contribute to an existion one).
However, users can change this setting in their UserCP Options. To make that impossible you will need a (small) plugin. Let it know when you need help with that.
nope i just want the default one to be turned off, as it seems to be on by default, thnx ill give it a try
Uhm what is xxxxthreadsubscriptions supposed to be? lol
also this wouldnt turn it off by default, new members would still have it.. ?
(2015-06-07, 04:18 PM)Alcatraz93 Wrote: [ -> ]nope i just want the default one to be turned off, as it seems to be on by default, thnx ill give it a try
Uhm what is xxxxthreadsubscriptions supposed to be? lol
also this wouldnt turn it off by default, new members would still have it.. ?
As explained, xxxx stands for the forum prefix in your database, this must be clear when you are on PhpMyAdmin, you can also see it in your confg.php file.
For the remaining, the database changes change things as they are (nobody subscribed to anything, and users will not be subscribed to threads which they start or contribute to).
For new members, these are given the choice how to deal with subscriptions. When you want to cancel that you need to change the register template, but best is to do that with a plugin.
The same for existing members who are able to change their subscription method through their UserCP. You can switch that off by changing a template or (better) by a plugin.
Last but not least, all buttons in forum and thread displays by which you can subscribe to forums and threads should be removed, again by changing the templates or by a plugin.
The plugin needed for this is not complicated, but it requires some research which templates must be changed.
When you do it by changing templates you get into trouble when a new software version becomes available, than you must repeat the template changes every time.