diff options
| author | David M <davidmj@users.sourceforge.net> | 2006-05-16 22:14:59 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2006-05-16 22:14:59 +0000 |
| commit | 68e374067b527ba8b670d53e5879112cf7f67872 (patch) | |
| tree | d9b5af08e903d27b257fececdb822cd9c68a5a21 /phpBB/includes | |
| parent | d52e31a4891a96d97157a36c266a0e81e198aa6a (diff) | |
| download | forums-68e374067b527ba8b670d53e5879112cf7f67872.tar forums-68e374067b527ba8b670d53e5879112cf7f67872.tar.gz forums-68e374067b527ba8b670d53e5879112cf7f67872.tar.bz2 forums-68e374067b527ba8b670d53e5879112cf7f67872.tar.xz forums-68e374067b527ba8b670d53e5879112cf7f67872.zip | |
Firebird!
git-svn-id: file:///svn/phpbb/trunk@5918 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/ucp/ucp_main.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/includes/ucp/ucp_main.php b/phpBB/includes/ucp/ucp_main.php index 5b6aaeeb0f..59f95936d8 100644 --- a/phpBB/includes/ucp/ucp_main.php +++ b/phpBB/includes/ucp/ucp_main.php @@ -818,7 +818,7 @@ class ucp_main AND f.forum_id = p.forum_id $post_count_sql GROUP BY f.forum_id - ORDER BY num_posts DESC"; + ORDER BY COUNT(p.post_id) DESC"; $result = $db->sql_query_limit($sql, 1); $active_f_row = $db->sql_fetchrow($result); $db->sql_freeresult($result); @@ -838,7 +838,7 @@ class ucp_main AND f.forum_id = t.forum_id $post_count_sql GROUP BY t.topic_id - ORDER BY num_posts DESC"; + ORDER BY COUNT(p.post_id) DESC"; $result = $db->sql_query_limit($sql, 1); $active_t_row = $db->sql_fetchrow($result); $db->sql_freeresult($result); |