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 :)
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).