Page 1 of 1

HELP fast please default

Posted: Mon Oct 12, 2015 7:04 pm
by Smithgb
I accidentally added as default many people to certain new group i created. can i somehow undo that or run sql query. before that they were either in registered user or nru+ru if new...im scared to put them all in those groups will they be defaulted? I cant select many people from acp interface...what i want to do is to remove everyone from custom group and move them back....but how do I know if I defaulted them.. help pls

Re: HELP fast please default

Posted: Mon Oct 12, 2015 7:10 pm
by KevC
Delete the group

Everyone should stay in the registered users group anyway. You shouldn't remove people from that.

Re: HELP fast please default

Posted: Wed Oct 14, 2015 1:34 pm
by Smithgb
ok did and it works...but can you please tell me how I can mass remove people from group and add new ones again where removed ones will have their coresponding group defaulted? I cant find option in acp to "remove all" and listing of users in group is pain...can i run SQL query?

Re: HELP fast please default

Posted: Thu Oct 15, 2015 6:12 pm
by Smithgb
someone pls..?

Re: HELP fast please default

Posted: Thu Oct 15, 2015 6:22 pm
by KevC
manage groups

Next to each group choose members.

You can select everyone and choose to remove them or set their default group.

If you want to add large numbers of people to a group you can click 'find a member' at the bottom of that page and tick all the users you want, a page at a time if you want to.

Re: HELP fast please default

Posted: Thu Oct 15, 2015 7:20 pm
by Smithgb
Hey kevc thanks..but how I will select all those pages...dont tell me I need to do this page by page...thanks
http://i.imgur.com/lpbOUw4.png

Re: HELP fast please default

Posted: Thu Oct 15, 2015 7:27 pm
by KevC
In post settings, increase the number of topics per page. That controls the list display in lots of pages like that.

Re: HELP fast please default

Posted: Thu Oct 15, 2015 7:41 pm
by Smithgb
kev im confused...that is list of members in group based on lottery and I change it daily but i need faster way of deleting users from that group without deleting group as whole...is there any sql query I can do? it is really time consuming to do all this manually lol.. :?

Re: HELP fast please default

Posted: Thu Oct 15, 2015 7:51 pm
by KevC
An SQL query would still have to know each user you want to add. I'm not a database expert so I can't suggest how to do it that way. You might have to find a different way to do whatever it is you're doing.

Re: HELP fast please default

Posted: Thu Oct 15, 2015 8:01 pm
by Nikola
SELECT * FROM `forum`.`phpbb_user_group` WHERE `group_id` = 'X';

Please note that X is group id you are targeting and forum is DB name. You can find the group ID by right clicking on it.This will list all users in the group you want for easier manipulation. Note that phpbb_ is standard prefix. Do not touch the DB if you don't know SQL basics.

Re: HELP fast please default

Posted: Fri Oct 16, 2015 8:54 am
by 2600
What exactly are you doing that you need to change users in groups all the time? There may be an extension for your needs.