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 {