3 require_once 'connect.db.inc.php';
4 require_once '../../include/name.func.inc.php';
6 // Returns the lower-cased name; if proper capitalization rule was not known,
7 // warns the user, and returns the initial name.
8 function capitalize_name_checked($name)
14 $capitalized = capitalize_name($name);
16 echo " - WARNING: Unable to capitalize '$name'.\n";
19 if (mb_strtolower($name, 'UTF-8') != mb_strtolower($capitalized, 'UTF-8')) {
20 echo " - WARNING: Capitalization of '$name' is unexpected: '$capitalized'\n";
27 // Returns true iff the @p name looks like it should be properly recapitalized.
28 function needs_conversion($name)
30 if (strlen($name) == 0) {
33 if ($name == mb_strtoupper($name, 'UTF-8')) {
37 $name_length = mb_strlen($name, 'UTF-8');
38 $name_capitals = preg_replace('/\P{Lu}/u', '', $name);
39 return (mb_strlen($name_capitals, 'UTF-8') > 0.4 * $name_length);
42 // Retrieves all the names to convert.
44 $names = XDB
::iterator('SELECT pid, lastname_initial, lastname_main, lastname_marital, lastname_ordinary,
45 firstname_initial, firstname_main, firstname_ordinary, pseudonym
46 FROM profile_public_names');
47 $name_list = array('lastname_initial', 'lastname_main', 'lastname_marital', 'lastname_ordinary',
48 'firstname_initial', 'firstname_main', 'firstname_ordinary', 'pseudonym');
49 $total = $names->total();
50 while ($item = $names->next()) {
51 foreach ($name_list as $type) {
52 $item[$type] = capitalize_name_checked($item[$type]);
55 XDB
::execute('UPDATE profile_public_names
56 SET lastname_initial = {?}, lastname_main = {?}, lastname_marital = {?}, lastname_ordinary = {?},
57 firstname_initial = {?}, firstname_main = {?}, firstname_ordinary = {?}, pseudonym = {?}
59 $item['lastname_initial'], $item['lastname_main'], $item['lastname_marital'], $item['lastname_ordinary'],
60 $item['firstname_initial'], $item['firstname_main'], $item['firstname_ordinary'], $item['pseudonym'],
62 $profile = Profile
::get($item['pid']);
63 update_display_names($profile, $item);
65 printf("\r%u / %u", $conversions, $total);
67 unset($item, $profile);
70 printf("\r%u / %u", $conversions, $total);
71 echo "\n$conversions names from profiles properly recapitalized.\n";
74 $names = XDB
::iterator('SELECT uid, firstname, lastname
76 WHERE NOT EXISTS (SELECT 1
78 WHERE account_profiles.uid = accounts.uid)');
80 $total = $names->total();
81 while ($item = $names->next()) {
82 $lastname = capitalize_name_checked($item['lastname']);
83 $firstname = capitalize_name_checked($item['firstname']);
85 $full_name = build_full_name($firstname, $lastname);
86 $directory_name = build_directory_name($firstname, $lastname);
87 $sort_name = build_sort_name($firstname, $lastname);
89 XDB
::execute('UPDATE accounts
90 SET firstname = {?}, lastname = {?}, full_name = {?}, directory_name = {?}, sort_name = {?}
92 $firstname, $lastname, $full_name, $directory_name, $sort_name, $item['uid']);
94 printf("\r%u / %u", $conversions, $total);
98 printf("\r%u / %u", $conversions, $total);
100 echo "\n$conversions names from accounts properly recapitalized.\n";
102 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8: