= u.user_lastvisit ORDER BY p.post_time ASC LIMIT 1"; $result = $db->sql_query($sql); if ( !($row = $db->sql_fetchrow($result)) ) { message_die(MESSAGE, 'No_new_posts_last_visit'); } $post_id = $row['post_id']; redirect("viewtopic.$phpEx$SID&p=$post_id#$post_id"); } } redirect("index.$phpEx$SID"); } else if ( $_GET['view'] == 'next' || $_GET['view'] == 'previous' ) { $sql_condition = ( $_GET['view'] == 'next' ) ? '>' : '<'; $sql_ordering = ( $_GET['view'] == 'next' ) ? 'ASC' : 'DESC'; $sql = "SELECT t.topic_id FROM " . TOPICS_TABLE . " t, " . TOPICS_TABLE . " t2 WHERE t2.topic_id = $topic_id AND t.forum_id = t2.forum_id AND t.topic_last_post_time $sql_condition t2.topic_last_post_time ORDER BY t.topic_last_post_time $sql_ordering LIMIT 1"; $result = $db->sql_query($sql); if ( !($row = $db->sql_fetchrow($result)) ) { $message = ( $_GET['view'] == 'next' ) ? 'No_newer_topics' : 'No_older_topics'; message_die(MESSAGE, $message); } else { $topic_id = $row['topic_id']; } } } // Start session management $user->start(); // End session management if ( $user->data['user_id'] && isset($_POST['rating']) ) { $sql = "SELECT rating FROM " . TOPICS_RATINGS_TABLE . " WHERE topic_id = $topic_id AND user_id = " . $user->data['user_id']; $result = $db->sql_query($sql); $rating = ( $row = $db->sql_fetchrow($result) ) ? $row['rating'] : ''; if ( empty($_POST['rating_value']) && $rating != '' ) { } else { $new_rating = intval($_POST['rating']); $sql = ( $rating != '' ) ? "UPDATE " . TOPICS_RATING_TABLE . " SET rating = $new_rating WHERE user_id = " . $user->data['user_id'] . " AND topic_id = $topic_id" : "INSERT INTO " . TOPICS_RATING_TABLE . " (topic_id, user_id, rating) VALUES ($topic_id, " . $user->data['user_id'] . ", $new_rating)"; } } // // This rather complex gaggle of code handles querying for topics but // also allows for direct linking to a post (and the calculation of which // page the post is on and the correct display of viewtopic) // $join_sql_table = ( !$post_id ) ? '' : ', ' . POSTS_TABLE . ' p, ' . POSTS_TABLE . ' p2 '; $join_sql = ( !$post_id ) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND p.post_approved = " . TRUE . " AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_approved = " . TRUE . " AND p2.post_id <= $post_id"; $count_sql = ( !$post_id ) ? '' : ", COUNT(p2.post_id) AS prev_posts"; $order_sql = ( !$post_id ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, f.forum_name, f.forum_status, f.forum_id, f.forum_style ORDER BY p.post_id ASC"; $sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, f.forum_name, f.forum_status, f.forum_id, f.forum_style" . $count_sql . " FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f" . $join_sql_table . " WHERE $join_sql AND f.forum_id = t.forum_id $order_sql"; $result = $db->sql_query($sql); if ( !(extract($db->sql_fetchrow($result))) ) { message_die(MESSAGE, 'Topic_post_not_exist'); } // Configure style, language, etc. $user->setup(false, $forum_style); $auth->acl($user->data, $forum_id); // End configure // // Start auth check // if ( !$auth->acl_get('f_read', $forum_id) ) { if ( $user->data['user_id'] ) { $redirect = ( isset($post_id) ) ? "p=$post_id" : "t=$topic_id"; $redirect .= ( isset($start) ) ? "&start=$start" : ''; redirect('login.' . $phpEx . $SID . '&redirect=viewtopic.' . $phpEx . '&' . $redirect); } message_die(MESSAGE, $user->lang['Sorry_auth_read']); } // // End auth check // if ( !empty($post_id) ) { $start = floor(($prev_posts - 1) / $board_config['posts_per_page']) * $board_config['posts_per_page']; } $s_watching_topic = ''; $s_watching_topic_img = ''; watch_topic_forum('topic', $s_watching_topic, $s_watching_topic_img, $user->data['user_id'], $topic_id); // // Post ordering options // $previous_days = array(0 => $user->lang['All_Posts'], 1 => $user->lang['1_Day'], 7 => $user->lang['7_Days'], 14 => $user->lang['2_Weeks'], 30 => $user->lang['1_Month'], 90 => $user->lang['3_Months'], 180 => $user->lang['6_Months'], 364 => $user->lang['1_Year']); $sort_by_text = array('a' => $user->lang['Author'], 't' => $user->lang['Post_time'], 's' => $user->lang['Subject']); $sort_by = array('a' => 'u.username', 't' => 'p.post_id', 's' => 'pt.post_subject'); if ( isset($_POST['sort']) ) { if ( !empty($_POST['sort_days']) ) { $sort_days = ( !empty($_POST['sort_days']) ) ? intval($_POST['sort_days']) : intval($_GET['sort_days']); $min_post_time = time() - ( $sort_days * 86400 ); $sql = "SELECT COUNT(post_id) AS num_posts FROM " . POSTS_TABLE . " WHERE topic_id = $topic_id AND post_time >= $min_post_time AND post_approved = " . TRUE; $result = $db->sql_query($sql); $start = 0; $topic_replies = ( $row = $db->sql_fetchrow($result) ) ? $row['num_posts'] : 0; $limit_posts_time = "AND p.post_time >= $min_post_time "; } else { $topic_replies++; } $sort_key = ( isset($_POST['sort_key']) ) ? $_POST['sort_key'] : $_GET['sort_key']; $sort_dir = ( isset($_POST['sort_dir']) ) ? $_POST['sort_dir'] : $_GET['sort_dir']; } else { $topic_replies++; $limit_posts_time = ''; $sort_days = 0; $sort_key = 't'; $sort_dir = 'a'; } $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' ) ? '' . $user->lang['Ascending'] . '' . $user->lang['Descending'] . '' : '' . $user->lang['Ascending'] . '' . $user->lang['Descending'] . ''; $select_sort_dir .= ''; $select_post_days = ''; for($i = 0; $i < count($previous_days); $i++) { $selected = ($post_days == $previous_days[$i]) ? ' selected="selected"' : ''; $select_post_days .= '' . $previous_days_text[$i] . ''; } $select_post_days .= ''; $sql = "SELECT * FROM " . RANKS_TABLE; $result = $db->sql_query($sql); $ranksrow = array(); while ( $row = $db->sql_fetchrow($result) ) { $ranksrow[] = $row; } $db->sql_freeresult($result); $rating = ''; if ( $user->data['user_id'] ) { $rating_text = array(-5 => $user->lang['Very_poor'], -2 => $user->lang['Quite_poor'], 0 => $user->lang['Unrated'], 2 => $user->lang['Quite_good'], 5 => $user->lang['Very_good']); $sql = "SELECT rating FROM " . TOPICS_RATINGS_TABLE . " WHERE topic_id = $topic_id AND user_id = " . $user->data['user_id']; $result = $db->sql_query($sql); $user_rating = ( $row = $db->sql_fetchrow($result) ) ? $row['rating'] : 0; for($i = -5; $i < 6; $i++) { $selected = ( $user_rating == $i ) ? ' selected="selected"' : ''; $rating .= '' . $i . ( ( !empty($rating_text[$i]) ) ? ' > ' . $rating_text[$i] : '' ) . ''; } $rating = '' . $rating . ''; } // // Was a highlight request part of the URI? Yes, this idea was // taken from vB but we did already have a highlighter in place // in search itself ... it's just been extended a bit! // if ( isset($_GET['highlight']) ) { $highlight_match = array(); // // Split words and phrases // $words = explode(' ', trim(urldecode($_GET['highlight']))); for($i = 0; $i < count($words); $i++) { if ( trim($words[$i]) != '' ) { $highlight_match[] = '#\b(' . str_replace('*', '([\w]+)?', $words[$i]) . ')\b#is'; } } $highlight_active = ( count($highlight_match) ) ? true : false; } else { $highlight_active = false; } // // Define censored word matches // $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); // // User authorisation levels output // $s_forum_rules = ''; get_forum_rules('topic', $s_forum_rules, $forum_id); $topic_mod = ''; $topic_mod .= ( $auth->acl_get('m_lock', $forum_id) ) ? ( ( $topic_status == TOPIC_UNLOCKED ) ? '' . $user->lang['Lock_topic'] . '' : '' . $user->lang['Unlock_topic'] . '' ) : ''; $topic_mod .= ( $auth->acl_get('m_delete', $forum_id) ) ? '' . $user->lang['Delete_topic'] . '' : ''; $topic_mod .= ( $auth->acl_get('m_move', $forum_id) ) ? '' . $user->lang['Move_topic'] . '' : ''; $topic_mod .= ( $auth->acl_get('m_split', $forum_id) ) ? '' . $user->lang['Split_topic'] . '' : ''; $topic_mod .= ( $auth->acl_get('m_merge', $forum_id) ) ? '' . $user->lang['Merge_topic'] . '' : ''; // // If we've got a hightlight set pass it on to pagination. // $pagination = ( $highlight_active ) ? generate_pagination("viewtopic.$phpEx$SID&t=$topic_id&postdays=$post_days&postorder=$post_order&highlight=" . $_GET['highlight'], $topic_replies, $board_config['posts_per_page'], $start) : generate_pagination("viewtopic.$phpEx$SID&t=$topic_id&postdays=$post_days&postorder=$post_order", $topic_replies, $board_config['posts_per_page'], $start); // // Post, reply and other URL generation for // templating vars // $new_topic_url = 'posting.' . $phpEx . $SID . '&mode=post&f=' . $forum_id; $reply_topic_url = 'posting.' . $phpEx . $SID . '&mode=reply&f=' . $forum_id . '&t=' . $topic_id; $view_forum_url = 'viewforum.' . $phpEx . $SID . '&f=' . $forum_id; $view_prev_topic_url = 'viewtopic.' . $phpEx . $SID . '&f=' . $forum_id . '&t=' . $topic_id . '&view=previous'; $view_next_topic_url = 'viewtopic.' . $phpEx . $SID . '&f=' . $forum_id . '&t=' . $topic_id . '&view=next'; $reply_img = ( $forum_status == FORUM_LOCKED || $topic_status == TOPIC_LOCKED ) ? $user->img('reply_locked', $user->lang['Topic_locked']) : $user->img('reply_new', $user->lang['Reply_to_topic']); $post_img = ( $forum_status == FORUM_LOCKED ) ? $user->img('post_locked', $user->lang['Forum_locked']) : $user->img('post_new', $user->lang['Post_new_topic']); // // Set a cookie for this topic // if ($user->data['user_id'] != ANONYMOUS) { $mark_topics = ( isset($_COOKIE[$board_config['cookie_name'] . '_t']) ) ? unserialize(stripslashes($_COOKIE[$board_config['cookie_name'] . '_t'])) : array(); $mark_topics[$forum_id][$topic_id] = 0; setcookie($board_config['cookie_name'] . '_t', serialize($mark_topics), 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); } // // Load templates // $template->set_filenames(array( 'body' => 'viewtopic_body.html') ); make_jumpbox('viewforum.'.$phpEx, $forum_id); // Output page header $page_title = $user->lang['View_topic'] .' - ' . $topic_title; include($phpbb_root_path . 'includes/page_header.'.$phpEx); if ( count($orig_word) ) { $topic_title = preg_replace($orig_word, $replacement_word, $topic_title); // Censor topic title } // Send vars to template $template->assign_vars(array( 'FORUM_ID' => $forum_id, 'FORUM_NAME' => $forum_name, 'TOPIC_ID' => $topic_id, 'TOPIC_TITLE' => $topic_title, 'PAGINATION' => $pagination, 'PAGE_NUMBER' => sprintf($user->lang['Page_of'], ( floor( $start / $board_config['posts_per_page'] ) + 1 ), ceil( $topic_replies / $board_config['posts_per_page'] )), 'MOD_CP' => ( $auth->acl_get('a_') || $auth->acl_get('m_', $forum_id) ) ? sprintf($user->lang['MCP'], '', '') : '', 'POST_IMG' => $post_img, 'REPLY_IMG' => $reply_img, 'L_AUTHOR' => $user->lang['Author'], 'L_MESSAGE' => $user->lang['Message'], 'L_POSTED' => $user->lang['Posted'], 'L_POST_SUBJECT' => $user->lang['Post_subject'], 'L_VIEW_NEXT_TOPIC' => $user->lang['View_next_topic'], 'L_VIEW_PREVIOUS_TOPIC' => $user->lang['View_previous_topic'], 'L_BACK_TO_TOP' => $user->lang['Back_to_top'], 'L_DISPLAY_POSTS' => $user->lang['Display_posts'], 'L_LOCK_TOPIC' => $user->lang['Lock_topic'], 'L_UNLOCK_TOPIC' => $user->lang['Unlock_topic'], 'L_MOVE_TOPIC' => $user->lang['Move_topic'], 'L_SPLIT_TOPIC' => $user->lang['Split_topic'], 'L_DELETE_TOPIC' => $user->lang['Delete_topic'], 'L_GOTO_PAGE' => $user->lang['Goto_page'], 'L_SORT_BY' => $user->lang['Sort_by'], 'L_RATE_TOPIC' => $user->lang['Rate_topic'], 'L_QUICK_MOD' => $user->lang['Quick_mod'], 'S_TOPIC_LINK' => 't', 'S_SELECT_SORT_DIR' => $select_sort_dir, 'S_SELECT_SORT_KEY' => $select_sort, 'S_SELECT_SORT_DAYS' => $select_sort_days, 'S_SELECT_RATING' => $rating, 'S_TOPIC_ACTION' => "viewtopic.$phpEx$SID&t=" . $topic_id . "&start=$start", 'S_AUTH_LIST' => $s_forum_rules, 'S_TOPIC_MOD' => ( $topic_mod != '' ) ? '' . $topic_mod . '' : '', 'S_MOD_ACTION' => "modcp.$phpEx$SID", 'S_WATCH_TOPIC' => $s_watching_topic, 'U_VIEW_TOPIC' => "viewtopic.$phpEx$SID&t=$topic_id&start=$start&postdays=$post_days&postorder=$post_order&highlight=" . $_GET['highlight'], 'U_VIEW_FORUM' => $view_forum_url, 'U_VIEW_OLDER_TOPIC' => $view_prev_topic_url, 'U_VIEW_NEWER_TOPIC' => $view_next_topic_url, 'U_POST_NEW_TOPIC' => $new_topic_url, 'U_POST_REPLY_TOPIC' => $reply_topic_url) ); // // Mozilla navigation bar // $nav_links['prev'] = array( 'url' => $view_prev_topic_url, 'title' => $user->lang['View_previous_topic'] ); $nav_links['next'] = array( 'url' => $view_next_topic_url, 'title' => $user->lang['View_next_topic'] ); $nav_links['up'] = array( 'url' => $view_forum_url, 'title' => $forum_name ); // // Does this topic contain a poll? // if ( !empty($poll_start) ) { $sql = "SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result FROM " . VOTE_DESC_TABLE . " vd, " . VOTE_RESULTS_TABLE . " vr WHERE vd.topic_id = $topic_id AND vr.vote_id = vd.vote_id ORDER BY vr.vote_option_id ASC"; $result = $db->sql_query($sql); if ( $vote_info = $db->sql_fetchrowset($result) ) { $db->sql_freeresult($result); $vote_options = count($vote_info); $vote_id = $vote_info[0]['vote_id']; $vote_title = $vote_info[0]['vote_text']; $sql = "SELECT vote_id FROM " . VOTE_USERS_TABLE . " WHERE vote_id = $vote_id AND vote_user_id = " . $user->data['user_id']; $result = $db->sql_query($sql); $user_voted = ( $row = $db->sql_fetchrow($result) ) ? TRUE : 0; $db->sql_freeresult($result); if ( isset($_GET['vote']) || isset($_POST['vote']) ) { $view_result = ( ( ( isset($_GET['vote']) ) ? $_GET['vote'] : $_POST['vote'] ) == 'viewresult' ) ? TRUE : 0; } else { $view_result = 0; } $poll_expired = ( $vote_info[0]['vote_length'] ) ? ( ( $vote_info[0]['vote_start'] + $vote_info[0]['vote_length'] < time() ) ? TRUE : 0 ) : 0; if ( $user_voted || $view_result || $poll_expired || !$auth->acl_get('f_vote', $forum_id) || $topic_status == TOPIC_LOCKED ) { $vote_results_sum = 0; for($i = 0; $i < $vote_options; $i++) { $vote_results_sum += $vote_info[$i]['vote_result']; } for($i = 0; $i < $vote_options; $i++) { $vote_percent = ( $vote_results_sum > 0 ) ? $vote_info[$i]['vote_result'] / $vote_results_sum : 0; $poll_length = round($vote_percent * $board_config['vote_graphic_length']); $vote_percent = sprintf("%.1d%%", ($vote_percent * 100)); $vote_graphic_img = $user->img($theme['voting_graphic'] . ' width="' . $poll_length . '"', $vote_percent); if ( count($orig_word) ) { $vote_info[$i]['vote_option_text'] = preg_replace($orig_word, $replacement_word, $vote_info[$i]['vote_option_text']); } $template->assign_block_vars('poll_option', array( 'POLL_OPTION_CAPTION' => $vote_info[$i]['vote_option_text'], 'POLL_OPTION_RESULT' => $vote_info[$i]['vote_result'], 'POLL_OPTION_PERCENT' => $vote_percent, 'POLL_OPTION_IMG' => $vote_graphic_img) ); } $template->assign_vars(array( 'S_HAS_POLL_DISPLAY' => true, 'L_TOTAL_VOTES' => $user->lang['Total_votes'], 'TOTAL_VOTES' => $vote_results_sum) ); } else { for($i = 0; $i < $vote_options; $i++) { if ( count($orig_word) ) { $vote_info[$i]['vote_option_text'] = preg_replace($orig_word, $replacement_word, $vote_info[$i]['vote_option_text']); } $template->assign_block_vars('poll_option', array( 'POLL_OPTION_ID' => $vote_info[$i]['vote_option_id'], 'POLL_OPTION_CAPTION' => $vote_info[$i]['vote_option_text']) ); } $template->assign_vars(array( 'S_HAS_POLL_OPTIONS' => true, 'L_SUBMIT_VOTE' => $user->lang['Submit_vote'], 'L_VIEW_RESULTS' => $user->lang['View_results'], 'U_VIEW_RESULTS' => "viewtopic.$phpEx$SID&t=$topic_id&postdays=$post_days&postorder=$post_order&vote=viewresult") ); $s_hidden_fields = ''; } if ( count($orig_word) ) { $vote_title = preg_replace($orig_word, $replacement_word, $vote_title); } $template->assign_vars(array( 'POLL_QUESTION' => $vote_title, 'S_HIDDEN_FIELDS' => ( !empty($s_hidden_fields) ) ? $s_hidden_fields : '', 'S_POLL_ACTION' => "posting.$phpEx$SID&t=$topic_id") ); } } // // Container for user details, only process once // $poster_details = array(); // // Go ahead and pull all data for this topic // // FROM phpbb_posts2 p, " . USERS_TABLE . " u // AND pt.post_id = p.post_id // pt.post_text, pt.post_subject, pt.bbcode_uid $sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u, " . POSTS_TEXT_TABLE . " pt WHERE p.topic_id = $topic_id AND p.post_approved = " . TRUE . " AND pt.post_id = p.post_id $limit_posts_time AND u.user_id = p.poster_id ORDER BY $sort_order LIMIT $start, " . $board_config['posts_per_page']; $result = $db->sql_query($sql); if ( $row = $db->sql_fetchrow($result) ) { do { $poster_id = $row['user_id']; $poster = ( !$poster_id ) ? $user->lang['Guest'] : $row['username']; $poster_posts = ( $row['user_id'] ) ? $user->lang['Posts'] . ': ' . $row['user_posts'] : ''; $poster_from = ( $row['user_from'] && $row['user_id'] ) ? $user->lang['Location'] . ': ' . $row['user_from'] : ''; if ( !isset($poster_details[$poster_id]['joined']) ) { $poster_details[$poster_id]['joined'] = ( $row['user_id'] ) ? $user->lang['Joined'] . ': ' . $user->format_date($row['user_regdate'], $user->lang['DATE_FORMAT']) : ''; } if ( !isset($poster_details[$poster_id]['avatar']) ) { if ( $row['user_avatar_type'] && $poster_id && $row['user_allowavatar'] ) { switch( $row['user_avatar_type'] ) { case USER_AVATAR_UPLOAD: $poster_details[$poster_id]['avatar'] = ( $board_config['allow_avatar_upload'] ) ? '' : ''; break; case USER_AVATAR_REMOTE: $poster_details[$poster_id]['avatar'] = ( $board_config['allow_avatar_remote'] ) ? '' : ''; break; case USER_AVATAR_GALLERY: $poster_details[$poster_id]['avatar'] = ( $board_config['allow_avatar_local'] ) ? '' : ''; break; } } else { $poster_details[$poster_id]['avatar'] = ''; } } // // Generate ranks, set them to empty string initially. // if ( !isset($poster_details[$poster_id]['rank_title']) ) { if ( $row['user_rank'] ) { for($j = 0; $j < count($ranksrow); $j++) { if ( $row['user_rank'] == $ranksrow[$j]['rank_id'] && $ranksrow[$j]['rank_special'] ) { $poster_details[$poster_id]['rank_title'] = $ranksrow[$j]['rank_title']; $poster_details[$poster_id]['rank_image'] = ( $ranksrow[$j]['rank_image'] ) ? '
' : ''; } } } else { for($j = 0; $j < count($ranksrow); $j++) { if ( $row['user_posts'] >= $ranksrow[$j]['rank_min'] && !$ranksrow[$j]['rank_special'] ) { $poster_details[$poster_id]['rank_title'] = $ranksrow[$j]['rank_title']; $poster_details[$poster_id]['rank_image'] = ( $ranksrow[$j]['rank_image'] ) ? '
' : ''; } } } } // // Handle anon users posting with usernames // if ( !$poster_id && $row['post_username'] != '' ) { $poster = $row['post_username']; $poster_rank = $user->lang['Guest']; } if ( !isset($poster_details[$poster_id]['profile']) && $poster_id ) { $temp_url = "profile.$phpEx$SID&mode=viewprofile&u=$poster_id"; $poster_details[$poster_id]['profile_img'] = '' . $user->img('icon_profile', $user->lang['Read_profile']) . ''; $poster_details[$poster_id]['profile'] = '' . $user->lang['Read_profile'] . ''; $temp_url = "privmsg.$phpEx$SID&mode=post&u=$poster_id"; $poster_details[$poster_id]['pm_img'] = '' . $user->img('icon_pm', $user->lang['Send_private_message']) . ''; $poster_details[$poster_id]['pm'] = '' . $user->lang['Send_private_message'] . ''; if ( !empty($row['user_viewemail']) || $auth->acl_get('m_', $forum_id) ) { $email_uri = ( $board_config['board_email_form'] ) ? "profile.$phpEx$SID&mode=email&u=" . $poster_id : 'mailto:' . $row['user_email']; $poster_details[$poster_id]['email_img'] = '' . $user->img('icon_email', $user->lang['Send_email']) . ''; $poster_details[$poster_id]['email'] = '' . $user->lang['Send_email'] . ''; } else { $poster_details[$poster_id]['email_img'] = ''; $poster_details[$poster_id]['email'] = ''; } $poster_details[$poster_id]['www_img'] = ( $row['user_website'] ) ? '' . $user->img('icon_www', $user->lang['Visit_website']) . '' : ''; $poster_details[$poster_id]['www'] = ( $row['user_website'] ) ? '' . $user->lang['Visit_website'] . '' : ''; if ( !empty($row['user_icq']) ) { $poster_details[$poster_id]['icq_status_img'] = ''; $poster_details[$poster_id]['icq_img'] = '' . $user->img('icon_icq', $user->lang['ICQ']) . ''; $poster_details[$poster_id]['icq'] = '' . $user->lang['ICQ'] . ''; } else { $poster_details[$poster_id]['icq_status_img'] = ''; $poster_details[$poster_id]['icq_img'] = ''; $poster_details[$poster_id]['icq'] = ''; } $poster_details[$poster_id]['aim_img'] = ( $row['user_aim'] ) ? '' . $user->img('icon_aim', $user->lang['AIM']) . '' : ''; $poster_details[$poster_id]['aim'] = ( $row['user_aim'] ) ? '' . $user->lang['AIM'] . '' : ''; $temp_url = "profile.$phpEx$SID&mode=viewprofile&u=$poster_id"; $poster_details[$poster_id]['msn_img'] = ( $row['user_msnm'] ) ? '' . $user->img('icon_msnm', $user->lang['MSNM']) . '' : ''; $poster_details[$poster_id]['msn'] = ( $row['user_msnm'] ) ? '' . $user->lang['MSNM'] . '' : ''; $poster_details[$poster_id]['yim_img'] = ( $row['user_yim'] ) ? '' . $user->img('icon_yim', $user->lang['YIM']) . '' : ''; $poster_details[$poster_id]['yim'] = ( $row['user_yim'] ) ? '' . $user->lang['YIM'] . '' : ''; if ( $auth->acl_get('f_search', $forum_id) ) { $temp_url = 'search.' . $phpEx . $SID . '&search_author=' . urlencode($row['username']) .'"&showresults=posts'; $search_img = '' . $user->img('icon_search', $user->lang['Search_user_posts']) . ''; $search ='' . $user->lang['Search_user_posts'] . ''; } else { $search_img = ''; $search = ''; } } else if ( !$poster_id ) { $poster_details[$poster_id]['profile_img'] = ''; $poster_details[$poster_id]['profile'] = ''; $poster_details[$poster_id]['pm_img'] = ''; $poster_details[$poster_id]['pm'] = ''; $poster_details[$poster_id]['email_img'] = ''; $poster_details[$poster_id]['email'] = ''; $poster_details[$poster_id]['www_img'] = ''; $poster_details[$poster_id]['www'] = ''; $poster_details[$poster_id]['icq_status_img'] = ''; $poster_details[$poster_id]['icq_img'] = ''; $poster_details[$poster_id]['icq'] = ''; $poster_details[$poster_id]['aim_img'] = ''; $poster_details[$poster_id]['aim'] = ''; $poster_details[$poster_id]['msn_img'] = ''; $poster_details[$poster_id]['msn'] = ''; $poster_details[$poster_id]['search_img'] = ''; $poster_details[$poster_id]['search'] = ''; } // // Non-user specific images/text // $temp_url = 'posting.' . $phpEx . $SID . '&mode=quote&p=' . $row['post_id']; $quote_img = '' . $user->img('icon_quote', $user->lang['Reply_with_quote']) . ''; $quote = '' . $user->lang['Reply_with_quote'] . ''; if ( ( $user->data['user_id'] == $poster_id && $auth->acl_get('f_edit', $forum_id) ) || $auth->acl_get('m_edit', $forum_id) || $auth->acl_get('a_') ) { $temp_url = "posting.$phpEx$SID&mode=edit&p=" . $row['post_id']; $edit_img = '' . $user->img('icon_edit', $user->lang['Edit_delete_post']) . ''; $edit = '' . $user->lang['Edit_delete_post'] . ''; } else { $edit_img = ''; $edit = ''; } if ( $auth->acl_get('m_ip', $forum_id) ) { $temp_url = "modcp.$phpEx$SID&mode=ip&p=" . $row['post_id'] . "&t=" . $topic_id; $ip_img = '' . $user->img('icon_ip', $user->lang['View_IP']) . ''; $ip = '' . $user->lang['View_IP'] . ''; } else { $ip_img = ''; $ip = ''; } if ( ( $user->data['user_id'] == $poster_id && $auth->acl_get('f_delete', $forum_id) && $forum_topic_data['topic_last_post_id'] == $row['post_id'] ) || $auth->acl_get('m_delete', $forum_id) ) { $temp_url = "posting.$phpEx$SID&mode=delete&p=" . $row['post_id']; $delpost_img = '' . $user->img('icon_delete', $user->lang['Delete_post']) . ''; $delpost = '' . $user->lang['Delete_post'] . ''; } else { $delpost_img = ''; $delpost = ''; } // // Parse the message and subject // // Note! The order used for parsing the message _is_ important, moving things around could break // output // $post_subject = ( $row['post_subject'] != '' ) ? $row['post_subject'] : ''; $message = $row['post_text']; $bbcode_uid = $row['bbcode_uid']; // // If the board has HTML off but the post has HTML // on then we process it, else leave it alone // if ( !$auth->acl_get('f_html', $forum_id) ) { if ( $row['enable_html'] && $auth->acl_get('f_bbcode', $forum_id) ) { $message = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $message); } } // // Parse message and/or sig for BBCode if reqd // if ( $bbcode_uid != '' ) { // $message = ( $auth->acl_get('f_bbcode', $forum_id) ) ? bbencode_second_pass($message, $bbcode_uid, $auth->acl_get('f_img', $forum_id)) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message); } if ( $row['enable_magic_url'] ) { // $message = make_clickable($message); } // // Highlight active words (primarily for search) // if ( $highlight_active ) { if ( preg_match('/<.*>/', $message) ) { $message = preg_replace($highlight_match, '\1', $message); $end_html = 0; $start_html = 1; $temp_message = ''; $message = ' ' . $message . ' '; while( $start_html = strpos($message, '<', $start_html) ) { $grab_length = $start_html - $end_html - 1; $temp_message .= substr($message, $end_html + 1, $grab_length); if ( $end_html = strpos($message, '>', $start_html) ) { $length = $end_html - $start_html + 1; $hold_string = substr($message, $start_html, $length); if ( strrpos(' ' . $hold_string, '<') != 1 ) { $end_html = $start_html + 1; $end_counter = 1; while ( $end_counter && $end_html < strlen($message) ) { if ( substr($message, $end_html, 1) == '>' ) { $end_counter--; } else if ( substr($message, $end_html, 1) == '<' ) { $end_counter++; } $end_html++; } $length = $end_html - $start_html + 1; $hold_string = substr($message, $start_html, $length); $hold_string = str_replace('', '', $hold_string); $hold_string = str_replace('', '', $hold_string); } else if ( $hold_string == '' ) { $hold_string = str_replace('', '', $hold_string); } else if ( $hold_string == '' ) { $hold_string = str_replace('', '', $hold_string); } $temp_message .= $hold_string; $start_html += $length; } else { $start_html = strlen($message); } } $grab_length = strlen($message) - $end_html - 1; $temp_message .= substr($message, $end_html + 1, $grab_length); $message = trim($temp_message); } else { $message = preg_replace($highlight_match, '\1', $message); } } // // Replace naughty words // if ( count($orig_word) ) { $post_subject = preg_replace($orig_word, $replacement_word, $post_subject); $message = preg_replace($orig_word, $replacement_word, $message); } if ( $row['enable_smilies'] && $auth->acl_get('f_smilies', $forum_id) ) { // $message = smilies_pass($message); } $message = nl2br($message); // // Editing information // if ( $row['post_edit_count'] ) { $l_edit_time_total = ( $row['post_edit_count'] == 1 ) ? $user->lang['Edited_time_total'] : $user->lang['Edited_times_total']; $l_edited_by = '

' . sprintf($l_edit_time_total, $poster, $user->format_date($row['post_edit_time']), $row['post_edit_count']); } else { $l_edited_by = ''; } // // Signature // if ( !isset($poster_details[$poster_id]['sig']) ) { $user_sig = ( $row['enable_sig'] && $row['user_sig'] != '' && $board_config['allow_sig'] ) ? $row['user_sig'] : ''; $user_sig_bbcode_uid = $row['user_sig_bbcode_uid']; if ( $user_sig != '' && $user_sig_bbcode_uid != '' && $auth->acl_get('f_sigs', $forum_id) ) { if ( !$auth->acl_get('f_html', $forum_id) && $user->data['user_allowhtml'] ) { $user_sig = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $user_sig); } // $poster_details[$poster_id]['sig'] = bbencode_second_pass($user_sig, $user_sig_bbcode_uid, $auth->acl_get('f_img', $forum_id)); // $poster_details[$poster_id]['sig'] = make_clickable($poster_details[$poster_id]['sig']); if ( $row['user_allowsmile'] ) { // $poster_details[$poster_id]['sig'] = smilies_pass($poster_details[$poster_id]['sig']); } if ( count($orig_word) ) { $user_sig = preg_replace($orig_word, $replacement_word, $user_sig); } $poster_details[$poster_id]['sig'] = '
_________________
' . nl2br($poster_details[$poster_id]['sig']); } else { $poster_details[$poster_id]['sig'] = ''; } } // // Define the little post icon // $mini_post_img = ( $row['post_time'] > $user->data['user_lastvisit'] && $row['post_time'] > $topic_last_read ) ? $user->img('goto_post_new', $user->lang['New_post']) : $user->img('goto_post', $user->lang['Post']); // // Again this will be handled by the templating // code at some point // $template->assign_block_vars('postrow', array( 'POSTER_NAME' => $poster, 'POSTER_RANK' => $poster_details[$poster_id]['rank_title'], 'RANK_IMAGE' => $poster_details[$poster_id]['rank_image'], 'POSTER_JOINED' => $poster_details[$poster_id]['joined'], 'POSTER_POSTS' => $poster_posts, 'POSTER_FROM' => $poster_from, 'POSTER_AVATAR' => $poster_details[$poster_id]['avatar'], 'POST_DATE' => $user->format_date($row['post_time']), 'POST_SUBJECT' => $post_subject, 'MESSAGE' => $message, 'SIGNATURE' => $poster_details[$poster_id]['sig'], 'EDITED_MESSAGE'=> $l_edited_by, 'MINI_POST_IMG' => $mini_post_img, 'EDIT_IMG' => $edit_img, 'EDIT' => $edit, 'QUOTE_IMG' => $quote_img, 'QUOTE' => $quote, 'IP_IMG' => $ip_img, 'IP' => $ip, 'DELETE_IMG' => $delpost_img, 'DELETE' => $delpost, 'PROFILE_IMG' => $poster_details[$poster_id]['profile_img'], 'PROFILE' => $poster_details[$poster_id]['profile'], 'SEARCH_IMG' => $poster_details[$poster_id]['search_img'], 'SEARCH' => $poster_details[$poster_id]['search'], 'PM_IMG' => $poster_details[$poster_id]['pm_img'], 'PM' => $poster_details[$poster_id]['pm'], 'EMAIL_IMG' => $poster_details[$poster_id]['email_img'], 'EMAIL' => $poster_details[$poster_id]['email'], 'WWW_IMG' => $poster_details[$poster_id]['www_img'], 'WWW' => $poster_details[$poster_id]['www'], 'ICQ_STATUS_IMG'=> $poster_details[$poster_id]['icq_status_img'], 'ICQ_IMG' => $poster_details[$poster_id]['icq_img'], 'ICQ' => $poster_details[$poster_id]['icq'], 'AIM_IMG' => $poster_details[$poster_id]['aim_img'], 'AIM' => $poster_details[$poster_id]['aim'], 'MSN_IMG' => $poster_details[$poster_id]['msn_img'], 'MSN' => $poster_details[$poster_id]['msn'], 'YIM_IMG' => $poster_details[$poster_id]['yim_img'], 'YIM' => $poster_details[$poster_id]['yim'], 'L_MINI_POST_ALT' => $mini_post_alt, 'S_ROW_COUNT' => $i, 'U_MINI_POST' => $mini_post_url, 'U_POST_ID' => $row['post_id']) ); $i++; } while ( $row = $db->sql_fetchrow($result) ); } else { message_die(MESSAGE, $user->lang['No_posts_topic']); } // // Update the topic view counter // $sql = "UPDATE " . TOPICS_TABLE . " SET topic_views = topic_views + 1 WHERE topic_id = $topic_id"; $db->sql_query($sql); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?>