|
From: Paul S. O. <ps...@us...> - 2002-04-04 15:30:00
|
Update of /cvsroot/phpbb/phpBB2 In directory usw-pr-cvs1:/tmp/cvs-serv32115 Modified Files: viewforum.php Log Message: Minor update to SQL to remove an IN where it was no longer necessary Index: viewforum.php =================================================================== RCS file: /cvsroot/phpbb/phpBB2/viewforum.php,v retrieving revision 1.138 retrieving revision 1.139 diff -C2 -r1.138 -r1.139 *** viewforum.php 2 Apr 2002 15:10:44 -0000 1.138 --- viewforum.php 4 Apr 2002 11:47:43 -0000 1.139 *************** *** 288,292 **** $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) AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id --- 288,292 ---- $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 = $forum_id AND t.topic_poster = u.user_id AND p.post_id = t.topic_last_post_id |