diff options
| author | Henry Sudhof <kellanved@phpbb.com> | 2007-06-19 11:45:29 +0000 |
|---|---|---|
| committer | Henry Sudhof <kellanved@phpbb.com> | 2007-06-19 11:45:29 +0000 |
| commit | 1447e8714d300f9a404f03672e77ab356921187a (patch) | |
| tree | 8d1e68472f3c320b5ad23fa57b25c160f33bb1cf | |
| parent | f81bb91ecaf3f16eac793aaec09c112c5c583dc7 (diff) | |
| download | forums-1447e8714d300f9a404f03672e77ab356921187a.tar forums-1447e8714d300f9a404f03672e77ab356921187a.tar.gz forums-1447e8714d300f9a404f03672e77ab356921187a.tar.bz2 forums-1447e8714d300f9a404f03672e77ab356921187a.tar.xz forums-1447e8714d300f9a404f03672e77ab356921187a.zip | |
#12545
git-svn-id: file:///svn/phpbb/trunk@7779 89ea8834-ac86-4346-8a33-228a782c2dd0
| -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 |