[SQL] Sorting users into one group

[eMike]

Originally Posted by MarcoH64

The most secure way if you are not using reputation that is, would be the following:

[sql]UPDATE user set reputation = 99999999 WHERE username LIKE 'Clan-A_%'[/sql]
Then create a Usergroup Promotion that will promote the user to the correct usergroup if they have > 99999998 reputation. Wait until the promotion has run.

Then reset (rebuild or reset with SQL) reputation, and go repeat the process for the next group.

Make sure that if you have 'Clan_Member' and 'Clan_A_Member' you process the longest identifier first, and exclude the longer group when you go processing 'Clan_%'.

I have not tested this, so first try on a testboard. Also make sure you have good backups.

It worked like a dream Marco!
My deepest and sincerest thanks! That saved me for endless upon endless hours of manual nightmares.