diff options
| author | Dhruv Goel <dhruv.goel92@gmail.com> | 2012-04-22 00:36:38 +0530 |
|---|---|---|
| committer | Dhruv Goel <dhruv.goel92@gmail.com> | 2012-05-10 22:53:04 +0530 |
| commit | 164054f0679caaa68fb8400d3469b1149022db29 (patch) | |
| tree | 0de4d086680570f008781395652ac0e398d0f131 /phpBB/includes/acp | |
| parent | cf303c34788b32e1c09f483e2760b77eff3e05ca (diff) | |
| download | forums-164054f0679caaa68fb8400d3469b1149022db29.tar forums-164054f0679caaa68fb8400d3469b1149022db29.tar.gz forums-164054f0679caaa68fb8400d3469b1149022db29.tar.bz2 forums-164054f0679caaa68fb8400d3469b1149022db29.tar.xz forums-164054f0679caaa68fb8400d3469b1149022db29.zip | |
[ticket/10308] fixes sql query, limit it to 1
instead of fetching all posts by user we limit the query to 1 to check if
a user has posts or not
PHPBB3-10308
Diffstat (limited to 'phpBB/includes/acp')
| -rw-r--r-- | phpBB/includes/acp/acp_users.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/includes/acp/acp_users.php b/phpBB/includes/acp/acp_users.php index 1f0f053a85..7565d43690 100644 --- a/phpBB/includes/acp/acp_users.php +++ b/phpBB/includes/acp/acp_users.php @@ -1009,11 +1009,11 @@ class acp_users $user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue'); $db->sql_freeresult($result); - $sql = 'SELECT COUNT(post_id) as user_total_posts + $sql = 'SELECT post_id FROM ' . POSTS_TABLE . ' WHERE poster_id = '. $user_id; - $result = $db->sql_query($sql); - $user_row['user_total_posts'] = (int) $db->sql_fetchfield('user_total_posts'); + $result = $db->sql_query_limit($sql, 1); + $user_row['user_has_posts'] = ($db->sql_fetchfield('post_id') ? 1 : 0); $db->sql_freeresult($result); $template->assign_vars(array( @@ -1043,7 +1043,7 @@ class acp_users 'USER_EMAIL' => $user_row['user_email'], 'USER_WARNINGS' => $user_row['user_warnings'], 'USER_POSTS' => $user_row['user_posts'], - 'USER_TOTAL_POSTS' => $user_row['user_total_posts'], + 'USER_HAS_POSTS' => $user_row['user_has_posts'], 'USER_INACTIVE_REASON' => $inactive_reason, )); |