aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/functions_user.php
diff options
context:
space:
mode:
authorMarc Alexander <admin@m-a-styles.de>2016-08-01 20:42:13 +0200
committerMarc Alexander <admin@m-a-styles.de>2016-08-01 20:42:13 +0200
commit3d4660a703ecd8d6e0273ad183ef38a7a139c81a (patch)
tree8d0d05117b6c8fe5a0e2bfabf61e1ba31241aa97 /phpBB/includes/functions_user.php
parentbd1d734dccfcc798ef67c892b9e436390cfee996 (diff)
parentf68820762b2d78bc26c59724a3dd98091bb3379b (diff)
downloadforums-3d4660a703ecd8d6e0273ad183ef38a7a139c81a.tar
forums-3d4660a703ecd8d6e0273ad183ef38a7a139c81a.tar.gz
forums-3d4660a703ecd8d6e0273ad183ef38a7a139c81a.tar.bz2
forums-3d4660a703ecd8d6e0273ad183ef38a7a139c81a.tar.xz
forums-3d4660a703ecd8d6e0273ad183ef38a7a139c81a.zip
Merge branch '3.1.x' into 3.2.x
Diffstat (limited to 'phpBB/includes/functions_user.php')
-rw-r--r--phpBB/includes/functions_user.php24
1 files changed, 17 insertions, 7 deletions
diff --git a/phpBB/includes/functions_user.php b/phpBB/includes/functions_user.php
index bbf00735af..a3dfafb000 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);
}
}