$searchname[1]); } } $sn_types_public = build_types('public'); $sn_types_private = build_types('private'); $full_name = build_full_name($search_names, $sn_types_public); return build_public_name($search_names, $sn_types_public, $full_name) . ';' . build_private_name($search_names, $sn_types_private); } function build_display_names(&$display_names, $search_names, $private_name_end = null, &$alias = null) { $sn_types_public = build_types('public'); $full_name = build_full_name($search_names, $sn_types_public); $display_names['public_name'] = build_public_name($search_names, $sn_types_public, $full_name); $display_names['private_name'] = $display_names['public_name'] . $private_name_end; $display_names['directory_name'] = build_directory_name($search_names, $sn_types_public, $full_name); $display_names['short_name'] = build_short_name($search_names, $sn_types_public, $alias); $display_names['sort_name'] = build_sort_name($search_names, $sn_types_public); } function build_types($pub = null) { if ($pub == 'public') { $sql_pub = "AND FIND_IN_SET('public', flags)"; } elseif ($pub == 'private') { $sql_pub = "AND NOT FIND_IN_SET('public', flags)"; } else { $sql_pub = ""; } $sql = "SELECT id, type, name FROM profile_name_enum WHERE NOT FIND_IN_SET('not_displayed', flags)" . $sql_pub; $sn_types = XDB::iterator($sql); $types = array(); while ($sn_type = $sn_types->next()) { if ($pub) { $types[$sn_type['type']] = $sn_type['id']; } else { $types[$sn_type['id']] = $sn_type['name']; } } return $types; } function build_full_name(&$search_names, &$sn_types) { $name = ""; if (isset($search_names[$sn_types['lastname_ordinary']])) { $name .= $search_names[$sn_types['lastname_ordinary']]['fullname'] . " (" . $search_names[$sn_types['lastname']]['fullname'] . ")"; } else { $name .= $search_names[$sn_types['lastname']]['fullname']; } if (isset($search_names[$sn_types['lastname_marital']]) || isset($search_names[$sn_types['pseudonym']])) { $name .= " ("; if (isset($search_names[$sn_types['lastname_marital']])) { $user = S::user(); if ($user->isFemale()) { $name .= "Mme "; } else { $name .= "M "; } $name .= $search_names[$sn_types['lastname_marital']]['fullname']; if (isset($search_names[$sn_types['pseudonym']])) { $name .= ", "; } } if (isset($search_names[$sn_types['pseudonym']])) { $name .= $search_names[$sn_types['pseudonym']]['fullname']; } $name .= ")"; } return $name; } function build_public_name(&$search_names, &$sn_types, $full_name) { return $search_names[$sn_types['firstname']]['fullname'] . " " . $full_name; } function build_private_name(&$search_names, &$sn_types) { $name = ""; if (isset($search_names[$sn_types['nickname']]) || (isset($search_names[$sn_types['name_other']]) || isset($search_names[$sn_types['name_other']]))) { $name .= " ("; if (isset($search_names[$sn_types['nickname']])) { $name .= "alias " . $search_names[$sn_types['nickname']]['fullname']; $i = 0; while (isset($search_names[$sn_types['nickname']][$i])) { $name .= ", " . $search_names[$sn_types['nickname']][$i]; $i++; } if (isset($search_names[$sn_types['name_other']]) || isset($search_names[$sn_types['name_other']])) { $name .= ", "; } } if (isset($search_names[$sn_types['firstname_other']])) { $name .= "autres prénoms : " . $search_names[$sn_types['firstname_other']]['fullname']; $i = 0; while (isset($search_names[$sn_types['firstname_other']][$i])) { $name .= ", " . $search_names[$sn_types['firstname_other']][$i]; $i++; } if (isset($search_names[$sn_types['name_other']])) { $name .= ", "; } } if (isset($search_names[$sn_types['name_other']])) { $name .= "autres noms : " . $search_names[$sn_types['name_other']]['fullname']; $i = 0; while (isset($search_names[$sn_types['name_other']][$i])) { $name .= ", " . $search_names[$sn_types['name_other']][$i]; $i++; } } $name .= ")"; } return $name; } function build_directory_name(&$search_names, &$sn_types, $full_name) { return $full_name . " " . $search_names[$sn_types['firstname']]['fullname']; } function build_short_name(&$search_names, &$sn_types, &$alias = null) { if (isset($search_names[$sn_types['lastname_ordinary']])) { $lastname = $search_names[$sn_types['lastname_ordinary']]['fullname']; } else { $lastname = $search_names[$sn_types['lastname']]['fullname']; } if (isset($search_names[$sn_types['firstname_ordinary']])) { $firstname = $search_names[$sn_types['firstname_ordinary']]['fullname']; } else { $firstname = $search_names[$sn_types['firstname']]['fullname']; } if ($alias) { $alias = make_username($firstname, $lastname); } return $firstname . " " . $lastname; } function build_sort_name(&$search_names, &$sn_types) { $name = ""; if (isset($search_names[$sn_types['lastname_ordinary']])) { $name .= $search_names[$sn_types['lastname_ordinary']]['name']; } else { $name .= $search_names[$sn_types['lastname']]['name']; } $name .= " " . $search_names[$sn_types['firstname']]['fullname']; return $name; } function set_profile_display(&$display_names) { XDB::execute("UPDATE profile_display SET public_name = {?}, private_name = {?}, directory_name = {?}, short_name = {?}, sort_name = {?} WHERE pid = {?}", $display_names['public_name'], $display_names['private_name'], $display_names['directory_name'], $display_names['short_name'], $display_names['sort_name'], S::v('uid')); } function build_sn_pub() { $res = XDB::iterator("SELECT CONCAT(sn.particle, sn.name) AS fullname, sn.typeid, sn.particle, sn.name, sn.id FROM profile_name AS sn INNER JOIN profile_name_enum AS e ON (e.id = sn.typeid) WHERE sn.pid = {?} AND NOT FIND_IN_SET('not_displayed', e.flags) AND FIND_IN_SET('public', e.flags) ORDER BY NOT FIND_IN_SET('always_displayed', e.flags), e.id, sn.name", S::i('uid')); $sn_old = array(); while ($old = $res->next()) { $sn_old[$old['typeid']] = array('fullname' => $old['fullname'], 'name' => $old['name'], 'particle' => $old['particle'], 'id' => $old['id']); } return $sn_old; } function set_alias_names(&$sn_new, $sn_old, $update_new = false, $new_alias = null) { $has_new = false; foreach ($sn_new as $typeid => $sn) { if (isset($sn['pub'])) { if (isset($sn_old[$typeid]) && ($sn_old[$typeid]['fullname'] == $sn['fullname'] && $update_new)) { XDB::execute("UPDATE profile_name SET particle = {?}, name = {?}, typeid = {?} WHERE id = {?} AND pid = {?}", $sn['particle'], $sn['name'], $typeid, $sn_old[$typeid]['id'], S::i('uid')); unset($sn_old[$typeid]); } elseif ($update_new || (isset($sn_old[$typeid]) && $sn_old[$typeid]['fullname'] == $sn['fullname'])) { XDB::execute("INSERT INTO profile_name (particle, name, typeid, pid) VALUES ({?}, {?}, {?}, {?})", $sn['particle'], $sn['name'], $typeid, S::i('uid')); unset($sn_old[$typeid]); } else { $has_new = true; } } else { if ($sn['fullname'] != '') { XDB::execute("INSERT INTO profile_name (particle, name, typeid, pid) VALUES ('', {?}, {?}, {?})", $sn['fullname'], $typeid, S::i('uid')); } $i = 0; while (isset($sn[$i])) { XDB::execute("INSERT INTO profile_name (particle, name, typeid, pid) VALUES ('', {?}, {?}, {?})", $sn[$i], $typeid, S::i('uid')); $i++; } } } if (count($sn_old) > 0) { if (!$update_new) { $has_new = true; foreach ($sn_old as $typeid => $sn) { XDB::execute("INSERT INTO profile_name (particle, name, typeid, pid) VALUES ({?}, {?}, {?}, {?})", $sn['particle'], $sn['name'], $typeid, S::i('uid')); } } else { foreach ($sn_old as $typeid => $sn) { XDB::execute("DELETE FROM profile_name WHERE pid = {?} AND id = {?}", S::i('uid'), $sn['id']); } } } if ($update_new) { XDB::execute("DELETE FROM aliases WHERE FIND_IN_SET('usage', flags) AND id = {?}", S::i('uid')); } if ($new_alias) { XDB::execute("INSERT INTO aliases (alias, type, flags, id) VALUES ({?}, 'alias', 'usage', {?})", $new_alias, S::i('uid')); } require_once('user.func.inc.php'); user_reindex($uid); return $has_new; } // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>