How to add all existing users to a usergroup by a query

  • In an effort to control spam I want to manually approve all new users and add them to a usergroup. I want to make certain categories and forums visible only to users in a specific usergroup, ex “Approved”. So when a new user registers and gets added to the WordPress user database they can’t see anything (or specific forums) until I or an assistant add them to the “Approved” usergroup.

    (see Asgaros Admin Guide for User Groups – https://www.asgaros.de/docs/administration-guide/user-groups/)

    But all my existing users (4,500) must be added to that “Approved” usergroup first. I tried using bulk edit of users but you can only bulk select a page of users at a time. I changed the screen options to show 999 users on a page but when I bulk select the page blows up (the tab disappears in the browser!).

    Is there another way to accomplish this? Can someone construct a SQL query with the appropriate fields and actions to use in phpmyadmin?

    Many thanks in advance

Viewing 1 replies (of 1 total)
  • Thread Starter ffooccuuss

    (@ffooccuuss)

    Nevermind! I figured it out. The users page doesn’t break if you select 300 users per page in the screen options. So I can have 300 users per page and click the ‘select all’ checkbox and then click ‘Bulk Actions’, select the usergroup I want to add them to, then click on ‘apply.’ The only issue is that will 4500 users that is about 15-16 pages to repeat that process. Not a big deal.

    But you have to remember, after you add all the users to the usergroup, then you have to edit your forum (or multiple forums or all of them) to require membership in that usergroup for them to be visible.

    Then, for newly registered users, you can review their applications or IP address or ‘reason for joining’ criteria and then manually add them to the ‘approved’ usergroup and then can see and post.

Viewing 1 replies (of 1 total)
  • The topic ‘How to add all existing users to a usergroup by a query’ is closed to new replies.