| 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 fenc=utf-8: |
| 29 | ?> |