Using SQL to upload forum selections

[designbysue]

I have many forum users – about 1000 – and there are 3 forums on my site. These user can have access to one, two or all three forums. I have a list (currently in excel) that shows what user can access what forum. Rather than have the user’s request forum memberships, I would like to upload this list in someway to edit the tables for your plug in. Can you please tell me if there is some way already available to do this? If not can you give me a clue to the table structure? What table holds the info for this and are there any related tables that need updating? This would be a great time saver and will make me look a lot better to my client!

Thanks
Sue

https://ww.wp.xz.cn/plugins/bbp-private-groups/

[Robin W]

just one table will need updating

Presuming you have users already set up, the this is held in usermeta

so to join a user to group 1, group 2 and group 3 who has a user_id of 1216

table usermeta

user id 1216
meta key private_group
value *group1*group2*group3*

basically the groups ‘*’ separated

[designbysue]

Thanks! Is there an easy way to get the user id numbers?

Sue

[Pascal Casier]

Hi, if it can help, check out the source of my ‘bbP Manage Subscriptions’ plugin on ww.wp.xz.cn . I’m doing in there what you need to do.

I should really add some bulk actions into that one…

Pascal.

[Robin W]

are you fixed, or do you need further help?

[designbysue]

I did it manually – could not get a grasp on the tables

Thanks

[Robin W]

ok, thanks !