Try this:

if ($option == 'com_mtree' and JRequest::getVar('task') == 'viewlink' ) {
  $link_id = JRequest::getInt('link_id', 0);
  $custom_field_id = 28; // replace with the ID of the custom field you want to check for
  $query = "SELECT value FROM  #__mt_cfvalues WHERE cf_id = $custom_field_id and link_id = $link_id";
  $db->setQuery( $query );
  $result = $db->loadResult();
  if ( $result == 1 ) return XXX; // replace XXX with module id to return when custom field id "28" has value "1"
}

Cheers,
Stephen

Hi Pembaris,

if you're getting an error in line 12 then you're not using the exact recipe I sent... perhaps you are using the $result variable outside of the { } characters?

And things for me... not too bad. Still no laptop, but they didn't steal my iMac which was sitting next to it, and all the Meta* stuff was synched with DropBox, so I have good backup. I'm very glad for good backups, DropBox, insurance, and incompetent burglars!

Cheers,
Stephen

Hi Ajmal,

Thanks for your good wishes. I generally refer to people's login name on the forum, even if I know the real name, unless they have signed their name at the bottom of the post. It's just a matter of privacy

Best regards,
Stephen