upgrade/1.1.5/xxx_fix_names.php

   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 ?>