Commit | Line | Data |
---|---|---|
f903d3b2 SJ |
1 | #!/usr/bin/php5 |
2 | <?php | |
3 | require_once 'connect.db.inc.php'; | |
4 | require_once '../../include/name.func.inc.php'; | |
5 | ||
6 | $pids = XDB::fetchOneRow("SELECT pid | |
7 | FROM profile_public_names | |
8 | WHERE firstname_ordinary = '0' OR lastname_marital = '0' OR lastname_ordinary = '0'"); | |
9 | ||
10 | XDB::execute("UPDATE profile_public_names | |
11 | SET firstname_ordinary = '' | |
12 | WHERE firstname_ordinary = '0'"); | |
13 | XDB::execute("UPDATE profile_public_names | |
14 | SET lastname_ordinary = '' | |
15 | WHERE lastname_ordinary = '0'"); | |
16 | XDB::execute("UPDATE profile_public_names | |
17 | SET lastname_ordinary = '' | |
18 | WHERE lastname_ordinary = '0'"); | |
19 | ||
20 | foreach ($pids as $pid) { | |
21 | $profile = Profile::get($pid); | |
22 | $item = XDB::fetchOneAssoc('SELECT * | |
23 | FROM profile_public_names | |
24 | WHERE pid = {?}', $pid); | |
25 | update_display_names($profile, $item); | |
26 | } | |
27 | ||
28 | // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: | |
29 | ?> |