diff options
| -rw-r--r-- | phpBB/docs/CHANGELOG.html | 3 | ||||
| -rw-r--r-- | phpBB/search.php | 12 |
2 files changed, 8 insertions, 7 deletions
diff --git a/phpBB/docs/CHANGELOG.html b/phpBB/docs/CHANGELOG.html index 2f78307315..827efafe6c 100644 --- a/phpBB/docs/CHANGELOG.html +++ b/phpBB/docs/CHANGELOG.html @@ -287,7 +287,8 @@ p a { <li>[Fix] Added post anchor to links in default warning message (Bug #12489)</li> <li>[Fix] Allow 5 digits in editing time fields (Bug #12489)</li> <li>[Fix] MS SQL DBAL drivers now write over extension limitations, they are too low for most installations (Bug #12415)</li> -</ul> + <li>[Fix] Fix sorting by author on "unanswered posts" (Bug #12545)</li> +ul> </div> <a href="#top">Top</a> diff --git a/phpBB/search.php b/phpBB/search.php index ed1b43fd9e..4b2563dbe5 100644 --- a/phpBB/search.php +++ b/phpBB/search.php @@ -299,14 +299,14 @@ if ($keywords || $author || $author_id || $search_id || $submit) $last_post_time = ''; } + + if ($sort_key == 'a') + { + $sort_join = USERS_TABLE . ' u, '; + $sql_sort = ' AND u.user_id = p.poster_id ' . $sql_sort; + } if ($show_results == 'posts') { - if ($sort_key == 'a') - { - $sort_join = USERS_TABLE . ' u, '; - $sql_sort = ' AND u.user_id = p.poster_id ' . $sql_sort; - } - $sql = "SELECT p.post_id FROM $sort_join" . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t WHERE t.topic_replies = 0 |