From da6b378e64d2457ddbcd299d769ecf0167ffb9c8 Mon Sep 17 00:00:00 2001 From: Oliver Schramm Date: Thu, 17 Jul 2014 16:30:22 +0200 Subject: [ticket/10729] Update message_edit_user when user being deleted PHPBB3-10729 --- phpBB/includes/functions_user.php | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'phpBB') diff --git a/phpBB/includes/functions_user.php b/phpBB/includes/functions_user.php index db98b8e7ca..20c371f8e5 100644 --- a/phpBB/includes/functions_user.php +++ b/phpBB/includes/functions_user.php @@ -502,6 +502,12 @@ function user_delete($mode, $user_id, $post_username = false) WHERE post_edit_user = ' . $user_id; $db->sql_query($sql); + // Change user_id to anonymous for pms edited by this user + $sql = 'UPDATE ' . PRIVMSGS_TABLE . ' + SET message_edit_user = ' . ANONYMOUS . ' + WHERE message_edit_user = ' . $user_id; + $db->sql_query($sql); + // Delete user log entries about this user $sql = 'DELETE FROM ' . LOG_TABLE . ' WHERE reportee_id = ' . $user_id; -- cgit v1.2.1