Square Wheels Posted February 5 Share Posted February 5 I want to move a couple thousand users to a new member group. I understand IPS does not advocate editing things directly in the database, but it would save me many hours of editing individual records in the ACP. Can I edit member_group_id directly? Link to comment Share on other sites More sharing options...
Solution Adriano Faria Posted February 5 Solution Share Posted February 5 3 minutes ago, Square Wheels said: Can I edit member_group_id directly? Yep. update core_members set member_group_id = X where member_group_id = Y A backup is always recommended. Square Wheels 1 Link to comment Share on other sites More sharing options...
Nathan Explosion Posted February 5 Share Posted February 5 8 minutes ago, Square Wheels said: I want to move a couple thousand users to a new member group. If that provided SQL query definitely is meeting your needs then you could have just done the following on the members listing in the ACP... On the resulting dialog, change "Group" from '-Any Group-' to the name of the group that people are in - then click the 'Search' button. Then click the link... Thus saving you many hours... 11 minutes ago, Square Wheels said: but it would save me many hours of editing individual records in the ACP. Link to comment Share on other sites More sharing options...
Square Wheels Posted February 5 Author Share Posted February 5 Just now, Nathan Explosion said: If that provided SQL query definitely is meeting your needs then you could have just done the following on the members listing in the ACP... On the resulting dialog, change "Group" from '-Any Group-' to the name of the group that people are in - then click the 'Search' button. Then click the link... Thus saving you many hours... Thanks, there are about 12k members in the database, I want to update select members from group x to group y, not all members of group x. Link to comment Share on other sites More sharing options...
Nathan Explosion Posted February 5 Share Posted February 5 (edited) 1 minute ago, Square Wheels said: I want to update select members from group x to group y, not all members of group x. What are the criteria that you are using at the query level to select those members? Note: I'm more interested in here in showing someone that the query above isn't needed, just in case someone arrives at this topic at a later point. Edited February 5 by Nathan Explosion Marc Stridgen 1 Link to comment Share on other sites More sharing options...
Square Wheels Posted February 5 Author Share Posted February 5 10 minutes ago, Nathan Explosion said: What are the criteria that you are using at the query level to select those members? Note: I'm more interested in here in showing someone that the query above isn't needed, just in case someone arrives at this topic at a later point. I'll be using email. Link to comment Share on other sites More sharing options...
Nathan Explosion Posted February 5 Share Posted February 5 specific email addresses? Understood...you've probably created a number of SQL queries then (1 per email address) and not just using one catch-all query. But for the benefit of those reading at a later point - if wanting to do this for a specific email domain then can be done via the above method: Square Wheels 1 Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts