diff options
| author | Ruslan Uzdenov <rxu@mail.ru> | 2009-06-16 14:36:12 +0000 |
|---|---|---|
| committer | Ruslan Uzdenov <rxu@mail.ru> | 2009-06-16 14:36:12 +0000 |
| commit | bfc8906a5ed4b99d0c592972b3267fe52d5da257 (patch) | |
| tree | 461f7d5e489b4808ae6c73c3826fbf810dff7494 | |
| parent | ce144ab0baaafa10bf3e37812e2f5875680de499 (diff) | |
| download | forums-bfc8906a5ed4b99d0c592972b3267fe52d5da257.tar forums-bfc8906a5ed4b99d0c592972b3267fe52d5da257.tar.gz forums-bfc8906a5ed4b99d0c592972b3267fe52d5da257.tar.bz2 forums-bfc8906a5ed4b99d0c592972b3267fe52d5da257.tar.xz forums-bfc8906a5ed4b99d0c592972b3267fe52d5da257.zip | |
Fix bug #40245 - Attachments table is not being updated when deleting user and retaining his posts
Authorised by: acydburn
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9599 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/docs/CHANGELOG.html | 1 | ||||
| -rw-r--r-- | phpBB/includes/functions_user.php | 5 |
2 files changed, 6 insertions, 0 deletions
diff --git a/phpBB/docs/CHANGELOG.html b/phpBB/docs/CHANGELOG.html index f596bd0048..9fc81f337b 100644 --- a/phpBB/docs/CHANGELOG.html +++ b/phpBB/docs/CHANGELOG.html @@ -109,6 +109,7 @@ <li>[Fix] Incorrect layout when loading PM-draft (Bug #38435 - Patch by nickvergessen)</li> <li>[Fix] Wrong message shown to user, when adding bots to friends/foes. (Bug #40205 - Patch by nickvergessen)</li> <li>[Fix] Fix Oracle database backup (Bug #46715)</li> + <li>[Fix] Update attachments table when deleting user and retaining his posts. (Bug #40245 - Patch by rxu)</li> <li>[Change] Change the data format of the default file ACM to be more secure from tampering and have better performance.</li> <li>[Change] Add index on log_time to the log table to prevent slowdown on boards with many log entries. (Bug #44665 - Patch by bantu)</li> <li>[Change] Template engine now permits to a limited extent variable includes.</li> diff --git a/phpBB/includes/functions_user.php b/phpBB/includes/functions_user.php index ab0122866c..144b323959 100644 --- a/phpBB/includes/functions_user.php +++ b/phpBB/includes/functions_user.php @@ -421,6 +421,11 @@ function user_delete($mode, $user_id, $post_username = false) WHERE topic_last_poster_id = $user_id"; $db->sql_query($sql); + $sql = 'UPDATE ' . ATTACHMENTS_TABLE . ' + SET poster_id = ' . ANONYMOUS . " + WHERE poster_id = $user_id"; + $db->sql_query($sql); + // Since we change every post by this author, we need to count this amount towards the anonymous user // Update the post count for the anonymous user |