start(); $acl = new acl($userdata, $forum_id); // // End session management // // // Check if the user has actually sent a forum ID with his/her request // If not give them a nice error page. // if ( !empty($forum_id) ) { $sql = "SELECT * FROM " . FORUMS_TABLE . " WHERE forum_id = $forum_id"; $result = $db->sql_query($sql); } else { message_die(MESSAGE, 'Forum_not_exist'); } if ( !($forum_data = $db->sql_fetchrow($result)) ) { message_die(MESSAGE, 'Forum_not_exist'); } // // Configure style, language, etc. // $userdata['user_style'] = ( $forum_data['forum_style'] ) ? $forum_data['forum_style'] : $userdata['user_style']; $session->configure($userdata); // // Auth check // if ( !$acl->get_acl($forum_id, 'forum', 'read') ) { if ( $userdata['user_id'] ) { $redirect = "f=$forum_id" . ( ( isset($start) ) ? "&start=$start" : '' ); $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: '; header($header_location . "login.$phpEx$SID&redirect=viewforum.$phpEx&$redirect"); exit; } // // The user is not authed to read this forum ... // message_die(MESSAGE, $lang['Sorry_auth_read']); } // // End of auth check // // // Topic read tracking cookie info // $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) : ''; $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) : ''; // // Handle marking posts // if ( $mark_read == 'topics' ) { if ( $userdata['user_id'] ) { $sql = "SELECT MAX(topic_last_post_time) AS last_post FROM " . TOPICS_TABLE . " WHERE forum_id = $forum_id"; $result = $db->sql_query($sql); if ( $row = $db->sql_fetchrow($result) ) { if ( ( count($tracking_forums) + count($tracking_topics) ) >= 150 && empty($tracking_forums[$forum_id]) ) { asort($tracking_forums); unset($tracking_forums[key($tracking_forums)]); } if ( $row['last_post'] > $userdata['user_lastvisit'] ) { $tracking_forums[$forum_id] = time(); setcookie($board_config['cookie_name'] . '_f', serialize($tracking_forums), 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); } } $template->assign_vars(array( 'META' => '') ); } $message = $lang['Topics_marked_read'] . '

' . sprintf($lang['Click_return_forum'], '', ' '); message_die(MESSAGE, $message); } // // End handle marking posts // // // Do the forum Prune // if ( $acl->get_acl($forum_id, 'mod', 'prune') && $board_config['prune_enable'] ) { if ( $forum_data['prune_next'] < time() && $forum_data['prune_enable'] ) { require($phpbb_root_path . 'includes/functions_admin.'.$phpEx); auto_prune($forum_id); } } // // End of forum prune // // // Forum rules, subscription info and word censors // $s_watching_forum = ''; $s_watching_forum_img = ''; watch_topic_forum('forum', $s_watching_forum, $s_watching_forum_img, $userdata['user_id'], $forum_id); $s_forum_rules = ''; get_forum_rules('forum', $s_forum_rules, $forum_id); $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); // // Topic ordering options // $previous_days = array(0 => $lang['All_Topics'], 1 => $lang['1_Day'], 7 => $lang['7_Days'], 14 => $lang['2_Weeks'], 30 => $lang['1_Month'], 90 => $lang['3_Months'], 180 => $lang['6_Months'], 364 => $lang['1_Year']); $sort_by_text = array('a' => $lang['Author'], 't' => $lang['Post_time'], 'r' => $lang['Replies'], 's' => $lang['Subject'], 'v' => $lang['Views']); $sort_by = array('a' => 'u.username', 't' => 't.topic_last_post_id', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views'); if ( isset($HTTP_POST_VARS['sort']) ) { if ( !empty($HTTP_POST_VARS['sort_days']) ) { $sort_days = ( !empty($HTTP_POST_VARS['sort_days']) ) ? intval($HTTP_POST_VARS['sort_days']) : intval($HTTP_GET_VARS['sort_days']); $min_topic_time = time() - ( $sort_days * 86400 ); // // ref type on as rows as topics ... also not great // $sql = "SELECT COUNT(topic_id) AS forum_topics FROM " . TOPICS_TABLE . " WHERE forum_id = $forum_id AND topic_last_post_time >= $min_topic_time"; $result = $db->sql_query($sql); $start = 0; $topics_count = ( $row = $db->sql_fetchrow($result) ) ? $row['forum_topics'] : 0; $limit_topics_time = "AND t.topic_last_post_time >= $min_topic_time"; } else { $topics_count = ( $forum_data['forum_topics'] ) ? $forum_data['forum_topics'] : 1; } $sort_key = ( isset($HTTP_POST_VARS['sort_key']) ) ? $HTTP_POST_VARS['sort_key'] : $HTTP_GET_VARS['sort_key']; $sort_dir = ( isset($HTTP_POST_VARS['sort_dir']) ) ? $HTTP_POST_VARS['sort_dir'] : $HTTP_GET_VARS['sort_dir']; } else { $topics_count = ( $forum_data['forum_topics'] ) ? $forum_data['forum_topics'] : 1; $limit_topics_time = ''; $sort_days = 0; $sort_key = 't'; $sort_dir = 'd'; } $sort_order = $sort_by[$sort_key] . ' ' . ( ( $sort_dir == 'd' ) ? 'DESC' : 'ASC' ); $select_sort_days = ''; foreach ( $previous_days as $day => $text ) { $selected = ( $sort_days == $day ) ? ' selected="selected"' : ''; $select_sort_days .= '' . $text . ''; } $select_sort_days .= ''; $select_sort = ''; foreach ( $sort_by_text as $key => $text ) { $selected = ( $sort_key == $key ) ? ' selected="selected"' : ''; $select_sort .= '' . $text . ''; } $select_sort .= ''; $select_sort_dir = ''; $select_sort_dir .= ( $sort_dir == 'a' ) ? '' . $lang['Ascending'] . '' . $lang['Descending'] . '' : '' . $lang['Ascending'] . '' . $lang['Descending'] . ''; $select_sort_dir .= ''; $post_alt = ( $forum_data['forum_status'] == FORUM_LOCKED ) ? $lang['Forum_locked'] : $lang['Post_new_topic']; $template->assign_vars(array( 'FORUM_ID' => $forum_id, 'FORUM_NAME' => $forum_data['forum_name'], 'POST_IMG' => '', 'PAGINATION' => generate_pagination("viewforum.$phpEx$SID&f=$forum_id&topicdays=$topic_days", $topics_count, $board_config['topics_per_page'], $start), 'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['topics_per_page'] ) + 1 ), ceil( $topics_count / $board_config['topics_per_page'] )), 'FOLDER_IMG' => create_img($theme['folder'], $lang['No_new_posts']), 'FOLDER_NEW_IMG' => create_img($theme['folder_new'], $lang['New_posts']), 'FOLDER_HOT_IMG' => create_img($theme['folder_hot'], $lang['No_new_posts_hot']), 'FOLDER_HOT_NEW_IMG' => create_img($theme['folder_hot_new'], $lang['New_posts_hot']), 'FOLDER_LOCKED_IMG' => create_img($theme['folder_locked'], $lang['No_new_posts_locked']), 'FOLDER_LOCKED_NEW_IMG' => create_img($theme['folder_locked_new'], $lang['New_posts_locked']), 'FOLDER_STICKY_IMG' => create_img($theme['folder_sticky'], $lang['Post_Sticky']), 'FOLDER_STICKY_NEW_IMG' => create_img($theme['folder_sticky_new'], $lang['Post_Sticky']), 'FOLDER_ANNOUNCE_IMG' => create_img($theme['folder_announce'], $lang['Post_Announcement']), 'FOLDER_ANNOUNCE_NEW_IMG' => create_img($theme['folder_announce_new'], $lang['Post_Announcement']), 'L_TOPICS' => $lang['Topics'], 'L_REPLIES' => $lang['Replies'], 'L_VIEWS' => $lang['Views'], 'L_POSTS' => $lang['Posts'], 'L_LASTPOST' => $lang['Last_Post'], 'L_VIEW_MODERATORS' => $lang['View_moderators'], 'L_DISPLAY_TOPICS' => $lang['Display_topics'], 'L_SORT_BY' => $lang['Sort_by'], 'L_MARK_TOPICS_READ' => $lang['Mark_all_topics'], 'L_NO_NEW_POSTS' => $lang['No_new_posts'], 'L_NEW_POSTS' => $lang['New_posts'], 'L_NO_NEW_POSTS_LOCKED' => $lang['No_new_posts_locked'], 'L_NEW_POSTS_LOCKED' => $lang['New_posts_locked'], 'L_NO_NEW_POSTS_HOT' => $lang['No_new_posts_hot'], 'L_NEW_POSTS_HOT' => $lang['New_posts_hot'], 'L_ANNOUNCEMENT' => $lang['Post_Announcement'], 'L_STICKY' => $lang['Post_Sticky'], 'L_POSTED' => $lang['Posted'], 'L_JOINED' => $lang['Joined'], 'L_AUTHOR' => $lang['Author'], 'L_NO_TOPICS' => ( $forum_data['forum_status'] == FORUM_LOCKED ) ? $lang['Forum_locked'] : $lang['No_topics_post_one'], 'L_GOTO_PAGE' => $lang['Goto_page'], 'S_SELECT_SORT_DIR' => $select_sort_dir, 'S_SELECT_SORT_KEY' => $select_sort, 'S_SELECT_SORT_DAYS' => $select_sort_days, 'S_AUTH_LIST' => $s_forum_rules, 'S_WATCH_FORUM' => $s_watching_forum, 'S_FORUM_ACTION' => 'viewforum.' . $phpEx . $SID . '&f=' . $forum_id . "&start=$start", 'U_POST_NEW_TOPIC' => 'posting.' . $phpEx . $SID . '&mode=newtopic&f=' . $forum_id, 'U_VIEW_FORUM' => 'viewforum.' . $phpEx . $SID . '&f=' . $forum_id, 'U_VIEW_MODERATORS' => 'memberslist.' . $phpEx . $SID . '&mode=moderators&f=' . $forum_id, 'U_MARK_READ' => 'viewforum.' . $phpEx . $SID . '&f=' . $forum_id . '&mark=topics') ); // // Grab all the basic data. If we're not on page 1 we also grab any // announcements that may exist. // $total_topics = 0; $topic_rowset = array(); if ( $start ) { $sql = "SELECT t.*, i.icons_url, i.icons_width, i.icons_height, u.username, u.user_id, u2.username as user2, u2.user_id as id2 FROM " . TOPICS_TABLE . " t, " . ICONS_TABLE . " i, " . USERS_TABLE . " u, " . USERS_TABLE . " u2 WHERE t.forum_id = $forum_id AND t.topic_type = " . POST_ANNOUNCE . " AND i.icons_id = t.topic_icon AND u.user_id = t.topic_poster AND u2.user_id = t.topic_last_poster_id ORDER BY $sort_order LIMIT " . $board_config['topics_per_page']; $result = $db->sql_query($sql); while( $row = $db->sql_fetchrow($result) ) { $topic_rowset[] = $row; $total_topics++; } } // // topic icon join requires full table scan ... not good // $sql = "SELECT t.*, i.icons_url, i.icons_width, i.icons_height, u.username, u.user_id, u2.username as user2, u2.user_id as id2 FROM " . TOPICS_TABLE . " t, " . ICONS_TABLE . " i, " . USERS_TABLE . " u, " . USERS_TABLE . " u2 WHERE t.forum_id = $forum_id AND i.icons_id = t.topic_icon AND u.user_id = t.topic_poster AND u2.user_id = t.topic_last_poster_id $limit_topics_time ORDER BY t.topic_type DESC, $sort_order LIMIT $start, " . $board_config['topics_per_page']; $result = $db->sql_query($sql); while( $row = $db->sql_fetchrow($result) ) { $topic_rowset[] = $row; $total_topics++; } $db->sql_freeresult($result); // // Okay, lets dump out the page ... // if ( $total_topics ) { $row_count = 0; for($i = 0; $i < $total_topics; $i++) { $topic_id = $topic_rowset[$i]['topic_id']; $topic_title = ( count($orig_word) ) ? preg_replace($orig_word, $replacement_word, $topic_rowset[$i]['topic_title']) : $topic_rowset[$i]['topic_title']; $topic_type = $topic_rowset[$i]['topic_type']; $topic_type = ''; if ( $topic_rowset[$i]['topic_status'] == TOPIC_MOVED ) { $topic_type = $lang['Topic_Moved'] . ' '; $topic_id = $topic_rowset[$i]['topic_moved_id']; $folder_image = $theme['folder']; $folder_alt = $lang['Topic_Moved']; $newest_post_img = ''; } else { switch ( $topic_rowset[$i]['topic_type'] ) { case POST_ANNOUNCE: $topic_type = $lang['Topic_Announcement'] . ' '; $folder = $theme['folder_announce']; $folder_new = $theme['folder_announce_new']; break; case POST_STICKY: $topic_type = $lang['Topic_Sticky'] . ' '; $folder = $theme['folder_sticky']; $folder_new = $theme['folder_sticky_new']; break; case TOPIC_LOCKED: $folder = $theme['folder_locked']; $folder_new = $theme['folder_locked_new']; break; default: if ( $replies >= $board_config['hot_threshold'] ) { $folder = $theme['folder_hot']; $folder_new = $theme['folder_hot_new']; } else { $folder = $theme['folder']; $folder_new = $theme['folder_new']; } break; } $newest_post_img = ''; if ( $userdata['user_id'] != ANONYMOUS ) { if ( $topic_rowset[$i]['post_time'] > $userdata['user_lastvisit'] ) { if ( !empty($tracking_topics) || !empty($tracking_forums) || isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) ) { $unread_topics = true; if ( !empty($tracking_topics[$topic_id]) ) { if ( $tracking_topics[$topic_id] >= $topic_rowset[$i]['post_time'] ) { $unread_topics = false; } } if ( !empty($tracking_forums[$forum_id]) ) { if ( $tracking_forums[$forum_id] >= $topic_rowset[$i]['post_time'] ) { $unread_topics = false; } } if ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) ) { if ( $HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all'] >= $topic_rowset[$i]['post_time'] ) { $unread_topics = false; } } if ( $unread_topics ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = '' . create_img($theme['goto_post_newest'], $lang['View_newest_post']) . ' '; } else { $folder_image = $folder; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } else { $folder_image = $folder_new; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = '' . create_img($theme['goto_post_newest'], $lang['View_newest_post']) . ' '; } } else { $folder_image = $folder; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } else { $folder_image = $folder; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } if ( $topic_rowset[$i]['topic_vote'] ) { $topic_type .= $lang['Topic_Poll'] . ' '; } if ( ( $replies + 1 ) > $board_config['posts_per_page'] ) { $total_pages = ceil( ( $replies + 1 ) / $board_config['posts_per_page'] ); $goto_page = ' [ ' . $lang['Goto_page'] . ': '; $times = 1; for($j = 0; $j < $replies + 1; $j += $board_config['posts_per_page']) { $goto_page .= '' . $times . ''; if ( $times == 1 && $total_pages > 4 ) { $goto_page .= ' ... '; $times = $total_pages - 3; $j += ( $total_pages - 4 ) * $board_config['posts_per_page']; } else if ( $times < $total_pages ) { $goto_page .= ', '; } $times++; } $goto_page .= ' ] '; } else { $goto_page = ''; } $view_topic_url = 'viewtopic.' . $phpEx . $SID . '&f=' . $forum_id . '&t=' . $topic_id; $topic_author = ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? $topic_rowset[$i]['username'] : ( ( $topic_rowset[$i]['topic_first_poster_name'] != '' ) ? $topic_rowset[$i]['topic_first_poster_name'] : $lang['Guest'] ); $topic_author .= ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $first_post_time = create_date($board_config['default_dateformat'], $topic_rowset[$i]['topic_time'], $board_config['board_timezone']); $last_post_time = create_date($board_config['default_dateformat'], $topic_rowset[$i]['topic_last_post_time'], $board_config['board_timezone']); $last_post_author = ( $topic_rowset[$i]['id2'] == ANONYMOUS ) ? ( ( $topic_rowset[$i]['topic_last_poster_name'] != '' ) ? $topic_rowset[$i]['topic_last_poster_name'] . ' ' : $lang['Guest'] . ' ' ) : '' . $topic_rowset[$i]['user2'] . ''; $last_post_url = '' . create_img($theme['goto_post_latest'], $lang['View_latest_post']) . ''; $views = $topic_rowset[$i]['topic_views']; $replies = $topic_rowset[$i]['topic_replies']; $topic_icon = ( !empty($topic_rowset[$i]['icons_url']) ) ? '' : ''; $topic_rating = ( !empty($topic_rowset[$i]['topic_rating']) ) ? '' : ''; $template->assign_block_vars('topicrow', array( 'FORUM_ID' => $forum_id, 'TOPIC_ID' => $topic_id, 'TOPIC_FOLDER_IMG' => create_img($folder_image, $folder_alt), 'TOPIC_AUTHOR' => $topic_author, 'GOTO_PAGE' => $goto_page, 'REPLIES' => $replies, 'NEWEST_POST_IMG' => $newest_post_img, 'TOPIC_TITLE' => $topic_title, 'TOPIC_TYPE' => $topic_type, 'TOPIC_ICON' => $topic_icon, 'TOPIC_RATING' => $topic_rating, 'VIEWS' => $views, 'FIRST_POST_TIME' => $first_post_time, 'LAST_POST_TIME' => $last_post_time, 'LAST_POST_AUTHOR' => $last_post_author, 'LAST_POST_IMG' => $last_post_url, 'S_ROW_COUNT' => $i, 'U_VIEW_TOPIC' => $view_topic_url) ); $row_count++; } } // // Dump out the page header and load viewforum template // $page_title = $lang['View_forum'] . ' - ' . $forum_data['forum_name']; $nav_links['up'] = array( 'url' => 'index.' . $phpEx . $SID, 'title' => sprintf($lang['Forum_Index'], $board_config['sitename']) ); include($phpbb_root_path . 'includes/page_header.'.$phpEx); $template->set_filenames(array( 'body' => 'viewforum_body.html') ); make_jumpbox('viewforum.'.$phpEx); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?>