Announcement

Collapse
No announcement yet.

A few questions regarding users who have declined admin emails

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

  • 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.

  • #2
    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.

    Comment


    • #3
      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?

      Comment


      • #4
        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

        Comment


        • #5
          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'?

          Comment


          • #6
            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'] = '';

            Comment


            • #7
              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?

              Comment


              • #8
                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

                Comment


                • #9
                  Thanks Jake!!!!!!!

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      Please your reply ASAP.

                      Thanks;

                      Comment


                      • #12
                        Experts Please your reply

                        Comment


                        • #13
                          I have no idea what you are asking. Please start your own thread with all the relevant details. Thank you.
                          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                          Change CKEditor Colors to Match Style (for 4.1.4 and above)

                          Steve Machol Photography


                          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                          Comment

                          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                          Working...
                          X