static function set_field_value_jomsocial($field, $value, $user_id)
{
$db = JFactory::getDBO();
/* Check if data needs transformation */
$type = JoomdleHelperMappings::get_field_type_jomsocial($field);
switch ($type) {
case 'country':
$value = JoomdleHelperMappings::get_joomla_country($value);
break;
default:
break;
}
$query = ' SELECT count(*) from #__community_fields_values' . " WHERE field_id = " . $db->Quote($field) . " AND user_id = " . $db->Quote($user_id);
$db->setQuery($query);
$exists = $db->loadResult();
if ($exists) {
$query = ' UPDATE #__community_fields_values' . ' SET value=' . $db->Quote($value) . " WHERE field_id = " . $db->Quote($field) . " AND user_id = " . $db->Quote($user_id);
} else {
$query = ' INSERT INTO #__community_fields_values' . ' (field_id, user_id, value) VALUES (' . $db->Quote($field) . ',' . $db->Quote($user_id) . ',' . $db->Quote($value) . ')';
}
$db->setQuery($query);
$db->query();
return true;
}
