diff options
| author | Wesley Fok <wesley.fok@yp.ca> | 2016-08-03 13:20:42 -0400 |
|---|---|---|
| committer | Wesley Fok <wesley.fok@yp.ca> | 2016-08-03 13:20:42 -0400 |
| commit | ba13832085bf05eb5ab19aeb9681b16c7a119df9 (patch) | |
| tree | 7fb014aeb08e614fe060dfeede0ea05885ff4d7d /phpBB/includes/functions_user.php | |
| parent | 2081a7809540db661193be376c1220a2c21acff4 (diff) | |
| parent | f68820762b2d78bc26c59724a3dd98091bb3379b (diff) | |
| download | forums-ba13832085bf05eb5ab19aeb9681b16c7a119df9.tar forums-ba13832085bf05eb5ab19aeb9681b16c7a119df9.tar.gz forums-ba13832085bf05eb5ab19aeb9681b16c7a119df9.tar.bz2 forums-ba13832085bf05eb5ab19aeb9681b16c7a119df9.tar.xz forums-ba13832085bf05eb5ab19aeb9681b16c7a119df9.zip | |
Merge remote-tracking branch 'upstream/3.1.x' into ticket/14638-3.1.x
Diffstat (limited to 'phpBB/includes/functions_user.php')
| -rw-r--r-- | phpBB/includes/functions_user.php | 24 |
1 files changed, 17 insertions, 7 deletions
diff --git a/phpBB/includes/functions_user.php b/phpBB/includes/functions_user.php index bfdd1badc3..8a09f055bf 100644 --- a/phpBB/includes/functions_user.php +++ b/phpBB/includes/functions_user.php @@ -119,19 +119,29 @@ function user_update_name($old_name, $new_name) global $config, $db, $cache, $phpbb_dispatcher; $update_ary = array( - FORUMS_TABLE => array('forum_last_poster_name'), - MODERATOR_CACHE_TABLE => array('username'), - POSTS_TABLE => array('post_username'), - TOPICS_TABLE => array('topic_first_poster_name', 'topic_last_poster_name'), + FORUMS_TABLE => array( + 'forum_last_poster_id' => 'forum_last_poster_name', + ), + MODERATOR_CACHE_TABLE => array( + 'user_id' => 'username', + ), + POSTS_TABLE => array( + 'poster_id' => 'post_username', + ), + TOPICS_TABLE => array( + 'topic_poster' => 'topic_first_poster_name', + 'topic_last_poster_id' => 'topic_last_poster_name', + ), ); foreach ($update_ary as $table => $field_ary) { - foreach ($field_ary as $field) + foreach ($field_ary as $id_field => $name_field) { $sql = "UPDATE $table - SET $field = '" . $db->sql_escape($new_name) . "' - WHERE $field = '" . $db->sql_escape($old_name) . "'"; + SET $name_field = '" . $db->sql_escape($new_name) . "' + WHERE $name_field = '" . $db->sql_escape($old_name) . "' + AND $id_field <> " . ANONYMOUS; $db->sql_query($sql); } } |