+include($phpbb_root_path . 'includes/bbcode.'.$phpEx);

+// -----------------------

+ // First see if we've got a single word enclosed in quotes. If so remove

+ // Next see if we've got an opening quote if we do then we assume a phrase is

+ // being entered so store first word (if any) and set $phrase to true

+ // Next check if we've got a closing quote if so end phrase input

+ // Finally store any other word (checking to see if phrase is true (if so

+ // store word in the same array position as previous word matches)

+

+ $searchstring .= " ( pt.post_text LIKE '% $findword %')";

+ }// OR pt.post_text LIKE '$findword %' OR pt.post_text LIKE '% $findword'

+

+ $searchstring .= " ( pt.post_text LIKE '% $findword %' )";

+ }// OR pt.post_text LIKE '$findword %' OR pt.post_text LIKE '% $findword'

+

+ $searchstring .= " ( pt.post_text NOT LIKE '% $findword %' AND pt.post_text NOT LIKE '$findword %' AND pt.post_text NOT LIKE '% $findword' AND pt.post_text NOT LIKE '$findword' ) ";

+ }//

+// ----------------------

+//

+// Define initial vars

+//

+if( isset($HTTP_POST_VARS['search_keywords']) || isset($HTTP_GET_VARS['search_keywords']) )

+{

+ $query_keywords = ( isset($HTTP_POST_VARS['search_keywords']) ) ? $HTTP_POST_VARS['search_keywords'] : $HTTP_GET_VARS['search_keywords'];

+}

+else

+{

+ $query_keywords = "";

+}

+if( isset($HTTP_POST_VARS['search_author']) || isset($HTTP_GET_VARS['search_author']) )

+{

+ $query_author = ( isset($HTTP_POST_VARS['search_author']) ) ? $HTTP_POST_VARS['search_author'] : $HTTP_GET_VARS['search_author'];

+}

+else

+{

+ $query_author = "";

+}

+$search_id = ( isset($HTTP_GET_VARS['search_id']) ) ? $HTTP_GET_VARS['search_id'] : "";

+

+if( isset($HTTP_POST_VARS['addterms']) )

+{

+ $search_all_terms = ( $HTTP_POST_VARS['addterms'] == "all" ) ? 1 : 0;

+}

+else if( isset($HTTP_GET_VARS['addterms']) )

+{

+ $search_all_terms = ( $HTTP_GET_VARS['addterms'] == "all" ) ? 1 : 0;

+}

+else

+{

+ $search_all_terms = 0;

+}

+

+if( isset($HTTP_POST_VARS['charsreqd']) || isset($HTTP_GET_VARS['charsreqd']) )

+{

+ $return_chars = ( isset($HTTP_POST_VARS['charsreqd']) ) ? $HTTP_POST_VARS['charsreqd'] : $HTTP_GET_VARS['charsreqd'];

+ if( $return_chars == "all" )

+ {

+ $return_chars = -1;

+ }

+}

+else

+{

+ $return_chars = 200;

+}

+

+$search_cat = ( isset($HTTP_POST_VARS['searchcat']) ) ? $HTTP_POST_VARS['searchcat'] : "";

+$search_forum = ( isset($HTTP_POST_VARS['searchforum']) ) ? $HTTP_POST_VARS['searchforum'] : "";

+

+if( isset($HTTP_POST_VARS['sortby']) || isset($HTTP_GET_VARS['sortby']) )

+{

+ $sortby = (isset($HTTP_POST_VARS['sortby'])) ? $HTTP_POST_VARS['sortby'] : $HTTP_GET_VARS['sortby'];

+}

+else

+{

+ $sortby = 0;

+}

+

+if( isset($HTTP_POST_VARS['sortdir']) || isset($HTTP_GET_VARS['sortdir']) )

+{

+ $sortby_dir = (isset($HTTP_POST_VARS['sortdir'])) ? $HTTP_POST_VARS['sortdir'] : $HTTP_GET_VARS['sortdir'];

+}

+else

+{

+ $sortby_dir = "DESC";

+}

+

+if( isset($HTTP_POST_VARS['showresults']) || isset($HTTP_GET_VARS['showresults']) )

+{

+ $show_results = (isset($HTTP_POST_VARS['showresults'])) ? $HTTP_POST_VARS['showresults'] : $HTTP_GET_VARS['showresults'];

+}

+else

+{

+ $show_results = "posts";

+}

+

+if(!empty($HTTP_POST_VARS['resultdays']) )

+{

+ $search_time = time() - ( $HTTP_POST_VARS['resultdays'] * 86400 );

+}

+else

+{

+ $search_time = 0;

+}

+

+$start = ( isset($HTTP_GET_VARS['start']) ) ? $HTTP_GET_VARS['start'] : 0;

+//

+// Begin core code

+//

+if( $query_keywords != "" || $query_author != "" || $search_id )

+ if( $query_keywords != "" || $query_author != "" || $search_id == "newposts" )

+ {

+ if( $search_id == "newposts" )

+ {

+ $show_results = "topics";

+ $search_time = $userdata['session_last_visit'];

+ $sortby = 0;

+ $sortby_dir = "DESC";

+ }

+ //

+ // Limit to search to accessible

+ // forums

+ //

+ $is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata);

+ //

+ // Start building appropriate SQL query

+ //

+ $sql_fields = ( $show_results == "posts") ? "pt.post_text, pt.post_subject, p.*, f.forum_name, t.*, u.username, u.user_id, u.user_sig" : "f.forum_id, f.forum_name, t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username" ;

+ $sql_from = ( $show_results == "posts") ? FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt " : FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt, " . USERS_TABLE . " u2";

+ $sql_where = ( $show_results == "posts") ? "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" : "pt.post_id = p.post_id AND f.forum_id = p.forum_id AND t.topic_id = p.topic_id AND u.user_id = t.topic_poster AND p.poster_id = u2.user_id";

+

+ $sql = "SELECT $sql_fields

+ FROM $sql_from ";

+

+ //

+ // 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

+ //

+

+ if( $query_keywords != "" || $query_author != "" || $search_id == "newposts" )

+ $search_sql = "";

+ if($query_keywords != "")

+ {

+ $searchdata = gensearch_sql($query_keywords, $search_all_terms);

+ $search_sql = $searchdata[0];

+ }

+

+ if($query_author != "")

+ {

+ $search_sql = preg_replace("/\(\)/", "", $search_sql);

+ $search_sql .= ($search_sql == "") ? "u.username LIKE '%$query_author%'" : " AND (u.username LIKE '%$query_author%')";

+ }

+

+ if( !ereg("\([ ]*\)", $search_sql) || $search_id == "newposts" )

+ {

+ $sql .= ( $search_id == "newposts" ) ? "WHERE $sql_where" : "WHERE $search_sql AND $sql_where";

+

+ if( $search_forum != "all" )

+ {

+ $sql .= ( $is_auth_ary[$searchforum]['auth_read'] ) ? " AND f.forum_id = '$searchforum'" : "";

+ }

+

+ while(list($key, $value) = each($is_auth_ary))

+ {

+ if( !$value['auth_read'] )

+ {

+ $sql .= " AND f.forum_id <> $key ";

+ }

+ }

+

+ if( $search_time )

+ {

+ $sql .= " AND p.post_time >= $search_time ";

+ }

+

+ if( $show_results != "posts")

+ {

+ $sql .= " GROUP BY t.topic_id ";

+ }

+

+ $sql .= " ORDER BY " . $sortby_sql[$sortby] . " $sortby_dir";

+

+ if( !$result = $db->sql_query($sql) )

+ {

+ message_die(GENERAL_ERROR, "Couldn't obtain search results", "", __LINE__, __FILE__, $sql);

+ }

+ $searchset = $db->sql_fetchrowset($result);

+

+ //

+ // Clean up search results table

+ //

+ $sql = "SELECT session_id

+ FROM " . SESSIONS_TABLE;

+ if( $result = $db->sql_query($sql) )

+ {

+ $delete_search_id_sql = "";

+ while( $row = $db->sql_fetchrow($result) )

+ {

+ if( $delete_search_id_sql != "" )

+ {

+ $delete_search_id_sql .= ", ";

+ }

+ $delete_search_id_sql .= "'" . $row['session_id'] . "'";

+ }

+

+ if( $delete_search_id_sql != "" )

+ {

+ $sql = "DELETE FROM phpbb_search_results

+ WHERE session_id NOT IN ($delete_search_id_sql)";

+ if( !$result = $db->sql_query($sql) )

+ {

+ message_die(GENERAL_ERROR, "Couldn't delete old search id sessions", "", __LINE__, __FILE__, $sql);

+ }

+ }

+ }

+

+ //

+ // Store new result data

+ //

+ if( count($searchset) )

+ {

+ $search_results = "";

+ for($i = 0; $i < count($searchset); $i++)

+ {

+ if( $show_results == "posts")

+ {

+ $search_results .= ($search_results != "") ? ", " . $searchset[$i]['post_id'] : $searchset[$i]['post_id'];

+ }

+ else

+ {

+ $search_results .= ($search_results != "") ? ", " . $searchset[$i]['topic_id'] : $searchset[$i]['topic_id'];

+ }

+ }

+

+ //

+ // 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();

+ $store_search_data['results'] = $search_results;

+ $store_search_data['data'] = $searchdata;

+ $store_search_data['data'][0] = "";

+

+ $result_array = serialize($store_search_data);

+ unset($store_search_data);

+ unset($search_results);

+

+ mt_srand ((double) microtime() * 1000000);

+ $search_id = mt_rand();

+

+ $sql = "UPDATE phpbb_search_results

+ SET search_id = $search_id, search_array = '$result_array'

+ WHERE session_id = '" . $userdata['session_id'] . "'";

+ $result = $db->sql_query($sql);

+ if( !$result || !$db->sql_affectedrows() )

+ {

+ $sql = "INSERT INTO phpbb_search_results (search_id, session_id, search_array)

+ VALUES($search_id, '" . $userdata['session_id'] . "', '$result_array')";

+ if( !$result = $db->sql_query($sql) )

+ {

+ message_die(GENERAL_ERROR, "Couldn't insert search results", "", __LINE__, __FILE__, $sql);

+ }

+ }

+ }

+ else

+ {

+ message_die(GENERAL_MESSAGE, $lang['No_search_match']);

+ }

+ }

+ }

+ else

+ {

+ $search_id = $HTTP_GET_VARS['search_id'];

+

+ $sql = "SELECT search_array

+ FROM phpbb_search_results

+ WHERE search_id = '$search_id'

+ AND session_id = '". $userdata['session_id'] . "'";

+ if( !$result = $db->sql_query($sql) )

+ message_die(GENERAL_ERROR, "Couldn't obtain search results", "", __LINE__, __FILE__, $sql);

+ if( $db->sql_numrows($result) )

+ $row = $db->sql_fetchrow($result);

+ $row = unserialize($row['search_array']);

+ $search_results = $row['results'];

+ $searchdata = $row['data'];

+

+ if( $show_results == "posts")

+ $sql = "SELECT pt.post_text, pt.post_subject, p.*, f.forum_name, t.*, u.username, u.user_id, u.user_sig

+ FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt

+ WHERE 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

+ AND p.post_id IN ($search_results)";

+ else

+ $sql = "SELECT t.*, f.forum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_username

+ FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . USERS_TABLE . " u2, " . POSTS_TABLE . " p

+ WHERE t.topic_id IN ($search_results)

+ AND f.forum_id = t.forum_id

+ AND u.user_id = t.topic_poster

+ AND p.post_id = t.topic_last_post_id

+ AND p.poster_id = u2.user_id";

+ $sql .= " ORDER BY " . $sortby_sql[$sortby] . " $sortby_dir";

+ if( !$result = $db->sql_query($sql) )

+ message_die(GENERAL_ERROR, "Couldn't obtain search results", "", __LINE__, __FILE__, $sql);

+

+ }

+ else

+ {

+ header("Location: " . append_sid("search.$phpEx"));

+ }

+ }

+

+ if( count($searchset) )

+ {

+

+ //

+ // Output header

+ //

+ $page_title = $lang['Search'];

+ include($phpbb_root_path . 'includes/page_header.'.$phpEx);

+

+ //

+ // Define censored word matches

+ //

+ $orig_word = array();

+ $replacement_word = array();

+ obtain_word_list($orig_word, $replacement_word);

+

+ if( $showresults == "posts" )

+ {

+ $template->set_filenames(array(

+ "body" => "search_results_posts.tpl",

+ "jumpbox" => "jumpbox.tpl")

+ );

+ }

+ else

+ {

+ $template->set_filenames(array(

+ "body" => "search_results_topics.tpl",

+ "jumpbox" => "jumpbox.tpl")

+ );

+ }

+

+ $jumpbox = make_jumpbox();

+ $template->assign_vars(array(

+ "L_GO" => $lang['Go'],

+ "L_JUMP_TO" => $lang['Jump_to'],

+ "L_SELECT_FORUM" => $lang['Select_forum'],

+

+ "S_JUMPBOX_LIST" => $jumpbox,

+ "S_JUMPBOX_ACTION" => append_sid("viewforum.$phpEx"))

+ );

+ $template->assign_var_from_handle("JUMPBOX", "jumpbox");

+

+ $template->assign_vars(array(

+ "SEARCH_MATCHES" => count($searchset),

+

+ "L_TOPIC" => $lang['Topic'])

+ );

+

+ for($j = 1; $j < count($searchdata); $j++)

+ {

+ $search_string[] = "'(" . preg_quote($searchdata[$j], "'") . ")'i";

+ $replace_string[] = "<font color=\"#" . $theme['fontcolor3'] . "\"><b>\\1</b></font>";

+ }

+

+ for($i = $start; $i < min($start + $board_config['posts_per_page'], 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']);

+ $poster_url = append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $searchset[$i]['user_id']);

+ $post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=".$searchset[$i]['post_id']."#".$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'];

+

+ if( $showresults == "posts" )

+ if($return_chars != 0 )

+ {

+ if($return_chars != -1)

+ {

+ $message = (strlen($message) > $return_chars) ? substr($message, 0, $return_chars) . " ..." : $message;

+ }

+

+ //

+ // If the board has HTML off but the post has HTML

+ // on then we process it, else leave it alone

+ //

+ if( $return_chars != -1 )

+ {

+ if( $searchset[$i]['enable_html'] )

+ {

+ $message = preg_replace("#(<)([\/]?.*?)(>)#is", "&lt;\\2&gt;", $message);

+ }

+ $message = preg_replace("/\:[0-9a-z\:]+\]/si", "]", $message);

+ }

+ else

+ {

+ $bbcode_uid = $searchset[$i]['bbcode_uid'];

+ $user_sig = $searchset[$i]['user_sig'];

+

+ if( !$board_config['allow_html'] )

+ {

+ if( $user_sig != "" && $searchset[$i]['enable_sig'] )

+ {

+ $user_sig = preg_replace("#(<)([\/]?.*?)(>)#is", "&lt;\\2&gt;", $user_sig);

+ }

+

+ if( $searchset[$i]['enable_html'] )

+ {

+ $message = preg_replace("#(<)([\/]?.*?)(>)#is", "&lt;\\2&gt;", $message);

+ }

+ }

+

+ if( $board_config['allow_bbcode'] && $bbcode_uid != "" )

+ {

+ if( $user_sig != "" && $searchset[$i]['enable_sig'] )

+ {

+ $sig_uid = make_bbcode_uid();

+ $user_sig = bbencode_first_pass($user_sig, $sig_uid);

+ $user_sig = bbencode_second_pass($user_sig, $sig_uid);

+ }

+

+ $message = bbencode_second_pass($message, $bbcode_uid);

+ }

+ else if( !$board_config['allow_bbcode'] && $bbcode_uid != "" )

+ {

+ $message = preg_replace("/\:[0-9a-z\:]+\]/si", "]", $message);

+ }

+

+ $message = make_clickable($message);

+ if( $searchset[$i]['enable_sig'] )

+ {

+ $message .= "<br /><br />_________________<br />" . make_clickable($user_sig);

+ }

+ }

+

+ if( count($orig_word) )

+ {

+ $topic_title = preg_replace($orig_word, $replacement_word, $searchset[$i]['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);

+ }

+

+ if($board_config['allow_smilies'] && $searchset[$i]['enable_smilies'])

+ {

+ $message = smilies_pass($message);

+ }

+

+ $message = str_replace("\n", "<br />", $message);

+

+ if( count($searchdata) > 1 )

+ {

+ $message = preg_replace($search_string, $replace_string, $message);

+ }

+ }

+

+ $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" => $searchset[$i]['username'],

+ "TOPIC_REPLIES" => $searchset[$i]['topic_replies'],

+ "TOPIC_VIEWS" => $searchset[$i]['topic_views'],

+ "MESSAGE" => $message,

+

+ "U_POST" => $post_url,

+ "U_TOPIC" => $topic_url,

+ "U_FORUM" => $forum_url,

+ "U_USER_PROFILE" => $poster_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'] . " ";

+ }

+

+ $forum_id = $searchset[$i]['forum_id'];

+ $topic_id = $searchset[$i]['topic_id'];

+ $replies = $searchset[$i]['topic_replies'];

+

+ if($replies > $board_config['posts_per_page'])

+ {

+ $goto_page = "&nbsp;&nbsp;&nbsp;(<img src=\"" . $images['icon_minipost'] . "\" alt=\"" . $lang['Goto_page'] . "\" />" . $lang['Goto_page'] . ": ";

+ $times = 1;

+ for($j = 0; $j < $replies + 1; $j += $board_config['posts_per_page'])

+ if($times > 4)

+ if( $j + $board_config['posts_per_page'] >= $replies + 1 )

+ {

+ $goto_page .= " ... <a href=\"".append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $topic_id . "&amp;start=$j") . "\">$times</a>";

+ }

+ else

+ {

+ if($times != 1)

+ {

+ $goto_page .= ", ";

+ }

+ $goto_page .= "<a href=\"" . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $topic_id . "&amp;start=$j") . "\">$times</a>";

+ }

+ $times++;

+ }

+ $goto_page .= ")";

+ }

+ else

+ {

+ $goto_page = "";

+ }

+ if($searchset[$i]['topic_status'] == TOPIC_LOCKED)

+ {

+ $folder_image = "<img src=\"" . $images['folder_locked'] . "\" alt=\"" . $lang['Topic_locked'] . "\" />";

+ }

+ else if($searchset[$i]['topic_status'] == TOPIC_MOVED)

+ {

+ $topic_type = $lang['Topic_Moved'] . " ";

+ $topic_id = $searchset[$i]['topic_moved_id'];

+ }

+ 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_new_hot'];

+ else

+ {

+ $folder = $images['folder'];

+ $folder_new = $images['folder_new'];

+ }

+ }

+ if( empty($HTTP_COOKIE_VARS['phpbb2_' . $forum_id . '_' . $topic_id]) && $searchset[$i]['post_time'] > $userdata['session_last_visit'] )

+ {

+ $folder_image = "<img src=\"$folder_new\" alt=\"" . $lang['New_posts'] . "\" />";

+ if( isset($HTTP_COOKIE_VARS['phpbb2_' . $forum_id . '_' . $topic_id]) )

+ {

+ $folder_image = ($HTTP_COOKIE_VARS['phpbb2_' . $forum_id . '_' . $topic_id] < $searchset[$i]['post_time'] ) ? "<img src=\"$folder_new\" alt=\"" . $lang['New_posts'] . "\" />" : "<img src=\"$folder\" alt=\"" . $lang['No_new_posts'] . "\" />";

+ }

+ else

+ {

+ $folder_image = "<img src=\"$folder\" alt=\"" . $lang['No_new_posts'] . "\" />";

+ }

+ }

+

+ $topic_poster = $searchset[$i]['username'];

+ $last_post_time = create_date($board_config['default_dateformat'], $searchset[$i]['post_time'], $board_config['board_timezone']);

+ if($searchset[$i]['id2'] == ANONYMOUS && $searchset[$i]['post_username'] != '')

+ {

+ $last_post_user = $searchset[$i]['post_username'];

+ }

+ else

+ {

+ $last_post_user = $searchset[$i]['user2'];

+ $last_post = $last_post_time . "<br />" . $lang['by'] . " ";

+ $last_post .= "<a href=\"" . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $searchset[$i]['id2']) . "\">" . $last_post_user . "</a>&nbsp;";

+ $last_post .= "<a href=\"" . append_sid("viewtopic.$phpEx?" . POST_POST_URL . "=" . $searchset[$i]['topic_last_post_id']) . "#" . $searchset[$i]['topic_last_post_id'] . "\"><img src=\"" . $images['icon_latest_reply'] . "\" border=\"0\" alt=\"" . $lang['View_latest_post'] . "\" /></a>";

+

+ $views = $searchset[$i]['topic_views'];

+

+ $template->assign_block_vars("searchresults", array(

+ "FORUM_NAME" => $searchset[$i]['forum_name'],

+ "FORUM_ID" => $forum_id,

+ "TOPIC_ID" => $topic_id,

+ "FOLDER" => $folder_image,

+ "TOPIC_POSTER" => $topic_poster,

+ "GOTO_PAGE" => $goto_page,

+ "REPLIES" => $replies,

+ "TOPIC_TITLE" => $topic_title,

+ "TOPIC_TYPE" => $topic_type,

+ "VIEWS" => $views,

+ "LAST_POST" => $last_post,

+

+ "U_VIEW_FORUM" => $forum_url,

+ "U_VIEW_TOPIC" => $topic_url,

+ "U_TOPIC_POSTER_PROFILE" => $topic_poster_profile_url)

+ );

+ }

+ }

+ $base_url = "search.$phpEx?search_id=$search_id&amp;showresults=" . $show_results . "&amp;sortby=" . $sortby . "&amp;sortdir=" . $sortby_dir . "&amp;charsreqd=" . $return_chars;

+ $template->assign_vars(array(

+ "PAGINATION" => generate_pagination($base_url, count($searchset), $board_config['posts_per_page'], $start),

+ "ON_PAGE" => (floor($start/$board_config['posts_per_page'])+1),

+ "TOTAL_PAGES" => ceil((count($searchset))/$board_config['posts_per_page']),

+ "L_OF" => $lang['of'],

+ "L_PAGE" => $lang['Page'],

+ "L_GOTO_PAGE" => $lang['Goto_page'])

+ );

+ $template->pparse("body");

+

+ include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

+// 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_id, f.forum_order";

+ message_die(GENERAL_ERROR, "Couldn't obtain forum_name/forum_id", "", __LINE__, __FILE__, $sql);

+$s_forums = "<option value=\"all\">" . $lang['All'] . "</option>";

+ $s_forums .= "<option value=\"" . $row['forum_id'] . "\">" . $row['forum_name'] . "</option>";

+ if(empty($list_cat[$row['cat_id']]))

+ {

+ $list_cat[$row['cat_id']] = $row['cat_title'];

+ }

+//

+// Category to search

+//

+$s_categories = "<option value=\"all\">" . $lang['All'] . "</option>";

+while( list($cat_id, $cat_title) = each($list_cat))

+{

+ $s_categories .= "<option value=\"$cat_id\">$cat_title</option>";

+}

+

+//

+// Number of chars returned

+//

+$s_characters = "<option value=\"all\">" . $lang['All'] . "</option>";

+

+ $selected = ($i == 200) ? "selected=\"selected\"" : "";

+ $s_characters .= "<option value=\"$i\"$selected>$i</option>";

+//

+// Sorting

+//

+ $s_sortby .= "<option value=\"$i\">" . $sortby_types[$i] . "</option>";

+//

+// Search time

+//

+$previous_days = array(0, 1, 7, 14, 30, 90, 180, 364);

+$previous_days_text = array($lang['All'], "1 " . $lang['Day'], "7 " . $lang['Days'], "2 " . $lang['Weeks'], "1 " . $lang['Month'], "3 ". $lang['Months'], "6 " . $lang['Months'], "1 " . $lang['Year']);

+

+$s_time = "<select name=\"resultdays\">";

+for($i = 0; $i < count($previous_days); $i++)

+{

+ $selected = ($topic_days == $previous_days[$i]) ? " selected=\"selected\"" : "";

+ $s_time .= "<option value=\"" . $previous_days[$i] . "\"$selected>" . $previous_days_text[$i] . "</option>";

+}

+$s_time .= "</select>";

+

+$page_title = $lang['Search'];

+

+ "L_GO" => $lang['Go'],

+ "L_JUMP_TO" => $lang['Jump_to'],

+ "L_SELECT_FORUM" => $lang['Select_forum'],

+

+ "S_JUMPBOX_LIST" => $jumpbox,

+ "S_JUMPBOX_ACTION" => append_sid("viewforum.$phpEx"))

+ "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_CATEGORY" => $lang['Category'],

+ "L_RETURN_FIRST" => $lang['Return_first'],

+ "L_CHARACTERS" => $lang['characters'],

+ "L_SORT_DESCENDING" => $lang['Sort_Decending'],

+ "L_SEARCH_PREVIOUS" => $lang['Search_previous'],

+ "L_DISPLAY_RESULTS" => $lang['Display_results'],

+ "S_FORUM_OPTIONS" => $s_forums,

+ "S_CATEGORY_OPTIONS" => $s_categories,

+ "S_TIME_OPTIONS" => $s_time,