[crushdg]

I know this is a little off topic, but what would I look for in the db, to change all the users in the database to be subscribed to category_id 246? Trying to figure out if I can just export the db and do a search and replace or addition. I hope my question makes sense.

[Robin W]

yes, you would be looking in the usermeta table 9noramlly called wp_usermeta at meta-key wp__bbp_subscriptions

this is comma deliminated, so if I was user ID 3, and was subscribed to topics 10, 12 and 15, and forums 1, 3 and 6, I would see

user_id 3
meta_key wp__bbp_subscriptions
meta_value 1,3,6,10,12,15

So to add category 246, you would just add this to the end, or create if not there

Someone cleverer than me out to be able to give you a sql string or two that would do this which you could run on phpmyadmin.

Logically you’d create two statements, the first would say

for all the user_id’s if wp_bbp_subscriptions exists, then make the meta_value equal to the meta_value concatenated with ‘,246’
Then second one
for all user_id’s if wp_bbp_subscriptions does not exist, make meta_key wp_bbp_subscriptions equal to 246.

I’m not good enough at sql to code this without lots of checking – anyone good at this stuff?

[crushdg]

Urghhhhh… Ya, I’m not great at it either. If someone could offer advice on what sql query to run, that would be great! Thank you so much @robin-w!

[crushdg]

No ideas? Really need some help with this, if possible. Thanks!

[Robin W]

I’d suggest that you

1. create a test site (which everyone should have in nay case !)

and

2. Google sql tutorial video, and work out how to code my statements

3. go into phpmyadmin on your test site and play until you get it right

4. Come back and post the resultant code to help others

sorry, but almost all of the stuff I have learn’t has been by spending time googling to find some examples, and then hours getting it to work 🙂

[crushdg]

Understood, appreciate the direction. Hopefully I will be able to find some time over the next several days to spend figuring this out.

[Robin W]

sorry if I wasn’t so busy, I’d have a crack at it 🙂

[crushdg]

I ended up just having to go with a User Data Manager plugin since it was quickest, though will probably try my hand at writing up some SQL to do it manually through phpmyadmin. Thanks so much for your help!

[Robin W]

No problem