source source_phpbb_1sqh9wuud70fuxy8_main
{
        type = mysql # mysql or pgsql
        sql_host = localhost # SQL server host sphinx connects to
        sql_user = phpbb
        sql_pass = {Your database passwd}
        sql_db = phpbb
        sql_port =  # optional, default is 3306 for mysql and 5432 for pgsql
        sql_query_pre = SET NAMES 'utf8'
        sql_query_pre = UPDATE phpbb_sphinx SET max_doc_id = (SELECT MAX(post_id) FROM phpbb_posts) WHERE counter_id = 1
        sql_query_range = SELECT MIN(post_id), MAX(post_id) FROM phpbb_posts
        sql_range_step = 5000
        sql_query = SELECT \
                                                p.post_id AS id, \
                                                p.forum_id, \
                                                p.topic_id, \
                                                p.poster_id, \
                                                p.post_visibility, \
                                                CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \
                                                p.post_time, \
                                                p.post_subject, \
                                                p.post_subject as title, \
                                                p.post_text as data, \
                                                t.topic_last_post_time, \
                                                0 as deleted \
                                        FROM phpbb_posts p, phpbb_topics t \
                                        WHERE \
                                                p.topic_id = t.topic_id \
                                                AND p.post_id >= $start AND p.post_id <= $end
        sql_query_post =
        sql_query_post_index = UPDATE phpbb_sphinx SET max_doc_id = $maxid WHERE counter_id = 1
        sql_attr_uint = forum_id
        sql_attr_uint = topic_id
        sql_attr_uint = poster_id
        sql_attr_uint = post_visibility
        sql_attr_bool = topic_first_post
        sql_attr_bool = deleted
        sql_attr_timestamp = post_time
        sql_attr_timestamp = topic_last_post_time
        sql_attr_string = post_subject
}
source source_phpbb_1sqh9wuud70fuxy8_delta : source_phpbb_1sqh9wuud70fuxy8_main
{
        sql_query_pre = SET NAMES 'utf8'
        sql_query_range =
        sql_range_step =
        sql_query = SELECT \
                                                p.post_id AS id, \
                                                p.forum_id, \
                                                p.topic_id, \
                                                p.poster_id, \
                                                p.post_visibility, \
                                                CASE WHEN p.post_id = t.topic_first_post_id THEN 1 ELSE 0 END as topic_first_post, \
                                                p.post_time, \
                                                p.post_subject, \
                                                p.post_subject as title, \
                                                p.post_text as data, \
                                                t.topic_last_post_time, \
                                                0 as deleted \
                                        FROM phpbb_posts p, phpbb_topics t \
                                        WHERE \
                                                p.topic_id = t.topic_id \
                                                AND p.post_id >=  ( SELECT max_doc_id FROM phpbb_sphinx WHERE counter_id=1 )
        sql_query_post_index =
}
index index_phpbb_1sqh9wuud70fuxy8_main
{
        path = /var/lib/manticore/dataindex_phpbb_1sqh9wuud70fuxy8_main
        source = source_phpbb_1sqh9wuud70fuxy8_main
        morphology = stem_en, icu_chinese
        stopwords = zh
        wordforms =   # optional, specify path to wordforms file. See ./docs/sphinx_wordforms.txt for example
        exceptions =   # optional, specify path to exceptions file. See ./docs/sphinx_exceptions.txt for example
        min_word_len = 1
        charset_table = 0..9, cjk, english, _
        min_prefix_len = 3 # Minimum number of characters for wildcard searches by prefix (min 1). Default is 3. If specified, set min_infix_len to 0
        min_infix_len = 0 # Minimum number of characters for wildcard searches by infix (min 2). If specified, set min_prefix_len to 0
        html_strip = 1
        index_exact_words = 1 # Set to 1 to enable exact search operator. Requires wordforms or morphology
        blend_chars = U+23, U+24, U+25, U+26, U+40
}
index index_phpbb_1sqh9wuud70fuxy8_delta : index_phpbb_1sqh9wuud70fuxy8_main
{
        path = /var/lib/manticore/dataindex_phpbb_1sqh9wuud70fuxy8_delta
        source = source_phpbb_1sqh9wuud70fuxy8_delta
}
indexer
{
        mem_limit = 1024M
}
searchd
{
        listen = 0.0.0.0:9308
        log = /var/lib/manticore/searchd.log
        query_log = /var/lib/manticore/manticore-query.log
        network_timeout = 5
        pid_file = /var/lib/manticore/datasearchd.pid
        binlog_path = /var/lib/manticore/data
        telemetry = 0
}