Geplaatst - Code
?php /*************************************************************************** * viewforum.php * ------------------- * begin : Saturday, Feb 13, 2001 * copyright : (C) 2001 The phpBB Group * email : support@phpbb.com * * $Id: viewforum.php,v 1.139.2.5 2002/05/17 13:14:05 psotfx Exp $ * * ***************************************************************************/ /*************************************************************************** * * This program is free software; you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License, or * (at your option) any later version. * ***************************************************************************/ define('IN_PHPBB', true); $phpbb_root_path = './'; include($phpbb_root_path . 'extension.inc'); include($phpbb_root_path . 'common.'.$phpEx); // // Start initial var setup // if ( isset($HTTP_GET_VARS[POST_FORUM_URL]) || isset($HTTP_POST_VARS[POST_FORUM_URL]) ) { $forum_id = ( isset($HTTP_GET_VARS[POST_FORUM_URL]) ) ? intval($HTTP_GET_VARS[POST_FORUM_URL]) : intval($HTTP_POST_VARS[POST_FORUM_URL]); } else if ( isset($HTTP_GET_VARS['forum'])) { $forum_id = intval($HTTP_GET_VARS['forum']); } else { $forum_id = ''; } $start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0; if ( isset($HTTP_GET_VARS['mark']) || isset($HTTP_POST_VARS['mark']) ) { $mark_read = (isset($HTTP_POST_VARS['mark'])) ? $HTTP_POST_VARS['mark'] : $HTTP_GET_VARS['mark']; } else { $mark_read = ''; } // // End initial var setup // // // Start session management // $userdata = session_pagestart($user_ip, $forum_id); init_userprefs($userdata); // // 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 . " f LEFT JOIN ".LASTREAD_TABLE." lr ON ( lr.user_id = ".$userdata['user_id']." AND lr.forum_id = -$forum_id) WHERE f.forum_id = $forum_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain forums information', '', __LINE__, __FILE__, $sql); } } else { message_die(GENERAL_MESSAGE, 'Forum_not_exist'); } // // If the query doesn't return any rows this isn't a valid forum. Inform // the user. // if ( !($forum_row = $db->sql_fetchrow($result)) ) { message_die(GENERAL_MESSAGE, 'Forum_not_exist'); } // // Start auth check // $is_auth = array(); $is_auth = auth(AUTH_ALL, $forum_id, $userdata, $forum_row); if ( $forum_id == REPORT_FORUM_ID ) { // Users can access this forum but they can only see their own topics. } else if ( !$is_auth['auth_read'] || !$is_auth['auth_view'] ) { if ( !$userdata['session_logged_in'] ) { $redirect = POST_FORUM_URL . "=$forum_id" . ( ( isset($start) ) ? "&start=$start" : '' ); $header_location = ( @preg_match("/Microsoft|WebSTAR|Xitami/", getenv("SERVER_SOFTWARE")) ) ? "Refresh: 0; URL=" : "Location: "; header($header_location . append_sid("login.$phpEx?redirect=viewforum.$phpEx&$redirect", true)); exit; } // // The user is not authed to read this forum ... // $message = ( !$is_auth['auth_view'] ) ? $lang['Forum_not_exist'] : sprintf($lang['Sorry_auth_read'], $is_auth['auth_read_type']); message_die(GENERAL_MESSAGE, $message); } // // End of auth check // // // Handle marking posts // if ( $mark_read == 'topics' ) { if ( $userdata['session_logged_in'] ) { markread('mark', $forum_id); /* $sql = "SELECT MAX(post_time) AS last_post FROM " . POSTS_TABLE . " WHERE forum_id = $forum_id"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain forums information', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) : array(); $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) : array(); 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' => 'sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql); } $moderators = array(); while( $row = $db->sql_fetchrow($result) ) { $moderators[] = 'sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not query forum moderator information', '', __LINE__, __FILE__, $sql); } while( $row = $db->sql_fetchrow($result) ) { $moderators[] = 'sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain limited topics count information', '', __LINE__, __FILE__, $sql); } $row = $db->sql_fetchrow($result); $topics_count = ( $row['forum_topics'] ) ? $row['forum_topics'] : 1; $limit_topics_time = "AND p.post_time >= $min_topic_time"; if ( !empty($HTTP_POST_VARS['topicdays']) ) { $start = 0; } } else { $topics_count = ( $forum_row['forum_topics'] ) ? $forum_row['forum_topics'] : 1; $limit_topics_time = ''; $topic_days = 0; } $select_topic_days = ''; for($i = 0; $i < count($previous_days); $i++) { $selected = ($topic_days == $previous_days[$i]) ? ' selected="selected"' : ''; $select_topic_days .= 'sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql); } $topic_rowset = array(); $total_announcements = 0; while( $row = $db->sql_fetchrow($result) ) { $topic_rowset[] = $row; $total_announcements++; } $db->sql_freeresult($result); */ // // Grab all the basic data (all topics except announcements) // for this forum // if($forum_row['events_forum']) { $events_fields = "DATE_FORMAT(cal.cal_date, '%e-%c') as cal_date, cal_repeat,"; $events_join = "LEFT JOIN ".MYCALENDAR_TABLE." cal ON (t.topic_id=cal.topic_id)"; } else { $events_fields = ''; $events_join = ''; } if ( $forum_id == REPORT_FORUM_ID && !$is_auth['auth_mod']) // mods? { $report_sql = "AND (t.topic_poster = " . $userdata['user_id'] . " OR topic_type IN ( " . POST_STICKY . ", " . POST_ANNOUNCE . ")) "; } switch ($forum_row['cat_id']) { case 5: // The 'eenmaal andermaal' forums are sorted by topicstart $order_by = 'ORDER BY t.topic_type DESC, t.topic_time DESC'; $board_config['topics_per_page'] = $board_config['topics_per_page'] * 2; break; default: // Other forums are sorted by lastpost $order_by = 'ORDER BY t.topic_type DESC, t.topic_last_post_id DESC'; break; } $sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, u2.user_level as user_level2, p.post_username, p2.post_username AS post_username2, p2.post_time, $events_fields lr.lasttime, lr.type as lr_type FROM " . TOPICS_TABLE . " t LEFT JOIN " . LASTREAD_TABLE . " lr ON ( lr.user_id = " . $userdata['user_id'] . " AND t.topic_id=lr.topic_id) $events_join ," . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2 WHERE t.forum_id = $forum_id $report_sql AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id $limit_topics_time $order_by LIMIT $start, ".$board_config['topics_per_page']; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain topic information', '', __LINE__, __FILE__, $sql); } $total_topics = 0; while( $row = $db->sql_fetchrow($result) ) { $topic_rowset[] = $row; $total_topics++; } $db->sql_freeresult($result); /* Not needed on Bokt.nl // // Total topics ... // $total_topics += $total_announcements; */ // // Define censored word matches // $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); // // Post URL generation for templating vars // $template->assign_vars(array( 'L_DISPLAY_TOPICS' => $lang['Display_topics'], 'U_POST_NEW_TOPIC' => append_sid("posting.$phpEx?mode=newtopic&" . POST_FORUM_URL . "=$forum_id"), 'S_SELECT_TOPIC_DAYS' => $select_topic_days, 'S_POST_DAYS_ACTION' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=" . $forum_id . "&start=$start")) ); // // User authorisation levels output // $s_auth_can = ( ( $is_auth['auth_post'] ) ? $lang['Rules_post_can'] : $lang['Rules_post_cannot'] ) . ''; $s_auth_can .= ( ( $is_auth['auth_reply'] ) ? $lang['Rules_reply_can'] : $lang['Rules_reply_cannot'] ) . ''; $s_auth_can .= ( ( $is_auth['auth_edit'] ) ? $lang['Rules_edit_can'] : $lang['Rules_edit_cannot'] ) . ''; $s_auth_can .= ( ( $is_auth['auth_delete'] ) ? $lang['Rules_delete_can'] : $lang['Rules_delete_cannot'] ) . ''; $s_auth_can .= ( ( $is_auth['auth_vote'] ) ? $lang['Rules_vote_can'] : $lang['Rules_vote_cannot'] ) . ''; if ( $is_auth['auth_mod'] ) { $s_auth_can .= sprintf($lang['Rules_moderate'], ' append_sid('index.'.$phpEx), 'title' => sprintf($lang['Forum_Index'], $board_config['sitename']) ); */ // // Dump out the page header and load viewforum template // $page_title = $forum_row['forum_name']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); $template->set_filenames(array( 'body' => 'viewforum_body.tpl') ); make_jumpbox('viewforum.'.$phpEx); $template->assign_vars(array( 'FORUM_ID' => $forum_id, 'FORUM_NAME' => $forum_row['forum_name'], 'MODERATORS' => $forum_moderators, 'POST_IMG' => ( $forum_row['forum_status'] == FORUM_LOCKED ) ? $images['post_locked'] : $images['post_new'], 'FOLDER_IMG' => $images['folder'], // using 'hot' for 'post' icons. 'FOLDER_NEW_IMG' => $images['folder_new'], 'FOLDER_HOT_IMG' => $images['folder_post'], 'FOLDER_HOT_NEW_IMG' => $images['folder_new_post'], 'FOLDER_LOCKED_IMG' => $images['folder_locked'], 'FOLDER_LOCKED_NEW_IMG' => $images['folder_locked_new'], 'FOLDER_STICKY_IMG' => $images['folder_sticky'], 'FOLDER_STICKY_NEW_IMG' => $images['folder_sticky_new'], 'FOLDER_ANNOUNCE_IMG' => $images['folder_announce'], 'FOLDER_ANNOUNCE_NEW_IMG' => $images['folder_announce_new'], 'L_TOPICS' => $lang['Topics'], 'L_REPLIES' => $lang['Replies'], 'L_VIEWS' => $lang['Views'], 'L_POSTS' => $lang['Posts'], 'L_LASTPOST' => $lang['Last_Post'], 'L_MODERATOR' => $l_moderators, 'L_MARK_TOPICS_READ' => $lang['Mark_all_topics'], 'L_POST_NEW_TOPIC' => ( $forum_row['forum_status'] == FORUM_LOCKED ) ? $lang['Forum_locked'] : $lang['Post_new_topic'], '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'], // using 'hot' for 'post' icons. //'L_NO_NEW_POSTS_HOT' => $lang['No_new_posts_hot'], //'L_NEW_POSTS_HOT' => $lang['New_posts_hot'], 'L_NO_NEW_POSTS_HOT' => $lang['No_new_posts_post'], 'L_NEW_POSTS_HOT' => $lang['New_posts_post'], 'L_ANNOUNCEMENT' => $lang['Post_Announcement'], 'L_STICKY' => $lang['Post_Sticky'], 'L_POSTED' => $lang['Posted'], 'L_JOINED' => $lang['Joined'], 'L_AUTHOR' => $lang['Author'], 'S_AUTH_LIST' => $s_auth_can, 'U_VIEW_FORUM' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL ."=$forum_id"), 'U_MARK_READ' => append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&mark=topics")) ); // // End header // $gezocht_forums = array(65,55,66); // // Okay, lets dump out the page ... // if( $total_topics ) { 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']; if($forum_id == REPORT_FORUM_ID && ($topic_rowset[$i]['user_level2'] != MOD && $topic_rowset[$i]['user_level2'] != ADMIN ) && $topic_rowset[$i]['topic_status'] != TOPIC_LOCKED && ($userdata['user_level'] == MOD || $userdata['user_level'] == ADMIN) ) { $topic_title = '' . $topic_title . ''; } if($forum_row['cat_id'] == 5 && $topic_rowset[$i]['topic_ad'] == TOPIC_AD_CLOSED) { $topic_prefix = '[Verkocht]'; if(in_array($forum_id, $gezocht_forums)) { $topic_prefix = '[Gevonden]'; } $topic_title = '' . $topic_prefix . ' ' . $topic_title . ''; } $topic_event = $topic_rowset[$i]['cal_date'] ? $topic_event = "(" . $topic_rowset[$i]['cal_date'] . ($topic_rowset[$i]['cal_repeat'] > 1 ? ", " . $topic_rowset[$i]['cal_repeat']. ' dagen' : '') . "" . ")" : ''; $replies = $topic_rowset[$i]['topic_replies']; $topic_type = $topic_rowset[$i]['topic_type']; if( $topic_type == POST_ANNOUNCE ) { $topic_type = $lang['Topic_Announcement'] . ' '; } else if( $topic_type == POST_STICKY ) { $topic_type = $lang['Topic_Sticky'] . ' '; } else { $topic_type = ''; } if( $topic_rowset[$i]['topic_vote'] ) { //$topic_type .= $lang['Topic_Poll'] . ' '; } if( $topic_rowset[$i]['topic_status'] == TOPIC_MOVED ) { $topic_type = $lang['Topic_Moved'] . ' '; $topic_id = $topic_rowset[$i]['topic_moved_id']; $folder_image = $images['folder']; $folder_alt = $lang['Topics_Moved']; $newest_post_img = ''; } else { if( $topic_rowset[$i]['topic_type'] == POST_ANNOUNCE ) { $folder = $images['folder_announce']; $folder_new = $images['folder_announce_new']; } else if( $topic_rowset[$i]['topic_type'] == POST_STICKY ) { $folder = $images['folder_sticky']; $folder_new = $images['folder_sticky_new']; } else if( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) { $folder = $images['folder_locked']; $folder_new = $images['folder_locked_new']; } else if( $topic_rowset[$i]['lr_type'] == 1 ) { $folder = $images['folder_post']; $folder_new = $images['folder_new_post']; } else { /* if($replies >= $board_config['hot_threshold']) { $folder = $images['folder_hot']; $folder_new = $images['folder_hot_new']; } else { */ $folder = $images['folder']; $folder_new = $images['folder_new']; // } } $newest_post_img = ''; if( $userdata['session_logged_in'] ) { // Last Modified mod if($topic_rowset[$i]['lasttime'] > $last_modified) { $last_modified = $topic_rowset[$i]['lasttime']; } if( $topic_rowset[$i]['post_time'] <= $topic_rowset[$i]['lasttime'] || $topic_rowset[$i]['post_time'] < (time()-$board_config['lastread']) || $topic_rowset[$i]['post_time'] < $forum_row['lasttime']) { // Old topic $folder_image = $folder; $folder_alt = ( $topic_rowset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } else { // New topic $topic_new = 1; $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&view=newest"); //$newest_post_img = ' $userdata['user_lastvisit'] ) { $unread_topics = true; if( $unread_topics ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = '= $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 = ' $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 .= ' 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 = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id"); $poster = $topic_rowset[$i]['username']; $topic_author = ( $topic_rowset[$i]['user_id'] != ANONYMOUS ) ? ' $last_modified) { $last_modified = $topic_rowset[$i]['post_time']; } $last_post_time = create_date($board_config['default_dateformat'], $topic_rowset[$i]['post_time'], $board_config['board_timezone']); $poster = $topic_rowset[$i]['user2']; $last_post_author = ( $topic_rowset[$i]['id2'] == ANONYMOUS ) ? ( ($topic_rowset[$i]['post_username2'] != '' ) ? $topic_rowset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : 'assign_block_vars('topicrow', array( 'ROW_COLOR' => $row_color, 'ROW_CLASS' => $row_class, 'FORUM_ID' => $forum_id, 'TOPIC_ID' => $topic_id, 'TOPIC_FOLDER_IMG' => $folder_image, 'TOPIC_FOLDER_NR' => $topic_nr, 'TOPIC_AUTHOR' => $topic_author, 'GOTO_PAGE' => $goto_page, 'REPLIES' => $replies, 'NEWEST_POST_IMG' => ($newest_post_img == '') ? append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $topic_rowset[$i]['topic_last_post_id']) . '#' . $topic_rowset[$i]['topic_last_post_id'] : $newest_post_img, 'TOPIC_TITLE' => $topic_title, 'TOPIC_EVENT' => $topic_event, 'TOPIC_TYPE' => $topic_type, '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, 'L_TOPIC_FOLDER_ALT' => $folder_alt, 'U_VIEW_TOPIC' => $view_topic_url) ); } $template->assign_vars(array( 'PAGINATION' => generate_pagination("viewforum.$phpEx?" . POST_FORUM_URL . "=$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'] )), 'L_GOTO_PAGE' => $lang['Goto_page']) ); } else { // // No topics // $no_topics_msg = ( $forum_row['forum_status'] == FORUM_LOCKED ) ? $lang['Forum_locked'] : $lang['No_topics_post_one']; $template->assign_vars(array( 'L_NO_TOPICS' => $no_topics_msg) ); $template->assign_block_vars('switch_no_topics', array() ); } last_modified($last_modified); // // Parse the page and print // $template->pparse('body'); // // Page footer // include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?>
Help?
