I don't really want to do this, but I am going to have to do it if it will work. I have 922 accounts I need to add to a new user group. Then after that, we are putting access to this group on sale to anyone who wants to cough up the dough ($77). We have money collection under control, but now I have to get new members into this user group basically instantly, right when they pay. So here is my plan.
DATA FOR ADDING A MEMBER TO A USER GROUP
- Add a record to the xf_user_group_relation table.
- On the xf_user record, add the user_group_id to the other secondary user groups the member has already. For example, what if they have 352c3234 that is hex for '5,24' and the new group is 37? I am thinking I'll change that to 352C32342C3337 which the heximadecimal for '5,24,37'
- Put an entry in the table xf_user_change log showing the old and new values