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 /phpBB/search.php | |
| parent | #12415 (diff) | |
| download | phpbb-1447e8714d300f9a404f03672e77ab356921187a.tar.gz phpbb-1447e8714d300f9a404f03672e77ab356921187a.tar.bz2 phpbb-1447e8714d300f9a404f03672e77ab356921187a.zip | |
#12545
git-svn-id: file:///svn/phpbb/trunk@7779 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/search.php')
| -rw-r--r-- | phpBB/search.php | 12 |
1 files changed, 6 insertions, 6 deletions
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 |