Can anyone tell me where the gid field is located in the community Builder tables? I looked at the jos_users tables and updated them, however, community Builder hasn't changed. I am trying to do a mass update on my users.

Thanks,
Winston

Just in case anyone is wondering, if you need to do a mass update on your userbank so that you can set everyone to an author, or editor etc, the table you want to use is jos_core_acl_groups_aro_map. It took me a while to find this but you just do an update where the aro_id is not equal to the super admin, or whomever else you don't want to blow away.

Good luck