A few questions regarding users who have declined admin emails

[Joe Blow]

Hello,

I have a few questions regarding users who have declined admin emails. I am now making it part of my terms of use that all registered members MUST allow admin emails or their access will be restricted.

My questions are:

1. How do I send out an email only to those members in a particular usergroup who have declined admin emails to notify them of the change? I would like to avoid sending this out to all 15,000+ members if possible.

2. How do I change the settings of all those who have declined admin emails so that they now accept them by default?

3. Is there any way to make it so that members of a particular user group can not change the admin emails setting (so that it is always set to 'accept')?

Any help with this would be appreciated.

[Jake Bunce]

1) You can send out a mass email in your:

Admin CP -> Users -> Send Email to Users

But there is no option to send it only to users who have declined to receive admin emails.

2) You can set the default for new registrations in your:

Admin CP -> vBulletin Options -> User Registration Options -> Default Registration Options

You can mass update the preferences of exsiting users in your:

Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries. You must have permission to execute queries in your includes/config.php file:

	//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
	//	The users specified here will be allowed to run queries from the control panel.
	//	See the above entries for more information on the format.
	//	Please note that the ability to run queries is quite powerful. You may wish
	//	to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

3) No, but the Send Email to Users page has an option to ignore that setting.

[Joe Blow]

1Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries. You must have permission to execute queries in your includes/config.php file:

Hi Jake,

Thanks for answering my queries.

What would be the SQL query if I only wanted to change the settings of the users in a particular usergroup so that they were opted in to accept admin emails?

[Jake Bunce]

You don't need to change that setting to send admin emails to a specific group. You can send email to a specific group and override that setting in your:

Admin CP -> Users -> Send Email to Users

[Joe Blow]

You don't need to change that setting to send admin emails to a specific group. You can send email to a specific group and override that setting in your:

Admin CP -> Users -> Send Email to Users

Sorry Jake, I didn't make myself clear. Some of the users in the 'Registered Users' usergroup selected 'No' to admin emails when they registered. I have since changed my TOU to require that everyone in the usergroup accept admin emails.

What I want to know is what SQL query will ensure that all members of that usergroup have 'Accept Admin Emails' set to 'Yes'?

[Jake Bunce]

You can mass update the preferences of exsiting users in your:

Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries. You must have permission to execute queries in your includes/config.php file:

	//	****** USERS WITH QUERY RUNNING PERMISSIONS ******
	//	The users specified here will be allowed to run queries from the control panel.
	//	See the above entries for more information on the format.
	//	Please note that the ability to run queries is quite powerful. You may wish
	//	to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

[Joe Blow]

You can mass update the preferences of exsiting users in your:

Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries. You must have permission to execute queries in your includes/config.php file:

    //    ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    //    The users specified here will be allowed to run queries from the control panel.
    //    See the above entries for more information on the format.
    //    Please note that the ability to run queries is quite powerful. You may wish
    //    to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = '';

Thanks Jake.

Will that do all forum users or can I choose particular usergroups?

[Jake Bunce]

That is for all users. Here is the query for just the Registered Users group:

UPDATE user
SET options = options + 16
WHERE NOT(options & 16)
AND usergroupid = 2

[Joe Blow]

Thanks Jake!!!!!!!

[faiz2005]

Dear Jake...

I have Data Import for MySQL, and it’s easy to update for my, in which table I have to update and what is the parameter to make it active?


Please your help ASAP.

Regards;

That is for all users. Here is the query for just the Registered Users group:

UPDATE user
SET options = options + 16
WHERE NOT(options & 16)
AND usergroupid = 2

[faiz2005]

Please your reply ASAP.

Thanks;

[faiz2005]

Experts Please your reply

[Steve Machol]

I have no idea what you are asking. Please start your own thread with all the relevant details. Thank you.