diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-04-02 14:48:56 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-04-02 14:48:56 +0000 |
| commit | ab57859a182a019b065a55e9905a9eaa10452591 (patch) | |
| tree | 72d930956f025f230f8099af225d7f9099236a92 | |
| parent | 582b838ae938f7ab0a81627600544101e442e999 (diff) | |
| download | forums-ab57859a182a019b065a55e9905a9eaa10452591.tar forums-ab57859a182a019b065a55e9905a9eaa10452591.tar.gz forums-ab57859a182a019b065a55e9905a9eaa10452591.tar.bz2 forums-ab57859a182a019b065a55e9905a9eaa10452591.tar.xz forums-ab57859a182a019b065a55e9905a9eaa10452591.zip | |
Errm, modified the forum query in make_jumpbox, doh
git-svn-id: file:///svn/phpbb/trunk@138 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rw-r--r-- | phpBB/functions/functions.php | 8 |
1 files changed, 3 insertions, 5 deletions
diff --git a/phpBB/functions/functions.php b/phpBB/functions/functions.php index b988b4a9cd..cc387ecde0 100644 --- a/phpBB/functions/functions.php +++ b/phpBB/functions/functions.php @@ -87,11 +87,9 @@ function make_jumpbox($db) $limit_forums = ""; - $sql = "SELECT f.*, u.username, u.user_id, p.post_time - FROM ".FORUMS_TABLE." f - LEFT JOIN ".POSTS_TABLE." p ON p.post_id = f.forum_last_post_id - LEFT JOIN ".USERS_TABLE." u ON u.user_id = p.poster_id - ORDER BY f.cat_id, f.forum_order"; + $sql = "SELECT * + FROM ".FORUMS_TABLE." + ORDER BY cat_id, forum_order"; if(!$q_forums = $db->sql_query($sql)) { error_die($db, QUERY_ERROR); |