Advertisement:

How to move ungrouped members ?

Aloittaja Tanks, maaliskuu 14, 2005, 08:25:22 AP

« edellinen - seuraava »

Tanks

Is there any easy way to move all ungrouped members to a member group i have made ??

on my board there is a group called Diplomatic Group - This is where all members who are not a member of the clan i am in goes.

So if i have 50 ungrouped members and i want them all to be put in that diplomatic group - how do i do this without goin into every single profil and do it.

Hope somebody understand my question  :)

Oldiesmann

First, figure out what the Group ID is for that group.

Easiest way to find it:
SELECT ID_GROUP FROM smf_membergroups WHERE groupName='Diplomatic Group';

Then, just do this:
UPDATE smf_members SET ID_GROUP = '{diplomatic_group_id}' WHERE ID_GROUP = '0';

Just replace {diplomatic_group_id} with the value you got from the first query and use your own database prefix in place of smf_ (if it's different).
Michael Eshom
Christian Metal Fans

Advertisement: