diff options
| author | Henry Sudhof <kellanved@phpbb.com> | 2007-05-25 16:03:40 +0000 |
|---|---|---|
| committer | Henry Sudhof <kellanved@phpbb.com> | 2007-05-25 16:03:40 +0000 |
| commit | 20993d5cf1abdb448eb57c8b0de6c0f36bfc6f70 (patch) | |
| tree | 0b217a8cf2f6945baccdc3e3fefe572db41adecd /phpBB/includes/acp/acp_forums.php | |
| parent | 17315b69c69fba5bad5f78bc1d38c301692f9904 (diff) | |
| download | forums-20993d5cf1abdb448eb57c8b0de6c0f36bfc6f70.tar forums-20993d5cf1abdb448eb57c8b0de6c0f36bfc6f70.tar.gz forums-20993d5cf1abdb448eb57c8b0de6c0f36bfc6f70.tar.bz2 forums-20993d5cf1abdb448eb57c8b0de6c0f36bfc6f70.tar.xz forums-20993d5cf1abdb448eb57c8b0de6c0f36bfc6f70.zip | |
Introduced checks to stop negative postcounts (Bug #11561, #11421)
Allow IP v4/v6 urls for remote avatars (Bug #11633)
Delete avatar files automatically (Bug #11631)
Automatically add selected columsn to group by statements in the converter (Bug #11465)
git-svn-id: file:///svn/phpbb/trunk@7677 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/acp/acp_forums.php')
| -rw-r--r-- | phpBB/includes/acp/acp_forums.php | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/phpBB/includes/acp/acp_forums.php b/phpBB/includes/acp/acp_forums.php index 0f38d6663b..3e5ca705da 100644 --- a/phpBB/includes/acp/acp_forums.php +++ b/phpBB/includes/acp/acp_forums.php @@ -1710,8 +1710,14 @@ class acp_forums foreach ($post_counts as $poster_id => $substract) { $sql = 'UPDATE ' . USERS_TABLE . ' + SET user_posts = 0 + WHERE user_id = ' . $poster_id . ' + AND user_posts < ' . $substract; + $db->sql_query($sql); + $sql = 'UPDATE ' . USERS_TABLE . ' SET user_posts = user_posts - ' . $substract . ' - WHERE user_id = ' . $poster_id; + WHERE user_id = ' . $poster_id . ' + AND user_posts >= ' . $substract; $db->sql_query($sql); } } |