59d9f7f5820bf72ae99ec5ba8d96fad32ab4c654
4 require_once 'connect.db.inc.php';
6 $globals->debug
= 0; // Do not store backtraces.
8 $it = XDB
::rawIterator('SELECT uid, full_name, email, type
10 WHERE type NOT IN (\'x\', \'master\', \'phd\')');
11 $total = $it->total();
14 while ($item = $it->next()) {
15 if ($item['type'] == 'virtual') {
17 $lastname = $item['full_name'];
18 } elseif ($item['full_name'] && strpos(' ', $item['full_name'])) {
19 list($firstname, $lastname) = explode(' ', $item['full_name']);
21 list($local_part, ) = explode('@', strtolower($item['email']));
22 $parts = explode('.', $local_part);
23 if (count($parts) == 1) {
24 $lastname = ucfirst($local_part);
27 $firstname = ucfirst($parts[0]);
28 $lastname = ucwords(implode(' ', array_slice($parts, 1)));
32 XDB
::execute('UPDATE accounts
33 SET firstname = {?}, lastname = {?}
35 $firstname, $lastname, $item['uid']);
37 printf("\r%u / %u", $done, $total);
41 /* vim:set et sw=4 sts=4 ts=4: */