root/phpBB2/search.php

<?php
/***************************************************************************</span>
<span class="code-comment"> *                search.php
 *                -------------------
 *   begin        : Saturday, Feb 13, 2001
 *   copyright        : (C) 2001 The phpBB Group
 *   email        : support@phpbb.com
 *
 *   $Id: search.php,v 1.72.2.17 2005/09/14 18:14:30 acydburn 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.
 *
 ***************************************************************************/

if ( !defined('IN_PHPBB2_BRIDGE') ) {</span>
<span class="code-keyword">    trigger_error('Invalid access');
}

define('IN_PHPBB', true);
$root_path = './';</span>
<span class="code-lang">include($root_path . 'extension.inc');
include($root_path . 'phpBB2/includes/bbcode.'.$phpEx);
include($root_path . 'phpBB2/includes/functions_search.'.$phpEx);
include($root_path . 'include/bbcode/bbcode.lib.php');

//</span>
<span class="code-comment">// Start session management
//
$userdata = session_pagestart($user_ip);
init_userprefs($userdata);
//</span>
<span class="code-comment">// End session management
//

/* */
$bb_code = new bbcode;
/* */</span>
<span class="code-comment">
//
// Define initial vars
//
$mode = request_var('mode', '');
$search_keywords = request_var('search_keywords', '');
$search_author = phpbb_clean_username(request_var('search_author', ''));
$search_id = request_var('search_id', '');
$show_results = request_var('show_results', 'posts');
$show_results = ($show_results == 'topics') ? 'topics' : 'posts';
$return_chars = request_var('return_chars', 200);
$search_cat = request_var('search_cat', -1);
$search_forum = request_var('search_forum', -1);
$sort_by = request_var('sort_by', 0);

$search_terms = request_var('search_terms', '');
$search_terms = ( $search_terms == 'all' ? 1 : 0 );

$search_fields = request_var('search_fields', '');
$search_fields = ( $search_fields == 'all' ? 1 : 0 );

$sort_dir = request_var('sort_dir', '');
$sort_dir = ( $sort_dir == 'ASC' ? 'ASC' : 'DESC' );

$search_time = request_var('search_time', 0);
$search_time = ( $search_time ? time() - $search_time * 86400 : 0 );

$topic_days = $search_time;

$start = request_var('start', 0);

$sort_by_types = array($lang['sort_time'], $lang['sort_post_subject'], $lang['sort_topic_title'], $lang['sort_author'], $lang['sort_forum']);

$split_search = array();

//</span>
<span class="code-comment">// Begin core code
//
if ( $mode == 'searchuser' )</span>
<span class="code-keyword">{
    $search_username = request_var('search_username', '');
    username_search($search_username);
    gc();
}
else if ( $search_keywords != '' || $search_author != '' || $search_id )
{
    $store_vars = array('search_results', 'total_match_count', 'split_search', 'sort_by', 'sort_dir', 'show_results', 'return_chars');
    $search_results = '';
    // Topic search MOD
    $tid = request_var('topic_id', 0);
    // Topic search MOD

    //
    // Search ID Limiter, decrease this value if you experience further timeout problems with searching forums
    $limiter = 5000;
    $current_time = time();
    $total_match_count = 0;

    //
    // Cycle through options ...
    //
    if ( $search_id == 'newposts' || $search_id == 'egosearch' || $search_id == 'unanswered' || $search_keywords != '' || $search_author != '' )
    {
        //
        // Flood control
        //
        $where_sql = ($userdata['uid'] == ANONYMOUS) ? "se.session_ip = '$user_ip'" : 'se.session_user_id = ' . $userdata['uid'];
        $sql = 'SELECT MAX(sr.search_time) AS last_search_time
                FROM ' . SEARCH_TABLE . ' sr, ' . SESSIONS_TABLE . " se
                WHERE sr.session_id = se.session_id
                AND $where_sql";
        $result = $db->sql_query($sql);
        if ( $row = $db->sql_fetchrow($result) ) {
            if ( $row['last_search_time'] > 0 && ($current_time - $row['last_search_time']) < $config['search_flood_interval'] ) {
                $wait_time = intval($config['search_flood_interval']) - ($current_time - intval($row['last_search_time']));
                trigger_error(sprintf($lang['search_flood_error'], $wait_time));
            }
        }

        if ( $search_id == 'newposts' || $search_id == 'egosearch' || ( $search_author != '' && $search_keywords == '' )  )
        {
            if ( $search_id == 'newposts' )
            {

                loggedinorreturn();

                $topic_ids = get_unread_topics();

                if ( sizeof($topic_ids) ) {
                    $topic_ids = array_keys($topic_ids);
                    $sql = 'SELECT post_id FROM ' . POSTS_TABLE . ' WHERE ' . $db->sql_in_set('topic_id', $topic_ids);
                }
                else {
                    $sql = false;
                }

                $show_results = 'topics';
                $sort_by = 0;
                $sort_dir = 'DESC';
            }
            else if ( $search_id == 'egosearch' )
            {
                loggedinorreturn();

                $sql = "SELECT post_id FROM " . POSTS_TABLE . " WHERE poster_id = " . $userdata['uid'];

                $show_results = 'topics';
                $sort_by = 0;
                $sort_dir = 'DESC';
            }
            else
            {
                $search_author = str_replace('*', '%', trim($search_author));

                if( ( strpos($search_author, '%') !== false ) && ( utf_strlen(str_replace('%', '', $search_author)) < $config['search_min_chars'] ) )
                {
                    $search_author = '';
                }

                $sql = "SELECT uid FROM " . USERS_TABLE . " WHERE name LIKE '" . $db->sql_escape($search_author) . "'";
                $result = $db->sql_query($sql);

                $matching_userids = '';
                if ( $row = $db->sql_fetchrow($result) )
                {
                    do
                    {
                        $matching_userids .= ( ( $matching_userids != '' ) ? ', ' : '' ) . $row['uid'];
                    }
                    while( $row = $db->sql_fetchrow($result) );
                }
                else
                {
                    trigger_error($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;
                }
            }

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

            $search_ids = array();
            while( $row = $db->sql_fetchrow($result) )
            {
                $search_ids[] = $row['post_id'];
            }

            $db->sql_freeresult($result);

            $total_match_count = sizeof($search_ids);

        }
        else if ( $search_keywords != '' )
        {
            $stopword_array = @file($root_path . 'languages/lang_' . $config['default_lang'] . '/search_stopwords.txt');
            $synonym_array = @file($root_path . 'languages/lang_' . $config['default_lang'] . '/search_synonyms.txt');

            $stripped_keywords = ( STRIP ? stripslashes($search_keywords) : $search_keywords );
            $split_search = split_words(clean_words('search', $stripped_keywords, $stopword_array, $synonym_array), 'search');
            unset($stripped_keywords);

            $search_msg_only = ( !$search_fields ) ? "AND m.title_match = 0" : '';

            $word_count = 0;
            $current_match_type = 'or';

            $word_match = array();
            $result_list = array();

            for($i = 0; $i < sizeof($split_search); $i++)
            {
                if ( utf_strlen(str_replace(array('*', '%'), '', trim($split_search[$i]))) < $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';
                        }

                        $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";
                        $result = $db->sql_query($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 )
                {

                    // Topic Search MOD
                    if($tid)
                    {
                        $sql = "SELECT post_id
                            FROM " . POSTS_TABLE . "
                            WHERE topic_id = '$tid'";
                        $result = $db->sql_query($sql);
                        while( $test = $db->sql_fetchrow($result) )
                        {
                            if($test['post_id'] == $post_id)
                            {
                                $search_ids[] = $post_id;
                            }
                        }
                        $show_results = 'posts';
                    }
                    else
                    { // End Topic Search MOD

                    $search_ids[] = $post_id;
                    // Topic Search MOD
                    }
                    // End Topic search MOD
                }
            }

            unset($result_list);
            $total_match_count = sizeof($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'] )
            {
                trigger_error($lang['no_searchable_forums']);
                return;
            }

            $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 ) && ( utf_strlen(str_replace('%', '', $search_author)) < $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 (sizeof($search_ids) > $limiter)
                {
                    for ($i = 0; $i < sizeof($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 < sizeof($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.uid = p.poster_id AND u.name 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";
                    }

                    $result = $db->sql_query($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.uid = p.poster_id AND u.name LIKE '$search_author'";
                    }

                    $sql = "SELECT " . $select_sql . "
                        FROM $from_sql
                        WHERE $where_sql";
                    $result = $db->sql_query($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";
            }

            $result = $db->sql_query($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
        {
            trigger_error($lang['no_search_match']);
            return;
        }

        //
        // Store new result data
        //
        $search_results = implode(', ', $search_ids);
        $per_page = ( $show_results == 'posts' ) ? $config['posts_per_page'] : $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 (utf_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 < sizeof($store_vars); $i++)
        {
            $store_search_data[$store_vars[$i]] = $$store_vars[$i];
        }

        $result_array = serialize($store_search_data);
        unset($store_search_data);

        $search_id = md5(dss_rand());

        $sql = "UPDATE " . SEARCH_TABLE . "
            SET search_id = '" . $db->sql_escape($search_id) . "', search_time = $current_time, search_array = '" . $db->sql_escape($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('" . $db->sql_escape($search_id) . "', '" . $userdata['session_id'] . "', $current_time, '" . $db->sql_escape($result_array) . "')";
            $result = $db->sql_query($sql);
        }
    }
    else
    {
        $search_id = intval($search_id);
        if ( $search_id )
        {
            $sql = "SELECT search_array
                FROM " . SEARCH_TABLE . "
                WHERE search_id = '" . $db->sql_escape($search_id) . "'
                    AND session_id = '". $userdata['session_id'] . "'";
            $result = $db->sql_query($sql);

            if ( $row = $db->sql_fetchrow($result) )
            {
                $search_data = unserialize($row['search_array']);
                for($i = 0; $i < sizeof($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.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.name AS username, u.uid, c.cat_id, c.cat_title, f2.forum_id AS p_forum_id, f2.forum_name AS p_forum_name
                FROM " . FORUMS_TABLE . " f LEFT JOIN " . FORUMS_TABLE . " f2 ON ( f.forum_parent = f2.forum_id ),
    " . FORUM_CATEGORIES_TABLE . " c, " . 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.uid
    AND f.cat_id = c.cat_id";
        }
        else
        {
            $sql = "SELECT t.*, f.forum_id, f.forum_name, u.name AS username, u.uid, u2.name as user2, u2.uid as id2, p.post_username, p2.post_username AS post_username2, p2.post_time, c.cat_id, c.cat_title, f2.forum_id AS p_forum_id, f2.forum_name AS p_forum_name
                FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f LEFT JOIN " . FORUMS_TABLE . " f2 ON ( f.forum_parent = f2.forum_id )," . FORUM_CATEGORIES_TABLE . " c, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
                WHERE t.topic_id IN ($search_results)
                    AND t.topic_poster = u.uid
                    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.uid = p2.poster_id
    AND f.cat_id = c.cat_id";
        }

        $per_page = ( $show_results == 'posts' ) ? $config['posts_per_page'] : $config['topics_per_page'];

    /*if ($userdata['session_logged_in'])
    {
    if ($config['load_db_track'] && $author_id !== $userdata['uid'])
    {
    $sql_from .= ' LEFT JOIN ' . TOPICS_POSTED_TABLE . ' tp ON (tp.user_id = ' . $userdata['uid'] . '
    AND t.topic_id = tp.topic_id)';
    $sql_select .= ', tp.topic_posted';
    }

    if ($config['load_db_lastread'])
    {
    $sql_from .= ' LEFT JOIN ' . TOPICS_TRACK_TABLE . ' tt ON (tt.user_id = ' . $userdata['uid'] . '
    AND t.topic_id = tt.topic_id)
    LEFT JOIN ' . FORUMS_TRACK_TABLE . ' ft ON (ft.user_id = ' . $userdata['uid'] . '
    AND ft.forum_id = f.forum_id)';
    $sql_select .= ', tt.mark_time, ft.mark_time as f_mark_time';
    }
    }

    if ($config['load_anon_lastread'] || ($userdata['session_logged_in'] && !$config['load_db_lastread']))
    {*/
    $tracking_topics = (isset($_COOKIE[$config['cookie_name'] . '_track'])) ? ((STRIP) ? stripslashes($_COOKIE[$config['cookie_name'] . '_track']) : $_COOKIE[$config['cookie_name'] . '_track']) : '';
    $tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();
    //}
    $topic_tracking_info = array();

        $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.name';
                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;

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

        $searchset = array();
        $forums = array();
        while( $row = $db->sql_fetchrow($result) )
        {
            $searchset[] = $row;

    $forums[$row['forum_id']]['topic_list'][] = $row['topic_id'];
        }

    foreach ($forums as $forum_id => $forum)
    {
    /*if ($userdata['session_logged_in'] && $config['load_db_lastread'])
    {
    $topic_tracking_info[$forum_id] = get_topic_tracking($forum_id, $forum['topic_list'], $forum['rowset'], array($forum_id => $forum['mark_time']), ($forum_id) ? false : $forum['topic_list']);
    }
    else if ($config['load_anon_lastread'] || $userdata['session_logged_in'])
    {*/
    $topic_tracking_info[$forum_id] = get_complete_topic_tracking($forum_id, $forum['topic_list'], ($forum_id) ? false : $forum['topic_list']);

    if (!$userdata['session_logged_in'])
    {
    $userdata['user_lastmark'] = (isset($tracking_topics['l'])) ? (int) (base_convert($tracking_topics['l'], 36, 10) + $config['onlinesince']) : 0;
    }
    //}
    }
    unset($forums);

        $db->sql_freeresult($result);

        //
        // Define censored word matches
        //
        $orig_word = array();
        $replacement_word = array();
        $cache->obtain_word_list($orig_word, $replacement_word);

        //
        // Output header
        //
        stdhead($lang['forums'] . ' :: ' . $lang['search'], false);

        if ( $show_results == 'posts' )
        {
            // Topic search MOD
            if( !$tid )
            {
                // End Topic search MOD
                $template->set_filenames(array(
                    'body' => 'forum/search_results_posts.tpl')
                );
            // Topic search MOD
            }
            else
            {
                $template->set_filenames(array(
                    'body' => 'forum/topic_search_results.tpl')
                );
            }
            // End Topic search MOD
        }
        else
        {
            $template->set_filenames(array(
                'body' => 'forum/search_results_topics.tpl')
            );
        }
        //make_jumpbox('viewforum.'.$phpEx);
        make_jumpbox('phpbb2.php?page=viewforum');

        $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)
        );

        $highlight_active = '';
        $highlight_match = array();
        for($j = 0; $j < sizeof($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 < sizeof($synonym_array); $k++)
                {
                    list($replace_synonym, $match_synonym) = split(' ', trim(utf_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));

        for($i = 0; $i < sizeof($searchset); $i++)
        {

            $topic_title = $searchset[$i]['topic_title'];

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

    // www.phpBB-SEO.com SEO TOOLKIT BEGIN
    $seo->set_url($searchset[$i]['cat_id'], $searchset[$i]['cat_title'], $seo->seo_static['forum_cat']);

    if ( !empty($searchset[$i]['p_forum_id']) ) {
    $seo->set_parent($searchset[$i]['p_forum_id'], $seo->seo_static['forum'], $searchset[$i]['cat_id'], $seo->seo_static['forum_cat']);
    $seo->set_url($searchset[$i]['p_forum_name'], $searchset[$i]['p_forum_id'], $seo->seo_static['forum']);
    $seo->set_parent($forum_id, $seo->seo_static['forum'], $searchset[$i]['p_forum_id'], $seo->seo_static['forum']);
    }
    else {
    $seo->set_parent($forum_id, $seo->seo_static['forum'], $searchset[$i]['cat_id'], $seo->seo_static['forum_cat']);
    }
    $seo->set_url($searchset[$i]['forum_name'], $forum_id, $seo->seo_static['forum']);

    $seo->set_parent($topic_id, $seo->seo_static['topic'], $forum_id, $seo->seo_static['forum']);
    $seo->set_url($topic_title, $topic_id, $seo->seo_static['topic']);

    if ( $show_results != 'posts' ) {

    $seo->set_user_url($searchset[$i]['username'], $searchset[$i]['uid']);
    $seo->set_user_url($searchset[$i]['user2'], $searchset[$i]['id2']);
    }
    // www.phpBB-SEO.com SEO TOOLKIT END

            //$forum_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . '=' . $searchset[$i]['forum_id']);
            $forum_url = append_sid($root_path . "phpbb2.php?page=viewforum&amp;" . POST_FORUM_URL . '=' . $searchset[$i]['forum_id']);
            //$topic_url = append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . '=' . $searchset[$i]['topic_id'] . "&amp;highlight=$highlight_active");
            $topic_url = append_sid($root_path . "phpbb2.php?page=viewtopic&amp;" . POST_TOPIC_URL . '=' . $searchset[$i]['topic_id'] . "&amp;highlight=$highlight_active");
            //$post_url = append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $searchset[$i]['post_id'] . "&amp;highlight=$highlight_active") . '#' . $searchset[$i]['post_id'];

            $post_date = create_date($searchset[$i]['post_time']);

            if ( $show_results == 'posts' )
            {
                    $message = $searchset[$i]['post_text'];
                    $post_url = append_sid($root_path . "phpbb2.php?page=viewtopic&amp;" . POST_POST_URL . '=' . $searchset[$i]['post_id'] . "&amp;highlight=$highlight_active") . '#' . $searchset[$i]['post_id'];

                if ( isset($return_chars) )
                {

                    //
                    // 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('/\[url\]|\[\/url\]/si', '', $message);
                        $message = ( utf_strlen($message) > $return_chars ) ? substr($message, 0, $return_chars) . ' ...' : $message;
                    }
                    else
                    {
                        if ( !$config['allow_html'] )
                        {
                            if ( $searchset[$i]['enable_html'] )
                            {
                                $message = preg_replace('#(<)([\/]?.*?)(>)#is', '&lt;\\2&gt;', $message);
                            }
                        }

        $bb_code->parse($message);
        $message = $bb_code->get_html();

                        if ( $highlight_active )
                        {
                            if ( preg_match('/<.*>/', $message) )
                            {
                                $message = preg_replace($highlight_match, '<!-- #sh -->\1<!-- #eh -->', $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 < utf_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('<!-- #sh -->', '', $hold_string);
                                            $hold_string = str_replace('<!-- #eh -->', '', $hold_string);
                                        }
                                        else if ( $hold_string == '<!-- #sh -->' )
                                        {
                                            $hold_string = str_replace('<!-- #sh -->', '<span style="color:#' . $theme['fontcolor3'] . '"><b>', $hold_string);
                                        }
                                        else if ( $hold_string == '<!-- #eh -->' )
                                        {
                                            $hold_string = str_replace('<!-- #eh -->', '</b></span>', $hold_string);
                                        }

                                        $temp_message .= $hold_string;

                                        $start_html += $length;
                                    }
                                    else
                                    {
                                        $start_html = utf_strlen($message);
                                    }
                                }

                                $grab_length = utf_strlen($message) - $end_html - 1;
                                $temp_message .= substr($message, $end_html + 1, $grab_length);

                                $message = trim($temp_message);
                            }
                            else
                            {
                                $message = preg_replace($highlight_match, '<span style="color:#' . $theme['fontcolor3'] . '"><b>\1</b></span>', $message);
                            }
                        }
                    }

                    $topic_title = censor_text($topic_title);
                    $post_subject = ( $searchset[$i]['post_subject'] != '' ) ? censor_text($searchset[$i]['post_subject']) : $topic_title;
                    $message = censor_text($message);

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

                }

                $poster = ( $searchset[$i]['uid'] != ANONYMOUS ) ? '<a href="' . append_sid($root_path . "userdetails.php?id=" . $searchset[$i]['uid']) . '">' : '';
                $poster .= ( $searchset[$i]['uid'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != "" ) ? $searchset[$i]['post_username'] : $lang['guest'] );
                $poster .= ( $searchset[$i]['uid'] != ANONYMOUS ) ? '</a>' : '';

                /*if ( $userdata['session_logged_in'] && $searchset[$i]['post_time'] > $userdata['user_lastvisit'] )
                {
                    $topic_last_read = 0;
                    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'];
                }*/

                $unread_topic = (isset($topic_tracking_info[$forum_id][$topic_id]) && $searchset[$i]['post_time'] > $topic_tracking_info[$forum_id][$topic_id]) ? true : false;

                if ( $unread_topic )
                    {
                        $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'];
                    }

                $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 ) > $config['posts_per_page'] )
                {
                    $total_pages = ceil( ( $replies + 1 ) / $config['posts_per_page'] );
                    //$goto_page = ' [ <img src="' . $images['icon_gotopost'] . '" alt="' . $lang['goto_page'] . '" title="' . $lang['goto_page'] . '" />' . $lang['goto_page'] . ': ';
                    $goto_page = ' [ <img src="' . $images['icon_gotopost'] . '" alt="' . $lang['goto_page'] . '" title="' . $lang['goto_page'] . '" />' . $lang['goto_page'] . ': ';

                    $times = 1;
                    for($j = 0; $j < $replies + 1; $j += $config['posts_per_page'])
                    {
                        //$goto_page .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=" . $topic_id . "&amp;start=$j") . '">' . $times . '</a>';
                        $goto_page .= '<a href="' . append_sid($root_path . "phpbb2.php?page=viewtopic&amp;" . POST_TOPIC_URL . "=" . $topic_id . "&amp;start=$j") . '">' . $times . '</a>';
                        if ( $times == 1 && $total_pages > 4 )
                        {
                            $goto_page .= ' ... ';
                            $times = $total_pages - 3;
                            $j += ( $total_pages - 4 ) * $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 = '<img src="' . $images['folder'] . '" alt="' . $lang['no_new_posts'] . '" />';
                    $folder_image = '<img src="' . $images['folder'] . '" alt="' . $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 >= $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($_COOKIE[$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($_COOKIE[$config['cookie_name'] . '_f_all']) )
                                {
                                    if ( $_COOKIE[$config['cookie_name'] . '_f_all'] > $searchset[$i]['post_time'] )
                                    {
                                        $unread_topics = false;
                                    }
                                }*/

                                $unread_topics = (isset($topic_tracking_info[$forum_id][$topic_id]) && $searchset[$i]['post_time'] > $topic_tracking_info[$forum_id][$topic_id]) ? true : false;

                                if ( $unread_topics )
                                {
                                    $folder_image = $folder_new;
                                    $folder_alt = $lang['new_posts'];

                                    //$newest_post_img = '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&amp;view=newest") . '"><img src="' . $images['icon_newest_reply'] . '" alt="' . $lang['view_newest_post'] . '" title="' . $lang['view_newest_post'] . '" border="0" /></a> ';
                                    $newest_post_img = '<a href="' . append_sid($root_path . "phpbb2.php?page=viewtopic&amp;" . POST_TOPIC_URL . "=$topic_id&amp;view=newest") . '"><img src="' . $images['icon_newest_reply'] . '" alt="' . $lang['view_newest_post'] . '" title="' . $lang['view_newest_post'] . '" border="0" /></a> ';
                                }
                                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 = '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&amp;view=newest") . '"><img src="' . $images['icon_newest_reply'] . '" alt="' . $lang['view_newest_post'] . '" title="' . $lang['view_newest_post'] . '" border="0" /></a> ';
                                $newest_post_img = '<a href="' . append_sid($root_path . "phpbb2.php?page=viewtopic&amp;" . POST_TOPIC_URL . "=$topic_id&amp;view=newest") . '"><img src="' . $images['icon_newest_reply'] . '" alt="' . $lang['view_newest_post'] . '" title="' . $lang['view_newest_post'] . '" border="0" /></a> ';
                            }
                            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 = '';
                    }*/
                }


                $topic_author = ( $searchset[$i]['uid'] != ANONYMOUS ) ? '<a href="' . append_sid($root_path . "userdetails.php?id=" . $searchset[$i]['uid']) . '">' : '';
                $topic_author .= ( $searchset[$i]['uid'] != ANONYMOUS ) ? $searchset[$i]['username'] : ( ( $searchset[$i]['post_username'] != '' ) ? $searchset[$i]['post_username'] : $lang['guest'] );

                $topic_author .= ( $searchset[$i]['uid'] != ANONYMOUS ) ? '</a>' : '';

                $first_post_time = create_date($searchset[$i]['topic_time']);

                $last_post_time = create_date($searchset[$i]['post_time']);

                $last_post_author = ( $searchset[$i]['id2'] == ANONYMOUS ) ? ( ($searchset[$i]['post_username2'] != '' ) ? $searchset[$i]['post_username2'] . ' ' : $lang['guest'] . ' ' ) : '<a href="' . append_sid($root_path . "userdetails.php?id="  . $searchset[$i]['id2']) . '">' . $searchset[$i]['user2'] . '</a>';

                $last_post_url = '<a href="' . append_sid($root_path . "phpbb2.php?page=viewtopic&amp;"  . POST_POST_URL . '=' . $searchset[$i]['topic_last_post_id']) . '#' . $searchset[$i]['topic_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" alt="' . $lang['view_latest_post'] . '" title="' . $lang['view_latest_post'] . '" border="0" /></a>';

                $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)
                );
            }
        }
        // Topic search MOD
        if( !$tid )
        {
        // End Topic search MOD
            $base_url = "phpbb2.php?page=search&amp;search_id=$search_id&amp;search_author=$search_author";
        // Topic search MOD
        }
        else
        {
            $base_url = "phpbb2.php?page=search&amp;search_id=$search_id&amp;topic_id=$tid";
        }
        // End Topic search MOD

        $template->assign_vars(array(
            'PAGINATION' => generate_pagination($root_path . $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 )),
        ));
        return;
    }
    else
    {
        trigger_error($lang['no_search_match']);
        return;
    }
}

//</span>
<span class="code-comment">// Search forum
//
$sql = "SELECT c.cat_title, c.cat_id, f.forum_name, f.forum_id, f.forum_parent</span>
<span class="code-lang">    FROM " . FORUM_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);
$is_auth_ary = auth(AUTH_READ, AUTH_LIST_ALL, $userdata);

$s_forums = '';
$list = array();</span>
<span class="code-lang">while( $row = $db->sql_fetchrow($result) )
{
    if ( $is_auth_ary[$row['forum_id']]['auth_read'] )
    {
        $list[] = $row;
    }
}

for( $i = 0; $i < count($list); $i++ )
{
    if( !$list[$i]['forum_parent'] )
    {
    $row = $list[$i];
        $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'];
        }
        $parent_id = $row['forum_id'];
    for( $j = 0; $j < count($list); $j++ )
    {
    if( $list[$j]['forum_parent'] == $parent_id )
    {
    $row = $list[$j];
    $s_forums .= '<option value="' . $row['forum_id'] . '">-- ' . $row['forum_name'] . '</option>';
    }
    }
    }
}

if ( $s_forums != '' )
{
    $s_forums = '<option value="-1">' . $lang['all_available'] . '</option>' . $s_forums;

    //
    // Category to search
    //
    $s_categories = '<option value="-1">' . $lang['all_available'] . '</option>';
    while( list($cat_id, $cat_title) = @each($list_cat))
    {
        $s_categories .= '<option value="' . $cat_id . '">' . $cat_title . '</option>';
    }
}
else
{
    trigger_error($lang['no_searchable_forums']);
    return;
}

//</span>
<span class="code-comment">// Number of chars returned
//
$s_characters = '<option value="-1">' . $lang['all_available'] . '</option>';
$s_characters .= '<option value="0">0</option>';
$s_characters .= '<option value="25">25</option>';
$s_characters .= '<option value="50">50</option>';</span>
<span class="code-lang">
for($i = 100; $i < 1100 ; $i += 100)
{
    $selected = ( $i == 200 ) ? ' selected="selected"' : '';
    $s_characters .= '<option value="' . $i . '"' . $selected . '>' . $i . '</option>';
}

//</span>
<span class="code-comment">// Sorting
//
$s_sort_by = "";</span>
<span class="code-lang">for($i = 0; $i < count($sort_by_types); $i++)
{
    $s_sort_by .= '<option value="' . $i . '">' . $sort_by_types[$i] . '</option>';
}

//</span>
<span class="code-comment">// 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 = '';</span>
<span class="code-lang">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>';
}

//</span>
<span class="code-comment">// Output the basic page
//
stdhead($lang['forums'] . ' :: ' . $lang['search'], false);

$template->set_filenames(array(</span>
<span class="code-lang">    'body' => 'forum/search_body.tpl')
);
//make_jumpbox('viewforum.'.$phpEx);
make_jumpbox('phpbb2.php?page=viewforum');

$template->assign_vars(array(</span>
<span class="code-lang">    '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_CHARACTERS' => $lang['characters_posts'],

    //'S_SEARCH_ACTION' => append_sid("search.$phpEx?mode=results"),
    'S_SEARCH_ACTION' => append_sid($root_path . 'phpbb2.php?page=search&amp;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' => '')
);

return;

?>