Useful queries for mass-moving members

A common request is for a method to mass move members into a new group (for example: you have created and adjusted your member groups but now you have a lot of members in the wrong group and do not want to manually move them all)

This is easy to achieve via a query.

As always with running a query, if in doubt: Stop and ask advice before doing anything.


First, find out the ID of the member groups you wish to move.

Visit the SQL toolbox > ACP > Admin > SQL Management > SQL Toolbox > Scroll down to the manual query window (this is where you will be running any queries)

Run this one...

SELECT g_id, g_title FROM ibf_groups

UPDATE ibf_members SET mgroup = X WHERE mgroup = Y

UPDATE ibf_members SET mgroup = X WHERE mgroup = Y AND posts > P

UPDATE ibf_members SET mgroup = X WHERE mgroup = Y AND posts < P

Komentarze:

Brak komentarzy