From 3fd79742a7d9edbf72836e5679ebb5b92f11f7a9 Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Fri, 23 Dec 2005 03:18:31 +0000 Subject: [PATCH] r678: TABLE_PREFIX needed --- index.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/index.php b/index.php index d2a37e7..f4a84c1 100644 --- a/index.php +++ b/index.php @@ -45,11 +45,11 @@ $pagination->split_pages(); $bugs_fetch = $db->query(" SELECT bug.*, user1.displayname AS firstreport, user2.displayname AS lastpost, user3.displayname AS hiddenlastpost FROM " . TABLE_PREFIX . "bug AS bug - LEFT JOIN user AS user1 + LEFT JOIN " . TABLE_PREFIX . "user AS user1 ON (bug.userid = user1.userid) - LEFT JOIN user AS user2 + LEFT JOIN " . TABLE_PREFIX . "user AS user2 ON (bug.lastpostby = user2.userid) - LEFT JOIN user AS user3 + LEFT JOIN " . TABLE_PREFIX . "user AS user3 ON (bug.hiddenlastpostby = user3.userid) WHERE bug.productid IN (" . fetch_on_bits('canviewbugs') . ") AND (!hidden OR (hidden AND productid IN (" . fetch_on_bits('canviewhidden') . "))) -- 2.22.5