Possible to Mass-move users into (COPPA) usergroup?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GearTripper
    Senior Member
    • Aug 2004
    • 440

    Possible to Mass-move users into (COPPA) usergroup?

    Is this action not possible within the AdminCP?
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    Admin CP -> Users -> Prune / Move Users

    Enter your search criteria. The next page will give you the option to move the matching users.

    Comment

    • GearTripper
      Senior Member
      • Aug 2004
      • 440

      #3
      Originally posted by Jake Bunce
      Admin CP -> Users -> Prune / Move Users

      Enter your search criteria. The next page will give you the option to move the matching users.
      Yes, but there is no option to move users into the COPPA usergroup.

      Comment

      • Jake Bunce
        Senior Member
        • Dec 2000
        • 46598
        • 3.6.x

        #4
        Oh ok, you will need to use a query for that. What is the criteria? From which group to which group?

        Also, why do you want to move users to that group? That group is used as a holding group for pending registrations.

        Comment

        • GearTripper
          Senior Member
          • Aug 2004
          • 440

          #5
          Our new setup recently is working well using this method. I would like to move a few hundred lost souls on my forum in order to help guide them on their journey. Criteria should be primary users from Usergroup 2 with a zero post count get moved into the COPPA usergroup 4.

          Comment

          • GearTripper
            Senior Member
            • Aug 2004
            • 440

            #6
            :bump:

            Comment

            • Jake Bunce
              Senior Member
              • Dec 2000
              • 46598
              • 3.6.x

              #7
              I don't know how I missed your post. Here is the query based on your criteria:

              Code:
              UPDATE user
              SET usergroupid = 4
              WHERE usergroupid = 2
              AND posts = 0

              Comment

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