aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-01-09 23:13:51 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-01-09 23:13:51 +0000
commit52784a3c60fab8fe5d364f2757822a449094ff2e (patch)
treeeaaa7de5d0c24ae839bb8abf46c7cf5ec7e5223c
parentdf86b7322d0c83de303be06f144bd2a0f1148a57 (diff)
downloadforums-52784a3c60fab8fe5d364f2757822a449094ff2e.tar
forums-52784a3c60fab8fe5d364f2757822a449094ff2e.tar.gz
forums-52784a3c60fab8fe5d364f2757822a449094ff2e.tar.bz2
forums-52784a3c60fab8fe5d364f2757822a449094ff2e.tar.xz
forums-52784a3c60fab8fe5d364f2757822a449094ff2e.zip
Delete soft-deleted users before updating user table ... Bart, please check
git-svn-id: file:///svn/phpbb/trunk@1829 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/upgrade.php7
1 files changed, 7 insertions, 0 deletions
diff --git a/phpBB/upgrade.php b/phpBB/upgrade.php
index 942622e379..e10b3be349 100644
--- a/phpBB/upgrade.php
+++ b/phpBB/upgrade.php
@@ -716,6 +716,13 @@ if( !empty($next) )
end_step('convert_users');
case 'convert_users':
+ //
+ // Completely remove old soft-deleted users
+ //
+ $sql = "DELETE FROM " . USERS_TABLE . "
+ WHERE user_level = -1";
+ query($sql, "Couldn't delete old soft-deleted users");
+
$sql = "SELECT COUNT(*) AS total, MAX(user_id) AS maxid
FROM " . USERS_TABLE;
$result = query($sql, "Couldn't get max post_id.");