static function get_field_value_jomsocial($field, $user_id) { $db = JFactory::getDBO(); $query = 'SELECT value ' . ' FROM #__community_fields_values' . " WHERE field_id = " . $db->Quote($field) . " AND user_id = " . $db->Quote($user_id); $db->setQuery($query); $field_obj = $db->loadObject(); if (!$field_obj) { return ""; } /* Check if data needs transformation */ $type = JoomdleHelperMappings::get_field_type_jomsocial($field); switch ($type) { case 'country': $field_obj->value = JoomdleHelperMappings::get_moodle_country($field_obj->value); break; default: break; } return $field_obj->value; }