Announcement

Collapse
No announcement yet.

A few questions regarding users who have declined admin emails

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:


  • faiz2005
    replied
    Experts Please your reply

    Leave a comment:


  • faiz2005
    replied
    Please your reply ASAP.

    Thanks;

    Leave a comment:


  • faiz2005
    replied
    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;



    Originally posted by Jake Bunce View Post
    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

    Leave a comment:


  • Joe Blow
    replied
    Thanks Jake!!!!!!!

    Leave a comment:


  • Jake Bunce
    replied
    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

    Leave a comment:


  • Joe Blow
    replied
    Originally posted by Jake Bunce View Post
    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:

    Code:
        //    ****** 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?

    Leave a comment:


  • Jake Bunce
    replied
    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:

    Code:
    	//	****** 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'] = '';

    Leave a comment:


  • Joe Blow
    replied
    Originally posted by Jake Bunce View Post
    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'?

    Leave a comment:


  • Jake Bunce
    replied
    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

    Leave a comment:


  • Joe Blow
    replied
    Originally posted by Jake Bunce View Post
    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?

    Leave a comment:


  • Jake Bunce
    replied
    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:

    Code:
    	//	****** 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.

    Leave a comment:


  • A few questions regarding users who have declined admin emails

    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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X