AND last_name.usd_usf_id = ' . $gProfileFields->getProperty('LAST_NAME', 'usf_id') . '
AND last_name.usd_value = \'' . $user->getValue('LAST_NAME') . '\'
JOIN ' . TBL_USER_DATA . ' first_name
ON first_name.usd_usr_id = usr_id
AND first_name.usd_usf_id = ' . $gProfileFields->getProperty('FIRST_NAME', 'usf_id') . '
AND first_name.usd_value = \'' . $user->getValue('FIRST_NAME') . '\'
WHERE usr_valid = 1 ';
$result = $gDb->query($sql);
$rowDuplicateUser = $gDb->fetch_array($result);
if ($rowDuplicateUser['usr_id'] > 0) {
$duplicate_user = new User($gDb, $gProfileFields, $rowDuplicateUser['usr_id']);
}
if ($rowDuplicateUser['usr_id'] > 0) {
if ($_SESSION['user_import_mode'] == USER_IMPORT_DISPLACE) {
// delete all user data of profile fields
$duplicate_user->deleteUserFieldData();
}
if ($_SESSION['user_import_mode'] == USER_IMPORT_COMPLETE || $_SESSION['user_import_mode'] == USER_IMPORT_DISPLACE) {
// edit data of user, if user already exists
foreach ($importedFields as $key => $field_name_intern) {
if ($duplicate_user->getValue($field_name_intern) != $user->getValue($field_name_intern)) {
if ($gProfileFields->getProperty($field_name_intern, 'usf_type') == 'DATE') {
// the date must be formated
$duplicate_user->setValue($field_name_intern, $user->getValue($field_name_intern, $gPreferences['system_date']));
} elseif ($field_name_intern == 'COUNTRY') {
// we need the iso-code and not the name of the country
$duplicate_user->setValue($field_name_intern, $gL10n->getCountryByName($user->getValue($field_name_intern)));
} elseif ($gProfileFields->getProperty($field_name_intern, 'usf_type') == 'DROPDOWN' || $gProfileFields->getProperty($field_name_intern, 'usf_type') == 'RADIO_BUTTON') {
// get number and not value of entry
$duplicate_user->setValue($field_name_intern, $user->getValue($field_name_intern, 'database'));
} else {