BuddyPress.org

I’m no master of PHP but what you described above is exactly what I would have written, there probably is a better approach if one had a deeper knowledge of BP/WP though.