Joomdle R0.82
While analyzing code to see why Joomla 1.6+ custom user profile mapping to Moodle not works,
(
www.joomdle.com/en/forum/r08-support/911...not-synced-in-moodle
)
I think that I found a possible bug which is not in correlation with my primary issue.
File: administrator/components/com_joomdle/helpers/mappings.php
Function: set_field_value_joomla16 ($field, $value, $user_id)
Line 1980:
instead of: ' INSERT INTO #__community_fields_values' .
should be: ' INSERT INTO #__user_profile' .
If we have new user it will be inserted into wrong table, and probably unexisting table ...
Code:
function set_field_value_joomla16 ($field, $value, $user_id)
{
$db =& JFactory::getDBO();
$query =
' SELECT count(*) from #__user_profiles' .
" WHERE profile_key = " . $db->Quote($field) . " AND user_id = " . $db->Quote($user_id);
$db->setQuery($query);
$exists = $db->loadResult();
if ($exists)
$query =
' UPDATE #__user_profiles' .
' SET profile_value='. $db->Quote($value) .
" WHERE profile_key = " . $db->Quote($field) . " AND user_id = " . $db->Quote($user_id);
else
$query =
' INSERT INTO #__community_fields_values' .
' (profile_key, user_id, profile_value) VALUES ('. $db->Quote($field) . ','. $db->Quote($user_id) . ',' . $db->Quote($value) . ')';
$db->setQuery($query);
$db->query();
return true;
}
