diff options
author | Meik Sievertsen <acydburn@phpbb.com> | 2003-02-26 13:17:45 +0000 |
---|---|---|
committer | Meik Sievertsen <acydburn@phpbb.com> | 2003-02-26 13:17:45 +0000 |
commit | d95588823a7e2797fa3502ea145ca54689135a16 (patch) | |
tree | 927aa2b4faa6b3657eb4718b19c4df83cf8eac61 /phpBB/search.php | |
parent | e295cab3043d1eafc3ab4344ab83dae171e058cc (diff) | |
download | forums-d95588823a7e2797fa3502ea145ca54689135a16.tar forums-d95588823a7e2797fa3502ea145ca54689135a16.tar.gz forums-d95588823a7e2797fa3502ea145ca54689135a16.tar.bz2 forums-d95588823a7e2797fa3502ea145ca54689135a16.tar.xz forums-d95588823a7e2797fa3502ea145ca54689135a16.zip |
only minor changes, some notes, played around with the code... nothing special.
git-svn-id: file:///svn/phpbb/trunk@3543 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/search.php')
-rw-r--r-- | phpBB/search.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/phpBB/search.php b/phpBB/search.php index b4ca6dd8be..bb5b08347a 100644 --- a/phpBB/search.php +++ b/phpBB/search.php @@ -586,10 +586,9 @@ if ( $search_keywords != '' || $search_author != '' || $search_id ) { if ( $show_results == 'posts' ) { - $sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid - FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt + $sql = "SELECT p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid + FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p WHERE p.post_id IN ($search_results) - AND pt.post_id = p.post_id AND f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND p.poster_id = u.user_id"; |