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; }