Hi asdfasdf,

I haven't checked the exact query you are using, but for now I'll assume it's correct.

The only other problem I see in the recipe is in the 2nd "if" line... when you compare things for equality, you have to use "==" and not "=".

So the last 3 lines should read:
if ( $member > 0 ) {
  if ( $group == 3 && $approv == 1 ) return 427;
}

With the syntax you were using, I think module 427 would ALWAYS be returned for logged in users. Is that what was happening?

Cheers,
Stephen

Ok, I think this is what you want. You need to be able to retrieve the user id of the page you are viewing, rather than doing the query based on the user id of the logged in user.

Therefore you can use this to get the user id of the user, as long as you are on a CB profile page:

$userid = JRequest::getInt('user',0);

So try this. I've fixed it up a bit so that it can detect multiple groups. The previous version only checked the 1st group the person was a member of.

if  ($option == "com_community" and $view == "profile" ) { 

  $userid = JRequest::getInt('userid',0); 

  if ( $userid > 0 ) { 

    $query = "select groupid from #__community_groups_members where memberid = '$userid' and approved = 1"; 

    $db->setQuery( $query ); 

    $results = $db->loadResultArray(); 

    if ( is_array( $results ) ) { 

      if ( in_array(3, $results) ) return 47; // for group 3, use module 47 

      // add more checks like the previous one, as appropriate 

    } 

  } 

}

Oops, it looks like I seriously confused CB (com_profiler) with JomSocial (com_community). Let me do a new version for JomSocial...

Sorry! This is now edited in the post above, and tested, this time!

Stephen