diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-04-04 11:47:43 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2002-04-04 11:47:43 +0000 |
| commit | 7012f5168f74216819b9148fd1e78b06f4dee3ff (patch) | |
| tree | 3c08384081d67f4392150b9bca6c898cce7d4407 | |
| parent | 232a6596cb185a311477a1d66bf7beeb56ba7376 (diff) | |
| download | forums-7012f5168f74216819b9148fd1e78b06f4dee3ff.tar forums-7012f5168f74216819b9148fd1e78b06f4dee3ff.tar.gz forums-7012f5168f74216819b9148fd1e78b06f4dee3ff.tar.bz2 forums-7012f5168f74216819b9148fd1e78b06f4dee3ff.tar.xz forums-7012f5168f74216819b9148fd1e78b06f4dee3ff.zip | |
Minor update to SQL to remove an IN where it was no longer necessary
git-svn-id: file:///svn/phpbb/trunk@2477 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/viewforum.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/viewforum.php b/phpBB/viewforum.php index a3d2c98a14..65c05f9426 100644 --- a/phpBB/viewforum.php +++ b/phpBB/viewforum.php @@ -287,7 +287,7 @@ $select_topic_days .= '</select>'; // $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . USERS_TABLE . " u2 - WHERE t.forum_id IN ($forum_id, -1) + WHERE t.forum_id = $forum_id AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id AND p.poster_id = u2.user_id |