diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-17 14:48:39 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-17 14:48:39 +0000 |
| commit | b621f70cd14a4a912837021604e723cefac406b7 (patch) | |
| tree | ff9ba32a10ce34179d10dabef9e980f538757e19 /phpBB/index.php | |
| parent | dcf65b486eeae372b5604a84bfbbfbabc7a22a8e (diff) | |
| download | forums-b621f70cd14a4a912837021604e723cefac406b7.tar forums-b621f70cd14a4a912837021604e723cefac406b7.tar.gz forums-b621f70cd14a4a912837021604e723cefac406b7.tar.bz2 forums-b621f70cd14a4a912837021604e723cefac406b7.tar.xz forums-b621f70cd14a4a912837021604e723cefac406b7.zip | |
Removed separate header/footers and moved into each pages body
git-svn-id: file:///svn/phpbb/trunk@311 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/index.php')
| -rw-r--r-- | phpBB/index.php | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/phpBB/index.php b/phpBB/index.php index e508a42ac7..27108595b1 100644 --- a/phpBB/index.php +++ b/phpBB/index.php @@ -48,8 +48,28 @@ if(empty($viewcat)) $viewcat = -1; } +// +// Output page header and +// open the index body template +// include('includes/page_header.'.$phpEx); +$template->set_filenames(array( + "body" => "index_body.tpl")); + +$template->assign_vars(array( + "TOTAL_POSTS" => $total_posts, + "TOTAL_USERS" => $total_users, + "NEWEST_USER" => $newest_user, + "NEWEST_UID" => $newest_uid, + "USERS_BROWSING" => $users_browsing, + + "U_NEWEST_USER_PROFILE" => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=$newest_uid")) +); + +// +// Start main +// $sql = "SELECT c.cat_id, c.cat_title, c.cat_order FROM ".CATEGORIES_TABLE." c, ".FORUMS_TABLE." f WHERE f.cat_id = c.cat_id @@ -107,7 +127,7 @@ if($total_categories) default: // This works on: MySQL, MSSQL and ODBC (Access) $limit_forums = ($viewcat != -1) ? "WHERE f.cat_id = $viewcat " : ""; - echo $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time + $sql = "SELECT f.*, t.topic_id, t.topic_replies, t.topic_last_post_id, u.username, u.user_id, p.post_time FROM (( ".FORUMS_TABLE." f LEFT JOIN ".POSTS_TABLE." p ON f.forum_last_post_id = p.post_id ) LEFT JOIN ".TOPICS_TABLE." t ON p.post_id = t.topic_last_post_id ) |