Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Square Wheels Posted February 5 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?
Solution Adriano Faria Posted February 5 Solution 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
Nathan Explosion Posted February 5 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.
Square Wheels Posted February 5 Author 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.
Nathan Explosion Posted February 5 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 1
Square Wheels Posted February 5 Author 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.
Nathan Explosion Posted February 5 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
Recommended Posts