public function profilegetdetailfields($id)
{
$db =& JFactory::getDBO();
$db->setQuery('SELECT #__sobipro_field.nid, #__sobipro_field_data.baseData, #__sobipro_field_option_selected.optValue FROM #__sobipro_field INNER JOIN #__sobipro_field_data USING(fid) LEFT OUTER JOIN #__sobipro_field_option_selected USING(fid,sid) WHERE sid=' . intval($id));
$fieldpool = $db->loadAssocList();
$fielda = array();
foreach ($fieldpool as $fielddata) {
$fielda[profilef::profilecleannid($fielddata['nid'])] = trim(stripslashes($fielddata[is_null($fielddata['optValue']) ? 'baseData' : 'optValue']));
}
return $fielda;
}
