sql_query($sql)) { if ($row = $db->sql_fetchrow($result)) { if (intval($row['last_search_time']) > 0 && ($current_time - intval($row['last_search_time'])) < intval($board_config['search_flood_interval'])) { message_die(GENERAL_MESSAGE, $lang['Search_Flood_Error']); } } } if ( $search_id == 'newposts' || $search_id == 'egosearch' || ( $search_author != '' && $search_keywords == '' ) ) { if ( $search_id == 'newposts' ) { if ( $userdata['session_logged_in'] ) { $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE post_time >= " . $userdata['user_lastvisit']; } else { redirect(append_sid("login.$phpEx?redirect=search.$phpEx&search_id=newposts", true)); } $show_results = 'topics'; $sort_by = 0; $sort_dir = 'DESC'; } else if ( $search_id == 'egosearch' ) { if ( $userdata['session_logged_in'] ) { $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE poster_id = " . $userdata['user_id']; } else { redirect(append_sid("login.$phpEx?redirect=search.$phpEx&search_id=egosearch", true)); } $show_results = 'topics'; $sort_by = 0; $sort_dir = 'DESC'; } else { $search_author = str_replace('*', '%', trim($search_author)); if( ( strpos($search_author, '%') !== false ) && ( strlen(str_replace('%', '', $search_author)) < $board_config['search_min_chars'] ) ) { $search_author = ''; } $sql = "SELECT user_id FROM " . USERS_TABLE . " WHERE username LIKE '" . str_replace("\'", "''", $search_author) . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, "Couldn't obtain list of matching users (searching for: $search_author)", "", __LINE__, __FILE__, $sql); } $matching_userids = ''; if ( $row = $db->sql_fetchrow($result) ) { do { $matching_userids .= ( ( $matching_userids != '' ) ? ', ' : '' ) . $row['user_id']; } while( $row = $db->sql_fetchrow($result) ); } else { message_die(GENERAL_MESSAGE, $lang['No_search_match']); } $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE poster_id IN ($matching_userids)"; if ($search_time) { $sql .= " AND post_time >= " . $search_time; } } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql); } $search_ids = array(); while( $row = $db->sql_fetchrow($result) ) { $search_ids[] = $row['post_id']; } $db->sql_freeresult($result); $total_match_count = count($search_ids); } else if ( $search_keywords != '' ) { $stopword_array = @file($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/search_stopwords.txt'); $synonym_array = @file($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/search_synonyms.txt'); $split_search = array(); $stripped_keywords = stripslashes($search_keywords); $split_search = ( !strstr($multibyte_charset, $lang['ENCODING']) ) ? split_words(clean_words('search', $stripped_keywords, $stopword_array, $synonym_array), 'search') : split(' ', $search_keywords); unset($stripped_keywords); $search_msg_only = ( !$search_fields ) ? "AND m.title_match = 0" : ( ( strstr($multibyte_charset, $lang['ENCODING']) ) ? '' : '' ); $word_count = 0; $current_match_type = 'or'; $word_match = array(); $result_list = array(); for($i = 0; $i < count($split_search); $i++) { if ( strlen(str_replace(array('*', '%'), '', trim($split_search[$i]))) < $board_config['search_min_chars'] ) { $split_search[$i] = ''; continue; } switch ( $split_search[$i] ) { case 'and': $current_match_type = 'and'; break; case 'or': $current_match_type = 'or'; break; case 'not': $current_match_type = 'not'; break; default: if ( !empty($search_terms) ) { $current_match_type = 'and'; } if ( !strstr($multibyte_charset, $lang['ENCODING']) ) { $match_word = str_replace('*', '%', $split_search[$i]); $sql = "SELECT m.post_id FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m WHERE w.word_text LIKE '$match_word' AND m.word_id = w.word_id AND w.word_common <> 1 $search_msg_only"; } else { $match_word = addslashes('%' . str_replace('*', '', $split_search[$i]) . '%'); $search_msg_only = ( $search_fields ) ? "OR post_subject LIKE '$match_word'" : ''; $sql = "SELECT post_id FROM " . POSTS_TEXT_TABLE . " WHERE post_text LIKE '$match_word' $search_msg_only"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql); } $row = array(); while( $temp_row = $db->sql_fetchrow($result) ) { $row[$temp_row['post_id']] = 1; if ( !$word_count ) { $result_list[$temp_row['post_id']] = 1; } else if ( $current_match_type == 'or' ) { $result_list[$temp_row['post_id']] = 1; } else if ( $current_match_type == 'not' ) { $result_list[$temp_row['post_id']] = 0; } } if ( $current_match_type == 'and' && $word_count ) { @reset($result_list); while( list($post_id, $match_count) = @each($result_list) ) { if ( !$row[$post_id] ) { $result_list[$post_id] = 0; } } } $word_count++; $db->sql_freeresult($result); } } @reset($result_list); $search_ids = array(); while( list($post_id, $matches) = each($result_list) ) { if ( $matches ) { $search_ids[] = $post_id; } } unset($result_list); $total_match_count = count($search_ids); } // // If user is logged in then we'll check to see which (if any) private // forums they are allowed to view and include them in the search. // // If not logged in we explicitly prevent searching of private forums // $auth_sql = ''; if ( $search_forum != -1 ) { $is_auth = auth(AUTH_READ, $search_forum, $userdata); if ( !$is_auth['auth_read'] ) { message_die(GENERAL_MESSAGE, $lang['No_searchable_forums']); } $auth_sql = "f.forum_id = $search_forum"; } else { $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata); if ( $search_cat != -1 ) { $auth_sql = "f.cat_id = $search_cat"; } $ignore_forum_sql = ''; while( list($key, $value) = each($is_auth_ary) ) { if ( !$value['auth_read'] ) { $ignore_forum_sql .= ( ( $ignore_forum_sql != '' ) ? ', ' : '' ) . $key; } } if ( $ignore_forum_sql != '' ) { $auth_sql .= ( $auth_sql != '' ) ? " AND f.forum_id NOT IN ($ignore_forum_sql) " : "f.forum_id NOT IN ($ignore_forum_sql) "; } } // // Author name search // if ( $search_author != '' ) { $search_author = str_replace('*', '%', trim($search_author)); if( ( strpos($search_author, '%') !== false ) && ( strlen(str_replace('%', '', $search_author)) < $board_config['search_min_chars'] ) ) { $search_author = ''; } } if ( $total_match_count ) { if ( $show_results == 'topics' ) { // // This one is a beast, try to seperate it a bit (workaround for connection timeouts) // $search_id_chunks = array(); $count = 0; $chunk = 0; if (count($search_ids) > $limiter) { for ($i = 0; $i < count($search_ids); $i++) { if ($count == $limiter) { $chunk++; $count = 0; } $search_id_chunks[$chunk][$count] = $search_ids[$i]; $count++; } } else { $search_id_chunks[0] = $search_ids; } $search_ids = array(); for ($i = 0; $i < count($search_id_chunks); $i++) { $where_sql = ''; if ( $search_time ) { $where_sql .= ( $search_author == '' && $auth_sql == '' ) ? " AND post_time >= $search_time " : " AND p.post_time >= $search_time "; } if ( $search_author == '' && $auth_sql == '' ) { $sql = "SELECT topic_id FROM " . POSTS_TABLE . " WHERE post_id IN (" . implode(", ", $search_id_chunks[$i]) . ") $where_sql GROUP BY topic_id"; } else { $from_sql = POSTS_TABLE . " p"; if ( $search_author != '' ) { $from_sql .= ", " . USERS_TABLE . " u"; $where_sql .= " AND u.user_id = p.poster_id AND u.username LIKE '$search_author' "; } if ( $auth_sql != '' ) { $from_sql .= ", " . FORUMS_TABLE . " f"; $where_sql .= " AND f.forum_id = p.forum_id AND $auth_sql"; } $sql = "SELECT p.topic_id FROM $from_sql WHERE p.post_id IN (" . implode(", ", $search_id_chunks[$i]) . ") $where_sql GROUP BY p.topic_id"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain topic ids', '', __LINE__, __FILE__, $sql); } while ($row = $db->sql_fetchrow($result)) { $search_ids[] = $row['topic_id']; } $db->sql_freeresult($result); } $total_match_count = sizeof($search_ids); } else if ( $search_author != '' || $search_time || $auth_sql != '' ) { $search_id_chunks = array(); $count = 0; $chunk = 0; if (count($search_ids) > $limiter) { for ($i = 0; $i < count($search_ids); $i++) { if ($count == $limiter) { $chunk++; $count = 0; } $search_id_chunks[$chunk][$count] = $search_ids[$i]; $count++; } } else { $search_id_chunks[0] = $search_ids; } $search_ids = array(); for ($i = 0; $i < count($search_id_chunks); $i++) { $where_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id IN (' . implode(', ', $search_id_chunks[$i]) . ')' : 'p.post_id IN (' . implode(', ', $search_id_chunks[$i]) . ')'; $select_sql = ( $search_author == '' && $auth_sql == '' ) ? 'post_id' : 'p.post_id'; $from_sql = ( $search_author == '' && $auth_sql == '' ) ? POSTS_TABLE : POSTS_TABLE . ' p'; if ( $search_time ) { $where_sql .= ( $search_author == '' && $auth_sql == '' ) ? " AND post_time >= $search_time " : " AND p.post_time >= $search_time"; } if ( $auth_sql != '' ) { $from_sql .= ", " . FORUMS_TABLE . " f"; $where_sql .= " AND f.forum_id = p.forum_id AND $auth_sql"; } if ( $search_author != '' ) { $from_sql .= ", " . USERS_TABLE . " u"; $where_sql .= " AND u.user_id = p.poster_id AND u.username LIKE '$search_author'"; } $sql = "SELECT " . $select_sql . " FROM $from_sql WHERE $where_sql"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain post ids', '', __LINE__, __FILE__, $sql); } while( $row = $db->sql_fetchrow($result) ) { $search_ids[] = $row['post_id']; } $db->sql_freeresult($result); } $total_match_count = count($search_ids); } } else if ( $search_id == 'unanswered' ) { if ( $auth_sql != '' ) { $sql = "SELECT t.topic_id, f.forum_id FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f WHERE t.topic_replies = 0 AND t.forum_id = f.forum_id AND t.topic_moved_id = 0 AND $auth_sql"; } else { $sql = "SELECT topic_id FROM " . TOPICS_TABLE . " WHERE topic_replies = 0 AND topic_moved_id = 0"; } if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain post ids', '', __LINE__, __FILE__, $sql); } $search_ids = array(); while( $row = $db->sql_fetchrow($result) ) { $search_ids[] = $row['topic_id']; } $db->sql_freeresult($result); $total_match_count = count($search_ids); // // Basic requirements // $show_results = 'topics'; $sort_by = 0; $sort_dir = 'DESC'; } else { message_die(GENERAL_MESSAGE, $lang['No_search_match']); } // // Delete old data from the search result table // $sql = 'DELETE FROM ' . SEARCH_TABLE . ' WHERE search_time < ' . ($current_time - (int) $board_config['session_length']); if ( !$result = $db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not delete old search id sessions', '', __LINE__, __FILE__, $sql); } // // Store new result data // $search_results = implode(', ', $search_ids); $per_page = ( $show_results == 'posts' ) ? $board_config['posts_per_page'] : $board_config['topics_per_page']; // // Combine both results and search data (apart from original query) // so we can serialize it and place it in the DB // $store_search_data = array(); // // Limit the character length (and with this the results displayed at all following pages) to prevent // truncated result arrays. Normally, search results above 12000 are affected. // - to include or not to include /* $max_result_length = 60000; if (strlen($search_results) > $max_result_length) { $search_results = substr($search_results, 0, $max_result_length); $search_results = substr($search_results, 0, strrpos($search_results, ',')); $total_match_count = count(explode(', ', $search_results)); } */ for($i = 0; $i < count($store_vars); $i++) { $store_search_data[$store_vars[$i]] = $$store_vars[$i]; } $result_array = serialize($store_search_data); unset($store_search_data); mt_srand ((double) microtime() * 1000000); $search_id = mt_rand(); $sql = "UPDATE " . SEARCH_TABLE . " SET search_id = $search_id, search_time = $current_time, search_array = '" . str_replace("\'", "''", $result_array) . "' WHERE session_id = '" . $userdata['session_id'] . "'"; if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() ) { $sql = "INSERT INTO " . SEARCH_TABLE . " (search_id, session_id, search_time, search_array) VALUES($search_id, '" . $userdata['session_id'] . "', $current_time, '" . str_replace("\'", "''", $result_array) . "')"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not insert search results', '', __LINE__, __FILE__, $sql); } } } else { $search_id = intval($search_id); if ( $search_id ) { $sql = "SELECT search_array FROM " . SEARCH_TABLE . " WHERE search_id = $search_id AND session_id = '". $userdata['session_id'] . "'"; if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not obtain search results', '', __LINE__, __FILE__, $sql); } if ( $row = $db->sql_fetchrow($result) ) { $search_data = unserialize($row['search_array']); for($i = 0; $i < count($store_vars); $i++) { $$store_vars[$i] = $search_data[$store_vars[$i]]; } } } } // // Look up data ... // if ( $search_results != '' ) { if ( $show_results == 'posts' ) { $sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid, u.user_level FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt WHERE p.post_id IN ($search_results) AND pt.post_id = p.post_id AND f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND p.poster_id = u.user_id"; } else { $sql = "SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u.user_level, 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 FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2 WHERE t.topic_id IN ($search_results) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_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"; } $per_page = ( $show_results == 'posts' ) ? $board_config['posts_per_page'] : $board_config['topics_per_page']; $sql .= " ORDER BY "; switch ( $sort_by ) { case 1: $sql .= ( $show_results == 'posts' ) ? 'pt.post_subject' : 't.topic_title'; break; case 2: $sql .= 't.topic_title'; break; case 3: $sql .= 'u.username'; break; case 4: $sql .= 'f.forum_id'; break; default: $sql .= ( $show_results == 'posts' ) ? 'p.post_time' : 'p2.post_time'; break; } $sql .= " $sort_dir LIMIT $start, " . $per_page; if ( !$result = $db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not obtain search results', '', __LINE__, __FILE__, $sql); } $searchset = array(); while( $row = $db->sql_fetchrow($result) ) { $searchset[] = $row; } $db->sql_freeresult($result); // // Define censored word matches // $orig_word = array(); $replacement_word = array(); obtain_word_list($orig_word, $replacement_word); // // Output header // $page_title = $lang['Search']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); if ( $show_results == 'posts' ) { $template->set_filenames(array( 'body' => 'search_results_posts.tpl') ); } else { $template->set_filenames(array( 'body' => 'search_results_topics.tpl') ); } make_jumpbox('viewforum.'.$phpEx); $l_search_matches = ( $total_match_count == 1 ) ? sprintf($lang['Found_search_match'], $total_match_count) : sprintf($lang['Found_search_matches'], $total_match_count); $template->assign_vars(array( 'L_SEARCH_MATCHES' => $l_search_matches, 'L_TOPIC' => $lang['Topic']) ); $highlight_active = ''; $highlight_match = array(); for($j = 0; $j < count($split_search); $j++ ) { $split_word = $split_search[$j]; if ( $split_word != 'and' && $split_word != 'or' && $split_word != 'not' ) { $highlight_match[] = '#\b(' . str_replace("*", "([\w]+)?", $split_word) . ')\b#is'; $highlight_active .= " " . $split_word; for ($k = 0; $k < count($synonym_array); $k++) { list($replace_synonym, $match_synonym) = split(' ', trim(strtolower($synonym_array[$k]))); if ( $replace_synonym == $split_word ) { $highlight_match[] = '#\b(' . str_replace("*", "([\w]+)?", $replace_synonym) . ')\b#is'; $highlight_active .= ' ' . $match_synonym; } } } } $highlight_active = urlencode(trim($highlight_active)); $tracking_topics = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_t']) : array(); $tracking_forums = ( isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) ) ? unserialize($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f']) : array(); for($i = 0; $i < count($searchset); $i++) { $forum_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $searchset[$i]['forum_id']); $topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $searchset[$i]['topic_id'] . "&highlight=$highlight_active"); $post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $searchset[$i]['post_id'] . "&highlight=$highlight_active") . '#' . $searchset[$i]['post_id']; $post_date = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']); $message = $searchset[$i]['post_text']; $topic_title = $searchset[$i]['topic_title']; $forum_id = $searchset[$i]['forum_id']; $topic_id = $searchset[$i]['topic_id']; if ( $show_results == 'posts' ) { if ( isset($return_chars) ) { $bbcode_uid = $searchset[$i]['bbcode_uid']; // // If the board has HTML off but the post has HTML // on then we process it, else leave it alone // if ( $return_chars != -1 ) { $message = strip_tags($message); $message = preg_replace("/\[.*?:$bbcode_uid:?.*?\]/si", '', $message); $message = preg_replace('/\[url\]|\[\/url\]/si', '', $message); $message = ( strlen($message) > $return_chars ) ? substr($message, 0, $return_chars) . ' ...' : $message; } else { if ( !$board_config['allow_html'] ) { if ( $postrow[$i]['enable_html'] ) { $message = preg_replace('#(<)([\/]?.*?)(>)#is', '<\\2>', $message); } } if ( $bbcode_uid != '' ) { $message = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($message, $bbcode_uid) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message); } $message = make_clickable($message); 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); } } } if ( count($orig_word) ) { $topic_title = preg_replace($orig_word, $replacement_word, $topic_title); $post_subject = ( $searchset[$i]['post_subject'] != "" ) ? preg_replace($orig_word, $replacement_word, $searchset[$i]['post_subject']) : $topic_title; $message = preg_replace($orig_word, $replacement_word, $message); } else { $post_subject = ( $searchset[$i]['post_subject'] != '' ) ? $searchset[$i]['post_subject'] : $topic_title; } if ($board_config['allow_smilies'] && $searchset[$i]['enable_smilies']) { $message = smilies_pass($message); } $message = str_replace("\n", '
', $message); } // Start add - Username Color Mod switch ( $searchset[$i]['user_level'] ) { case ADMIN: $post_username_color = '' . $searchset[$i]['post_username'] . ''; $style_color = ' style="color: #' . $theme['fontcolor3'] . '"'; break; case MOD: $post_username_color = '' . $searchset[$i]['post_username'] . ''; $style_color = ' style="color: #' . $theme['fontcolor2'] . '"'; break; default: $post_username_color = $searchset[$i]['post_username']; $style_color = ''; break; } // End add - Username Color Mod $poster = ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $poster .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != "" ) ? $post_username_color : $lang['Guest'] ); $poster .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; if ( $userdata['session_logged_in'] && $searchset[$i]['post_time'] > $userdata['user_lastvisit'] ) { if ( !empty($tracking_topics[$topic_id]) && !empty($tracking_forums[$forum_id]) ) { $topic_last_read = ( $tracking_topics[$topic_id] > $tracking_forums[$forum_id] ) ? $tracking_topics[$topic_id] : $tracking_forums[$forum_id]; } else if ( !empty($tracking_topics[$topic_id]) || !empty($tracking_forums[$forum_id]) ) { $topic_last_read = ( !empty($tracking_topics[$topic_id]) ) ? $tracking_topics[$topic_id] : $tracking_forums[$forum_id]; } if ( $searchset[$i]['post_time'] > $topic_last_read ) { $mini_post_img = $images['icon_minipost_new']; $mini_post_alt = $lang['New_post']; } else { $mini_post_img = $images['icon_minipost']; $mini_post_alt = $lang['Post']; } } else { $mini_post_img = $images['icon_minipost']; $mini_post_alt = $lang['Post']; } $template->assign_block_vars("searchresults", array( 'TOPIC_TITLE' => $topic_title, 'FORUM_NAME' => $searchset[$i]['forum_name'], 'POST_SUBJECT' => $post_subject, 'POST_DATE' => $post_date, 'POSTER_NAME' => $poster, 'TOPIC_REPLIES' => $searchset[$i]['topic_replies'], 'TOPIC_VIEWS' => $searchset[$i]['topic_views'], 'MESSAGE' => $message, 'MINI_POST_IMG' => $mini_post_img, 'L_MINI_POST_ALT' => $mini_post_alt, 'U_POST' => $post_url, 'U_TOPIC' => $topic_url, 'U_FORUM' => $forum_url) ); } else { $message = ''; if ( count($orig_word) ) { $topic_title = preg_replace($orig_word, $replacement_word, $searchset[$i]['topic_title']); } $topic_type = $searchset[$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 ( $searchset[$i]['topic_vote'] ) { $topic_type .= $lang['Topic_Poll'] . ' '; } $views = $searchset[$i]['topic_views']; $replies = $searchset[$i]['topic_replies']; if ( ( $replies + 1 ) > $board_config['posts_per_page'] ) { $total_pages = ceil( ( $replies + 1 ) / $board_config['posts_per_page'] ); $goto_page = ' [ ' . $lang['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 = ''; } if ( $searchset[$i]['topic_status'] == TOPIC_MOVED ) { $topic_type = $lang['Topic_Moved'] . ' '; $topic_id = $searchset[$i]['topic_moved_id']; $folder_image = '' . $lang['No_new_posts'] . ''; $newest_post_img = ''; } else { if ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) { $folder = $images['folder_locked']; $folder_new = $images['folder_locked_new']; } else if ( $searchset[$i]['topic_type'] == POST_ANNOUNCE ) { $folder = $images['folder_announce']; $folder_new = $images['folder_announce_new']; } else if ( $searchset[$i]['topic_type'] == POST_STICKY ) { $folder = $images['folder_sticky']; $folder_new = $images['folder_sticky_new']; } 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']; } } if ( $userdata['session_logged_in'] ) { if ( $searchset[$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] > $searchset[$i]['post_time'] ) { $unread_topics = false; } } if ( !empty($tracking_forums[$forum_id]) ) { if ( $tracking_forums[$forum_id] > $searchset[$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'] > $searchset[$i]['post_time'] ) { $unread_topics = false; } } if ( $unread_topics ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = '' . $lang['View_newest_post'] . ' '; } else { $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $folder_image = $folder; $folder_alt = $folder_alt; $newest_post_img = ''; } } else if ( $searchset[$i]['post_time'] > $userdata['user_lastvisit'] ) { $folder_image = $folder_new; $folder_alt = $lang['New_posts']; $newest_post_img = '' . $lang['View_newest_post'] . ' '; } else { $folder_image = $folder; $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } else { $folder_image = $folder; $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } else { $folder_image = $folder; $folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts']; $newest_post_img = ''; } } // Start add - Username Color Mod switch ( $searchset[$i]['user_level'] ) { case ADMIN: $username_color = '' . $searchset[$i]['username'] . ''; $style_color = ' style="color: #' . $theme['fontcolor3'] . '"'; break; case MOD: $username_color = '' . $searchset[$i]['username'] . ''; $style_color = ' style="color: #' . $theme['fontcolor2'] . '"'; break; default: $username_color = $searchset[$i]['username']; $style_color = ''; break; } switch ( $searchset[$i]['user_level2'] ) { case ADMIN: $username_color2 = '' . $searchset[$i]['user2'] . ''; $style_color2 = ' style="color: #' . $theme['fontcolor3'] . '"'; break; case MOD: $username_color2 = '' . $searchset[$i]['user2'] . ''; $style_color2 = ' style="color: #' . $theme['fontcolor2'] . '"'; break; default: $username_color2 = $searchset[$i]['user2']; $style_color2 = ''; break; } // End add - Username Color Mod $topic_author = ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $topic_author .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? $username_color : ( ( $searchset[$i]['post_username'] != '' ) ? $searchset[$i]['post_username'] : $lang['Guest'] ); $topic_author .= ( $searchset[$i]['user_id'] != ANONYMOUS ) ? '' : ''; $first_post_time = create_date($board_config['default_dateformat'], $searchset[$i]['topic_time'], $board_config['board_timezone']); $last_post_time = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']); $last_post_author = ( $searchset[$i]['id2'] == ANONYMOUS ) ? ( ($searchset[$i]['post_username2'] != '' ) ? $searchset[$i]['post_username2'] . ' ' : $lang['Guest'] . ' ' ) : '' . $username_color2 . ''; $last_post_url = '' . $lang['View_latest_post'] . ''; $template->assign_block_vars('searchresults', array( 'FORUM_NAME' => $searchset[$i]['forum_name'], 'FORUM_ID' => $forum_id, 'TOPIC_ID' => $topic_id, 'FOLDER' => $folder_image, 'NEWEST_POST_IMG' => $newest_post_img, 'TOPIC_FOLDER_IMG' => $folder_image, 'GOTO_PAGE' => $goto_page, 'REPLIES' => $replies, 'TOPIC_TITLE' => $topic_title, 'TOPIC_TYPE' => $topic_type, 'VIEWS' => $views, 'TOPIC_AUTHOR' => $topic_author, '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_FORUM' => $forum_url, 'U_VIEW_TOPIC' => $topic_url) ); } } $base_url = "search.$phpEx?search_id=$search_id"; $template->assign_vars(array( 'PAGINATION' => generate_pagination($base_url, $total_match_count, $per_page, $start), 'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $per_page ) + 1 ), ceil( $total_match_count / $per_page )), 'L_AUTHOR' => $lang['Author'], 'L_MESSAGE' => $lang['Message'], 'L_FORUM' => $lang['Forum'], 'L_TOPICS' => $lang['Topics'], 'L_REPLIES' => $lang['Replies'], 'L_VIEWS' => $lang['Views'], 'L_POSTS' => $lang['Posts'], 'L_LASTPOST' => $lang['Last_Post'], 'L_POSTED' => $lang['Posted'], 'L_SUBJECT' => $lang['Subject'], 'L_GOTO_PAGE' => $lang['Goto_page']) ); $template->pparse('body'); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); } else { message_die(GENERAL_MESSAGE, $lang['No_search_match']); } } // // Search forum // $sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order"; $result = $db->sql_query($sql); if ( !$result ) { message_die(GENERAL_ERROR, 'Could not obtain forum_name/forum_id', '', __LINE__, __FILE__, $sql); } $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata); $s_forums = ''; while( $row = $db->sql_fetchrow($result) ) { if ( $is_auth_ary[$row['forum_id']]['auth_read'] ) { $s_forums .= ''; if ( empty($list_cat[$row['cat_id']]) ) { $list_cat[$row['cat_id']] = $row['cat_title']; } } } if ( $s_forums != '' ) { $s_forums = '' . $s_forums; // // Category to search // $s_categories = ''; while( list($cat_id, $cat_title) = @each($list_cat)) { $s_categories .= ''; } } else { message_die(GENERAL_MESSAGE, $lang['No_searchable_forums']); } // // Number of chars returned // $s_characters = ''; $s_characters .= ''; $s_characters .= ''; $s_characters .= ''; for($i = 100; $i < 1100 ; $i += 100) { $selected = ( $i == 200 ) ? ' selected="selected"' : ''; $s_characters .= ''; } // // Sorting // $s_sort_by = ""; for($i = 0; $i < count($sort_by_types); $i++) { $s_sort_by .= ''; } // // Search time // $previous_days = array(0, 1, 7, 14, 30, 90, 180, 364); $previous_days_text = array($lang['All_Posts'], $lang['1_Day'], $lang['7_Days'], $lang['2_Weeks'], $lang['1_Month'], $lang['3_Months'], $lang['6_Months'], $lang['1_Year']); $s_time = ''; for($i = 0; $i < count($previous_days); $i++) { $selected = ( $topic_days == $previous_days[$i] ) ? ' selected="selected"' : ''; $s_time .= ''; } if ( $board_config['AJAXed_user_list'] ) { include($phpbb_root_path . 'includes/sajax.'.$phpEx); $sajax->request_type = 'POST'; $sajax->init('ajax.'.$phpEx); $sajax->export('build_user_list'); $sajax->handle_client_request(); $sajax->show_javascript(); $template->assign_block_vars('switch_ajax', array()); } // // Output the basic page // $page_title = $lang['Search']; include($phpbb_root_path . 'includes/page_header.'.$phpEx); $template->set_filenames(array( 'body' => 'search_body.tpl') ); make_jumpbox('viewforum.'.$phpEx); $template->assign_vars(array( 'L_SEARCH_QUERY' => $lang['Search_query'], 'L_SEARCH_OPTIONS' => $lang['Search_options'], 'L_SEARCH_KEYWORDS' => $lang['Search_keywords'], 'L_SEARCH_KEYWORDS_EXPLAIN' => $lang['Search_keywords_explain'], 'L_SEARCH_AUTHOR' => $lang['Search_author'], 'L_SEARCH_AUTHOR_EXPLAIN' => $lang['Search_author_explain'], 'L_SEARCH_ANY_TERMS' => $lang['Search_for_any'], 'L_SEARCH_ALL_TERMS' => $lang['Search_for_all'], 'L_SEARCH_MESSAGE_ONLY' => $lang['Search_msg_only'], 'L_SEARCH_MESSAGE_TITLE' => $lang['Search_title_msg'], 'L_CATEGORY' => $lang['Category'], 'L_RETURN_FIRST' => $lang['Return_first'], 'L_CHARACTERS' => $lang['characters_posts'], 'L_SORT_BY' => $lang['Sort_by'], 'L_SORT_ASCENDING' => $lang['Sort_Ascending'], 'L_SORT_DESCENDING' => $lang['Sort_Descending'], 'L_SEARCH_PREVIOUS' => $lang['Search_previous'], 'L_DISPLAY_RESULTS' => $lang['Display_results'], 'L_FORUM' => $lang['Forum'], 'L_TOPICS' => $lang['Topics'], 'L_POSTS' => $lang['Posts'], 'AJAXED_USER_LIST_1' => ( $board_config['AJAXed_user_list'] ) ? ' onkeyup="ub(this.value,1);" autocomplete="off"' : '', 'AJAXED_USER_LIST_2' => ( $board_config['AJAXed_user_list'] ) ? '
' : '', 'S_SEARCH_ACTION' => append_sid("search.$phpEx?mode=results"), 'S_CHARACTER_OPTIONS' => $s_characters, 'S_FORUM_OPTIONS' => $s_forums, 'S_CATEGORY_OPTIONS' => $s_categories, 'S_TIME_OPTIONS' => $s_time, 'S_SORT_OPTIONS' => $s_sort_by, 'S_HIDDEN_FIELDS' => '') ); $template->pparse('body'); include($phpbb_root_path . 'includes/page_tail.'.$phpEx); ?>