1chan.conf

source posts
{
    type = mysql
    sql_host = localhost
    sql_user = <DB_USER>
    sql_pass = <DB_PASSWORD>
    sql_db = <DB_NAME>
    sql_port = 3306

    sql_query_pre = SET NAMES utf8
    sql_query_pre = SET CHARACTER SET utf8

    sql_query = SELECT id, rated, category, created_at, updated_at, link, title, text, text_full, rate, comments FROM 1chan_post WHERE hidden = 0
    sql_attr_bool = rated
    sql_attr_uint = category
	sql_attr_bigint = rate
	sql_attr_uint = comments
	sql_attr_timestamp = created_at
	sql_attr_timestamp = updated_at

    sql_query_info = SELECT * FROM 1chan_post WHERE ID = $id
}

source forceometer {
    type = mysql
    sql_host = localhost
    sql_user = <DB_USER>
    sql_pass = <DB_PASSWORD>
    sql_db = <DB_NAME>
    sql_port = 3306

    sql_query_pre = SET NAMES utf8
    sql_query_pre = SET CHARACTER SET utf8

    sql_query_pre = CREATE TEMPORARY TABLE \
                        1chan_forceometer_index ( \
                            id INT NOT NULL, \
                            ip VARCHAR(16), \
                            title VARCHAR(255) DEFAULT '', \
                            text TEXT, \
                            created_at INT(32) NOT NULL, \
                            uniq_f INT(1) NOT NULL DEFAULT 0, \
                            uniq_m INT(1) NOT NULL DEFAULT 0, \
                            PRIMARY KEY (id), KEY (ip) \
                        ) \
                    TYPE=MyISAM;

    sql_query_pre = INSERT IGNORE INTO 1chan_forceometer_index (id, ip, title, text, created_at) \
                        SELECT 1chan_post.id, 1chan_post.ip, 1chan_post.title, CONCAT(1chan_post.text, ' ', 1chan_post.text_full) as text, 1chan_post.created_at \
                            FROM 1chan_post;

    sql_query_pre = INSERT IGNORE INTO 1chan_forceometer_index (id, ip, text, created_at) \
                        SELECT 1chan_comment.id, 1chan_comment.ip, 1chan_comment.text, 1chan_comment.created_at \
                            FROM 1chan_comment;

    sql_query_pre = UPDATE 1chan_forceometer_index, \
                        ( \
                            SELECT id, ip, FROM_UNIXTIME(created_at, '%Y%m') as month_at \
                                FROM 1chan_comment \
                                    GROUP BY ip, month_at \
                        ) as slice \
                        SET 1chan_forceometer_index.uniq_m = 1 \
                        WHERE 1chan_forceometer_index.id = slice.id;

    sql_query_pre = UPDATE 1chan_forceometer_index, \
                        ( \
                            SELECT id, ip, FROM_UNIXTIME(created_at, '%Y%m') as month_at \
                                FROM 1chan_post \
                                    GROUP BY ip, month_at \
                        ) as slice \
                        SET 1chan_forceometer_index.uniq_m = 1 \
                        WHERE 1chan_forceometer_index.id = slice.id;

    sql_query_pre = UPDATE 1chan_forceometer_index, \
                        ( \
                            SELECT id \
                                FROM 1chan_comment \
                                    GROUP BY ip \
                        ) as slice \
                        SET 1chan_forceometer_index.uniq_f = 1 \
                        WHERE 1chan_forceometer_index.id = slice.id;

    sql_query_pre = UPDATE 1chan_forceometer_index, \
                        ( \
                            SELECT id \
                                FROM 1chan_post \
                                    GROUP BY ip \
                        ) as slice \
                        SET 1chan_forceometer_index.uniq_f = 1 \
                        WHERE 1chan_forceometer_index.id = slice.id;

    sql_query = SELECT id, title, text, created_at, uniq_m, uniq_f FROM 1chan_forceometer_index;
    sql_attr_bool = uniq_m
    sql_attr_bool = uniq_f
	sql_attr_timestamp = created_at
}

index forceometer
{
    source = forceometer

    path = /var/lib/sphinxsearch/data/forceometer

    docinfo = extern

    mlock = 0

    min_word_len = 3

    charset_type = utf-8
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F

	phrase_boundary	= ., ?, !
	html_strip = 1
}

index posts
{
    source = posts

    path = /var/lib/sphinxsearch/data/posts
    docinfo = extern

    mlock = 0

    min_word_len = 2

    morphology 	= stem_en, stem_ru, soundex
    charset_type = utf-8
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F

	phrase_boundary	= ., ?, !

	html_strip = 1

    min_infix_len = 2
    enable_star = 1
}

indexer
{
    mem_limit = 64M
    max_iops = 40
}

searchd
{
    port = 3312
    log = /var/lib/sphinxsearch/data/searchd.log

    read_timeout = 5
    max_children = 30

    pid_file = /var/www/1chan.ru/searchd.pid
    max_matches = 1000
}