From f903d3b20f14b1bab6b85b03efe1802f7bf60363 Mon Sep 17 00:00:00 2001
From: =?utf8?q?St=C3=A9phane=20Jacob?= <sj@m4x.org>
Date: Sun, 3 Jun 2012 12:37:47 +0200
Subject: [PATCH] Adds script to fix names issues.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Stéphane Jacob <sj@m4x.org>
---
 upgrade/1.1.5/xxx_fix_names.php | 29 +++++++++++++++++++++++++++++
 1 file changed, 29 insertions(+)
 create mode 100755 upgrade/1.1.5/xxx_fix_names.php

diff --git a/upgrade/1.1.5/xxx_fix_names.php b/upgrade/1.1.5/xxx_fix_names.php
new file mode 100755
index 0000000..0660ede
--- /dev/null
+++ b/upgrade/1.1.5/xxx_fix_names.php
@@ -0,0 +1,29 @@
+#!/usr/bin/php5
+<?php
+require_once 'connect.db.inc.php';
+require_once '../../include/name.func.inc.php';
+
+$pids = XDB::fetchOneRow("SELECT  pid
+                            FROM  profile_public_names
+                           WHERE  firstname_ordinary = '0' OR lastname_marital = '0' OR lastname_ordinary = '0'");
+
+XDB::execute("UPDATE  profile_public_names
+                 SET  firstname_ordinary = ''
+               WHERE  firstname_ordinary = '0'");
+XDB::execute("UPDATE  profile_public_names
+                 SET  lastname_ordinary = ''
+               WHERE  lastname_ordinary = '0'");
+XDB::execute("UPDATE  profile_public_names
+                 SET  lastname_ordinary = ''
+               WHERE  lastname_ordinary = '0'");
+
+foreach ($pids as $pid) {
+    $profile = Profile::get($pid);
+    $item = XDB::fetchOneAssoc('SELECT  *
+                                  FROM  profile_public_names
+                                 WHERE  pid = {?}', $pid);
+    update_display_names($profile, $item);
+}
+
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+?>
-- 
2.1.4