Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 5, 2024Feb 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?
February 5, 2024Feb 5 Solution 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.
February 5, 2024Feb 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.
February 5, 2024Feb 5 Author 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.
February 5, 2024Feb 5 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, 2024Feb 5 by Nathan Explosion
February 5, 2024Feb 5 Author 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.
February 5, 2024Feb 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:
